Print Page - Mybb 1.4 > SMF problems

Title: Mybb 1.4 > SMF problems
Post by: werewolfhero on October 04, 2008, 10:41:27 PM

Converting...
Converting members... Unsuccessful!

Caused the error:

Field 'lngfile' doesn't have a default value

(didnt include the query with usernames/emails)

Title: Re: Mybb 1.4 > SMF problems
Post by: ThorstenE on October 05, 2008, 04:03:29 AM

seems to be a mysql strict specific error ..

edit the mybb14x_to_smf.sql

find

Code Select

SUBSTRING(buddylist, 1, 255) AS buddy_list,

replace with

Code Select

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

Title: Re: Mybb 1.4 > SMF problems
Post by: werewolfhero on October 05, 2008, 04:17:47 AM

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

Title: Re: Mybb 1.4 > SMF problems
Post by: ThorstenE on October 05, 2008, 07:48:11 AM

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

Title: Re: Mybb 1.4 > SMF problems
Post by: werewolfhero on October 05, 2008, 11:02:06 PM

Thank you, it worked this time n.n

Simple Machines Community Forum

SMF Support => Converting to SMF => MyBB => Topic started by: werewolfhero on October 04, 2008, 10:41:27 PM