• Welcome to Simple Machines Community Forum. Please login or sign up.
September 27, 2021, 08:16:48 AM

News:

Want to get involved in developing SMF, then why not lend a hand on our github!


Help with phpBB > SMF

Started by BlazingFire456, January 14, 2007, 07:43:28 PM

Previous topic - Next topic

BlazingFire456

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

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', 'blazingfire456@gmail.com', '0', 'blazingfire456@gmail.com', 'BlazingFire365', '', '', 'http://sailormoonzone.ifastnet.com', 'http://sailormoonzone.ifastnet.com', '1', '0', '0', '', '\'m bored', '1', '1', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('3', 'Aeris', 'Aeris', 'dbc35b433666fa97c5225de465ab9eef', '0', '1166715126', '', '0', '', '0', 'Maria.Paakyla@jippii.fi', '0', '', '', '', '', '', '', '0', '6', '1', '', '', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('4', 'Aeris_6', 'Aeris_6', '2b017373fe5c5bb6b6ff1ce29b157909', '0', '1166715356', '', '0', '', '0', 'pikkumisu_6@hotmail.com', '0', '', '', '', '', '', '', '0', '6', '1', '', '', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('5', 'neoprincessjupiter', 'neoprincessjupiter', '3a4b5f2f801ada677ac11ce2db032f1c', '0', '1167342236', 'jupiter', '0', '', '0', 'angel_of_death1519@hotmail.com', '0', 'angel_of_death1519@hotmail.com', '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', 'babygurl_aic@yahoo.com', '0', '', '', '', '', '', '', '1', '0', '1', '', '', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('7', 'moneymaker_aic', 'moneymaker_aic', '6264ff3353d5b83fb82ed9dac6f90c99', '0', '1167780187', '', '0', '', '0', 'moneymaker@yahoo.com', '0', '', '', '', '', '', '', '1', '0', '1', '', '', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('8', 'theobin', 'theobin', 'ba9f9c72cb0514a4c9724d7de2289c3f', '0', '1168086358', '', '0', '', '0', 'whitelighter_lightsdesky@hotmail.com', '0', '', '', '', '', '', '', '1', '0', '1', '', '', '1', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('9', 'binbinboy', 'binbinboy', 'ba9f9c72cb0514a4c9724d7de2289c3f', '0', '1168086656', '', '0', '', '0', 'elder_lightsdesky@hotmail.com', '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+
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

BlazingFire456

Quote from: JayBachatero on January 14, 2007, 09:09:05 PM
Try using the converter in this topic: phpBB 2.0.19+

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

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?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

BlazingFire456


JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

BlazingFire456

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

Advertisement: