3.2.1 to 3.2.2 update timeout

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
User avatar
bacon tacon
Registered User
Posts: 236
Joined: Sun Oct 27, 2002 8:17 pm
Contact:

3.2.1 to 3.2.2 update timeout

Post by bacon tacon » Mon Jan 08, 2018 7:55 pm

Support Request Template
What version of phpBB are you using? phpBB 3.2.2
What is your board's URL? https://pennymachines.co.uk/Forum/index.php
Who do you host your board with? hostradical
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.0-B1
What extensions do you have installed? boardtools
phpBB Gallery
Change Post Time
fancybox
ELONW
What styles do you currently have installed? prosilver, custom style
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? Routine auto-update from phpBB 3.2.1 to 3.2.2
Please describe your problem. "The installer has detected a timeout, you may try to refresh the page, which may lead to data corruption."
Generated by SRT Generator

I'm not sure whether the package was downloaded from NL. I downloaded from UK via phpbb.com but didn't note where package was coming from.
I followed the locked topic on the issue with different suggestions but would appreciate something definitive before proceeding further.

Fezroux
Registered User
Posts: 29
Joined: Thu Dec 14, 2017 7:41 am

Re: 3.2.1 to 3.2.2 update timeout

Post by Fezroux » Tue Jan 09, 2018 3:00 am

I don't know if this will help your specific case, but editing the config.php file mentioned in that locked thread worked for me.

Find:

Code: Select all

mysql
And replace it with:

Code: Select all

mysqli

User avatar
bacon tacon
Registered User
Posts: 236
Joined: Sun Oct 27, 2002 8:17 pm
Contact:

Re: 3.2.1 to 3.2.2 update timeout

Post by bacon tacon » Tue Jan 09, 2018 12:18 pm

Hi Fezrous,
Thanks - I saw that suggestion in the locked thread together with this one:

Fix: Open phpbb/db/migration/data/v32x/fix_user_styles.php & find:
$enabled_styles = $result->fetch_array();
Replace with:
$enabled_styles = $this->db->sql_fetchrowset($result);

The problem is I don't know - should I make both changes and what then? Upload the edited files and refresh my ACP update page?

I'm reluctant to refresh because of the warning: "you may try to refresh the page, which may lead to data corruption."

User avatar
Mick
Support Team Member
Support Team Member
Posts: 21078
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket - definitely

Re: 3.2.1 to 3.2.2 update timeout

Post by Mick » Tue Jan 09, 2018 1:48 pm

You have a working backup don't you?
"The more connected we get the more alone we become" - Kyle Broflovski

zvezda
Registered User
Posts: 3
Joined: Fri Jul 03, 2015 8:14 am

Re: 3.2.1 to 3.2.2 update timeout

Post by zvezda » Tue Jan 09, 2018 2:59 pm

Same timeout problem occurred to my forum while auto-updating.
Changing "mysql" to "mysqli" in config.php solved the issue. Many thanks.

Support Request Template
What version of phpBB are you using? phpBB 3.2.2
What is your board's URL? -
Who do you host your board with? aruba.it
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.2.1
What extensions do you have installed? pages
mediaembed
similartopics
tapatalk
What styles do you currently have installed? prosilver
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5.5.57
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? Routine auto-update from phpBB 3.2.1 to 3.2.2
Please describe your problem. "The installer has detected a timeout, you may try to refresh the page, which may lead to data corruption."
Generated by SRT Generator

User avatar
bacon tacon
Registered User
Posts: 236
Joined: Sun Oct 27, 2002 8:17 pm
Contact:

Re: 3.2.1 to 3.2.2 update timeout

Post by bacon tacon » Tue Jan 09, 2018 3:08 pm

Hi - Thanks for the replies.

$dbms is already mysqli in config.php
Mick wrote:
Tue Jan 09, 2018 1:48 pm
You have a working backup don't you?
I have a backup of the database prior to the failed update.

Should I restore it and run the update again?

Should I refresh the page first and see what happens (after editing fix_user_styles.php as suggested in the locked thread)?

I'm just reluctant to do anything that might compound the problem.

User avatar
bacon tacon
Registered User
Posts: 236
Joined: Sun Oct 27, 2002 8:17 pm
Contact:

Re: 3.2.1 to 3.2.2 update timeout

