Migrating forum from PunBB 1.4.2 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.
Suggested Hosts
Jbbc
Registered User
Posts: 7
Joined: Wed Apr 28, 2010 3:03 am

Re: Migrating forum from PunBB 1.4.2 to phpBB3

Post by Jbbc »

prototech wrote:Please try using the convertor attached below.
I tried to use the convertor from PunBB 1.4.4 to phpBB 3.1.6. All is well until after the pre-conversion, where I got this:

Code: Select all

SQL ERROR [ mysqli ]

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

SQL

INSERT INTO sr_bb_forums (forum_id, forum_name, parent_id, forum_parents, forum_desc, forum_type, forum_link, forum_status, enable_prune, prune_next, prune_days, prune_viewed, prune_freq, left_id, right_id, forum_flags, forum_options, forum_desc_bitfield, forum_desc_options, forum_desc_uid, forum_password, forum_style, forum_image, forum_rules, forum_rules_link, forum_rules_bitfield, forum_rules_options, forum_rules_uid, forum_topics_per_page, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_post_subject, forum_last_post_time, forum_last_poster_name, forum_last_poster_colour, display_on_index, enable_indexing, enable_icons) VALUES (38, 'Equipe SR Missions', 43, '', 'Réservé au groupe de travail sur les SR Missions - pour vos questions à ce sujet, merci de poster dans le forum général "Sixième Monde".', 1, '', 0, 0, 0, 0, 0, 0, 1, 2, 98, 0, '', 7, '', '', 0, '', '', '', '', 7, '', 0, 0, 0, 0, 0, 0, '', 0, '', '', 1, 1, 0)

BACKTRACE

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

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 852
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/install/convertors/functions_punbb14.php
LINE: 818
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/install/install_convert.php(1028) : eval()'d code
LINE: 3
CALL: punbb_insert_forums()

FILE: [ROOT]/install/install_convert.php
LINE: 1028
CALL: eval()

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

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

FILE: [ROOT]/install/index.php
LINE: 289
CALL: module->load()
With PHP 5.5.22, MySQL 5.5
Jbbc
Registered User
Posts: 7
Joined: Wed Apr 28, 2010 3:03 am

Re: Migrating forum from PunBB 1.4.2 to phpBB3

Post by Jbbc »

Similar issue while converting to phpbb 3.0.14:

Code: Select all

SQL ERROR [ mysqli ]

Lost connection to MySQL server during query [2013]

SQL

SELECT topics.id AS topic_id, topics.forum_id, users.id AS poster_id, topics.subject, topics.posted, topics.num_views, topics.num_replies, topics.last_post_id, topics.closed, topics.sticky, topics.first_post_id, posts.posted FROM dev_srfr_punbb_topics topics, dev_srfr_punbb_posts posts, dev_srfr_punbb_users users WHERE (topics.last_post_id = posts.id AND topics.moved_to IS NULL AND topics.poster = users.username) ORDER BY topics.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()
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Migrating forum from PunBB 1.4.2 to phpBB3

Post by Lumpy Burgertushie »

you can't use the convertor to go to 3.1 . the database is quite different from 3.0 to 3.1

as to the error in your last post, it is not similar at all. that error says that you lost the connection to the database server.


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.
Jbbc
Registered User
Posts: 7
Joined: Wed Apr 28, 2010 3:03 am

Re: Migrating forum from PunBB 1.4.2 to phpBB3

Post by Jbbc »

Right indeed, thanks.

So I tried again, in local this time. The conversion goes along until the near end, where I got this error:

Code: Select all

General Error
SQL ERROR [ mysqli ]

Column 'topic_poster' cannot be null [1048]

SQL

UPDATE sr_bb_topics SET topic_poster = NULL, topic_views = NULL, topic_replies = NULL, topic_replies_real = NULL, topic_first_post_id = NULL, topic_first_poster_name = NULL, topic_first_poster_colour = NULL, topic_last_post_id = NULL, topic_last_poster_name = NULL, topic_last_poster_colour = NULL, topic_last_post_time = NULL, topic_last_view_time = NULL WHERE topic_id = 118

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]/install/convertors/functions_punbb14.php
LINE: 246
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/install/install_convert.php(1654) : eval()'d code
LINE: 2
CALL: punbb_fix_moved_topics()

FILE: [ROOT]/install/install_convert.php
LINE: 1654
CALL: eval()

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

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()
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Migrating forum from PunBB 1.4.2 to phpBB3

Post by Lumpy Burgertushie »

I am no expert on these convertors at all. My guess would be that the convertor is too out of date for even 3.0.14

