I got the above error in the subject line while trying to change from Berkeley DB to mysql. This I am doing in preparation for an upgrade to MT4.01 (from MT3.35). I've used both http://code.as-is.net/public/wiki/MT_Database_Converter and mt-db2sql.cgi to attempt this; both show pretty much the same warnings and errors. Full paths have been scrubbed from the paste-in below.
Before the conversion process begins, I get:
**** WARNING: Subroutine template redefined at **********cgi-bin/movabletype/plugins/nofollow/nofollow.pl line 49.
**** WARNING: Subroutine config redefined at **********cgi-bin/movabletype/plugins/nofollow/nofollow.pl line 63.
**** WARNING: Subroutine nofollowfy_hdlr redefined at **********cgi-bin/movabletype/plugins/nofollow/nofollow.pl line 77.
**** WARNING: Subroutine nofollowfy redefined at **********cgi-bin/movabletype/plugins/nofollow/nofollow.pl line 137.
After the conversion attempt, I get:
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in unpack at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in substr at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: Use of uninitialized value in addition (+) at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 196.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 241.
**** WARNING: Use of uninitialized value in exists at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 242.
**** WARNING: Use of uninitialized value in hash element at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 197.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in unpack at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in substr at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: Use of uninitialized value in addition (+) at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 196.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 241.
**** WARNING: Use of uninitialized value in exists at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 242.
**** WARNING: Use of uninitialized value in hash element at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 197.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in unpack at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in substr at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: Use of uninitialized value in addition (+) at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 196.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 241.
**** WARNING: Use of uninitialized value in exists at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 242.
**** WARNING: Use of uninitialized value in hash element at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 197.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in unpack at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in substr at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: Use of uninitialized value in addition (+) at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 196.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 241.
**** WARNING: Use of uninitialized value in exists at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 242.
**** WARNING: Use of uninitialized value in hash element at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 197.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in unpack at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in substr at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: Use of uninitialized value in addition (+) at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 196.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 241.
**** WARNING: Use of uninitialized value in exists at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 242.
**** WARNING: Use of uninitialized value in hash element at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 197.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in unpack at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in substr at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: Use of uninitialized value in addition (+) at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 196.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 241.
**** WARNING: Use of uninitialized value in exists at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 242.
**** WARNING: Use of uninitialized value in hash element at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 197.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in unpack at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 194.
**** WARNING: Use of uninitialized value in substr at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 195.
**** WARNING: Use of uninitialized value in addition (+) at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 196.
**** WARNING: substr outside of string at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 241.
**** WARNING: Use of uninitialized value in exists at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 242.
**** WARNING: Use of uninitialized value in hash element at **********cgi-bin/movabletype/lib/MT/Serialize.pm line 197.
**** WARNING: Use of uninitialized value in print at **********cgi-bin/movabletype/mt-db2sql.cgi line 87.
An error occurred while loading data:
Insertion test failed on SQL error Column 'entry_blog_id' cannot be null
Any ideas?
For the record, I have tried disabling the nofollow plugin (albeit I think I have), but that only got rid of the warnings before the conversion attempt.
Thanks,
Jonathan.