Jump to content

Unable to proceed with upgrade


Go to solution Solved by Jim M,

Recommended Posts

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? 

 

 

Could contain: Text, Page, File

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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. 

 

Could contain: Text, Menu, Page

to add, as you can prob. imagine some dont get affected. I did get some rows affected indications 
Could contain: Menu, Text

Link to comment
Share on other sites

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. 

 

Could contain: Text, Menu, Page

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. 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

 

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • Solution

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.

Link to comment
Share on other sites

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:

Could contain: Text, Scoreboard

Link to comment
Share on other sites

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...