2. ASPRunnerPro General questions
  3. Document upload problem
This topic is locked

Document upload problem

 		2/4/2007 4:37:54 PM
ASPRunnerPro General questions
Z
 zion4ever author

Hi,
I have created a website with asprunner pro 4.1 that houses the members of a small gaming community. Everything works fine. The only problem is that I have added a document upload feature so users may post small files. If already succesfully logged in, the document upload function works fine when adding or editing, listing or viewing. However, on the registration page on submit, an sql error is displayed saying: Mysql 3.51 driver error. "player in action" (name of the mysql db field and form control) has no default value. I don't understand this. All fields are filled in, even the upload field is filled in by browsing to a small txt file.
Is there a way to fix this?
TIA
Hans

Holland
Sergey Kornilov admin 2/4/2007

It's hard to tell what's wrong without seeing your files.
Post your files to Demo Account and send me the URL where I can see this.
Z
 		zion4ever author 2/5/2007

Sergey,
Thanks for responding so rapidly. The testdatabase and test asp pages are setup at:

http://85.147.2.198/lp/test/
Should you need my project files, plz say so.

I am certain that Myqsl is setup properly, so is IIS 6 on my Win2k3 box.
Thnx
Hans
Sergey Kornilov admin 2/5/2007

Hans,
Post your files to Demo Account and send me the URL where I can see this.

Demo Account button can be found on the last tab in ASPRunnerPro.

In this case I'll be able to see your files and find what's wrong.
Z
 		zion4ever author 2/5/2007

Sergey,
I must be overlooking it. Can''t seem to find a demo account button.

I'm using the trial version of ASPRunner 4.1. Does this version has this button too?
Should it be located on the BUILD page (publish to frontpage, publish via ftp, open output folder)?
Thnx
Hans
J
 		Jane 2/5/2007

Hans,
Demo Account is available in the last ASPRunnerPro update.

Here is a download link:

http://www.asprunner.com/files/asprunnerpro411.exe
Z
 		zion4ever author 2/5/2007

Hi,
I can see the demo button now:

http://demo.asprunner.net/zion4ever_orange...vised/login.asp
Greetz
Hans
J
 		Jane 2/5/2007

I can't reproduce this error.

Please send me a detailed instructions on how to reproduce the error.
Z
 		zion4ever author 2/5/2007

Jane,
It seems I have changed something by accident. When clicking the register page after submitting the form all form data is cleared, but nothing is saved to the db.

Arrrrgggg. It has gotten worse now.
Do you have any suggestions? I'll look into it as well
Z
 		zion4ever author 2/5/2007

On the Register page in the Visual studio, the yellow building block for PLAYER IN ACTION FIELD is missing. Only the label "player in action is available" That's why the error can't be reproduced I think. How can I add such a yellow field with the right name? I've tried to go back to the login editor -->create registration page --> removed the PLAYER IN ACTION item-->saved all-->added the item and built the project. Still in the visual editor the yellow field is missing. Any tips?
Btw, is it possible to apply a filter to the uploaded documents, for example only allow .WMV files with a max limit of 1 MB?
Thank you very much for your effort.
Hans
Z
 		zion4ever author 2/5/2007

Oke, I fixed it by renaming a column in the db and rebuilding the pages. After that it recognized db setting change, i only needed to reset the register page. Thnx for your time sergey and jane. Btw, see my previous question about applying a file extension filter and upload size limit. Is this possible?
Hans