Updating from 3.1.9 to 3.2.2 - database update times out

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
DaKaren
Registered User
Posts: 20
Joined: Tue Jan 19, 2010 4:22 pm

Updating from 3.1.9 to 3.2.2 - database update times out

Post by DaKaren » Mon Feb 19, 2018 8:27 am

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

User avatar
Mick
Support Team Member
Support Team Member
Posts: 19368
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff
Contact:

Re: Updating from 3.1.9 to 3.2.2 - database update times out

Post by Mick » Mon Feb 19, 2018 9:47 am

Please post the contents of your config.php, without the password, in code tags.
"The more connected we get the more alone we become" - Kyle Broflovski

There are no ‘threads’ in phpBB, they are topics.
Forza Garibaldi

DaKaren
Registered User
Posts: 20
Joined: Tue Jan 19, 2010 4:22 pm

Re: Updating from 3.1.9 to 3.2.2 - database update times out

Post by DaKaren » Mon Feb 19, 2018 10:32 am

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);
?>

User avatar
Mick
Support Team Member
Support Team Member
Posts: 19368
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff
Contact:

Re: Updating from 3.1.9 to 3.2.2 - database update times out

Post by Mick » Mon Feb 19, 2018 11:27 am

Change this line in your config.php:

Code: Select all

$dbms = 'mysql';
To:

Code: Select all

$dbms = 'mysqli';
and try the dB update again.
"The more connected we get the more alone we become" - Kyle Broflovski

There are no ‘threads’ in phpBB, they are topics.
Forza Garibaldi

DaKaren
Registered User
Posts: 20
Joined: Tue Jan 19, 2010 4:22 pm

Re: Updating from 3.1.9 to 3.2.2 - database update times out

Post by DaKaren » Mon Feb 19, 2018 4:46 pm

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()
Last edited by DaKaren on Mon Feb 19, 2018 4:51 pm, edited 2 times in total.

User avatar
3Di
Registered User
Posts: 12557
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Updating from 3.1.9 to 3.2.2 - database update times out

Post by 3Di » Mon Feb 19, 2018 4:48 pm

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

Usually is
$dbhost = 'localhost';
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
Extensions, Scripts, MOD porting, Update/Upgrades
My development's activity º PhpStorm's proud user

DaKaren
Registered User
Posts: 20
Joined: Tue Jan 19, 2010 4:22 pm

Re: Updating from 3.1.9 to 3.2.2 - database update times out

Post by DaKaren » Mon Feb 19, 2018 5:01 pm

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

Thank you for your help!

User avatar
3Di
Registered User
Posts: 12557
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

Re: Updating from 3.1.9 to 3.2.2 - database update times out

Post by 3Di » Mon Feb 19, 2018 5:07 pm

Good news! :)
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
Extensions, Scripts, MOD porting, Update/Upgrades
My development's activity º PhpStorm's proud user

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: Froddelaar and 19 guests