Migrating forum from PunBB 1.4.2 to phpBB3

[Jbbc]

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]

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()

[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

[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()

[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

[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]

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]

Nope didn't solved it

[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