Mybb 1.4 > SMF problems

Started by werewolfhero, October 04, 2008, 10:41:27 PM

Previous topic - Next topic

werewolfhero

Converting...
Converting members... Unsuccessful!


Caused the error:

Field 'lngfile' doesn't have a default value

(didnt include the query with usernames/emails)

ThorstenE

seems to be a mysql strict specific error ..

edit the mybb14x_to_smf.sql

findSUBSTRING(buddylist, 1, 255) AS buddy_list,

replace with
SUBSTRING(buddylist, 1, 255) AS buddy_list, '' AS lngfile,

werewolfhero

still no go....


Converting...
Converting members... Unsuccessful!
This query:
INSERT INTO `werewolfhero`.smf_members


Caused the error:

Field 'messageLabels' doesn't have a default value

and i'm using the sql and the convert.php linked here http://www.simplemachines.org/community/index.php?topic=256073.0

ThorstenE

please try the attached version. This should also work in mysql strict mode..

werewolfhero

Thank you, it worked this time n.n

Advertisement: