DB Conversion Error

[Mike_Smith]

I posted this in another topic but i think it went un-noticed :o

I seem to have run into a problem with the converting of the old GooseBerry DB. I am testing this on a VMware machine running winxp and have taken a snapshot of where I am.

I can complete the install fine if I don't import the old SQL DB!

But if I try use the old DB I get the following error:

Performing installation...Generating LocalSettings.php configuration file...
Database type: MySQL
Attempting to connect to database server as root...success.
Connected to 5.0.45-community-nt
Database wikidb exists
This appears to be a Deki Wiki Gooseberry database. Attempting to upgrade the DB schema to Hayes.
Granting user permissions to wikiuser on wikidb...success.
combo permissions system DB upgrade...done
adding content-type column to `pages`
sprocs update complete
Applying misc database updates...done
adding at_image_width, at_image_height to `attachments`
adding tags tables
migrationg dekifarm db to hayes schema
adding special pages Query "INSERT INTO `pages` (`page_namespace`, `page_title`, `page_tip`, `page_parent`, `page_restriction_id`, `page_content_type`) VALUES (101, 'Redirects', 'Special page', 0, 0, 'text/plain'), (101, 'Userlogin', 'Special page', 0, 0, 'text/plain'), (101, 'Userlogout', 'Special page', 0, 0, 'text/plain'), (101, 'Preferences', 'Special page', 0, 0, 'text/plain'), (101, 'Watchedpages', 'Special page', 0, 0, 'text/plain'), (101, 'Recentchanges', 'Special page', 0, 0, 'text/plain'), (101, 'Listusers', 'Special page', 0, 0, 'text/plain'), (101, 'Listguests', 'Special page', 0, 0, 'text/plain'), (101, 'ListTemplates', 'Special page', 0, 0, 'text/plain'), (101, 'ListRss', 'Special page', 0, 0, 'text/plain'), (101, 'Search', 'Special page', 0, 0, 'text/plain'), (101, 'Sitemap', 'Special page', 0, 0, 'text/plain'), (101, 'Specialpages', 'Special page', 0, 0, 'text/plain'), (101, 'Contributions', 'Special page', 0, 0, 'text/plain'), (101, 'Emailuser', 'Special page', 0, 0, 'text/plain'), (101, 'Undelete', 'Special page', 0, 0, 'text/plain'), (101, 'Popularpages', 'Special page', 0, 0, 'text/plain'), (101, 'DeleteAll', 'Special page', 0, 0, 'text/plain'), (101, 'Watchlist', 'Special page', 0, 0, 'text/plain'), (101, 'Statistics', 'Special page', 0, 0, 'text/plain')" failed with error code "Field 'page_text' doesn't have a default value

Any ideas?
Thanks!

[PeteE]

I posted this in another topic but i think it went un-noticed :o

I seem to have run into a problem with the converting of the old GooseBerry DB. I am testing this on a VMware machine running winxp and have taken a snapshot of where I am.

I can complete the install fine if I don't import the old SQL DB!

But if I try use the old DB I get the following error:

Performing installation...Generating LocalSettings.php configuration file...
Database type: MySQL
Attempting to connect to database server as root...success.
Connected to 5.0.45-community-nt
Database wikidb exists
This appears to be a Deki Wiki Gooseberry database. Attempting to upgrade the DB schema to Hayes.
Granting user permissions to wikiuser on wikidb...success.
combo permissions system DB upgrade...done
adding content-type column to `pages`
sprocs update complete
Applying misc database updates...done
adding at_image_width, at_image_height to `attachments`
adding tags tables
migrationg dekifarm db to hayes schema
adding special pages Query "INSERT INTO `pages` (`page_namespace`, `page_title`, `page_tip`, `page_parent`, `page_restriction_id`, `page_content_type`) VALUES (101, 'Redirects', 'Special page', 0, 0, 'text/plain'), (101, 'Userlogin', 'Special page', 0, 0, 'text/plain'), (101, 'Userlogout', 'Special page', 0, 0, 'text/plain'), (101, 'Preferences', 'Special page', 0, 0, 'text/plain'), (101, 'Watchedpages', 'Special page', 0, 0, 'text/plain'), (101, 'Recentchanges', 'Special page', 0, 0, 'text/plain'), (101, 'Listusers', 'Special page', 0, 0, 'text/plain'), (101, 'Listguests', 'Special page', 0, 0, 'text/plain'), (101, 'ListTemplates', 'Special page', 0, 0, 'text/plain'), (101, 'ListRss', 'Special page', 0, 0, 'text/plain'), (101, 'Search', 'Special page', 0, 0, 'text/plain'), (101, 'Sitemap', 'Special page', 0, 0, 'text/plain'), (101, 'Specialpages', 'Special page', 0, 0, 'text/plain'), (101, 'Contributions', 'Special page', 0, 0, 'text/plain'), (101, 'Emailuser', 'Special page', 0, 0, 'text/plain'), (101, 'Undelete', 'Special page', 0, 0, 'text/plain'), (101, 'Popularpages', 'Special page', 0, 0, 'text/plain'), (101, 'DeleteAll', 'Special page', 0, 0, 'text/plain'), (101, 'Watchlist', 'Special page', 0, 0, 'text/plain'), (101, 'Statistics', 'Special page', 0, 0, 'text/plain')" failed with error code "Field 'page_text' doesn't have a default value

Any ideas?
Thanks!

Hey Mike_Smith - Could you try editing your mysql config (my.ini on windows) and remove the STRICT_TRANS_TABLES sql-mode?

change:
sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
to:
sql-mode="NO_ENGINE_SUBSTITUTION"

Then restart mysql and try again?

Thanks,
pete

[Mike_Smith]

wow thats insane! I dunno where you guys pull these solutions from :p, but they work! Awesome stuff! Thanks PeteE :) Works great now :D

[royk]

wow thats insane! I dunno where you guys pull these solutions from :p, but they work! Awesome stuff! Thanks PeteE :) Works great now :D

pete's our resident genius :)

[SteveB]

Thumbs up for Pete indeed! :)