Page 1 of 1
SQL Error in uniupload.php
Posted: Wed Jul 29, 2009 5:41 am
by Alcedema
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 : 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
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.
Posted: Wed Jul 29, 2009 8:43 am
by Rollie
I'll look into it
Posted: Wed Jul 29, 2009 9:45 am
by Rollie
So this error that you get. Do you only get it sometimes? Or every time you try to upload?
Posted: Wed Jul 29, 2009 10:08 am
by Alcedema
Only sometimes.
Posted: Wed Jul 29, 2009 10:09 am
by Alcedema
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.
Posted: Wed Jul 29, 2009 4:45 pm
by Alcedema
Maybe not, my first sub in a few hours results in this:
Code: Select all
<Uploading>
Looking for file
IP: **.**.**.**<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: 4.2.2 <Found> Locale: EU <=
Attempting to make entry
Getting User/pass
Username : Alcedema<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
SQL Error
Posted: Mon Feb 01, 2010 4:13 pm
by NowhereRx7
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
Posted: Sun Feb 21, 2010 12:27 am
by Beebolini
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.
Posted: Mon Feb 22, 2010 4:52 pm
by Balgair
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!