Quote from: Aleksi "Lex" Kilpinen on April 09, 2024, 02:25:00 PMThat can be a big table, it can simply take a while - And by a while, I mean a long time.
But if everything went OK with the CLI, and you are only stuck at maintenance, you can get out of it by editing the related setting in Settings.php
Hi there, i have the some problem, that upgrade stuck on URF8 convertion and it already takes a lot of time.
COuld You tell me what should to be edit to finish it?
Thank You from the moutain ;)
Pawel
Different problem, you should start a new topic, this one is marked solved.
You can try changing table/column collation to utf8mb3_general_ci in phpmyadmin before running upgrade.
as i Can see the problem is the some but upgrade stuck on different table.
About converting It was changed before and I am still waiting for at least 1 day
Start your own topic. And don't forget to include information like what table is it actually stalling on.
I have split the topic.
In the future, please start your own topic -- even if you THINK it might be the same thing - often it is not, and also, the previous topic was marked as solved - which means that it will often not be looked at.
You also have to provide actual DETAILS for your situation - as indicated by Sir Osis.
OK, sorry guys
ok so it stopped at:
Completed 4 out of 89 tables.
Current Table: "attachments"
but in the database I changed the character encoding to that indicated by Sir Osis of Liver
by now Time Elapsed: 567 mins, 7 seconds.
How many attachments do you have?
Any server errors?
Who is your host?
attachments about 662 files
No server errors
nazwa.pl
PHP version? Mysql version?
PHP 8.1
MariaDB 10.11 currently
Upgrade should run fine in that environment. Unless your database is huge it shouldn't take more than 15-20 minutes, even on a slow server. If the upgrade fails on different tables it's most likely a server issue, you need to contact host support.
Ok, I ill try to contact them but there is no error, just freezing on this table and thats it. Even when I have start it again its stops excatly on the some spot
Two things come to mind (such as it is):
- Is forum language set to english? This was a common problem early on in 2.1, but I believe it was fixed. Doesn't hurt to try.
- Are you restarting upgrade from beginning, or does it pick up from where it left off from previous attempt?
Generally, the language was set to English and fortunately I do this on a copy of the forum and db.
When I go to the /upgrade.php page
I see the information:
QuoteWarning!
"Admin" is running the upgrade script.
The upgrade script has been running for the last 18 hours, 21 minutes and 2 seconds.
The upgrade script was last updated 18 hours, 11 minutes and 32 seconds ago.
You can choose to either run the upgrade again from the beginning or continue from the last step reached during the most recent upgrade.
and after entering the administrator password I can select:
Continue from step reached during last execution of upgrade script.
It has been my experience that the run time displayed for upgrade script is not always correct. IIRC, resuming an incomplete upgrade gives you a choice of continuing from the point where it failed or restarting from beginning. If upgrade stalls it adds some code to Settings.php that saves the progress to that point, and that's used to continue execution from previous attempt. You can remove it manually before restarting upgrade, or restore a clean Settings.php from before your first upgrade run.
How large is your database?