minds Posted July 10, 2022 Share 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? Link to comment Share on other sites More sharing options...
Jim M Posted July 10, 2022 Share 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? Link to comment Share on other sites More sharing options...
minds Posted July 10, 2022 Author Share Posted July 10, 2022 no, only these queries. If i do mannualy nothing changes, al those lines keeps the same. Link to comment Share on other sites More sharing options...
Randy Calvert Posted July 10, 2022 Share Posted July 10, 2022 When you run those commands via SSH, what was the output? Link to comment Share on other sites More sharing options...
minds Posted July 10, 2022 Author Share 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. Link to comment Share on other sites More sharing options...
Randy Calvert Posted July 10, 2022 Share 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 Link to comment Share on other sites More sharing options...
minds Posted July 10, 2022 Author Share 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. Link to comment Share on other sites More sharing options...
Marc Posted July 11, 2022 Share 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 Link to comment Share on other sites More sharing options...
minds Posted July 11, 2022 Author Share 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. Link to comment Share on other sites More sharing options...
Marc Posted July 11, 2022 Share 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. Link to comment Share on other sites More sharing options...
minds Posted July 11, 2022 Author Share 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. Link to comment Share on other sites More sharing options...
Marc Posted July 11, 2022 Share 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 Link to comment Share on other sites More sharing options...
Solution minds Posted July 11, 2022 Author Solution Share Posted July 11, 2022 seems like there is a bug, manual update was done without any problems. SeNioR- 1 Link to comment Share on other sites More sharing options...
Marc Posted July 11, 2022 Share 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 Link to comment Share on other sites More sharing options...
minds Posted July 11, 2022 Author Share 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. Link to comment Share on other sites More sharing options...
Marc Posted July 11, 2022 Share Posted July 11, 2022 No problem. Just let us know if you see that happen on any future upgrades minds 1 Link to comment Share on other sites More sharing options...
Recommended Posts