Upgrade issue from 3.2 to 3.3

[DoctorB2]

Not sure whether this should be in the 3.2 section!

I hit major problems with the upgrade.

I started with your guide
"https://www.phpbb.com/support/docs/en/3 ... e/upgrade3"
and followed it accurately.

?At what stage should I have updated the server PHP from 5.4 to 7.2?

First warning I got was
"SQL ERROR [ mysqli ] Unknown column 'user last active' in 'field list' [1054]"

Decided I needed to update the MySql db, so ran myforum/install/app.php, but got this warning
"No Valid Update Directory Was Found"
and I could not update the db.

Full restore on CPanel (and the necessary tweaking) and I am back running 3.2.

How to try again? I'm nervous!

[Mick]

Not sure whether this should be in the 3.2 section!

Support for 3.2 has ended so you wouldn’t have been able to post there anyway, this forum is good for asking about 3.3 upgrades.

Once you’ve removed the old files and replaced them with the new just before you run install is the usual time to upgrade PHP.

You should be following Upgrading from 3.2 to 3.3

It’s my opinion that one job at a time is the way to go. If you’re upgrading phpBB don’t break off and start messing with the database. If you want to do some server work don’t start upgrading phpBB until you’ve finished. Mixing all this different stuff can cause unholy hell.

Why nervous, you’ve got a backup?

[thecoalman]

?At what stage should I have updated the server PHP from 5.4 to 7.2?

Upgrade to 8.2 preferably.

[DoctorB2]

You should be following Upgrading from 3.2 to 3.3 - indeed I was!

Only reason I tried to update the db was because of the warning, as I posted.
"First warning I got was
"SQL ERROR [ mysqli ] Unknown column 'user last active' in 'field list' [1054]"

Should I just ignore it and will it go away? What caused it?

Unholy hell was what I got......

How do I know the upgrade is complete and when to run the db update? Will the acp come back before I update the db?b

[Mick]

You should be following Upgrading from 3.2 to 3.3 - indeed I was!

Not according to this:

I started with your guide
"https://www.phpbb.com/support/docs/en/3 ... e/upgrade3"
and followed it accurately.

Just follow the instructions, I’m assuming you got those error messages because of the PHP version. Just remember to upgrade the PHP version before you run install. You will be told when it’s finished.

[thecoalman]

That warning is likely because of the php version. Follow the directions in the link Mick provided, when you get to step ten switch the php version. If you have 8.2 available use that.

[DoctorB2]

OK - FYI
DoctorB2 wrote: ↑Sat Aug 03, 2024 11:42 am
You should be following Upgrading from 3.2 to 3.3 - indeed I was!

Not according to this:

DoctorB2 wrote: ↑Sat Aug 03, 2024 10:41 am
I started with your guide
"https://www.phpbb.com/support/docs/en/3 ... e/upgrade3"
and followed it accurately.

As far as I can see the same document?

So, what was the problem with
"Decided I needed to update the MySql db, so ran myforum/install/app.php, but got this warning
"No Valid Update Directory Was Found"
and I could not update the db." ?

[warmweer]

OK - FYI
DoctorB2 wrote: ↑Sat Aug 03, 2024 11:42 am
You should be following Upgrading from 3.2 to 3.3 - indeed I was!

Not according to this:

DoctorB2 wrote: ↑Sat Aug 03, 2024 10:41 am
I started with your guide
"https://www.phpbb.com/support/docs/en/3 ... e/upgrade3"
and followed it accurately.

As far as I can see the same document?

Not really:
The link you posted resolves to https://www.phpbb.com/support/docs/en/3.3/ug/upgradeguide/upgrade3/

And the link with the relevant info = https://www.phpbb.com/support/docs/en/3.3/ug/upgradeguide/upgrade32/

[DoctorB2]

My mistake with that link, sorry - I had in fact followed the correct one which retains the /ext directory. I have it printed off for safety!

I would still appreciate any help with the second warning I received -"No Valid Update Directory Was Found" when trying to run app.php

[Mick]

Did you try the upgrade again in the right order?

I’m assuming you got those error messages because of the PHP version

That warning is likely because of the php version

[warmweer]

The PHP version could be the cause: make sure you're using PHP > 7.2.0, preferably 7.4+ (even better 8.0 or higher.

Apart from that, delete /install and /production from /cache
Upload all the directories as described in the install document

and check your /store: if there's an install_config.php and/or io_lock.lock: delete those before navigating to /install. Navigate to /install (actually when /install is present it will automatically resolve to /install.
From then on just follow the messages on the screen (assuming you've uploaded all the files and directories as described) , update database only

[DoctorB2]

I am still stuck! I tried again today, following exactly the 'upgrading from 3.2 to 3.3' script, and fared better than before until I reset the board via the ACP when I lost access and am getting 500 errors. I did get the 'update database only' option this time.

PHP is 7.4. This will be the second time I have had to ask for a complete site restore for the host! Should I be doing a smaller upgrade step, perhaps, rather than to 3.3.12?

The first few lines of the error log are:

Code: Select all

[16-Aug-2024 19:47:12 Australia/Sydney] PHP Warning:  require(./includes/startup.php): failed to open stream: No such file or directory in /home/**/public_html/ops-normal.org/common.php on line 23
[16-Aug-2024 19:47:12 Australia/Sydney] PHP Warning:  require(./includes/startup.php): failed to open stream: No such file or directory in /home/**/public_html/ops-normal.org/common.php on line 23
[16-Aug-2024 19:47:12 Australia/Sydney] PHP Fatal error:  require(): Failed opening required './includes/startup.php' (include_path='.:/opt/alt/php74/usr/share/pear') in /home/**/public_html/ops-normal.org/common.php on line 23
[16-Aug-2024 19:47:26 Australia/Sydney] PHP Warning:  require(./includes/startup.php): failed to open stream: No such file or directory in /home/**/public_html/ops-normal.org/common.php on line 23
[16-Aug-2024 19:47:26 Australia/Sydney] PHP Warning:  require(./includes/startup.php): failed to open stream: No such file or directory in /home/**/public_html/ops-normal.org/common.php on line 23
[16-Aug-2024 19:47:26 Australia/Sydney] PHP Fatal error:  require(): Failed opening required './includes/startup.php' (include_path='.:/opt/alt/php74/usr/share/pear') in /home/**/public_html/ops-normal.org/common.php on line 23
[16-Aug-2024 19:47:27 Australia/Sydney] PHP Warning:  require(./includes/startup.php): failed to open stream: No such file or directory in /home/**/public_html/ops-normal.org/common.php on line 23

The startup.php file exists in /include.

[janus_zonstraal]

Should I be doing a smaller upgrade step, perhaps, rather than to 3.3.12?

Going from 3.2 to 3.3.12 can't be a problem.

[I did get the 'update database only' option this time. /quote]
What did you see?

[DoctorB2]

The database upgrade seemed to work correctly - how can I check?

Host has now restored a site backup and I show 3.3.12 and PHP 7.4.

But even more serious confusion for me now! I have been getting weird issues in the restored site like the reply box misbehaving, PMs will not accept text in the message box and quoting posts does not work. The 'front page' of the site has also changed significantly with bits moved around.

HOWEVER, I decided to revert the PHP to the original 5.4 and everything is now fine and as it was! BUT the documentation tells me I need 7.2 or higher for 3.3??? I do not understand!

[janus_zonstraal]

I link to your board will help.