Updating from 3.1.9 to 3.2.2 - database update times out

[DaKaren]

Support Request Template
What version of phpBB are you using? phpBB 3.2.2
What is your board's URL? http://www.uorpc.net/phpBBB/index.php
Who do you host your board with? icdsoft.com
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What version of phpBB3 did you update from? phpBB 3.1.9
What extensions do you have installed? An extension which links user accounts so users can switch between names easily.
What styles do you currently have installed? A version of Prosilver (a mildly modified pbwow3)
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? Comfortable with PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? I uploaded the update to 3.2.2 to my site, ran the update, made all the file changes it wanted and then moved on to the database portion of the update.
Please describe your problem. The updater claims it is timing out somewhere during the database update. It slows down around 54%, then a few seconds later jumps to 93% and says it timed out. I am highly dubious that it is actually timing out in so short a span of time. It suggests that timeout settings are increased, or that I try something called CLI (not that it bothers ti explain what, or where such a thing is...)

Refreshing the window leads to database corruption, thus I have to restore it from backup.

I've tried running it about 10 times now, with exactly the same results.
Generated by SRT Generator

[Mick]

Please post the contents of your config.php, without the password, in code tags.

[DaKaren]

Code: Select all

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost:/tmp/mysql5.sock';
$dbport = '';
$dbname = 'uorpc_DB';
$dbuser = 'phpbb';
$dbpasswd = '';
$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>

[Mick]

Change this line in your config.php:

Code: Select all

$dbms = 'mysql';

To:

Code: Select all

$dbms = 'mysqli';

and try the dB update again.

[DaKaren]

That didn't work:

Code: Select all

General Error:SQL ERROR [ mysqli ]Connection refused [2002] in file /home/uorpc/www/www/phpBBB/install/update/new/phpbb/db/driver/driver.php on line 996BACKTRACEFILE: (not given by php)LINE: (not given by php)CALL: installer_msg_handler()FILE: [ROOT]/phpbb/db/driver/driver.phpLINE: 996CALL: trigger_error()FILE: [ROOT]/phpbb/db/driver/driver.phpLINE: 439CALL: phpbb\db\driver\driver->sql_error()FILE: [ROOT]/phpbb/db/tools/tools.phpLINE: 1056CALL: phpbb\db\driver\driver->sql_transaction()FILE: [ROOT]/phpbb/db/tools/tools.phpLINE: 444CALL: phpbb\db\tools\tools->_sql_run_sql()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 1011CALL: phpbb\db\tools\tools->sql_create_table()FILE: [ROOT]/phpbb/install/module/update_database/task/update.phpLINE: 134CALL: phpbb\db\migrator->create_migrations_table()FILE: [ROOT]/phpbb/install/module_base.phpLINE: 149CALL: phpbb\install\module\update_database\task\update->run()FILE: [ROOT]/phpbb/install/installer.phpLINE: 219CALL: phpbb\install\module_base->run()FILE: [ROOT]/phpbb/install/controller/update.phpLINE: 133CALL: phpbb\install\installer->run()FILE: (not given by php)LINE: (not given by php)CALL: phpbb\install\controller\update->phpbb\install\controller\{closure}()FILE: /home/uorpc/www/www/phpBBB/vendor/symfony/http-foundation/StreamedResponse.phpLINE: 111CALL: call_user_func()FILE: /home/uorpc/www/www/phpBBB/vendor/symfony/http-foundation/Response.phpLINE: 377CALL: Symfony\Component\HttpFoundation\StreamedResponse->sendContent()FILE: /home/uorpc/www/www/phpBBB/install/app.phpLINE: 62CALL: Symfony\Component\HttpFoundation\Response->send()

[3Di]

$dbhost = 'localhost:/tmp/mysql5.sock';

Usually is
$dbhost = 'localhost';

[DaKaren]

Together, those two changes allowed the update to complete successfully!

Thank you for your help!

[3Di]

Good news!