PDA

View Full Version : MySQL-Errors during install (MySQL 5.0)


noox
October 7th, 2006, 06:49 AM
I've MySQL 5.0 on my development computer. I get some mySQL-errors during install. In http://www.photopost.com/forum/showthread.php?t=119776&highlight=Data+too+long+for+column+description it is said that it's a MySQL strict mode problem. (I'm not allowed to post there)

True is that it only occurs there, but older MySQL version only silently ignore the errors.

Table categories has no default value for column "theme", so an INSERT without specifying a value for "theme" is not correct.

Same with table "settings". The description column is only varchar(150), but the values inserted there are for instance 166 chars.

I've corrected these two glitches and installation works like a charm.

noox
October 7th, 2006, 08:48 AM
sorry - didn't see the sticky mysql post here. And this post is just to (hopefully) become a verified customer..