Mysql 5.X problem by adding a cat ?

[Interdit]

Hello,

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.

Script:

Query: INSERT INTO categories (id,catname,description,catorder,thumbs,parent,header,footer,headtags,password,ugnoview,
ugnoupload,ugnopost,ugnoanno,ugnovote,watermark,sortorder,frames,maximages,ratingtype,ismember)
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.

Thanks,

Best regards,
Francois

[Chuck S]

Are you intentionally entering a cat name of this

Hog Doggin'

Try entering this

Hog Doggin

[Interdit]

Yes, I can not ?

Thanks,
Francois

[Chuck S]

what do you mean you can not

[Interdit]

Can i name my category Hog Doggin' ? Should it work normally ?

[Chuck S]

Well you can try adding this line in bold in adm-cats.php your mysql flips out using the semi colon

Content visible to verified customers only.

[Astaran]

Please use
$ncatname = mysql_real_escape_string($ncatname);
or at least addslashes() to escape the value.
htmlentities() should be used for output escaping not for input escaping that will be inserted into the database.

[Chuck S]

mysql_real_escape_string thats one I had not thought of