LifeType 中文開發論壇

創建資料庫時發生以下錯誤訊息
請問是否與MySQL版本有關？(我的版本是5.0.37)


There was an error creating the tables in the database. Please make sure that the user chosen to connect to the database has enough permissions to create tables.

Database created successfully.
Error creating table: BLOB/TEXT column 'properties' can't have a default value
Error creating table: BLOB/TEXT column 'description' can't have a default value
Error creating table: BLOB/TEXT column 'properties' can't have a default value
Table Notifications created successfully.
Table Blogs created successfully.
Error creating table: BLOB/TEXT column 'properties' can't have a default value
Error creating table: BLOB/TEXT column 'properties' can't have a default value
Table MyRecent created successfully.
Table MyRecent categories created successfully.
Table Permissions created successfully.
Table Referrers created successfully.
Error creating table: BLOB/TEXT column 'properties' can't have a default value
Error creating table: BLOB/TEXT column 'properties' can't have a default value
Table Permissions created successfully.
Table Configuration created successfully.
Table Filtered Content created successfully.
Table Blocked content created successfully.
Error creating table: BLOB/TEXT column 'normalized_description' can't have a default value
Error creating table: BLOB/TEXT column 'properties' can't have a default value
Table Bayesian Filter data table created successfully.
Table Bayesian Filter Information created successfully.
Table Map of categories to articles created successfully.
Table Definition of custom fields created successfully.
Table Custom fields that have been assigned to articles created successfully.
Error creating table: BLOB/TEXT column 'text' can't have a default value

請先將 mysql 的 strict_mode 移除。目前 LifeType 在 MySQL 5 的 strict_mode 下運作還有些問題。

Mark

了解，謝謝唷

移除strict_mode 出現的錯誤還是一樣呢，我跟原PO的版本跟狀況完全一樣，還有沒有其他的方式可以用呢，謝謝