I have updated MySQL to the latest version of my web host but the board is not working properly, I can't see any content.

Any click reloads the home page while any click on "Topics" list shows a page with no main content, just right blocks and online users

I tried the "Fix This" button inside the admin panel but it will corrupt the database and I must import the latest backup to have this.

Actually the board is offline, I can bring it online to see the behaviour

  On 2/17/2025 at 8:38 PM, th3madcap said:

I have updated MySQL to the latest version of my web host but the board is not working properly, I can't see any content.

Any click reloads the home page while any click on "Topics" list shows a page with no main content, just right blocks and online users

I tried the "Fix This" button inside the admin panel but it will corrupt the database and I must import the latest backup to have this.

Actually the board is offline, I can bring it online to see the behaviour

What errors are you getting on the forum when loading it? What about either the System Logs and the Server Error log page, any messages logged in there? Can you post the link to your forum?

No errors both in system logs and error log pages

The board is online now, you can see the behaviour

www.radiochitarra.it

  On 2/17/2025 at 8:49 PM, th3madcap said:

No errors both in system logs and error log pages

The board is online now, you can see the behaviour

www.radiochitarra.it

What is your forum version? I think that maybe the issue is the incompability of your forum version with that of MySql. By the looks of it you are using an older version. You can try to upgrade your forum to 4.7.20 and see if it would help. But first can you disable all third party stuff and see if that would fix the issue?

Is the MySQL update the only change you did?

What version of MySQL did you upgrade to? Did you make any other changes? Did any of the tables crash?

Are you getting any other errors on your server?

This is what I have done.

Update the DB. Board OK

Started to update the board, click the "Fix This" button. DB error.

DB backup imported. No error but Actual issue.

Version is 4.3.5, I'm having troubles updating the board because of a 500 error when I switch to php8, but this is another problem.

  On 2/17/2025 at 8:38 PM, th3madcap said:

I have updated MySQL to the latest version of my web host [...]

From which version have you upgraded MySQL? And what's the new version?

If you have a backup made before the MySQL upgrade, your best option would be to empty the database, downgrade MySQL to the previous version, and restore the database backup.

  On 2/17/2025 at 9:23 PM, th3madcap said:

Started to update the board, click the "Fix This" button. DB error.

What was the exact database error?

  On 2/17/2025 at 9:23 PM, th3madcap said:

Version is 4.3.5, I'm having troubles updating the board because of a 500 error when I switch to php8, but this is another problem.

That's normal behavior as Ipb 4.3.5 isn't compatible with php 8. What you need to do imo is to upgrade your forum to at least 4.7.20 which will fix the php and MySQL incompatibility issues.

  On 2/17/2025 at 9:33 PM, teraßyte said:

From which version have you upgraded MySQL? And what's the new version?

If you have a backup made before the MySQL upgrade, your best option would be to empty the database, downgrade MySQL to the previous version, and restore the database backup.

I have imported the db backup in a MySQL v5.7 just like before. Nothing.
EDIT: Articles works fine

Edited February 18Feb 18 by th3madcap

  On 2/17/2025 at 9:35 PM, Miss_B said:

What was the exact database error?

That's normal behavior as Ipb 4.3.5 isn't compatible with php 8. What you need to do imo is to upgrade your forum to at least 4.7.20 which will fix the php and MySQL incompatibility issues.

even with lower version of php I have errors (translated)

1C287/2 You are using PHP 7.4.33. You need version PHP 5.3.0 or superior. Contact...

Im not sure why it is you are changing PHP if the only thing you changed prior was mysql.

To be honest, what you need to be doing here is trying to get it upgraded to the latest release of the platform by uploading a new version of the requirement checker, ensuring things are compatible, then manually uploading 4.7.20, then upgrading from /admin/upgrade

  On 2/18/2025 at 9:43 AM, Marc said:

To be honest, what you need to be doing here is trying to get it upgraded to the latest release of the platform by uploading a new version of the requirement checker, ensuring things are compatible, then manually uploading 4.7.20, then upgrading from /admin/upgrade

I have an error 500 now.

I uploaded the ips folder to my root folder, error 500 with php7.4 and with php8, I had to upload the old folder again

