PDA

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!