View Full Version : Bug when upload
electro76
03-28-2007, 04:24 PM
I installed Pixelpost 1.6 last monday and Uploaded a picture on monday and thursday with no problems.
But, right now I try to upload a new picture and I receive this error message :
Error: 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 2
Can you help me with this problem?
Thanks you!
Gino
P.S. Sorry for my bad english, I'm french
jaywilliams
03-28-2007, 05:46 PM
Could you please copy-paste the the entire error message?
Dennis
03-28-2007, 06:33 PM
This is probably an exif error. Please check this thread on how to resolve it: http://forum.pixelpost.org/showthread.php?t=6317
electro76
03-28-2007, 06:47 PM
You were right, this is an exif problem, I remove all of the exif info in the JPG as a test and my photo uploaded correctly.
I then remove the photo and try to update th exif.php file et I cannot upload the file with exif info, I receive always the same error message. Here is a screenshot of the message:
http://www.gino-caron.com/photos/upload.gif
Thank you for your help!
Gino
Dennis
03-28-2007, 08:34 PM
Have you updated the exif.php file from the zip file in that thread?
If so, please send me the picture with exif.
electro76
03-28-2007, 08:37 PM
Yes, I've updated the exif.php file from the last version this afternoon and still receive the error.
To upload my photo without this error, I removed the hexa lines in the exif of the picture and no more errors.
Gino
Dennis
03-28-2007, 09:21 PM
hexa lines? please inform me of this because I never heard of those.
electro76
03-29-2007, 02:08 PM
Sorry, I think I made a mistake, this isn't hexa line, but blank line. In the picture I posted yesterday, there was 14 blank line. I don't know which one created the problem, but after I remove them all, the problem was resolved.
If you want, you can take a look in my original picture with all the exif info:
http://www.gino-caron.com/maisons_iles2.jpg
Gino
Dennis
03-29-2007, 03:30 PM
Thanks Gino, I was able to fix the bug thanks to your picture.
Please apply the fix from http://forum.pixelpost.org/showthread.php?t=6317 and let me know if the issue has been resolved.
electro76
03-29-2007, 04:02 PM
Thank you, the issue is now resolved!
vBulletin® v3.7.3, Copyright ©2000-2013, Jelsoft Enterprises Ltd.