Convert from IPB 3.4.x to phpBB3

Converting from other board software? Good decision! Need help? Have a question about a convertor? Wish to offer a convertor package? Post here.
Scam Warning
Wall E
Registered User
Posts: 2
Joined: Wed Jan 29, 2014 4:45 pm

Convert from IPB 3.4.x to phpBB3

Post by Wall E »

Hello,
How can i convert from IPB 3.4.x to phpBB3 ? Thanks!
User avatar
Lumpy Burgertushie
Registered User
Posts: 69228
Joined: Mon May 02, 2005 3:11 am

Re: Convert from IPB 3.4.x to phpBB3

Post by 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
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
Wall E
Registered User
Posts: 2
Joined: Wed Jan 29, 2014 4:45 pm

Re: Convert from IPB 3.4.x to phpBB3

Post by Wall E »

Yes i did. Can you just give me the answer.. ?
User avatar
Lumpy Burgertushie
Registered User
Posts: 69228
Joined: Mon May 02, 2005 3:11 am

Re: Convert from IPB 3.4.x to phpBB3

Post by 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
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
User avatar
prototech
Former Team Member
Posts: 5406
Joined: Mon Mar 19, 2007 2:04 pm
Location: Southern California

Re: Convert from IPB 3.4.x to phpBB3

Post by 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.
You do not have the required permissions to view the files attached to this post.
Need help with MOD/style installations or other phpBB problems? Contact me for a quote.
amorcage
Registered User
Posts: 1
Joined: Wed Jul 30, 2014 4:27 pm

Re: Convert from IPB 3.4.x to phpBB3

Post by amorcage »

prototech wrote: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 ...

Image

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

Thx for debug :)
User avatar
Vlada87
Registered User
Posts: 7
Joined: Tue Jun 27, 2006 4:48 pm
Location: Serbia/Belgrade

Re: Convert from IPB 3.4.x to phpBB3

Post by 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()
I LOVE TECHNO
tommytom
Registered User
Posts: 2
Joined: Sat Jan 25, 2014 5:02 am

Re: Convert from IPB 3.4.x to phpBB3

Post by 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
Registered User
Posts: 1
Joined: Sun Nov 09, 2014 5:41 pm
Location: 66°5′1.51″N, 76°45′16.15″E
Name: light nur

Re: Convert from IPB 3.4.x to phpBB3

Post by light.nur »

prototech wrote: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
Registered User
Posts: 1
Joined: Fri Oct 24, 2014 8:28 am

Re: Convert from IPB 3.4.x to phpBB3

Post by 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
Registered User
Posts: 4
Joined: Fri Dec 26, 2014 6:36 am

Re: Convert from IPB 3.4.x to phpBB3

Post by 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
Registered User
Posts: 2
Joined: Wed Jan 30, 2008 5:04 pm

Re: Convert from IPB 3.4.x to phpBB3

Post by 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
Registered User
Posts: 4
Joined: Wed Sep 21, 2011 5:13 pm

Re: Convert from IPB 3.4.x to phpBB3

Post by Gefahrensucher »

I am also very interested in such a converter.
Is there anyone still working on a thing like this?
User avatar
Vanea'Moldoveanu
Registered User
Posts: 15
Joined: Tue Oct 28, 2014 6:10 pm
Location: Localhost
Name: Stefan Alexandru

Re: Convert from IPB 3.4.x to phpBB3

Post by 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
User avatar
Sven2157
Registered User
Posts: 48
Joined: Thu Jun 25, 2015 5:13 pm

Re: Convert from IPB 3.4.x to phpBB3

Post by 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! ;)
Regards,

Sven2157

Return to “[3.0.x] Convertors”