check to see what version of phpbb the convertor you are using was designed to work on.

I think you will see that it is several versions before 3.0.14

there very well may have been some database changes that occurred since the convertor was created.
also, could be changes in the mysql versions between the old and new etc.
sorry I can't be more help.

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.
Jbbc
Registered User
Posts: 7
Joined: Wed Apr 28, 2010 3:03 am

Re: Migrating forum from PunBB 1.4.2 to phpBB3

Post by Jbbc »

Thanks. I tried again with 3.0.11, which was the last version before the converter's date and the author's last posts.

Error:

Code: Select all

SQL ERROR [ mysqli ]

Column 'topic_poster' cannot be null [1048]

SQL

UPDATE sr_ph_topics SET topic_poster = NULL, topic_views = NULL, topic_replies = NULL, topic_replies_real = NULL, topic_first_post_id = NULL, topic_first_poster_name = NULL, topic_first_poster_colour = NULL, topic_last_post_id = NULL, topic_last_poster_name = NULL, topic_last_poster_colour = NULL, topic_last_post_time = NULL, topic_last_view_time = NULL WHERE topic_id = 118

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: 182
CALL: dbal->sql_error()

FILE: [ROOT]/install/convertors/functions_punbb14.php
LINE: 246
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/install/install_convert.php(1654) : eval()'d code
LINE: 2
CALL: punbb_fix_moved_topics()

FILE: [ROOT]/install/install_convert.php
LINE: 1654
CALL: eval()

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

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()
janekpogwad
Registered User
Posts: 1
Joined: Tue Nov 03, 2015 11:50 am

Re: Migrating forum from PunBB 1.4.2 to phpBB3

Post by janekpogwad »

That's the same problem what you had in 3.0.14. Did you solve it? Or maybe someone knows where the problem is?
Jbbc
Registered User
Posts: 7
Joined: Wed Apr 28, 2010 3:03 am

Re: Migrating forum from PunBB 1.4.2 to phpBB3

Post by Jbbc »

Nope didn't solved it :(
clyd
Registered User
Posts: 1
Joined: Fri Apr 15, 2016 8:38 pm

Re: Migrating forum from PunBB 1.4.2 to phpBB3

Post by clyd »

Hello.
I am trying to migrate my punbb 1.4.2 forum to phpbb3.1.8, I using the converter station 0.0.4 few higher posts in this discussion.
I have taken account phpbb that has evolved since the output of the converter that is now no longer supported.
I would use it and make it compatible with the current version of phpbb.
First encountered errors were the names of fields that were changed, so I edited the file (root / install / convertors / punbb / functions_punbb14.php) lines 802 and 803 with the new field names in the database.

Code: Select all

General Error
SQL ERROR [ mysqli ]

Column 'topic_poster' cannot be null [1048]

SQL

UPDATE sr_bb_topics SET topic_poster = NULL, topic_views = NULL, topic_replies = NULL, topic_replies_real = NULL, topic_first_post_id = NULL, topic_first_poster_name = NULL, topic_first_poster_colour = NULL, topic_last_post_id = NULL, topic_last_poster_name = NULL, topic_last_poster_colour = NULL, topic_last_post_time = NULL, topic_last_view_time = NULL WHERE topic_id = 118

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]/install/convertors/functions_punbb14.php
LINE: 246
CALL: dbal_mysqli->sql_query()

FILE: [ROOT]/install/install_convert.php(1654) : eval()'d code
LINE: 2
CALL: punbb_fix_moved_topics()

FILE: [ROOT]/install/install_convert.php
LINE: 1654
CALL: eval()

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

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()
Then I encounter a call problem to the function. $ PhpEx (line 940) that is in the file (root includes / db / db_tools.php)

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/install/convertors/functions_punbb14.php on line 940: include(./../includes/db/db_tools.php): failed to open stream: No such file or directory
[phpBB Debug] PHP Warning: in file [ROOT]/install/convertors/functions_punbb14.php on line 940: include(./../includes/db/db_tools.php): failed to open stream: No such file or directory
[phpBB Debug] PHP Warning: in file [ROOT]/install/convertors/functions_punbb14.php on line 940: include(): Failed opening './../includes/db/db_tools.php' for inclusion (include_path='.:/usr/local/php5.6/lib/php')
With phpbb of Evolution, this and this file is lost, if an expert can give me a hand, to give this converter day.
I thank those who prenent the time to give us a hand to make this easier migration.


Of course as soon as I have a functionnal converter I share
Text translated with Google Translation
Locked

Return to “[3.0.x] Convertors”