| Junior Member Verified Customer
Join Date: Sep 2006
Posts: 23
|  Bug when description contains apostrophe
I was trying to upload some files via FTP, and it had been working fine. When I tried to do a batch with the approval bypass checked, and the description read: "Photos from Evergrey's 2003 tour" it came back with: There was an error uploading this photo. Please report to System Administrator.
I tried multiple times, every time I had to remove the 's after Evergrey. I got a MySQL error report that confirms this: Quote:
An error was encountered during execution of the query:
INSERT INTO pp_photos (id,user,userid,cat,date,title,description,keywords,bigimage,width,height,filesize,medwidth,medheight,medsize,approved,lastpost,
watermarked,allowprint,extra1,extra2,extra3,extra4,extra5,extra6,ipaddress,allowrate,allowcoms)
values(NULL,'MetalAges', 1273, 717, 1163309088, 'Evergrey Live 2003', 'Various photos from Evergrey's 2003 tour', 'evergrey live 2003', '20122.jpg', 449, 337, 148434,
0, 0, 0, 1, 1163309088, 'no','yes','','','','','','','71.114.45.88','1','1')
The query returned with an errorcode of:
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 's 2003 tour', 'evergrey live 2003', '20122.jpg', 449, 337, 148434,
0' at line 3
| |
Linear Mode
