Upload Error

[Proudman]

MySQL error reported!

Script: bulkupload

Query: INSERT INTO photo_notify (id,userid,photo) values(NULL,,13086)

Result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '13086)' at line 1

Database handle: Resource id #6

I get this error every time I try to process files if I selected that I wanted to be notified by e-mail of any comments.
From what I read in the error message the script has not picked up my userid.

Greg

I tried to post maybe 10 or 15 mins ago, and could not either.



Had to wit and tried 4 times, before allowed to post.

[Proudman]

When I have not selected the notification check box it has worked for me every time.

This is not the sort of error that you would expect to be intermittent. A required field in the database table, in this case userid, just isn't there.

[JetDog]

Proudman wrote:

When I have not selected the notification check box it has worked for me every time.

This is not the sort of error that you would expect to be intermittent. A required field in the database table, in this case userid, just isn't there.

My suspicion is that the server load is greater than the mySQL server can cope with - that would explain it being intermittent.

What time of day did this occur?

EDIT: Does it occur every time when you select Photo Notification?

[Proudman]

MySQL error reported!

Script: bulkupload

Query: INSERT INTO photo_notify (id,userid,photo) values(NULL,,13113)

Result: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '13113)' at line 1

Database handle: Resource id #6

Just tried and got the same results.