Post by bacon tacon » Tue Jan 09, 2018 4:44 pm

OK - I threw caution to the winds and after editing fix_user_styles.php (as above) I refreshed the ACP page (stalled at timeout).

On 'Update database' the timeout occurred again.

I would be grateful for any suggestions.

PA_Willy
Registered User
Posts: 4
Joined: Tue Jan 09, 2018 3:26 pm

Re: 3.2.1 to 3.2.2 update timeout

Post by PA_Willy » Tue Jan 09, 2018 4:54 pm


User avatar
bacon tacon
Registered User
Posts: 236
Joined: Sun Oct 27, 2002 8:17 pm
Contact:

Re: 3.2.1 to 3.2.2 update timeout

Post by bacon tacon » Tue Jan 09, 2018 5:00 pm

Hi - thanks, yes I read that thread but unfortunately it doesn't apply. Some are solving the issue by changing mysql to mysqli in config.php, but my config.php already contains the line $dbms = 'phpbb\\db\\driver\\mysqli';

User avatar
warmweer
Registered User
Posts: 2013
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: 3.2.1 to 3.2.2 update timeout

Post by warmweer » Tue Jan 09, 2018 5:12 pm

Perhaps you've done it before attempting to upgrade but a) extensions should be disabled (and AFAIAC removed to be reinstalled after updating).
+ I've read a couple of topics about tapatalk creating problems so I would certainly remove that (albeit temporarily).

I would forget about this session, reinstall the backup, disable/remove the extensions, apply the changes mentioned by Marc and try again.
A bug is a feature that hasn't made it to the manual (yet)

User avatar
bacon tacon
Registered User
Posts: 236
Joined: Sun Oct 27, 2002 8:17 pm
Contact:

Re: 3.2.1 to 3.2.2 update timeout

Post by bacon tacon » Tue Jan 09, 2018 5:20 pm

Don't have tapatalk.
Must admit I didn't know extensions had to be disabled before updating.
I'll proceed as you suggest - thank you!

User avatar
warmweer
Registered User
Posts: 2013
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: 3.2.1 to 3.2.2 update timeout

Post by warmweer » Tue Jan 09, 2018 6:25 pm

bacon tacon wrote:
Tue Jan 09, 2018 5:20 pm
Don't have tapatalk.
Oops, I hadn't noticed that this post was by someone else, sorry about that.
zvezda wrote:
Tue Jan 09, 2018 2:59 pm
What extensions do you have installed?
tapatalk
A bug is a feature that hasn't made it to the manual (yet)

User avatar
bacon tacon
Registered User
Posts: 236
Joined: Sun Oct 27, 2002 8:17 pm
Contact:

Re: 3.2.1 to 3.2.2 update timeout

Post by bacon tacon » Tue Jan 09, 2018 7:09 pm

Oh dear...

Edited and uploaded fix_user_styles.php as per Marc's instruction.

Restored pre-update database.

Disabled and removed all extensions.

Re-ran Update.

Exactly the same result, timing out at the same time and on same file: 71% (Installing Schema: \phpbb\db\migration\data\v32x\update_prosilver_bitfield)

Tarantino
Registered User
Posts: 730
Joined: Sat Feb 18, 2012 1:51 pm
Contact:

Re: 3.2.1 to 3.2.2 update timeout

Post by Tarantino » Tue Jan 09, 2018 7:24 pm

If you've mysqli, change to mysql, it worked on the past for some users (go figure why since it doesnt make sense :lol: )

User avatar
warmweer
Registered User
Posts: 2013
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: 3.2.1 to 3.2.2 update timeout

Post by warmweer » Tue Jan 09, 2018 7:47 pm

Tarantino wrote:
Tue Jan 09, 2018 7:24 pm
If you've mysqli, change to mysql, it worked on the past for some users (go figure why since it doesnt make sense :lol: )
He has mysql, ran into the timeout problem, changed it to mysqli and ran into the same problem.

@bacon tacon: I just had a look at you site (in maintenance) but the active style is not prosilver!?
Did you set prosilver as default style? (and disable the other styles, not sure if it's absolutely necessary but I always do it, same thing with language, British English as default and only language)
A bug is a feature that hasn't made it to the manual (yet)

Post Reply

Return to “[3.2.x] Support Forum”