kstan

9 minutes ago, Daniel F said:

No, that's something what you'll have to ask your web hosting provider.

I see... Well, I am my own hosting provider (although I don't really know what I'm doing), and I did in fact have ModSecurity installed. It seemed like a difficult and risky task to just turn it off altogether, so instead I experimented with turning certain features off, and lo and behold, turning off "Backend Compression" did the trick!

Thank you for saving me!

Would that be in the conf_global file? Is so, I do not.

When I click the "Edit HTML and CSS" button for a theme (any theme) I get an "Internal server error". I have tried to look for information in the error log for the server, but I can't find anything. I also tried to downgrade to PHP 8 from PHP 8.1, but that makes the whole site fail. I also tried to disable plugins to no avail.

I have no idea what to do next.

I just want to report that the problem has finally been resolved. In the end converting the database to utf8mb4 did the trick. I can't find it now, but I think someone at some point asked me why I hadn't done that. I replied that I intended to, but I wanted the other problem resolved first before messing with converting the database. Nowhere that I saw was utf8mb4 listed as a requirement to upgrade, but nonetheless, that's what solved it.

Thank you to everybody who tried to help. Much appreciated!

50 minutes ago, Miss_B said:

Is your forum running without issues right now or do you get errors?

It looks like the upgrade wasn't finished successfully indeed. As it hapens a couple of weeks ago I was contacted by a member here who had a very similiar issue. What I did was, roll back to the backup made before the upgrade and then re-do it again and fixing the problems that popped up, which were several sql queries as in your case. After that the upgrade went through smoothly.

My advice to you if I may, is to roll back to the most recent backup made before the upgrade and re-do the upgrade again.

It appears to be running without errors. Everything seems fine except that it won't update. As far as a backup, since the problem first started in July, I no longer have a backup that old. What I would be interested in knowing is if it actually performed those changes to the database to make it ready for 4.7. If so, would it be possible to install IC 4.7.3 from scratch with a new database and then, after installation, connect it to the old database?

20 minutes ago, Miss_B said:

I meant from what version did you try to upgrade to 4.7.0?

Hmm.... I see what you mean. When you asked your question, I went to my dashboard to check, and my dashboard says I have 4.7.0, so that's what I replied. However, the upgrade to 4.7.0 never finished succesfully, which is the whole problem. Another detail is that the upgrade I'm  trying to perform says it includes version 4.7.0 through 4.7.3. So I probably still have 4.6.12.1, but my dashboard thinks I have 4.7.0. Or something. I'm confused.

8 minutes ago, Miss_B said:

What version are you trying to upgrade from?

4.7.0

9 hours ago, Marc Stridgen said:

Are you using PHP 8? If so, could you test with 7.4 and see ig that then upgrades? Just seen a report of something very similar

Thank you for the suggestion. I now tried to roll back from PHP 8 to 7.4, but unfortunately, it made no difference. I still go around in circles.

I also used Navicat for MySQL which is a desktop app. It did take a few minutes, but it performed all the commands without error.

Does phpmyadmin or similar MySQL software qualify as SSH? Because I did that and the result was the same.

26 minutes ago, Miss_B said:

What is the actual query that it keeps asking you to run?

It's too long to post, but I attached it.

query.txt

One week later...

The database no longer crashes when I attempt the upgrade. It still tells me there is a problem with the database and to run a long query before proceding with the upgrade. I do that. It goes fine, no errors, but after finishing the query, it once again tells me there is a problem with the database and to run the same script again. In other words, I'm going around in circles and never get to the point where I can do the actual upgrade.

Any ideas?

Okay, I will do a thorough database check and see what else I can do on the server side.

Failed again. I'm getting "Incorrect key file for table..." error messages for different tables when I try to load the forum. I try to repair tables, but they are unrepairable. Now trying to reestablish the database from a backup.

Any ideas?

Just now, Stuart Silvester said:

EXPLAIN statements only work with SELECT, DELETE, INSERT, REPLACE and UPDATE queries, that likely explains why you're seeing an error message.

My only suggestion is to try the update again with 4.7.3 and make sure that you have a working backup of your community before you start.

Thank you! I did not know that. I will try the update again and hope for the best.

A couple of months ago I tried to upgrade to version 4.7.0, but it went terribly wrong. During the initial database query, the database crashed so thoroughly it wasn't even salvageable. I had to restore it with a database backup that, fortunately, was only a couple of days old.

So now I want to try again, but because of my previous failed attempt, I'm using extra caution. I put the long query into my MySQL Navicat software and asked it to explain the query. It doesn't get far. It tells me that just about every line has sql errrors. For instance:

EXPLAIN DROP TABLE `core_modules`
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE `core_modules`' at line 1
> Time: 0,118s

So naturally, I checked my MySQL server version, which is MySQL 8. There is no upgrade available.

What on earth is wrong with my setup and what should I do?

I deleted a cookie and voila, I was back in business. It then asked me to add a line to my constants.php, and after doing that, the rest worked smoothly.

Thank you for your help.

Well, I have now paused Cloudflare. Cloudflare is still handling DNS, but traffic doesn't go through Cloudflare, and I still get the same error message.

It's extremely weird what exactly is happening, but until I figure that out with my hosting company, is there any way I can abort the upgrade so that my visitors can access the forum again and don't get the "upgrade in process" message.

This is giving me all sorts of new problems with my certificate, license key, posts not showing up from the last month, etc. It's a mess. I will have to contact my host to figure out the certificate issue before I can fix the upgrade problem, unless someone has a different suggestion?

Thanks for your response.

When I do as suggested, it asks me to log in again. When I do that, I get the same error message.

I just changed the url of my community. Everything seemed to be working, including my admin area. Now I'm trying to upgrade to the latest version, but after a couple of steps I get this message:

Quote

 

This site can’t be reached

The webpage at https://***/?app=core&module=system&controller=upgrade might be temporarily down or it may have moved permanently to a new web address.
ERR_FAILED

 

I tried clearing the cache, but that doesn't seem to work either.

What to do?

PS, The community itself was also working, but now only shows an "upgrade in process" message.