SQL Error in uniupload.php

Alcedema · Post by **Alcedema** » Wed Jul 29, 2009 5:41 am

I know this is applicable to different forums, but as it's web based I'll put it here.

Every now and then, with or without user/pass in uniupload I get the following error:

Code: Select all

Error => Unable to query &#58; 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&#58; 281 of /home/wrlogin/public_html/uniupload.php

Sometimes the script doesn't run at all, just shows that. Or sometimes it gets to the username section and then spews the error.

So I assume my data isn't getting to you! Noo.

Post by **Rollie** » Wed Jul 29, 2009 8:43 am

I'll look into it

Post by **Rollie** » Wed Jul 29, 2009 9:45 am

So this error that you get. Do you only get it sometimes? Or every time you try to upload?

Alcedema · Post by **Alcedema** » Wed Jul 29, 2009 10:08 am

Only sometimes.

Alcedema · Post by **Alcedema** » Wed Jul 29, 2009 10:09 am

Looks like it might be to do with your 1 hour cut-off period. I just successfully uploaded via uniuploader, and then when I tried again it just shows that SQL error, with no other info.

Alcedema · Post by **Alcedema** » Wed Jul 29, 2009 4:45 pm

Maybe not, my first sub in a few hours results in this:

Code: Select all

<Uploading>




Looking for file
IP&#58; **.**.**.**<br>
Denmark<br>
**.**.**.** - dk - 
Upload file appears to be valid, checking your version number.
Checking your file
Found CensusPlus Database
Found CensusPlus Info Data
Found Version Number => Version&#58; 4.2.2 <Found> Locale&#58; EU <=
Attempting to make entry

Getting User/pass
Username &#58; Alcedema<Error> Unable to query &#58; 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&#58; 281 of /home/wrlogin/public_html/uniupload.php

NowhereRx7 · Post by **NowhereRx7** » Mon Feb 01, 2010 4:13 pm

Same occurence here...and it may have something to do with the hour cut-off, because I don't think I've seen it with a regular upload. I've been trying to get Uni to work with another site and since this is my primary upload site, it's been getting hit a few times.

Getting User/pass
Username : xxxxxxx <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: 281 of /home/wrlogin/public_html/uniupload.php

Beebolini · Post by **Beebolini** » Sun Feb 21, 2010 12:27 am

I get this all the time as well.

Same message. I agree that it COULD be something to do with the 1 hour re-upload thing.

I've also noticed that with all three versions of Windows that I've used, XP, Vista, and 7, Uniupload crashes on a regular basis. It's always when doing a reloadui, or logging out.

Balgair · Post by **Balgair** » Mon Feb 22, 2010 4:52 pm

Yeah it crashes all the time for me too, didn't used to when I had an older version but since I got the latest one when I upgraded to Windows 7, it ALWAYS crashes unless I exit it immediately after doing an upload (I tend to just leave it running in the background to upload again later). Was wondering if it was a windows 7 compatibility thing but guess it's UU to blame then!