Uhh...

Balgair · Post by **Balgair** » Wed Apr 08, 2009 7:31 pm

<Uploading>

Looking for file
IP: X.X.X.X<br>
United Kingdom<br>
X.X.X.X - gb -
File appears to be valid, checking your version number.
Checking your file
Found CensusPlus Database
Found CensusPlus Info Data
Found Version Number => Version: 4.2.2 <Found> Locale: EU <=
Attempting to make entry

Getting User/pass
Username : Balgair<Error> Unable to query : 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 '' at line 3 on line: 285 of /home/wrlogin/public_html/uniupload.php

Not sure if this is connected to me having already done an upload in the last 15 mins (uploaded from wrong account and trying to overwrite it) but that's what I got just now on uniuploader anyway

I'll watch the server response next time I do any uploads and see if it happens again, might be a one-off but thought I'd give a heads-up anyway!

Kosh · Post by **Kosh** » Thu Apr 09, 2009 2:47 am

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?

Post by **Rollie** » Fri Apr 10, 2009 12:45 am

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 · Post by **Kosh** » Fri Apr 10, 2009 7:34 pm

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 · Post by **Kosh** » Thu Apr 16, 2009 4:03 am

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.

Post by **Rollie** » Fri Apr 17, 2009 8:11 am

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

Thank you for your trials and info!