Try this:
In this command, replace DROP with ADD
This will create the missing column, then upgrader will successfully remove it.
I.e. After successfully creating it, run upgrader
When you flashed back the 7.x PHP and restored your forum, it was OK. right?
After downloading ips 4.7.9 files, and upload it, you should change php to 8.x and then run update.
Try this - log in via ftp
Open Applications folder
Delete the Pages folder. You can download this folder to your computer before deleting.
You will no longer see it in your admin panel.
And you check through phpMyAdmin which of the tables in your database actually has a large size.
There is such a column - size, in the list of tables, just scroll and you will find which table has a strangely large size. This will direct help reasoning to you in the direction of solving the issue
Don't miss the fact that the content maximum also depends on your host plan, i.e. from the real space on your server that you have available. I.e. software settings are relative - IPS has no way of knowing how much space you have on your server, how many users there are in your community to display an accurate size indicator.
It is possible, but it would follow with a default theme that the IPS does not have an issue with the JS. And an author mentioned that he included this theme with the same result.
This is strange - images from your admin panel only exist when the suite is enabled in designer mode.
It might be a good idea to restore with the help of your host a backup of your forum and database before the update date.
The theme doesn't matter, your suite is in designer mode. In the Themes section, at the top right, you have a Designer mode button.
Click this button and disable this mode and also refuse sync because you are in update mode at the same time.