3.1.6 to 3.1.9 update - DB won't update

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Get Involved
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
DavidLi
Registered User
Posts: 7
Joined: Thu May 19, 2016 1:56 pm

3.1.6 to 3.1.9 update - DB won't update

Post by DavidLi »

Support Request Template
What version of phpBB are you using? phpBB 3.1.6
What is your board's URL? No answer given
Who do you host your board with? No answer given
How did you install your board? Please select your answer
What is the most recent action performed on your board? Please select your answer
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What styles do you currently have installed? none
What language(s) is your board currently using? english
Which database type/version are you using? MS SQL Server
What is your level of experience? New to PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Attempting to update from 3.1.6 to 3.1.9
Please describe your problem. files were checked and updated. When DB upgrader is invoked, immediately says that is has been updated to 3.1.9. When clicking Next Step, advises that DB needs to be updated. DB is currently reporting as 3.1.6 so it did not completely get updated. Forum is working currently. How can I "reset" the version so the upgrade completes?
We also had an issue prior to the update that user's couldn't change their password. Root cause was cache directory was not writeable. Not sure if this is related to the DB update. Cache has recently been cleared and update DB still fails.
Thanx
Generated by SRT Generator

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

Re: 3.1.6 to 3.1.9 update - DB won't update

Post by 3Di »

Ok, since those info are not enough I guess, I invite you to use once more my tool..
http://3di.space/32/viewtopic.php?f=3&t=2
and post here within the QUOTE BBcode tags the WHOLE results, thank you.

That will help us to find a better diagnosis of your issue.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
:studio_microphone: Premium extensions @ The Studio

DavidLi
Registered User
Posts: 7
Joined: Thu May 19, 2016 1:56 pm

Re: 3.1.6 to 3.1.9 update - DB won't update

Post by DavidLi »

Your CONSTANTS file belongs to phpBB 3.1.9
Your DB says you are running phpBB 3.1.6
Your PHP version says you are running PHP 5.6.11
The following stats are just for information purposes at the present time
The file config.php exists, size: 428 bytes
Available stream wrappers: php, file, glob, data, http, ftp, zip, compress.zlib, compress.bzip2, https, ftps, phar
PHP module json: loaded
PHP module getimagesize: loaded
Styles (phpBB ver) available: prosilver (3.1.9)
Default style of the Board (for new users): prosilver
Styles installed: prosilver
Styles in use (incl. bots and guests): prosilver (2647)
Override user style: No
Languages available: en
Your Board's default language is en
Languages installed: British English
Languages in use (incl. bots and guests): en (2647)
Server name: forum.cinemaronline.com
Cookie domain: .forum.cinemaronline.com
Cookie name: cinemarforum
Cookie path: /
Cookie secure: Disabled
DB info: MySQL(i) 5.7.7-rc-log
ImageMagick path:
Cache folder chmod: 0777
Store folder chmod: 0777
Files folder chmod: 0777
Images/avatar/upload folder chmod: 0777

DavidLi
Registered User
Posts: 7
Joined: Thu May 19, 2016 1:56 pm

Re: 3.1.6 to 3.1.9 update - DB won't update

Post by DavidLi »

3Di wrote:Ok, since those info are not enough I guess, I invite you to use once more my tool..
http://3di.space/32/viewtopic.php?f=3&t=2
and post here within the QUOTE BBcode tags the WHOLE results, thank you.

That will help us to find a better diagnosis of your issue.
Your CONSTANTS file belongs to phpBB 3.1.9
Your DB says you are running phpBB 3.1.6
Your PHP version says you are running PHP 5.6.11
The following stats are just for information purposes at the present time
The file config.php exists, size: 428 bytes
Available stream wrappers: php, file, glob, data, http, ftp, zip, compress.zlib, compress.bzip2, https, ftps, phar
PHP module json: loaded
PHP module getimagesize: loaded
Styles (phpBB ver) available: prosilver (3.1.9)
Default style of the Board (for new users): prosilver
Styles installed: prosilver
Styles in use (incl. bots and guests): prosilver (2647)
Override user style: No
Languages available: en
Your Board's default language is en
Languages installed: British English
Languages in use (incl. bots and guests): en (2647)
Server name: forum.cinemaronline.com
Cookie domain: .forum.cinemaronline.com
Cookie name: cinemarforum
Cookie path: /
Cookie secure: Disabled
DB info: MySQL(i) 5.7.7-rc-log
ImageMagick path:
Cache folder chmod: 0777
Store folder chmod: 0777
Files folder chmod: 0777
Images/avatar/upload folder chmod: 0777

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

Re: 3.1.6 to 3.1.9 update - DB won't update

Post by 3Di »

What's inside your store folder?
There should be some files with the starting filename like migration_..

The last one of those (cronologically) says what?
Post the content of it (please use the Bbcode CODE tags to post it)
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
:studio_microphone: Premium extensions @ The Studio

DavidLi
Registered User
Posts: 7
Joined: Thu May 19, 2016 1:56 pm

Re: 3.1.6 to 3.1.9 update - DB won't update

Post by DavidLi »

There are many .log files in that directory. The most recent is empty. It seems all since the DB upgrade attempts are empty.
The most current one that has any content was when the update to 3.1.6 took place. That is a 615KB file.
Thanx for looking into this. Truly appreciated.

Tom49er
Registered User
Posts: 133
Joined: Sat Jun 07, 2014 4:51 am

Re: 3.1.6 to 3.1.9 update - DB won't update

Post by Tom49er »

I had the same problem. I downloaded full package. I deleted image folder, store folder, file folder, ext folder and config.php . Then I uploaded full package. It worked

DavidLi
Registered User
Posts: 7
Joined: Thu May 19, 2016 1:56 pm

Re: 3.1.6 to 3.1.9 update - DB won't update

Post by DavidLi »

Tom49er,
followed your suggestion...same deal. Checks the files, all are good. Click to update DB, immediately on click says it was successful. Then, click to continue...says DB needs to be updated.
Sigh...

thanx anyway!

Ok, Now we "know" that the files are correct, and the DB something is wacky there.
Keep in mind this is on a Windows 2013 Server...could that have something to do with it not updating?

Thanx

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

Re: 3.1.6 to 3.1.9 update - DB won't update

Post by 3Di »

Try purging your cache now.
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
:studio_microphone: Premium extensions @ The Studio

DavidLi
Registered User
Posts: 7
Joined: Thu May 19, 2016 1:56 pm

Re: 3.1.6 to 3.1.9 update - DB won't update

Post by DavidLi »

Ok, we figured it out....had to temporarily give the user IIS_USR write access to the folders. otherwise the files were not being updated.
All updated.

Locked

Return to “[3.1.x] Support Forum”