PlaneShift
Development => Development Deliberation => Topic started by: talentraspel on December 31, 2006, 09:36:42 am
-
Hi.
Some scripts in src\server\database\mysql have default values on blob or text fields that are not allowed when running mysql in strict mode wich is default. I suggest removing the default values for the blob and text fields in the following files:
petition.sql
progess_events.sql
quest_skript.sql
tips.sql
Info from the Net:
"MySQL 5.x BLOB/TEXT columns cannot have default values any longer.
As of MysQL 5.0.2, when in strict mode adding a default value to BLOB/TEXT columns will cause an error, otherwise it will return a warning."
An other option would be to include the information for setting the correct mode in the documenation.
Regards,
Kai.