I am getting what seems to maybe a related problem when new users try and create an account:
Code:
Request URI:
http://localhost:8081/deki/users?dream.out.format=php&dream.in.host=wiki.lavenderdigital.com.au&dream.in.scheme=http&dream.in.origin=192.168.203.66&accountpassword=xxx
Server response:
Array
(
[exception] => Array
(
[message] => Field 'user_options' doesn't have a default value
[source] => MySql.Data
[stacktrace] => Array
(
[frame] => Array
(
[0] => MySql.Data.MySqlClient.MySqlStream.OpenPacket () [0x00000]
[1] => MySql.Data.MySqlClient.NativeDriver.ReadResult (System.UInt64& affectedRows, System.Int64& lastInsertId) [0x00000]
[2] => MySql.Data.MySqlClient.MySqlDataReader.GetResultSet () [0x00000]
[3] => MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00000]
)
)
[type] => MySql.Data.MySqlClient.MySqlException
)
)
When I run php update-db.php I get the following error:
Code:
Query "INSERT INTO `pages` (`page_namespace`, `page_title`, `page_tip`, `page_parent`, `page_restriction_id`, `page_content_type`) VALUES (101, 'Tags', 'Special page', 0, 0, 'text/plain'), (101, 'Events', 'Special page', 0, 0, 'text/plain'), (101, 'About', 'Special page', 0, 0, 'text/plain'), (10, '', 'Template page', 0, 0, 'text/plain'), (2, '', 'User page', 0, 0, 'text/plain')" failed with error code "Field 'page_text' doesn't have a default value".
When I run patch-specialpages.sql on my database directly I get the same "#1364 - Field 'page_text' doesn't have a default value" error, it does not not having default values. Not really sure how to fix this. If I try to give page_text a value it says:
Code:
#1101 - BLOB/TEXT column 'page_text' can't have a default value