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 Tuesday 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 🙂 

[Maxwellshouse]

I am also having this same issue, when I upgrade to PHP 8+ I can’t access my forum to complete the upgrade in the CP and a manual upgrade is a little over my head 

[Miss_B]

18 hours ago, Maxwellshouse said:

I am also having this same issue, when I upgrade to PHP 8+ I can’t access my forum to complete the upgrade in the CP and a manual upgrade is a little over my head 

Manual upgrade is very easy. All you have to do is follow the steps mentioned at the following guide: (Manual Upgrade is the section that you need)

 Or did you mean running the aforementioned sql queries manually? If that's the case all you have to do is copy/paste them at the SQL Box of your forum's database at the phpmyadmin.

Edited 15 hours ago by Miss_B

[Maxwellshouse]

16 hours ago, Miss_B said:

Manual upgrade is very easy. All you have to do is follow the steps mentioned at the following guide: (Manual Upgrade is the section that you need)

 Or did you mean running the aforementioned sql queries manually? If that's the case all you have to do is copy/paste them at the SQL Box of your forum's database at the phpmyadmin.

Thanks @Miss_B my concern is if I change to PHP 8 do the manual upgrade then what if I still can't access to login to my site and CP ?

[Miss_B]

46 minutes ago, Maxwellshouse said:

Thanks @Miss_B my concern is if I change to PHP 8 do the manual upgrade then what if I still can't access to login to my site and CP ?

Php 8 is supported by the current stable Ipb version, so I don't think that there will be any issues after the upgrade. But it would be best t o make first a full backup of your database and forum files too before the upgrade. That's for just in case if things don't go as planned you can always roll back.

Another way to go about it is to make a duplicate of your live forum to your test forum and proceed with upgrading that first. Like that you will know what to expect when you upgrade your main forum. 

Hope it helps.

[Maxwellshouse]

2 minutes ago, Miss_B said:

Php 8 is supported by the current stable Ipb version, so I don't think that there will be any issues after the upgrade. But it would be best t o make first a full backup of your database and forum files too before the upgrade. That's for just in case if things don't go as planned you can always roll back.

Another way to go about it is to make a duplicate of your live forum to your test forum and proceed with upgrading that first. Like that you will know what to expect when you upgrade your main forum. 

Hope it helps.

so maybe I should have waited for your reply and not jumped straight in, All files uploaded successfully but I'm getting this error when trying to access my site, mmaybe I should have disabled the arcade before starting

 

Fatal error: Only files produced by the PHP 8.1 ionCube Encoder can run on PHP 8.1. The file /home/sites/99b/5/58fe60a87a/public_html/forum/applications/arcade/Application.php has been encoded by the ionCube Encoder for PHP 7.1. in Unknown on line 0

[Miss_B]

18 minutes ago, Maxwellshouse said:

so maybe I should have waited for your reply and not jumped straight in, All files uploaded successfully but I'm getting this error when trying to access my site, mmaybe I should have disabled the arcade before starting

Have you actually run the upgrader? Because uploading of the files only isn't enough to upgrade your forum. If you haven't run the upgrader yet, you are in time to make a backup of the database.

That being said,  according to the error message it looks like it was generated with a version of ionCube for PHP 7.1 . Meaning that the file was encoded with PHP 7.1 and cannot be decoded by the currently set PHP 8.x version.

What version of Ipb and php did you try to upgrade from?

Edited 14 hours ago by Miss_B

[Maxwellshouse]

I haven't run the upgrader as I can't access the site

ionCube I new nothing about 

I think I was on Ipb 7.4 with PHP 7.3

really appreciate the help and advice 

I just tried rollin back to PHP 7.3 to access CP and I'm getting this error

 Fatal error: Exception thrown without a stack frame in Unknown on line 0

Edited 13 hours ago by Maxwellshouse

[Miss_B]

15 minutes ago, Maxwellshouse said:

I just tried rollin back to PHP 7.3 to access CP and I'm getting this error

Did you roll back only the php version or the forum files too? Because the forum files should be compatible with php 7.3 as well. It looks like you have the latest Ipb files on Php 7.3. and that is causing the conflict as they are not compatible with each other.

Did you make a backup of the database? If you haven't done it yet, I would strongly advice you, if I may, to do that a.s.a.p. 

[Maxwellshouse]

18 minutes ago, Miss_B said:

Did you roll back only the php version or the forum files too? Because the forum files should be compatible with php 7.3 as well. It looks like you have the latest Ipb files on Php 7.3. and that is causing the conflict as they are not compatible with each other.

Did you make a backup of the database? If you haven't done it yet, I would strongly advice you, if I may, to do that a.s.a.p. 

