PhotoPost Community - View Single Post - MySQL-Errors during install (MySQL 5.0)

noox · October 7th, 2006, 07:49 AM

I've MySQL 5.0 on my development computer. I get some mySQL-errors during install. In Install Errors (INSERT INTO pp_categories) 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.

October 7th, 2006, 07:49 AM	#1 (permalink)
noox Junior Member Verified Customer Join Date: Oct 2006 Location: Salzburg, Austria Posts: 5	MySQL-Errors during install (MySQL 5.0) I've MySQL 5.0 on my development computer. I get some mySQL-errors during install. In Install Errors (INSERT INTO pp_categories) 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.