Please ensure you are doing the following. If you are then still getting errors, we need to know at which point, and what is being logged in your server error logs. We can then go from there and see if we can get you sorted

1. Upload the latest requirement checker, and check your server meets minimum requirements (you absolutely would be using PHP 8.1 if you are upgrading to the latest version of 4)

2. Upload a fresh set of files, downloaded from your client area. You should not need to be reuploading uploads or anything, as you should be merging, not replacing entirely

3. Run the upgrader from /admin/upgrade (manually visit that URL)

  On 2/18/2025 at 9:25 AM, th3madcap said:

1C287/2 You are using PHP 7.4.33. You need version PHP 5.3.0 or superior. Contact...

This indicates that your forum version isn't compatible with php 7.4.

  On 2/18/2025 at 11:57 AM, th3madcap said:

I uploaded the ips folder to my root folder, error 500 with php7.4 and with php8, I had to upload the old folder again

Can you check your server error log and post here the most recent messages logged in there?

And to quote myself:

  On 2/17/2025 at 9:35 PM, Miss_B said:

What you need to do imo is to upgrade your forum to at least 4.7.20 which will fix the php and MySQL incompatibility issues.

Here you can find a detailed guide on how to perform the upgrade:

https://invisioncommunity.com/4guides/advanced-options/server-management/install-and-upgrade-r259/

Edited February 18Feb 18 by Miss_B

The site is working now, the threads are visible but I have an error trying to reply to a topic:

[[Template forums/front/topics/topic is throwing an error. This theme may be out of date. Run the support tool in the AdminCP to restore the default theme.]]

At this point I want to update to 4.7 but:

4.3.5 does not work with PHP8 while PHP8 is required for 4.7.

I Think I need a version in between that works both with actual php7.4 and php8, to upgrade to that version, then update php to php8, then upgrade again the board to 4.7

1. Upload the latest requirement checker, and check your server meets minimum requirements (you absolutely would be using PHP 8.1 if you are upgrading to the latest version of 4)

2. Upload a fresh set of files, downloaded from your client area. You should not need to be reuploading uploads or anything, as you should be merging, not replacing entirely

3. Run the upgrader from /admin/upgrade (manually visit that URL)

Doing the above, you can update your PHP version. I understand the current version wont work, but that doesnt matter, as you are upgrading manually

1: Done. All green except PHP. Actually I have v4.3.5 that doesn't work with PHP8 so I have PHP7.4, but I can switch in any moment

2: Done This Morning: I have an error 500 when I merge the ips_38aea content with my actual site root, and...

3) ...the entire site including /admin/upgrade doesn't work even switching to PHP8.4

http://www.radiochitarra.it/ic5.php

I try again later
Thanks

PHP info says you're still using PHP 7.4.33, not 8.0. Also, version 4 supports only 8.0 and 8.1.

Anything 8.2+ is supported only by v5, so PHP 8.4 won't work, either.

OK, I will switch to 8.1 then

  On 2/18/2025 at 4:54 PM, Marc said:

1. Upload the latest requirement checker, and check your server meets minimum requirements (you absolutely would be using PHP 8.1 if you are upgrading to the latest version of 4)

2. Upload a fresh set of files, downloaded from your client area. You should not need to be reuploading uploads or anything, as you should be merging, not replacing entirely

3. Run the upgrader from /admin/upgrade (manually visit that URL)

Doing the above, you can update your PHP version. I understand the current version wont work, but that doesnt matter, as you are upgrading manually

1: Done
2: Done
3: Error while upgrading: Field 'conf_id' doesn't have a default value
/web/htdocs/www.radiochitarra.it/home/applications//setup/upg_/queries.json - query #2

REPLACE INTO `rc_core_sys_conf_settings` ( `conf_key`, `conf_default`, `conf_value`, `conf_app`, `conf_report` ) VALUES ( ?, ?, ?, ?, ? )

The conf_id column should be set as an auto-increment value, so the ID missing shouldn't be a problem. This is the first time I've ever seen this error.

Never seen it before in all the upgrades I did.

I think I need the SQL structure of the DB to fix it with the right properties

I will dump the content of the DB, fix the structure then import all the data again

Is there a way to have the SQL structure?

The only way would be to install a new instance, but in all honesty, you should not be doing this. Really you need to revert to the backup taken prior to this issue