I only ran back the PHP version, seems a catch 22 issue, the new files aren't compatible with PHP 7.3 to access the upgrader 

I haven't done any upgrades etc for a number of years so I'm extremely rusty, not that I ever found this side of things easy anyway lol 

[Miss_B]

47 minutes ago, Maxwellshouse said:

I only ran back the PHP version, seems a catch 22 issue, the new files aren't compatible with PHP 7.3 to access the upgrader 

If you reupload back your previous files then everything will be fine. If you don't have a copy of the files then try to ask your host if they do. Most hosts make regular backups and you might luck out.

47 minutes ago, Maxwellshouse said:

I haven't done any upgrades etc for a number of years so I'm extremely rusty, not that I ever found this side of things easy anyway lol 

I hear you. Upgrading Ipb is a pretty straight forward procedure. The steps on how to do it are mentioned in the link I posted above. If you aren't comfortable with doing it yourself you can hire someone else. You can take a look at the Providers page where several users, among them myself as well, offer paid services. 

Or better yet, you can take a look at Ips Cloud hosting and you won't have to worry about these kind of issues anymore, but concentrate on building and managing your community headache free instead. 

Edited 12 hours ago by Miss_B

[Maxwellshouse]

2 minutes ago, Miss_B said:

If you reupload back your previous files then everything will be fine. If you don't have a copy of the files then try to ask your host if they do. Most hosts make regular backups and you might luck out.

I hear you. Upgrading Ipb is a pretty straight forward procedure. The stsps are mentioned in the link I posted above. If you aren't comfortable with doing it yourself you can hire someone else. You can take a look at the Providers page where several users, among them myself as well, offer paid services. 

Or better yet, you can take a look at Ips Cloud hosting and you won't have to worry yourself about these kind of issues anymore, but concentrate on building and managing your community headache free. 

I didn’t backup before uploading the new IPB files but they uploaded without any errors, I have now just done a database backup though (a little late I know)

I’ve followed the instructions with uploading the files I just can’t access the site to complete the next step of running the upgrader so I’m stuck

[Maxwellshouse]

I contacted my host in the hope they cold help or be able to provide an earlier backup. Is the issue just with the arcade ? would it work to delete the arcade via FTP and look at reinstalling again after the upgrade ?

 

Quote

So the error suggested reverting the PHP Version to 7.1 here so I have just done that for you now. This does however return the following error here: Fatal error: Class 'IPS\Application' not found in /home/sites/99b/5/58fe60a87a/public_html/forum/applications/arcade/Application.php on line 0 This implies there is a file missing from the application that should be loading here. Are you able to check with the Software developers how this should be set up on your Hosting please?

 

[Maxwellshouse]

deleted the arcade and seem to be getting somewhere, I've managed to login to the upgrader but I'm getting this error, can anyone tell me what the permissions should be ?

 

[Jim M]

6 hours ago, Maxwellshouse said:

so maybe I should have waited for your reply and not jumped straight in, All files uploaded successfully but I'm getting this error when trying to access my site, mmaybe I should have disabled the arcade before starting

 

Fatal error: Only files produced by the PHP 8.1 ionCube Encoder can run on PHP 8.1. The file /home/sites/99b/5/58fe60a87a/public_html/forum/applications/arcade/Application.php has been encoded by the ionCube Encoder for PHP 7.1. in Unknown on line

You would need to contact the author as PHP 7 Ioncube is not compatible with PHP8.

1 minute ago, Maxwellshouse said:

deleted the arcade and seem to be getting somewhere, I've managed to login to the upgrader but I'm getting this error, can anyone tell me what the permissions should be ?

 

This would likely be that the files here are not up to date so ensure they’ve been overwritten with the latest. Otherwise, they would need to be readable by your web server. This typically is 644 and owned by the correct user/group. If you are unsure, please contact your host. 

[Maxwellshouse]

2 minutes ago, Jim M said:

You would need to contact the author as PHP 7 Ioncube is not compatible with PHP8.

This would likely be that the files here are not up to date so ensure they’ve been overwritten with the latest. Otherwise, they would need to be readable by your web server. This typically is 644 and owned by the correct user/group. If you are unsure, please contact your host. 

I have a new arcade version to install after the upgrade

permissions look correct I'll try uploading the new files again as it suggests bt there were no failed uploads

[Maxwellshouse]

1 hour ago, Maxwellshouse said:

I have a new arcade version to install after the upgrade

permissions look correct I'll try uploading the new files again as it suggests bt there were no failed uploads

uploaded file  again but I'm getting the same errors

[Jim M]

24 minutes ago, Maxwellshouse said:

uploaded file  again but I'm getting the same errors

Check ownership of the files and ensure that is correct. Your server might not be able to read them.