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', '[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! >:(
Was your phpbb forum heavily modded?
Not really, but why would that cause an error like that?
Try using the converter in this topic: phpBB 2.0.19+ (http://www.simplemachines.org/community/index.php?topic=142124)
Quote from: JayBachatero on January 14, 2007, 09:09:05 PM
Try using the converter in this topic: phpBB 2.0.19+ (http://www.simplemachines.org/community/index.php?topic=142124)
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'
What version of SMF are you using?
phpBB 2.0.21 and SMF 1.0.7
Uograde to SMF 1.1.1.
Oh ok thanks. I used the Zantastica tool with my webhost, I guess they haven't updated yet.