Shawn Watson Posted June 29, 2022 Posted June 29, 2022 I'm trying to update a large forum to 4.6.12.1. during the upgrade it asks to run some DB cleanup commands (and by some, i mean it was a small Novel). The Database is quite large so i ran everything manually on the console directly. I hit "check again" after doing so but it still reports the same command. On the support page its showing DB issues, but i'm unable to get past them. is there an index i'm supposed to run to realign the dashboard? am i not waiting long enough for the checks to.. check out?
Jim M Posted June 29, 2022 Posted June 29, 2022 What specifically are the database problems that you are running to fix?
Shawn Watson Posted June 29, 2022 Author Posted June 29, 2022 I dont know. it just says "Database problems" when you click on it, it shows a novel (about 1k lines)
Jim M Posted June 29, 2022 Posted June 29, 2022 When running these manually are you running them on the correct database? Does each query run and complete without error? Have you tried running the queries through the ACP?
Shawn Watson Posted June 29, 2022 Author Posted June 29, 2022 i ran each of them against the right DB and, as far as i could tell, there were no errors returned (snippit below) I tried running them through the ACP before and it broke the forum because it took too long - i ended up restoring the backup db and files. I can try it again... but dont want to risk breaking it again. to add, as you can prob. imagine some dont get affected. I did get some rows affected indications
Jim M Posted June 29, 2022 Posted June 29, 2022 2 minutes ago, Shawn Watson said: i ran each of them against the right DB and, as far as i could tell, there were no errors returned (snippit below) I tried running them through the ACP before and it broke the forum because it took too long - i ended up restoring the backup db and files. I can try it again... but dont want to risk breaking it again. You can find the correct database in conf_global.php What you showed here is different than above screenshot. Is this just a snippet or are you getting new/different queries after each run? If just a snippet, please provide us access: We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you.
Shawn Watson Posted June 29, 2022 Author Posted June 29, 2022 the black screenshots are the sql console directly, showing the rows affected, and that the query succeeded. I did console directly to prevent the timeouts that i think i ran into the last attempt i just modified the access information a minute ago, should be correct
Jim M Posted June 29, 2022 Posted June 29, 2022 4 minutes ago, Jim M said: You can find the correct database in conf_global.php Please ensure you ran it against the database mentioned in the file above. 2 minutes ago, Shawn Watson said: i just modified the access information a minute ago, should be correct Unfortunately, it is still invalid.
Shawn Watson Posted June 29, 2022 Author Posted June 29, 2022 i did confirm that the db i was running the commands against is the right one. (the SQL commands call for creating "_new" tables, i see them being created and records being moved to them, before it drops the old and renames the new) i'm not sure the issue with the FTP, i just re-copied/pasted the information and it worked for me? i changed the option to just "FTP" maybe that should help? it should be FTP with SSL though
Jim M Posted June 29, 2022 Posted June 29, 2022 Not just FTP is required here. ACP access is as well.
Shawn Watson Posted June 29, 2022 Author Posted June 29, 2022 Ah, sorry about that. i must've reset my password since i put that in there. Try now 🙂
Solution Jim M Posted June 29, 2022 Solution Posted June 29, 2022 Thank you for updating those. Did you manually attempt to update your tables to UTF8MB4? Unfortunately, there are a lot of weird collations in your database. I would suggest running our conversion if you attempted this manually.
Shawn Watson Posted June 29, 2022 Author Posted June 29, 2022 I ran the advised commands manually but nothing further than that. can you point me in the right direction to convert? i see this in "phpmyadmin", it couldnt be just this easy, could it?
Jim M Posted June 29, 2022 Posted June 29, 2022 For UTF8mb4, you will need to use our conversion tool. There is no way around it, I'm afraid. There is a CLI option which is available and recommended for large databases. You can find this information it the ACP -> Support area:
Shawn Watson Posted June 29, 2022 Author Posted June 29, 2022 i ran the tool hoping to see it display the commands like it did earlier but it went right to it. *fingers crossed* that it doesnt time out
Shawn Watson Posted June 29, 2022 Author Posted June 29, 2022 Hey Hey, that worked. thank you for your assistance. Updating the DB resolved the issue enough for me to perform the upgrade.
Recommended Posts