1.1 Converters

[Compuart]

Try replacing (phpbb2_to_smf.sql)

Code Select Expand

---* {$to_prefix}boards
SELECT
forum_id AS ID_BOARD, forum_order AS boardOrder, forum_posts AS numPosts,
forum_last_post_id AS ID_LAST_MSG, forum_name AS name, cat_id AS ID_CAT,
forum_desc AS description, forum_topics AS numTopics,
CASE auth_read
WHEN 0 THEN '-1,0,2'
WHEN 1 THEN '0,2'
WHEN 3 THEN '2'
ELSE ''
END AS memberGroups
FROM {$from_prefix}forums;
---*

by:

Code Select Expand

---* {$to_prefix}boards
SELECT
forum_id AS ID_BOARD, forum_order AS boardOrder, forum_posts AS numPosts,
forum_last_post_id AS ID_LAST_MSG, forum_name AS name, cat_id AS ID_CAT,
forum_desc AS description, forum_topics AS numTopics,
CASE auth_read
WHEN 0 THEN '-1,0,2'
WHEN 1 THEN '0,2'
WHEN 3 THEN '2'
ELSE ''
END AS memberGroups
FROM {$from_prefix}forums
WHERE forum_id > 0;
---*

[MysticBrewing]

well... got past that error and got this one..... the good news is... all teh posts have converted over..... so this may not be a major error....other than board permissions... and those can be changed manualy if needed

Code Select Expand

Converting board access... Unsuccessful!
This query:

    INSERT INTO `reality_smf1`.smf1_board_permissions
    (ID_GROUP, ID_BOARD, permission)
    VALUES
    (-1, -99, 'post_new'),
    (-1, -99, 'mark_notify'),
    (-1, -99, 'mark_any_notify'),
    (-1, -99, 'post_reply_any'),
    (-1, -99, 'modify_own'),
    (-1, -99, 'make_sticky'),
    (-1, -99, 'announce_topic'),
    (-1, -99, 'remove_own'),
    (-1, -99, 'delete_own'),
    (-1, -99, 'poll_vote'),
    (-1, -99, 'poll_view'),
    (-1, -99, 'poll_post'),
    (-1, -99, 'poll_add_own'),
    (0, -99, 'post_new'),
    (0, -99, 'mark_notify'),
    (0, -99, 'mark_any_notify'),
    (0, -99, 'post_reply_any'),
    (0, -99, 'modify_own'),
    (0, -99, 'make_sticky'),
    (0, -99, 'announce_topic'),
    (0, -99, 'remove_own'),
    (0, -99, 'delete_own'),
    (0, -99, 'poll_vote'),
    (0, -99, 'poll_view'),
    (0, -99, 'poll_post'),
    (0, -99, 'poll_add_own'),
    (2, -99, 'post_new'),
    (2, -99, 'mark_notify'),
    (2, -99, 'mark_any_notify'),
    (2, -99, 'post_reply_any'),
    (2, -99, 'modify_own'),
    (2, -99, 'make_sticky'),
    (2, -99, 'announce_topic'),
    (2, -99, 'remove_own'),
    (2, -99, 'delete_own'),
    (2, -99, 'poll_vote'),
    (2, -99, 'poll_view'),
    (2, -99, 'poll_post'),
    (2, -99, 'poll_add_own'),
    (3, -99, 'post_new'),
    (3, -99, 'mark_notify'),
    (3, -99, 'mark_any_notify'),
    (3, -99, 'post_reply_any'),
    (3, -99, 'modify_own'),
    (3, -99, 'make_sticky'),
    (3, -99, 'announce_topic'),
    (3, -99, 'remove_own'),
    (3, -99, 'delete_own'),
    (3, -99, 'poll_vote'),
    (3, -99, 'poll_view'),
    (3, -99, 'poll_post'),
    (3, -99, 'poll_add_own');

Caused the error:

    Duplicate entry '-1-0-poll_view' for key 1

[Compuart]

replace (phpbb2_to_smf.sql)

