When I click to go into the galleries to view the images (I can see the summary page with some pictures on) I get this here database error SQL-DATABASE ERROR Database error in WoltLab Burning Board: Invalid SQL: SELECT c_name, c_description FROM bb1_gallery_category WHERE c_id = 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 '' at line 1 mysql error number: 1064 Date: 14.07.2006 @ 03:45 Script: /gallery.php?action=view_cat&id=1 Referer: http://www.gatchamania.net/gallery.php?sid=

As do I. Same error message.

Fixed

Springie raises hand...me, too me, too!

oooh... that was fast, Cep, thanks!

Thanks Cep

Ok... Cep... I posted three...but two of my pics won't load...I get that same SQL- Database Error message. it acts like it's going to load... then the message comes up. I know the pics aren't great... but they're not so bad that the computer won't take them, are they? LOL The only difference with the other two pics is that they are black and white????

This is the message that pops up... SQL-DATABASE ERROR Database error in WoltLab Burning Board: Invalid SQL: INSERT INTO bb1_gallery_images (i_name, i_description, i_category, i_image, i_sub_by, i_sub_by_id, i_sub_on, i_views, i_width, i_height, i_filesize, i_exif_make, i_exif_model, i_exif_timestamp, i_exif_exposuretime, i_exif_isospeed, i_exif_flength) VALUES ('Mark and Princess Sittin' in a Tree..', 'This is another illustratiom for one of my fics, Dysfunctional Family Outing. Mark and Princess are getting "cozy" by the lake... ', '2', 'file19.jpg', 'Springie', '267', '1152903591', '0', '1394', '1022', '805133', '', '', '', '', '', '') 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 'a Tree..', 'This is another illustratiom for one of my fics, Dysfunctional Famil' at line 1 mysql error number: 1064 Date: 14.07.2006 @ 13:59 Script: /gallery.php Referer: http://www.gatchamania.net/gallery.php?action=add_image

Aha - I'm guessing that error is because you've called it 'Mark and Princess Sittin' in a Tree..' - if you called it 'Mark and Princess Sittin in a Tree..' without the apostrophe on "sittin" then it might work.

Thanks Meridian... I tried and it still doesn't work...and the other one is called Dysfunctional Family Outing...the only other thing I can think of is ...too many letters?

Can you post the error you're getting again, now that you've got rid of the apostrophes?

Would you believe the two that wouldn't work yesterday are working today? I only have one left that won't work...here's the error message... SQL-DATABASE ERROR Database error in WoltLab Burning Board: Invalid SQL: INSERT INTO bb1_gallery_images (i_name, i_description, i_category, i_image, i_sub_by, i_sub_by_id, i_sub_on, i_views, i_width, i_height, i_filesize, i_exif_make, i_exif_model, i_exif_timestamp, i_exif_exposuretime, i_exif_isospeed, i_exif_flength) VALUES ('Condor and Swan Cuddle', 'Joe's face is so hard to draw! I must have erased it 50 times! I finally gave up... ', '2', 'file22.jpg', 'Springie', '267', '1152975929', '0', '876', '694', '309876', '', '', '', '', '', '') 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 's face is so hard to draw! I must have erased it 50 times! I finally gave up... ' at line 1 mysql error number: 1064 Date: 15.07.2006 @ 10:05 Script: /gallery.php Referer: http://www.gatchamania.net/gallery.php?action=add_image

ok... I figured it out... it doesn't like apostrophies...you told me that before...thanks, Meridian!

Wonder if I forgot to add that apostraphy code in. Ok I will get that added soon enough

Heehee ...love those apostrophes! '''''''''''''