Update to 3.1 hanging at DB upgrade

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Anti-Spam Guide
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
kenmoody
Registered User
Posts: 42
Joined: Tue May 16, 2006 4:47 pm

Update to 3.1 hanging at DB upgrade

Post by kenmoody » Sat Jan 07, 2017 6:05 pm

Support Request Template
What version of phpBB are you using? phpBB 3.1.0
What is your board's URL? http://forum.dynastyleaguefootball.com
Who do you host your board with? rackspace
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? Yes
Do you have any MODs installed? No
Do you have any extensions installed? No
What version of phpBB3 did you update from? phpBB 3.0-B1
What styles do you currently have installed? prosilver only
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 username can be used to view this issue? No answer given
What password can be used to view this issue? No answer given
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Was running version 3.0.x (can't recall specific build). Updated last night to 3.1 following this process,

https://www.phpbb.com/support/docs/en/3 ... /upgrade3/

with the hope to upgrade to 3.2 later this weekend. Maybe I should have just gone straight to 3.2? Anyway...

FTP'ed files up to server fine, ran install/database_update.php page but it kept timing out to a blank page. I then uploaded the updated migrator.php file and that helped in that the page did not time out to a blank page any more, but rather it now just hangs at

Updating database to latest stable release

Database type :: mysql4
Previous version :: 3.1.0-dev

With no progress, no continue button, no nothing.

Maybe you can see it here.

http://forum.dynastyleaguefootball.com/ ... update.php

DB size is listed as 1.5gb in the phpbb general admin window, but the full backup zip I took last night before the update is only about .8gb.

The site appears to be partially functional, but db is clearly still stuck at 3.1.0-dev.

Suggestions on next steps would be welcomed.

Thanks so much!

KM

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69300
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Update to 3.1 hanging at DB upgrade

Post by KevC » Sat Jan 07, 2017 6:42 pm

Make sure the /store folder is writeable.

phpBB3 Chmod Permissions
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

User avatar
Lumpy Burgertushie
Registered User
Posts: 66601
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Update to 3.1 hanging at DB upgrade

Post by Lumpy Burgertushie » Sat Jan 07, 2017 6:50 pm

also, with a database of that size, it can sometimes take hours for it to complete.

try reloading the page or backing up and restarting the database update.

you should eventually get a continue button at the bottom of the page.
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

kenmoody
Registered User
Posts: 42
Joined: Tue May 16, 2006 4:47 pm

Re: Update to 3.1 hanging at DB upgrade

Post by kenmoody » Sat Jan 07, 2017 7:22 pm

Thank you for the responses. I should have included, I left the update to run overnight, and have tried refreshing the database_update.php page several times.

The /store Folder was set to 775, just now changed it to 777 per your link, thank you for sharing that. Not sure if that will make a difference, but I'll try refreshing the update.

When you suggest backing up and starting the database update again, do you mean restoring the database from a backup and trying again or is there something else I should try?

Also, would it be a bad idea to try to go straight to 3.2 right now?

Thanks a ton!

KM
Last edited by kenmoody on Sat Jan 07, 2017 7:31 pm, edited 1 time in total.

User avatar
Lumpy Burgertushie
Registered User
Posts: 66601
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Update to 3.1 hanging at DB upgrade

Post by Lumpy Burgertushie » Sat Jan 07, 2017 7:30 pm

I just meant to hit the back button in your browser to go back to the first page of the database_update.php.

basically, just restart the update from the beginning.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

kenmoody
Registered User
Posts: 42
Joined: Tue May 16, 2006 4:47 pm

Re: Update to 3.1 hanging at DB upgrade

Post by kenmoody » Sat Jan 07, 2017 7:33 pm

Ah, OK thanks Lumpy. Only ever saw one page from database_update.php so just hitting refresh should be the same, I think.

kenmoody
Registered User
Posts: 42
Joined: Tue May 16, 2006 4:47 pm

Re: Update to 3.1 hanging at DB upgrade

Post by kenmoody » Sat Jan 07, 2017 11:49 pm

Tried again, gave it several hours, still nothing. Just sits at

Updating database to latest stable release

Database type :: mysql4
Previous version :: 3.1.0-dev

Hmmm...
so.

1. Try to restore db from backup and start over?
2. Just try to to upgrade straight to 3.2?
3. Any other thoughts or suggestions?

Many thanks!

KM

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7639
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: Update to 3.1 hanging at DB upgrade

Post by JimA » Sun Jan 08, 2017 12:58 am

I would recommend you to try and upgrade to 3.2 instantly, saves the trouble of doing this twice. :)

Do first put the database back-up from 3.0.x back, please.
You can then use the instructions from here: viewtopic.php?f=556&t=2376856#convert3
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

kenmoody
Registered User
Posts: 42
Joined: Tue May 16, 2006 4:47 pm

Re: Update to 3.1 hanging at DB upgrade

Post by kenmoody » Sun Jan 08, 2017 5:17 am

I have attempted to restore my db from a backup taken last night just before the upgrade process began. I made a local backup as well as a downloaded backup. When I went to restore from the backup, I could select the local backup made last night. It asked if I would confirm, I said yes, the restore process started, and after a few minutes the pages timed out. Now about an hour later, the General admin screen still shows a board version of 3.1.0-dev (I was running 3.0.x when the backup was made). The board size went from about 1.5gb and is now showing 480mb. Posts, topics and user numbers all look about right. Getting a little nervous now.

How long does a db restore typically take? How do I know it has complete before moving on?

Also, when I try to log in from a different browser/pc, I receive the following error message;

General Error
SQL ERROR [ mysql4 ]

Data too long for column 'user_password' at row 1 [1406]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


I'm hanging on to a session on my main pc, but I feel like if that is lost, I'm locked out. Been running phpbb for 10 years, this is the first time I've been legitimately nervous.


Thank you very much everyone for your gracious and much appreciated assistance!

KM

kenmoody
Registered User
Posts: 42
Joined: Tue May 16, 2006 4:47 pm

Re: Update to 3.1 hanging at DB upgrade

Post by kenmoody » Sun Jan 08, 2017 7:39 pm

I was able to finally restore the database after several attempts back to the 3.0.11 version from the local backup taken right before the initial update began. After taking two more backups of the database, local and downloaded, I began the process of upgrading directly to 3.2. This upgrade is also experiencing issues, and I have opened a new thread on the 3.2 support forum here;

viewtopic.php?f=556&t=2400376&p=14601461#p14601461

Any possible assistance with this would be supremely appreciated.

Thank you all very much!

KM

Locked

Return to “[3.1.x] Support Forum”