Help with phpBB > SMF

[BlazingFire456]

Hi everyone.  I want to convert my phpBB board to SMF.  However when I tried to convert it, I got this error:

Code Select Expand

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:

    INSERT INTO `sailormoonzone_forum`.smf_members
    (ID_MEMBER, memberName, realName, passwd, lastLogin, dateRegistered, location, posts, ID_GROUP, instantMessages, emailAddress, unreadMessages, MSN, AIM, ICQ, YIM, websiteTitle, websiteUrl, showOnline, timeOffset, hideEmail, avatar, signature, pm_email_notify, is_activated, lngfile, buddy_list, pm_ignore_list, messageLabels, personalText, timeFormat, usertitle, memberIP, secretQuestion, secretAnswer, validation_code, additionalGroups, smileySet, passwordSalt, memberIP2)
    VALUES ('2', 'Blaze', 'Blaze', '253dceeedd6ee339926a39e206ed9916', '1168299929', '1166028238', 'Suffolk, VA', '12', '1', '0', '[email protected]', '0', '[email protected]', 'BlazingFire365', '', '', 'http://sailormoonzone.ifastnet.com', 'http://sailormoonzone.ifastnet.com', '1', '0', '0', '', '\'m bored', '1', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('3', 'Aeris', 'Aeris', 'dbc35b433666fa97c5225de465ab9eef', '0', '1166715126', '', '0', '', '0', '[email protected]', '0', '', '', '', '', '', '', '0', '6', '1', '', '', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('4', 'Aeris_6', 'Aeris_6', '2b017373fe5c5bb6b6ff1ce29b157909', '0', '1166715356', '', '0', '', '0', '[email protected]', '0', '', '', '', '', '', '', '0', '6', '1', '', '', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('5', 'neoprincessjupiter', 'neoprincessjupiter', '3a4b5f2f801ada677ac11ce2db032f1c', '0', '1167342236', 'jupiter', '0', '', '0', '[email protected]', '0', '[email protected]', 'redhsoe231323@ao', '', '', 'http://youtube.com/neoprincessjupiter', 'http://youtube.com/neoprincessjupiter', '1', '0', '1', '', 'lita kino', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('6', 'babygurl_aic', 'babygurl_aic', '65b74f3db3e2f34260e99052a355ef15', '0', '1167780101', '', '0', '', '0', '[email protected]', '0', '', '', '', '', '', '', '1', '0', '1', '', '', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('7', 'moneymaker_aic', 'moneymaker_aic', '6264ff3353d5b83fb82ed9dac6f90c99', '0', '1167780187', '', '0', '', '0', '[email protected]', '0', '', '', '', '', '', '', '1', '0', '1', '', '', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('8', 'theobin', 'theobin', 'ba9f9c72cb0514a4c9724d7de2289c3f', '0', '1168086358', '', '0', '', '0', '[email protected]', '0', '', '', '', '', '', '', '1', '0', '1', '', '', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('9', 'binbinboy', 'binbinboy', 'ba9f9c72cb0514a4c9724d7de2289c3f', '0', '1168086656', '', '0', '', '0', '[email protected]', '0', '', '', '', '', '', '', '1', '0', '1', '', '', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

Caused the error:

    Unknown column 'pm_email_notify' in 'field list'

Anyone know what's up?  I tried clicking Try Again, but same error! 

[The Ghost 14]

Was your phpbb forum heavily modded?

[BlazingFire456]

Not really, but why would that cause an error like that?

[JayBachatero]

Try using the converter in this topic: phpBB 2.0.19+

[BlazingFire456]

Try using the converter in this topic: phpBB 2.0.19+

I tried that, but I got a new error now:

Code Select Expand

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:

    INSERT INTO `sailormoonzone_forum`.smf_attachments
    (ID_MSG, ID_MEMBER, filename, attachmentType)
    VALUES (0, 2, SUBSTRING('avatar_2.jpg', 1, 255), 0);

Caused the error:

    Unknown column 'attachmentType' in 'field list'

[JayBachatero]

What version of SMF are you using?

[BlazingFire456]

phpBB 2.0.21 and SMF 1.0.7

[JayBachatero]

Uograde to SMF 1.1.1.

[BlazingFire456]

Oh ok thanks.  I used the Zantastica tool with my webhost, I guess they haven't updated yet.