1.1 Converters

[CMDR-ZOD]

Only god knows why phpBB does something like it does but it wasnt my choice when we took that for our forum. Now same thing but different entry. I truncated the table by hand and the same error appeared again.

Code Select Expand

Converting posts (this may take some time)... Successful.
Converting polls...Successful.
Converting polls options...Successful.
Converting polls options... Unsuccessful!
This query:

    INSERT INTO `v030320`.smf_log_polls
    (ID_POLL, ID_MEMBER)
    VALUES ('102', '2293'),
    ('99', '2293'),
    ('100', '2294'),
    ('110', '2294'),
    ('76', '2295'),
Caused the error:

    Duplicate entry '81-2297-0' for key 1

[Tomer]

vbulletin3 = > SMF Converter not working correctly. It screws up with errors on the converting avatars part.

- Tomer

Works fine for me and has worked for others.  Are you certain you are using a recent convert.php *and* vbulletin3_to_smf.sql file?  Both have been updated more than once.  If so, post the errors.

It may just be missing avatars.

Here are the errors.

Converting members...Successful.
Converting categories...Successful.
Converting boards...Successful.
Converting topics...Successful.
Converting posts (this may take some time)...Successful.
Converting polls...Successful.
Converting poll options...
Notice: Undefined offset: 4 in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 6
Successful.
Converting poll votes...Successful.
Converting personal messages (step 1)...Successful.
Converting personal messages (step 2)...Successful.
Converting topic notifications...Successful.
Converting board notifications...Successful.
Converting smileys...Successful.
Converting attachments...Successful.
Converting avatars...
Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33

