Re: Problems trying to upgrade from 2.0.19 to 2.1.4

[swo0p]

That 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

[Sir Osis of Liver]

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.

[swo0p]

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

[Aleksi "Lex" Kilpinen]

Start your own topic. And don't forget to include information like what table is it actually stalling on.

[Kindred]

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.

[swo0p]

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.

[Sir Osis of Liver]

How many attachments do you have?

Any server errors?

Who is your host?

[swo0p]

attachments about 662 files
No server errors
nazwa.pl

[Sir Osis of Liver]

PHP version?  Mysql version?

[swo0p]

PHP 8.1
MariaDB 10.11 currently

[Sir Osis of Liver]

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.

[swo0p]

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

[Sir Osis of Liver]

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?

[swo0p]

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:

Warning!

"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.

[Sir Osis of Liver]

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?