Convert 2.0.22 -> 3.2.2 Error

[jcapice]

Hi,
I'm trying to convert a PhPBB2.0.22 board to PhPBB3.2.2. After (or during?) step 17 where it converts the posts I get this error (######### is an actual number in the original):

Code: Select all

General Error:

SQL ERROR [ mysql4 ]

MySQL server has gone away [2006]

SQL

UPDATE phpbb_config SET config_value = '#########' WHERE config_name = 'rand_seed_last_update'
in file /home/directory/phpBB3/phpbb/db/driver/driver.php on line 996

this is the backtrace:

Code: Select all

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

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

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

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysql->sql_query()

FILE: [ROOT]/phpbb/config/db.php
LINE: 148
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/config/db.php
LINE: 122
CALL: phpbb\config\db->set_atomic()

FILE: [ROOT]/phpbb/passwords/driver/helper.php
LINE: 105
CALL: phpbb\config\db->set()

FILE: [ROOT]/phpbb/passwords/driver/helper.php
LINE: 134
CALL: phpbb\passwords\driver\helper->unique_id()

FILE: [ROOT]/phpbb/passwords/driver/salted_md5.php
LINE: 122
CALL: phpbb\passwords\driver\helper->get_random_salt()

FILE: [ROOT]/phpbb/passwords/driver/salted_md5.php
LINE: 84
CALL: phpbb\passwords\driver\salted_md5->generate_salt()

FILE: [ROOT]/phpbb/passwords/manager.php
LINE: 248
CALL: phpbb\passwords\driver\salted_md5->hash()

FILE: [ROOT]/install/convertors/functions_phpbb20.php
LINE: 1968
CALL: phpbb\passwords\manager->hash()

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

FILE: [ROOT]/install/convert/convertor.php
LINE: 1503
CALL: call_user_func_array()

FILE: [ROOT]/install/convert/convertor.php
LINE: 744
CALL: phpbb\convert\convertor->process_row()

FILE: [ROOT]/install/convert/controller/convertor.php
LINE: 370
CALL: phpbb\convert\convertor->convert_data()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\convert\controller\convertor->convert()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 137
CALL: call_user_func_array()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 57
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/install/app.php
LINE: 61
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()

Any help on what's going wrong on what I can do to fix it would be appreciated. Thanks.

[david63]

The clue is this line MySQL server has gone away [2006] which is server problem. This may help - https://matomo.org/faq/troubleshooting/faq_183/

Also try looking in your server error logs to see if they can give you more specific information.

[jcapice]

I'll give that a shot, thanks.

Edit: It seems it was timing out in the middle of converting posts. I'm getting further than I was before after increasing those limits. I'll confirm after I get through the whole conversion.

FinalEdit: Seems like it all worked. I changed all the settings in the link suggested (wait_timeout and max_allowed_packet in my.cnf) so I can't say which one fixed it but it all went through.

Thanks again!