Join Date: Jul 2002
Mysql 5.X problem by adding a cat ?
I'm getting this:
"Error adding new category to the database. Returned id was 0"
and the details is:
We're sorry, but the system experienced an unrecoverable error. Please try again later.
Query: INSERT INTO categories (id,catname,description,catorder,thumbs,parent,header,footer,headtags,password,ugnoview,
VALUES(NULL,'Hog Doggin'','Hog Dogging Photos','4','yes',510,'','','','', '', '', '', '5,1,3,4,2', '', '', '1', '', '', '', '')
Result: 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 'Hog Dogging Photos','4','yes',510,'','','','', '', '', '', '5,1,3,4,2', '', '', ' at line 2
Database handle: Resource id #6
When adding a cat. I read that there was some problem with Mysql 5.X, did you fix it ? The autoincrement seems correct.