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.
Get Involved
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 » Mon Oct 26, 2015 12:30 pm

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 » Mon Oct 26, 2015 1:37 pm

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: 63196
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Migrating forum from PunBB 1.4.2 to phpBB3

Post by Lumpy Burgertushie » Mon Oct 26, 2015 2:38 pm

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
I am available for custom work on a donation basis. Please send me a PM with your needs.
Premium phpBB 3.2 Styles by PlanetStyles.net

New phpbb 3.0 support site

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 » Mon Oct 26, 2015 3:35 pm

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: 63196
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Migrating forum from PunBB 1.4.2 to phpBB3

Post by Lumpy Burgertushie » Mon Oct 26, 2015 4:31 pm

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
I am available for custom work on a donation basis. Please send me a PM with your needs.
Premium phpBB 3.2 Styles by PlanetStyles.net

New phpbb 3.0 support site

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 » Mon Oct 26, 2015 6:40 pm

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 » Tue Nov 03, 2015 11:57 am

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 » Thu Nov 05, 2015 12:18 am

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 » Fri Apr 15, 2016 9:22 pm

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”

Who is online

Users browsing this forum: No registered users and 5 guests