Parse error: parse error, unexpected '}' in /home/sdesignz/public_html/smf/convert.php(758) : eval()'d code on line 33
Unsuccessful!
This query:

    INSERT INTO `sdesignz_smf1`.smf_attachments
    (ID_MEMBER, avatardata, filename, avatarrevision)
    VALUES ('1', '�״�א\0JFIF\0
\0\0d\0d\0\0�ל\0Ducky\0
\0\0\0\0P\0\0�מ\0Adobe\0dְ\0\0\0
��\0,,\0

    
 
     
    �ְ\0\0P\0P
\0

�ִ\0©\0\0




\0\0\0\0\0\0\0\0\0 \0
\0


\0\0\0\0\0\0\0\0\0\0\0
\0
 \0\0\0\0
\0!1AQ\"q2a�¡ׁB±ֱbנ'3בR,#c4\'\0
\0\0\0\0
\0!1AQa�'\"נq±ֱׁ¡בR'2Bbr,C²#3¢S4��\0
\0\0?\0שץeֲ1K־
‹ֻkµG÷ַ²[_¼��Sן¶¨�«ך'¾QYו¾�׳z׳c�R@׃ .�¸8gYיnֹ\\5R˜ץ�™­״"H—‡Z[¨גּU@eֳZ�
    �ץ(׳L!�א
Lmמ$—R��}´צ·¼�-נ,,�9W1ײiCj<ׂ�
    ס<\05#©�§Pק9ל¬­ו�±...ׁ...!gצGjחR·‎Dׂ5¡־GqS�kַ·u�3��ƒ��וGzBם¬,,{¨וֹ –ק>�1´tםikc:˜ˆIג�´,²]0�\\ל
    fs –>�בwEs^±;]¿†¢

   ....more and more of this gibberish...

Thanks for looking at it.

- Tomer

[Pakistani]

I have the 1.0.5 version of SMF as the new 1.1 version is in beta stages. Can I use the Invision Power Board ( 1.3 ) coverter to convert from Invision Power Board 1.3 to SMF 1.0.5 ?

[Chelle]

Unknown: wow, quick response    It says this:

Database query: (skipped)

You are definitely using a very old version of the convert.php file.



-[Unknown]

Wow, that just really stirs my grits...I could have had my board converted by now.  Alright, Dunno how I did that..but I DLed it from this thread.  I'm hoping this is the updated one, and I'll give it a go.  Thanks!

[[Unknown]]

Only god knows why phpBB does something like it does but it wasnt my choice when we took that for our forum. Now same thing but different entry. I truncated the table by hand and the same error appeared again.

I've attached another converter.  Sorry for all the trouble.

Tomer, I've attached one for you as well.

I have the 1.0.5 version of SMF as the new 1.1 version is in beta stages. Can I use the Invision Power Board ( 1.3 ) coverter to convert from Invision Power Board 1.3 to SMF 1.0.5 ?

You can use the one from the downloads page, but not the one here.

-[Unknown]

[CMDR-ZOD]

Now an error because vote_option_id dosnt exist in that table. That table only contains who voted not what he voted for.

Code Select Expand

Converting poll votes... Unsuccessful!
This query:

    SELECT vote_id AS ID_POLL, vote_user_id AS ID_MEMBER
    FROM `v030320`.iw_vote_voters
    WHERE vote_user_id > 0
    GROUP BY vote_id, vote_option_id
    LIMIT 0, 500;

Caused the error:

    Unknown column 'vote_user_id' in 'field list'

table vote_voters
vote_id
vote_user_id
vote_user_ip

table vote_results
vote_id
vote_option_id
vote_option_text
vote_result

table vote_desc
vote_id
topic_id
vote_text
vote_start
vote_length



Hope this might help. Im away for the weekend if you, probably you will much earlier, finish the next fix it will take some time for me to respond.
Have a nice one too.

[[Unknown]]

Change "option_id" to "user_id" there.

-[Unknown]

[CMDR-ZOD]

I manually fixed 2 other errors of the same type with group by.

http://www.geezod.de/storage/phpbb2_to_smf.sql [nofollow]

Works fine with me now. Everything seems to be converted very well. Only problem my 100 message where 100 are new arent getting markes as read. But thats nothing for this forum i think. Thanks again for the quick responses. Are you rentable as support bot? *g*

[Tomer]

Excellent! Thanks a lot!

- Tomer

[Hamsterpants]

Where are the latest versions of these converters, specifically for phpbb to smf 1.1. I tried dl the ones at the start of this topic, but files cant be found?

Thanks in advance.
Dill

[tentronik]

Cant find phpBB2 to SMF 1.1 converter the link from 1st page gives a 404.
And the file from the official download section is not 1.1 compatible.

I try to convert phpbb2 2.016 with 1 security fix as a mambo component (com_forum) to convert to SMF

404 error URL

[[Unknown]]

I've uploaded new ones.  I expect this is a side effect from the recent server maintenance problem.

-[Unknown]

[tentronik]

The convert.php script and phpbb_smf.sql i guess works but i did something wrong so im not sure if its basicly not compatible but i get error:

Code Select Expand

Notice: Undefined variable: Itemid in /customers/xxxxxxx/httpd.www/components/com_forum/extension.inc on line 30

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: Table 'xxxxxxx.phpbb_users' doesn't exist

I tried converting from a mambo phpbb com_forum component.
Anyway i start from scratch now(20 user lost).

[tentronik]

Well i tried to recreate the  mos_user table to phpbb_user and when i then run the script i get:

Code Select Expand

Converting...
Converting ranks...Successful.
Converting groups...Successful.
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, mg.ID_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 `xxxxx`.phpbb_users AS u
    LEFT JOIN `xxxxxx`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `xxxxxx`.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:

    Unknown column 'u.user_id' in 'field list'

Ok i will try another way to restore the data - i just bridge :-p

[[Unknown]]

I'm afraid for the members you're going to want to cobble together the SimpleBoard and phpBB converters.

-[Unknown]

[davo88]

pbpbb v2.0.16 to smf

Just did two test runs of the converter - one using convert.php and phpbb2_to_smf.sql downloaded from page 1 of this thread on 17th July.
It gave this result.

Code Select Expand

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting poll questions... Successful.
Converting polls options... Successful.
Converting polls options... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting avatar gallery images... Successful.
Converting censored words... Successful.
Converting reserved names... Successful.
Converting banned users... Successful.
Converting settings... Successful.
Converting attachment mod (if installed)... Successful.
Recalculating forum statistics... Successful.

Conversion Complete

Then ran the conversion again using the latest (about 3hours ago) convert.php and phpbb2_to_smf.sql and got this result.

Code Select Expand

Converting...
Converting ranks...Successful.
Converting groups...Successful.
Converting members...Successful.
Converting additional member groups...Successful.
Converting categories...Successful.
Converting boards...Successful.
Converting topics...Successful.
Converting posts (this may take some time)...Successful.
Converting polls...Successful.
Converting poll options...Successful.
Converting poll votes...Successful.
Converting personal messages (step 1)...Successful.
Converting personal messages (step 2)...Successful.
Converting topic notifications...Successful.
Converting board access...Successful.
Converting group access...Successful.
Converting moderators...Successful.
Converting avatar gallery images...Successful.
Converting censored words...Successful.
Converting reserved names...Successful.
Converting banned users...Successful.
Converting settings...
Parse error: parse error, unexpected ']' in /home/httpd/vhosts/my_domain.com/httpdocs/test1/convert.php(627) : eval()'d code on line 9
Error in convert script phpbb2_to_smf.sql on line 832!
Successful.
Converting attachment mod (if installed)... Successful.
Recalculating forum statistics... Successful.

Conversion Complete

So just wondering whether I should stick with the July 17th version? - maybe it likes my data better. 

Dave

ps ... left out a bit of info. Actually ran the scripts three times - first July 17th version, then latest, then July 17th again. Both July 17th runs gave the same result.

[[Unknown]]

Try the latest now.

-[Unknown]

[Hasif]

is this possible to convert punbb 1.2.6 to smf. or only 1.2.5 please let me know it is argent for me because i am facing some bugs on my punbb forum.

[[Unknown]]

It should work for both versions.  If you get any errors, please post them here.

-[Unknown]

[davo88]

Try the latest now.

-[Unknown]

Similar error...


Converting settings...
Parse error: parse error, unexpected ':', expecting ')' in /home/httpd/vhosts/my_domain.com/httpdocs/test1/convert.php(627) : eval()'d code on line 12
Error in convert script phpbb2_to_smf.sql on line 832!
Successful.


Everything else says "successful". Thought it might have something to do with the theme and data I had installed. But dropped all the SMF tables, re-installed 1.1 and it did the same.

Davo