Upgraded from 3.0.16 to 3.1.6 - Broke logins

Noviets · Post by **Noviets** » Sun Nov 22, 2015 4:19 pm

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?

Oyabun1 · Post by **Oyabun1** » Sun Nov 22, 2015 8:53 pm

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?

Noviets · Post by **Noviets** » Sun Nov 22, 2015 9:12 pm

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.

Oyabun1 · Post by **Oyabun1** » Mon Nov 23, 2015 8:41 am

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$%'

Noviets · Post by **Noviets** » Mon Nov 23, 2015 9:09 am

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

Oyabun1 · Post by **Oyabun1** » Mon Nov 23, 2015 11:14 am

The results of those queries were as they should be for a correctly updated database.

Noviets · Post by **Noviets** » Mon Nov 23, 2015 12:16 pm

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)

david63 · Post by **david63** » Mon Nov 23, 2015 1:46 pm

Noviets wrote:Can I convert them back?

Restore your backup

Noviets · Post by **Noviets** » Mon Nov 23, 2015 2:26 pm

Should I try running the update_database.php again?

Noviets · Post by **Noviets** » Mon Nov 23, 2015 5:13 pm

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

advertisements