Join Date: May 2004
Bulk Import Bypass Error
When I try to bulk import with bypass typing any ' in the title and/or description, an error comes up.
I tested this on two gallery installs, one a recent upgrade and one with a fresh install, both running v 5.62 and it occurs on both.
The error e-mail I receive says this:
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,
values(NULL,'Beautiful-Girl', 2, 2163, 1169499075, 'Willa Holland - This Girl's Life Premiere', 'The O.C. actress Willa Holland attends This Girl's Life Los Angeles Premiere and After Party on October 20th 2004', '', 'willaholland-dot-net_thisgirlslife-lapremeire-2004oct20-040.jpg', 342, 512, 32824,
0, 0, 0, 1, 1169499075, 'no','yes','','','','','','','126.96.36.199','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 Life Premiere', 'The O.C. actress Willa Holland attends This Girl's Life Los A' at line 3
Thanks for helping me with this!
Last edited by bajabob; January 22nd, 2007 at 11:43 PM.