Convert from IPB 3.4.x to phpBB3

[Wall E]

Hello,
How can i convert from IPB 3.4.x to phpBB3 ? Thanks!

[Lumpy Burgertushie]

there is a post two posts below yours that is a discussion about this, and several other posts as well. did you look around at all before you posted?

robert

[Wall E]

Yes i did. Can you just give me the answer.. ?

[Lumpy Burgertushie]

if you had read even the first post that I mentioned above, you would know the answer.

there is currently no convertor.

robert

[prototech]

This is the first release, so it may still be buggy. Instructions on how to use it can be found in the Convert How To stickied at the top of this forum. The convertor does not attempt to convert permissions, so you will have to set these yourself. Polls are also skipped at this time due to IPB allowing multiple questions per poll, whereas phpBB only allows one. They will be included in the next release - likely picking the first question or skipping polls with multiple questions. Please let me know if you run into any problems.

PS: You may wish to run it locally as it's very likely that you'll run into resource limits if tested online.

[amorcage]

This is the first release, so it may still be buggy. Instructions on how to use it can be found in the Convert How To stickied at the top of this forum. The convertor does not attempt to convert permissions, so you will have to set these yourself. Polls are also skipped at this time due to IPB allowing multiple questions per poll, whereas phpBB only allows one. They will be included in the next release - likely picking the first question or skipping polls with multiple questions. Please let me know if you run into any problems.

PS: You may wish to run it locally as it's very likely that you'll run into resource limits if tested online.

hello all

I go back this topic.
I tried the script and xxxxxx there a bug ...



All goes well until step 7/26 then SQL error: (

Thx for debug

[Vlada87]

I got this error after 15/27

Can you see whats going on?

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'pfields_content.field_1' in 'field list' [1054]

SQL

SELECT members.member_id, members.member_id AS poster_id, members.member_group_id, members.joined, members.name, members.members_pass_hash, members.members_pass_salt, members.posts, members.email, members.bday_day, members.bday_month, members.bday_year, members.last_visit, members.time_offset, members.dst_in_use, pfields_content.field_3, pfields_content.field_9, pfields_content.field_2, pfields_content.field_8, pfields_content.field_1, pfields_content.field_4, pfields_content.field_6, profile_portal.pp_main_photo, profile_portal.pp_main_height, profile_portal.pp_main_width, members.msg_count_new, members.members_disable_pm, profile_portal.signature, members.joined AS post_date FROM members, pfields_content, profile_portal WHERE (members.member_id = pfields_content.member_id AND members.member_id = profile_portal.pp_member_id) ORDER BY members.member_id LIMIT 2000

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 189
CALL: dbal->sql_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 231
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/includes/db/dbal.php
LINE: 170
CALL: dbal_mysqli->_sql_query_limit()

FILE: [ROOT]/install/install_convert.php
LINE: 1233
CALL: dbal->sql_query_limit()

FILE: [ROOT]/install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 326
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 203
CALL: module->load()

[tommytom]

The author of the convertor seems to have gotten busy with other things.

Haven't gotten a response from him since he made it (around january?).

I don't think it works for anyone yet.

Really disappointing.

Only one person working on this (and seems to have stopped) and you can tell from posts and downloads that a lot of people really want to ditch horrible IPB for good ol' phpBB.

I hope he or someone else picks it up and finishes it.

I'm willing to help wherever I can. I have a HUGE database that's over 12 years old that desperately needs to be converted at some point.

PM or email me if you ever need a beta tester for a working (or work in progress) converter.

[light.nur]

Please let me know if you run into any problems.

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'forum_options' in 'field list' [1054]

SQL

INSERT INTO phpbb_forums (forum_id, forum_name, parent_id, forum_parents, forum_desc, forum_type, forum_status, forum_password, forum_posts, forum_link, left_id, right_id, forum_flags, forum_options, forum_desc_bitfield, forum_desc_options, forum_desc_uid, forum_style, forum_image, forum_rules, forum_rules_link, forum_rules_bitfield, forum_rules_options, forum_rules_uid, display_on_index, enable_indexing, enable_icons) VALUES (5, 'Главный Форум', '150', '', 'Здесь все что касается нашего форума.', 1, 0, '', 0, '', 2, 5, 34, 0, '', 7, '', 0, '', '', '', '', 7, '', 1, 1, 0)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 143
CALL: dbal->sql_error()

FILE: install/convertors/functions_ipb34.php
LINE: 241
CALL: dbal_mysqli->sql_query()

FILE: install/install_convert.php(1004) : eval()'d code
LINE: 4
CALL: ipb_insert_forums()

FILE: install/install_convert.php
LINE: 1004
CALL: eval()

FILE: install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: install/index.php
LINE: 402
CALL: install_convert->main()

FILE: install/index.php
LINE: 274
CALL: module->load()

whats wrong?

[LazyKid]

So does this not work? I have tried to convert many times and always failing. Seems like the author isn't updating either

[Technowix]

Still nothing here ? o: i got this error...

Code: Select all

General error
SQL ERROR [ mysqli ]

Duplicate entry '343-509' for key 'PRIMARY' [1062]

SQL

INSERT INTO phpbb_topics_track (user_id, forum_id, topic_id, mark_time) VALUES (343, 4, 509, 1417777819), (343, 4, 536, 1418824035), (343, 4, 552, 1419591763)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 189
CALL: dbal->sql_error()

FILE: [ROOT]/includes/db/dbal.php
LINE: 550
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/install/convertors/functions_ipb34.php
LINE: 705
CALL: dbal->sql_multi_insert()

FILE: (not given by php)
LINE: (not given by php)
CALL: ipb_insert_topic_tracking()

FILE: [ROOT]/install/install_convert.php
LINE: 2069
CALL: call_user_func_array()

FILE: [ROOT]/install/install_convert.php
LINE: 1276
CALL: install_convert->process_row()

FILE: [ROOT]/install/install_convert.php
LINE: 203
CALL: install_convert->convert_data()

FILE: [ROOT]/install/index.php
LINE: 326
CALL: install_convert->main()

FILE: [ROOT]/install/index.php
LINE: 203
CALL: module->load()

[Fischje]

I need this convertor, too.

I'm not willing to pay further for IPB. The changes to ipb 4 are not the way i want my forums run.

[Gefahrensucher]

I am also very interested in such a converter.
Is there anyone still working on a thing like this?

[Vanea'Moldoveanu]

This work at phpBB 3.1.x ?


I have this problem > Fatal error: Call to undefined function phpbb_hash() in /var/www/html/phpBB3/install/convertors/functions_ipb34.php on line 210

[Sven2157]

For those that are having an issue with this converter, you need to have a clean install of phpBB 3.0.12 installed. This is what was used when @prototech created the converter. So the database will match the conversion properly.

Once converted, you can then log in to the ACP. You will have to generate the Search Index, as well as set forum topic permissions manually - including the ability to see them. By default the boards' visibility settings are set to no one. Once you are satisfied, you can then update the boards to the latest version and apply/create your desired style.

Hope that helps!