1.1 Converters

[apc]

I sorted it out; had to add the smf user to the phpbb database.

Looks like it is working 

Thanks for your assistance!

[Harzem]

Your SMF database user should have access to phpBB2 database. Set it via cPanel if you have.

[CoasterJoe.com]

I'm converting from Ikonboard 3.1.2 to smf and I get this error message any ideas?

Converting poll logs... Successful.
Converting personal messages (step 1)... Unsuccessful!
This query:

    TRUNCATE `floridac_mambo`.smf_personal_messages;

Caused the error:

    Table 'floridac_mambo.smf_personal_messages' doesn't exist

[Harzem]

It seems you don't have a proper SMF installation, since there are missing tables in your SMF database.

Try re-installing a fresh copy of SMF and convert again.

[danialdabiri]

Hi,
I wanna Convert phpBB2 to SMF
upload convert.php and phpbb2_to_smf.sql , enter path of smf and phpbb and SMF Database password , but say

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: SELECT command denied to user: 'irooni_danial@localhost' for table 'phpbb_users'

Please Help me for this problem

[apc]

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: SELECT command denied to user: 'irooni_danial@localhost' for table 'phpbb_users'
Please Help me for this problem

Add your smf database user to your PHPBB database and it should work.

[danialdabiri]

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: SELECT command denied to user: 'irooni_danial@localhost' for table 'phpbb_users'
Please Help me for this problem

Add your smf database user to your PHPBB database and it should work.

Thanks a lot 

[CoasterJoe.com]

It seems you don't have a proper SMF installation, since there are missing tables in your SMF database.

Try re-installing a fresh copy of SMF and convert again.

I tried this with the same result. Any other thoughts?

[Mystique]

Go to THIS http://www.simplemachines.org/community/index.php?topic=65677.0;all thread and the first post is a converter file. ITS THE ONE YOU SHOULD USE. as the one listed at the beginning of this topic.. won't work. The other thread has the better convert.php file to use as it was fixed because the one listed on this topic had a ton of missing stuff. It may work with older versions of php but it won't work with the newest php versions of 2.0.18, 19 or 20. So, get the convert.php file from that other thread I posted and make sure you also get the phpbb2_to_smf.sql file as well and follow the directions.

[Xniver]

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: SELECT command denied to user: 'irooni_danial@localhost' for table 'phpbb_users'
Please Help me for this problem

Add your smf database user to your PHPBB database and it should work.

I use DirectAdmin ,and i cant add smf user to ipb db HELP 

[Oldiesmann]

If you can't add the SMF user to the IPB database, then you will have to either move the SMF tables to the IPB database or move the IPB tables to the SMF database.

[dincer04]

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... Successful.
Converting attachment mod (if installed)... Successful.
Recalculating forum statistics... Unsuccessful!
This query:
UPDATE `swgsehir`.smf_boards
SET ID_LAST_MSG = 3089, lastUpdated = 1145280734
WHERE ID_BOARD = 1
LIMIT 1;
Caused the error:

Unknown column 'lastUpdated' in 'field list'



help me please

[Harzem]

You've already finished converting You have one last step to do:

Admin > Forum Maintenance > "Recalculate forum totals and statistics"

or

Admin > Forum Bakımı > "İstatistikleri ve forum toplamını yeniden say."

[dincer04]

thanks sipa sive

your another before post reading



(daha önce yazmışssın yeni gordum 14. page) teşekkürler

[desertlavender]

From reading through the posts below, is it fair to assume that attempting to import data from an old phpbb1 bulletin board is probably not a good idea, especially for someone with limited programming ability?  Thanks!

[Harzem]

No, you don't need programming at all. Just use the appropriate converter. What made you think not to convert?

Edit: Wow, post #2222

[Holly]

Hi !!
THANKS!

[SKY-Yoshi]

I have a problem with converting my IPB 2.1.3 to SMF 1.1 RC2.

Converting...
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... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Notice: unserialize(): Error at offset 5 of 160 bytes in /home/kaktus/public_html/abi07/smf/convert.php(653) : eval()'d code on line 89

Fatal error: Unsupported operand types in /home/kaktus/public_html/abi07/smf/convert.php(653) : eval()'d code on line 89

Is it possible that i have to use the newest Version of IPB ? Or is the problem, that i have some settings in "board permissions" SMF can't handle ?

cu Yoshi !

[modcase]

ok  first i tried it with rc2 then i got an error bringing over my posts from my XOOPS 2.0.9.2 based site using NewBB 2.0 version 2.02  with your 1.1 converter
its brought over the members/users names data but none of the catagories/topics/posts or anything at all
i have this error

Code Select Expand

...Converting boards... Unsuccessful!
This query:
SELECT
forum_id AS ID_BOARD, cat_id AS ID_CAT, forum_name AS name,
forum_desc AS description, forum_topics AS numTopics,
IF(forum_access = 1, '0,2', IF(forum_access = 3, '', '0,-1,2')) AS memberGroups,
forum_posts AS numPosts
FROM `gamehacking`.xoops_bb_forums
LIMIT 0, 500;
Caused the error:

Unknown column 'forum_access' in 'field list'

Having the exact same error here. Ill post if I find a solution. (all members etc copy over, no posts)

[VistaXP]

Grudge, I think I found a bug. After converting, I go to MemberGroup, then look at "Post count based groups"

On every member except for Newbie, it adds the word phpbb next to it. Why is that added? Of course I can modify it.

Ex.

Newbie     *     0     0     Modify
phpBB Human    *    0    0    Modify
phpBB Mutating Phase    **    0    15    Modify
phpBB The Beast    ***    0    30    Modify
phpBB Skull Dragon    ****    0    60    Modify
phpBB Magician Of Black Chaos    *****    0    120    Modify
phpBB Grim Reaper    *****    0    240    Modify
phpBB Transforming Phase    *****    0    480    Modify
phpBB Keepers Of The Key    *****    0    960    Modify
phpBB Shaolin Buddhist    *****    0    1920    Modify
phpBB Unsung Hero    *****    0    3840    Modify
phpBB GOD    *****    0    7680    Modify
phpBB INVINCIBLE (MAX)    *****    0    15360    Modify