Menu

#3 error creating / uploading pictures

open
nobody
None
5
2009-02-13
2009-02-13
PQuery
No

I've finally gotten to a point where I could try and upload / point to a directory where I had FTP'd some pictures to try and create an album.

First uploading didn't work. Although the album does show 2 broken thumbnails from the 2 pictures which I tried to upload.

Second, when I pointed to a directory called "temp" which I placed inside the pia folder and then put about 8 pictures in there I got this big red error for each instance:

An error occured!
MySQL error-number: 1064
MySQL 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 'Administrative Main Menu' - kiahands_dealer2_php.jpg','jpg','50','26.15384615384' at line 1
Query: INSERT INTO `tbl_prefix_photos` (`photo_ID`,`album_ID`,`filename`,`type`,`width`,`height`,`orientation`) VALUES ('','2','FireShot capture #53 - 'Administrative Main Menu' - kiahands_dealer2_php.jpg','jpg','50','26.153846153846','h')

now just from looking at it I do see a missing apostrophe in the sql statement

it still didn't create the album though

Discussion


Log in to post a comment.