Updating from 3.2.2 to 3.2.3 - Files Yes, Db No

TritonZA · Post by **TritonZA** » Thu Sep 20, 2018 8:31 am

Morning All,

Have 4 boards to update to 3.2.3. Of the 4, 3 worked perfectly fine with the file replacement method as indicated. On the 4th one, received the following errors/messages:

During the Db update process:

What the ACP page shows:

Tried restoring previous Db but get the message "This file is the incorrect format".

Any advice would be sincerely appreciated.

david63 · Post by **david63** » Thu Sep 20, 2018 10:29 am

That is nothing to do with phpBB.

Possible reasons - your site has been hacked, your host has added something to your site, you have added something to your site.

TritonZA · Post by **TritonZA** » Thu Sep 20, 2018 12:12 pm

david63 wrote: ↑Thu Sep 20, 2018 10:29 am That is nothing to do with phpBB.

Possible reasons - your site has been hacked, your host has added something to your site, you have added something to your site.

Interesting you say this David.

I have just done an update from 3.2.2 to 3.2.3 with the ISP host used on my other 3 sites (where there were no problems at all) and I get the exact same error messages.

This would indicate a Db problem then surely because it occurred with two different ISP's?

PS, I used a Db backup from before trying the update today.

/T

Post by **stevemaury** » Thu Sep 20, 2018 3:32 pm

You actually get the message "Picture is in a password protected album"?

TritonZA · Post by **TritonZA** » Fri Sep 21, 2018 6:57 am

stevemaury wrote: ↑Thu Sep 20, 2018 3:32 pm You actually get the message "Picture is in a password protected album"?

Fixed this image display issue. Now as attachments in first post.

Any other suggestions what the error is indicating?

Post by **stevemaury** » Fri Sep 21, 2018 1:42 pm

How did you upgrade (NOT "update")?

TritonZA · Post by **TritonZA** » Fri Sep 21, 2018 2:07 pm

stevemaury wrote: ↑Fri Sep 21, 2018 1:42 pm How did you upgrade (NOT "update")?

Hi Steve, I upgraded by following the steps in this link: https://www.phpbb.com/support/docs/en/3 ... ating-32x/

Post by **stevemaury** » Fri Sep 21, 2018 3:15 pm

In your /store directory, there is a file migrations_(some digits).log. Change its extension to .txt and attach it here.

TritonZA · Post by **TritonZA** » Sat Sep 22, 2018 6:42 am

stevemaury wrote: ↑Fri Sep 21, 2018 3:15 pm In your /store directory, there is a file migrations_(some digits).log. Change its extension to .txt and attach it here.

Here you go.

suewright · Post by **suewright** » Sat Sep 22, 2018 9:25 am

I have the same problem - Files have updated but not the DB

Post by **stevemaury** » Sat Sep 22, 2018 1:55 pm

@suewright, please start your own topic.

Post by **stevemaury** » Sat Sep 22, 2018 4:50 pm

OP, try running this SQL on your database and then do the database update again.

Code: Select all

ALTER TABLE phpbb_user_notifications DROP INDEX itm_usr_mthd

For how to do that, see Executing SQL Queries in phpMyAdmin

Also, you did backup your 3.2.2 database before starting the update, didn't you?

TritonZA · Post by **TritonZA** » Sun Sep 23, 2018 7:08 am

stevemaury wrote: ↑Sat Sep 22, 2018 4:50 pm OP, try running this SQL on your database and then do the database update again.

Will do.

stevemaury wrote: ↑Sat Sep 22, 2018 4:50 pm Also, you did backup your 3.2.2 database before starting the update, didn't you?

Yes I did

TritonZA · Post by **TritonZA** » Sun Sep 23, 2018 1:07 pm

Fantastic news Steve, it worked

. Db update ran to 100% and all is good again. No errors.

For a layman, what did the SQL query actually do to the Db?

/T

TritonZA · Post by **TritonZA** » Tue Sep 25, 2018 5:17 am

TritonZA wrote: ↑Sun Sep 23, 2018 1:07 pm For a layman, what did the SQL query actually do to the Db?

Morning All,

Would really appreciate knowing what the SQL query did to fix this Db issue - trying to learn from the support given