Code Select Expand

$request = convert_query("
SELECT
CASE auth_post WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_post,
CASE auth_reply WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_reply,
CASE auth_edit WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_edit,
CASE auth_sticky WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_sticky,
CASE auth_announce WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_announce,
CASE auth_delete WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_delete,
CASE auth_vote WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_vote,
CASE auth_pollcreate WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_pollcreate,
forum_id AS ID_BOARD
FROM {$from_prefix}forums");

by:

Code Select Expand

$request = convert_query("
SELECT
CASE auth_post WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_post,
CASE auth_reply WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_reply,
CASE auth_edit WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_edit,
CASE auth_sticky WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_sticky,
CASE auth_announce WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_announce,
CASE auth_delete WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_delete,
CASE auth_vote WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_vote,
CASE auth_pollcreate WHEN 0 THEN '-1,0,2,3' WHEN 1 THEN '0,2,3' WHEN 3 THEN '2,3' ELSE '' END AS auth_pollcreate,
forum_id AS ID_BOARD
FROM {$from_prefix}forums
WHERE forum_id > 0");

[MysticBrewing]

thank you soooooo much... conversion complete... you just made one of my customers VERY happy

[Compuart]

Glad I could help

[Twistey]

I have problem with converting Mercuryboard 1.1.4 to SMF it says smf_personal_messages isnt there so it can't convert the personal messages to SMF..

[Compuart]

Strange, can you confirm the table does exist? It should in a default install of SMF. Also can you paste the exact error?

[Twistey]

sorry had 1.0.5 ...

[graffixjones]

First off, thanks for all the hard work.  It's much appreciated.

However, I'm having a little problem with the vbulletin_to_smf.sql converter (for vbulletin 2.x).  At one point in the conversion (when it's converting posts), I get a huge dump to the browser window, and at the bottom it says: error 'Got a packet bigger than 'max_allowed_packet'.

The posts contain several jpeg attachments, and after a bit of searching, I determined that it's exceeding the max_packet_size setting on mysqld, but unfortunately I don't think there's a way I can change that on our server.

Is there a way to split the sql INSERTS into smaller chunks so that I don't run into this problem?

Thanks.

[graffixjones]

Well, I was able to work around the problem on my local computer by typing:

SET GLOBAL max_allowed_packet = 16 * 1024 * 1024; (16MB)

but I wonder if it would be possible to simply include:

SET max_allowed_packet = 16 * 1024 * 1024; (or something similar)

to the beginning of the .sql file?  Since max_allowed_packet is a dynamic runtime variable, and the script is already running as an authorized user, could it be as simple as that?

I'm not sure why I've ran into this problem and it doesn't seem that anybody else has, but it occurs with both vbulletin 2.x and 3.x converters (I also tried it on a database converted to vB 3.x).

Thanks.

[Vranx]

Im trying to convert from phpbb 2.0.10 to smf 1.1rc1. I tried both the default download on page one of this thread and a modified version using the changes above this post on page 14. I still get an error when trying to convert topics:

Duplicate entry '34026-4' for key 2

If I click the retry button I get this, over and over:

Duplicate entry '2083' for key 1

I searched my phpbb_topics table for 34026-4 and couldnt find it. Any ideas?

[Vranx]

I found the duplicate entry. Got my forum converted.

[MaximusDM]

Hello all 

I have this problem when i try to convert phpBB 2.0.17 to SMF 1.1 RC1 :

Converting...
Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS ID_MEMBER, u.username AS memberName, u.username AS realName,
u.user_password AS passwd, u.user_lastvisit AS lastLogin,
u.user_regdate AS dateRegistered, u.user_from AS location,
u.user_posts AS posts, IF(u.user_level = 1, 1, hxxp:mg.id [nonactive]_GROUP) AS ID_GROUP,
u.user_new_privmsg AS instantMessages, u.user_email AS emailAddress,
u.user_unread_privmsg AS unreadMessages, u.user_msnm AS MSN,
u.user_aim AS AIM, u.user_icq AS ICQ, u.user_yim AS YIM,
u.user_website AS websiteTitle, u.user_website AS websiteUrl,
u.user_allow_viewonline AS showOnline, u.user_timezone AS timeOffset,
IF(u.user_viewemail = 1, 0, 1) AS hideEmail, u.user_avatar AS avatar,
REPLACE(u.user_sig, '\n', '<br />') AS signature,
u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
u.user_notify_pm AS pm_email_notify, u.user_active AS is_activated
FROM `phpbb`.phpbb_users AS u
LEFT JOIN `phpbb`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN `smf`.smf_membergroups AS mg ON (mg.groupName = CONCAT('phpBB ', r.rank_title))
WHERE u.user_id != -1
GROUP BY u.user_id
LIMIT 0, 500;
Caused the error:

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Is there somewone who had an idea ?

P.S. : sorry for my english 

[Compuart]

Can you try replacing (phpbb2_to_smf.sql):

Code Select Expand

LEFT JOIN {$to_prefix}membergroups AS mg ON (mg.groupName = CONCAT('phpBB ', r.rank_title))
by:

Code Select Expand

LEFT JOIN {$to_prefix}membergroups AS mg ON (SUBSTRING(mg.groupName, 7) = r.rank_title)


[MaximusDM]

No, always the same problem 

[Compuart]

These collation problems always cause headaches

If you like, I can look into it. In that case, PM me the access data to phpMyAdmin and I'll try to see where the collation problem originates from and how it can be solved.

[MaximusDM]

I send you a pm 

[vostok4]

I'm having some troubles in importing phpBB 2.0.10 to 1.1 RC1 using the importer revolving around groups and ranks.

The convertor is importing all the ranks as groups, and it is setting the user's ID_GROUP to their RANKID, so that the real groups I have created are not populated like they should be. Is it possible to remove the importing of the ranks, and not use the rankid as the groupID so that it only imports the user's group as their group?

Let me just explain whats happening:

I have 4 groups in phpBB and about 10 ranks.

When I convert phpBB data -> SMF, the 4 groups show up with their regular names in the memberGroups table, and the ranks showup with the prefix "phpBB ". The problem is, is that the 4 groups have 0 members in them, while everyone who was assigned a custom rank now retains that as their group, so the ranks are being transformed into groups when this should not be the case.

Seeing as SMF does not have a rank system (where you can just select from a list a user's rank, something that has no effect on their permissions), the ranks (at least it seems this way) should not be imported at all...

*EDIT*

OK, I have edited the file to fix this issue, but now I have an issue with avatars that were selected as "uploaded by the user" to phpBB. The image source is the link to dlattach option of attachments, and that is not right. For now I am just removing those user's avatars.

[maharg]

Has anyone tried doing a vbulletin3 conversion to 1.1RC1? I have it not copying any posts over at all, and refusing to put any of the forums in the correct categories -- instead they go into the recovered forums area, despite the fact that in the database the correct categories seem to have been created. No errors are reported (Successful!) until it gets to stats recalculating forum statistics, at which point it gives a completely unrelated one about the IMs:

Code Select Expand


     SELECT mem.ID_MEMBER, COUNT(pmr.ID_PM) AS realNum, mem.instantMessages
     FROM members AS mem
     LEFT JOIN pm_recipients AS pmr ON (mem.ID_MEMBER = pmr.ID_MEMBER AND pmr.deleted = 0)
     GROUP BY mem.ID_MEMBER
     HAVING realNum != instantMessages;

     No database selected


I have no problem with the stats error, as smf seems perfectly capable of rebuilding its own stats anyways. It's the other stuff that's not working.

Unfortunately, because the database is very very large (about 2.0GB) and the site is a live one (so I can only do this during the nightly cron), it's very difficult to diagnose problems with it.

[melodiq]

I am getting this error with converting from Vbulletin 3 to SMF... it happens during Converting Posts...

Caused the error:

    MySQL server has gone away