DB Conversion Error

[Mike_Smith]

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

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

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 , but they work! Awesome stuff! Thanks PeteE Works great now

[royk]

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

pete's our resident genius

[SteveB]

Thumbs up for Pete indeed!