Trying to upgrade to latest IPB version - Database Issue

[THL]

I'm getting the following warning when trying to update (image attached) , even after manually running these queries I cannot process past this step.

Any help or suggestions ?

[THL]

Also when I upgrade to PHP8 the site will not work and I have to downgrade to PHP 7.4 even though the upgrade tool says I need to have PHP8 or higher..

[Jim M]

You are running a rather old release so PHP 8 will not work on your current site, you will need to do the following:

1. Change to PHP 8.1 or 8.0 (preferably 8.1)
2. Check that PHP 8 includes all modules/extensions required: https://invisioncommunity.com/files/file/7046-invision-community-requirements-checker/
3. Run a manual upgrade: https://invisioncommunity.com/4guides/advanced-options/server-management/install-and-upgrade-r259/#manualupgrade

[THL]

Changed to PHP 8.1

Checked all required files, all ok

Uploaded all new files to server via FTP

Tried to run upgrade and get a 501 error and forum is not accessible at all..

I've had to re-instate the forum to a previous back to allow it to function again.

[Marc]

You would need to upload a fresh set of files from your client area and upgrade from /admin/upgrade . The issue you have there is (Im assuming) you are trying to run the upgrader from the admin CP. But the version you are on now doesnt support PHP 8, and the version you are going to only supports PHP 8. So the only option is to manually upgrader.

In terms of the original error, before you start the upgrade, ensure you arent showing the option to enable UTF8MB4 within the support area of your admin CP. If you are, then you need to action that before you proceed

[THL]

On 12/9/2024 at 10:20 AM, Marc said:

You would need to upload a fresh set of files from your client area and upgrade from /admin/upgrade . The issue you have there is (Im assuming) you are trying to run the upgrader from the admin CP. But the version you are on now doesnt support PHP 8, and the version you are going to only supports PHP 8. So the only option is to manually upgrader.

In terms of the original error, before you start the upgrade, ensure you arent showing the option to enable UTF8MB4 within the support area of your admin CP. If you are, then you need to action that before you proceed

I have tried all the above and my forum has now been down for 7 days, how do I get assistance with this as doing the above has cause a pile of errors and I've basically lost nearly 20 years of forum history...

[Gary]

Hi @THL,

Have you downloaded the most recent set of files from Invision Community (currently 4.7.19) and uploaded them to replace all of your existing files?

Do you get the 501 error before, during or after running the upgrade process?

Some things to think about:

• Try running the Invision Community Requirements Checker to ensure your server is all good to run on the latest version of Invision Community.
• Do you have any server error logs that provide more information about what could be happening?
• Have you disabled any plugins/add ons on your community prior to upgrading?

This is what I can think of before someone more tech savvy can assist. It is obvious to ensure you have backups of your community before upgrading or attempting any major backend changes.

Edited yesterday at 06:07 AM by Gary

[Marc]

Please provide the error that is being logged in your server error logs, and ensure that you access details are up to date, and we can take a look

4 hours ago, THL said:

I have tried all the above and my forum has now been down for 7 days, how do I get assistance with this as doing the above has cause a pile of errors and I've basically lost nearly 20 years of forum history...

If all else fails, you should be able to revert to your backup taken before upgrading. So you shouldnt lose anything there 🙂