minds Posted July 10, 2022 Posted July 10, 2022 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?
Jim M Posted July 10, 2022 Posted July 10, 2022 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?
minds Posted July 10, 2022 Author Posted July 10, 2022 no, only these queries. If i do mannualy nothing changes, al those lines keeps the same.
Randy Calvert Posted July 10, 2022 Posted July 10, 2022 When you run those commands via SSH, what was the output?
minds Posted July 10, 2022 Author Posted July 10, 2022 36 minutes ago, Randy Calvert said: 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.
Randy Calvert Posted July 10, 2022 Posted July 10, 2022 (edited) 3 minutes ago, minds said: 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, 2022 by Randy Calvert
minds Posted July 10, 2022 Author Posted July 10, 2022 2 hours ago, Randy Calvert said: 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.
Marc Posted July 11, 2022 Posted July 11, 2022 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
minds Posted July 11, 2022 Author Posted July 11, 2022 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.
Marc Posted July 11, 2022 Posted July 11, 2022 24 minutes ago, minds said: 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.
minds Posted July 11, 2022 Author Posted July 11, 2022 but why this database fix not works automatically? Maybe i can check somewhere for more info whats happening? in admin cp logs no errors.
Marc Posted July 11, 2022 Posted July 11, 2022 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 minds 1
Solution minds Posted July 11, 2022 Author Solution Posted July 11, 2022 seems like there is a bug, manual update was done without any problems. SeNioR- 1
Marc Posted July 11, 2022 Posted July 11, 2022 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
minds Posted July 11, 2022 Author Posted July 11, 2022 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.
Marc Posted July 11, 2022 Posted July 11, 2022 No problem. Just let us know if you see that happen on any future upgrades minds 1
Recommended Posts