Upgraded from 3.0.16 to 3.1.6 - Broke logins

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Suggested Hosts
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
Noviets
Registered User
Posts: 24
Joined: Thu Nov 12, 2015 7:04 pm
Location: Australia

Upgraded from 3.0.16 to 3.1.6 - Broke logins

Post by Noviets »

Okay I'll explain what has happened.

I installed a fresh copy of phpbb3.0.16 and used the conversion process to get all of the users etc from out phpbb2.0 install. People were able to log in and everything was working fine. (I had about 3-4 people log-in when they were testing and checking out the site, out of hundreds of users (about 60 active)).

I recently upgraded the 3.0.16 to 3.1.6 by recommendation to fix some compatibility issues with a few extensions I am using.

After upgrading, those that have already logged into the website are able to log back in, but everyone that hasn't is now unable to do so.

The members list seems intact but their credentials are not working.

Is this fixable? What has caused the issue?
User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Upgraded from 3.0.16 to 3.1.6 - Broke logins

Post by Oyabun1 »

Noviets wrote:I recently upgraded the 3.0.16 to 3.1.6 by recommendation to fix some compatibility issues with a few extensions I am using.
3.0.16 doesn't exist and extensions cannot be installed on the 3.0.x branch. So, which version did you update from and how did you update?
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests
Noviets
Registered User
Posts: 24
Joined: Thu Nov 12, 2015 7:04 pm
Location: Australia

Re: Upgraded from 3.0.16 to 3.1.6 - Broke logins

Post by Noviets »

Sorry about that, 3.0.14 was the version.
I used the "Conversion" built into the 3.0.14 installer to get the data from the phpbb2.0 install and was using that for a bit. (Site was working fine at this point, users could log in)

Then updated the 3.0.14 to 3.1.6.

I removed all files from the phpbb3.0.14 directory instead of Files/Images/Store and the config.php.
Then removed those specific ones from the new 3.1.6 directory before putting them onto the ftp.

Then I navigated to [root]/install/update_database.php

Once that was done I deleted the install directory.

I followed this guide: https://www.phpbb.com/support/docs/en/3 ... /upgrade3/

Edit: Users that had logged in before I did the update are still able to log in fine. However users that did not log in are now not able to do so, and get an invalid password error.
User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Upgraded from 3.0.16 to 3.1.6 - Broke logins

Post by Oyabun1 »

It may be an incomplete upgrade.

Run this SQL query

Code: Select all

SELECT COUNT(user_pass_convert) FROM phpbb_users
Change phpbb_ if that is not your table prefix.

See Executing SQL Queries in phpMyAdmin if you are unfamiliar with running queries.

If that query generates an error "Unknown column 'user_pass_convert'" Then run this query

Code: Select all

SELECT COUNT(user_id) FROM phpbb_users WHERE user_password LIKE '$CP$%'
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests
Noviets
Registered User
Posts: 24
Joined: Thu Nov 12, 2015 7:04 pm
Location: Australia

Re: Upgraded from 3.0.16 to 3.1.6 - Broke logins

Post by Noviets »

So the top command errored with this: http://puu.sh/lvDcv/5e1683f18e.png
So I ran the second which did this: http://puu.sh/lvDb4/712dcfa6be.png
Then the first command errored the same way again
User avatar
Oyabun1
Former Team Member
Posts: 23162
Joined: Sun May 17, 2009 1:05 pm
Location: Australia
Name: Bill

Re: Upgraded from 3.0.16 to 3.1.6 - Broke logins

Post by Oyabun1 »

The results of those queries were as they should be for a correctly updated database.
                      Support Request Template
3.0.x: Knowledge Base Styles Support MOD Requests
3.1.x: Knowledge BaseStyles SupportExtension Requests
Noviets
Registered User
Posts: 24
Joined: Thu Nov 12, 2015 7:04 pm
Location: Australia

Re: Upgraded from 3.0.16 to 3.1.6 - Broke logins

Post by Noviets »

So what's my next step? It looks like it has changed everyones password that didn't log in prior to the update, which is about 460 accounts.

Why did it only change those passwords and not everyones? Does it have something to do with the update converting passwords over? Can I convert them back?

Also getting an error

Code: Select all

Fatal error: Uncaught exception 'Exception' with message 'DateTime::__construct(): Failed to parse time string (@) at position 0 (@): Unexpected character' in /home/vvv1host/public_html/phpBB3/phpbb/datetime.php:50 Stack trace: #0 /home/vvv1host/public_html/phpBB3/phpbb/datetime.php(50): DateTime->__construct('@', Object(DateTimeZone)) #1 /home/vvv1host/public_html/phpBB3/phpbb/user.php(728): phpbb\datetime->__construct(Object(phpbb\user), '@', Object(DateTimeZone)) #2 /home/vvv1host/public_html/phpBB3/includes/functions_display.php(1652): phpbb\user->format_date(NULL) #3 /home/vvv1host/public_html/phpBB3/memberlist.php(1464): phpbb_show_profile(NULL, false, false, false) #4 {main} thrown in /home/vvv1host/public_html/phpBB3/phpbb/datetime.php on line 50 
When I click on on of the groups (Administrator or Global Moderator links at the bottom of the page)
User avatar
david63
Registered User
Posts: 19038
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Contact:

Re: Upgraded from 3.0.16 to 3.1.6 - Broke logins

Post by david63 »

Noviets wrote:Can I convert them back?
Restore your backup
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
Noviets
Registered User
Posts: 24
Joined: Thu Nov 12, 2015 7:04 pm
Location: Australia

Re: Upgraded from 3.0.16 to 3.1.6 - Broke logins

Post by Noviets »

Should I try running the update_database.php again?
Noviets
Registered User
Posts: 24
Joined: Thu Nov 12, 2015 7:04 pm
Location: Australia

Re: Upgraded from 3.0.16 to 3.1.6 - Broke logins

Post by Noviets »

Okay you can mark this is resolved.

I install a fresh copy of the 3.1.6 board, did the conversion from the phpbb2.0 DB, seems to have fixed everything.

Not sure what caused the issue, but may be a note there, if you convert, dont upgrade. Better to use the latest version fresh and convert to that straight up.

Luckily I only lost about a week of posts :)

Thanks for the help anyway guys, appreciate your time.

Regards,
Noviets
Locked

Return to “[3.1.x] Support Forum”