There is a lot of lines to change,

when i press fix automatically it takes some tame and returns to the same list what i need to change, if i do this manually and press check again it returns to the same list again with all those lines, nothing changed. What i have to check to resolve this issue?

If you run these manually on your MySQL server, do you get the same results? Are there any other database related errors in ACP -> Support?

no, only these queries. If i do mannualy nothing changes, al those lines keeps the same.

When you run those commands via SSH, what was the output?

 

When you run those commands via SSH, what was the output?

i run those commands on phpmyadmin sql tab, all commands done succesfully. But when i try to check again, all those queries appears again.

 

i run those commands on phpmyadmin sql tab, all commands done succesfully. But when i try to check again, all those queries appears again.

I generally would not run them via phpMyAdmin.  Instead run them via SSH inside of the mysql command.  

Edited July 10, 20222 yr by Randy Calvert

 

I generally would not run them via phpMyAdmin.  Instead run them via SSH inside of the mysql command.  

Still the same result, query is ok, but nothing changes on the list.

Have you checked to ensure these are being run on the correct database? This would only come up if its actively checked if those issues are present on your database

how it can being run on other database, there is no other database, only one. All previous updates were fine and now i have this.

 

how it can being run on other database, there is no other database, only one

Unfortunately, I am not aware of this as I cannot see the database. Please upload a fresh set of files from your client area, then run the upgrade from /admin/upgrade if you are sure you have those database updates in place.

but why this database fix not works automatically? Maybe i can check somewhere for more info whats happening? in admin cp logs no errors.

It may well be a bug here. As mentioned, it should really be seeing the changed if you are making them, however if not it will correct them during the upgrade process

seems like there is a bug, manual update was done without any problems.

Glad to see you got that upgraded. Its likely the upgrade procedure has actually run the queries there, so you shouldnt see them going forward. However if you have that issue in the future, of course let us know

there was few times appeared box asking update database some tables and it was fixed automatically. But whats funny that all those lines what i posted in first post they are still there in admin cp, saying that i need to fix them. Until everything is working its okay for me.

No problem. Just let us know if you see that happen on any future upgrades