Uhh...

Kosh · Posted: Thu Apr 09, 2009 2:47 am Post subject:

Yea, it seems that several people (including me) have occasionally seen that error. From the context and verbiage, I suspect that what is actually happening is that an error handler is assuming that a MySQL error is a SQL syntax error, where in this case, it is probably another database error (my guess would be a table or other resource lock that is blocking the query).

At least for me, retrying the upload a little later is successful. so just try again in a couple of minutes.

Rollie, this brings up a question I keep meaning to ask.... I can't think of any case where random Joe-user crediting my account for an upload would be detrimental to me, so I was wondering why the password is needed for the upload script?

Rollie · Posted: Fri Apr 10, 2009 12:45 am Post subject:

You know, that makes a lot of sense. There really is no reason that you would have to be authenticated to do an upload.

@Bal -

Yes, if you see that occur again, please let me know as it is not something I would expect to see.

Kosh · Posted: Fri Apr 10, 2009 7:34 pm Post subject:

Rollie, if you have sufficiently detailed logging, check for a couple of errored-out submissions from me before my successful submission at 18:35:07 today. My script doesn't currently output a timestamp on errors, so can't be more exact than a couple of minutes before the successful try. They would all be from the same IP address. The error text is always the same (script & line number, but no SQL in the quotes).

As noted, I waited a couple of minutes after the errors, and the submission succeeded.

Kosh · Posted: Thu Apr 16, 2009 4:03 am Post subject:

I have been paying closer attention to when I have been receiving a MySQL error during uploads. My sample size is small, so this might just be an anomaly, but in each such case, the failed upload was attempted "soon" (but over 15 minutes) after the previous upload.

For example, after my successful upload at 04-16-2009 03:01:22, I attempted to upload three times starting at about 03:18, which all failed. The fourth attempt was successful, at 03:19:30, ending 18:08 after the previous successful upload.

Not knowing your queries & DML, I don't know if "time since last seen" could affect anything relevant, but if this gives you any possibilities to look into, great. Otherwise, I will keep looking for patterns; after all, it is a small sample size. Smile

Rollie · Posted: Fri Apr 17, 2009 8:11 am Post subject:

It is very possible I have something jacked in the subsequent uploads for uniuploader.

Thank you for your trials and info!