News:

Wondering if this will always be free?  See why free is better.

Main Menu

HELP. Upgrade stuck

Started by Kootch, September 25, 2022, 12:48:18 PM

Previous topic - Next topic

Kootch

I'm trying to upgrade from 2.0.17 on a large forum and it's stalled at the json part of the upgrade.  I'm stuck and the forum is down!

Suggestions???

Rick

TMLfans.ca/communityYou cannot view this attachment.

Kootch

I guess I only clipped part of the screenshot.  Here's the full capture.

You cannot view this attachment.

Kindred

Have you tried restarting the upgrade?
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Jeff Lewis

Quote from: Kindred on September 25, 2022, 02:31:18 PMHave you tried restarting the upgrade?

He has yes. He even emptied the log_spider_hits table and it still got stuck on the same step and table.
Co-Founder of SMF

Doug Heffernan

Is there any error(s) logged in at the server error log pertaining to this?

You can also try to run the the upgrader in CLI mode. Please see the following guide on how to upgrade your forum using the command line.

https://wiki.simplemachines.org/smf/Upgrading#Upgrading_Using_the_Command_Line

Jeff Lewis

Thanks Doug, the command line worked for him sort of. He ran the 2.0.19 upgrade via command line and now has the error:

Table 'tmlfans4_smf.smf_collapsed_categories' doesn't exist
He's trying the 2.1.2 upgrade now.

*edit* and that worked and got him going again!
Co-Founder of SMF

Doug Heffernan

Quote from: Jeff Lewis on September 27, 2022, 03:39:45 PMThanks Doug

You are welcome :)

Quote from: Jeff Lewis on September 27, 2022, 03:39:45 PMthe command line worked for him sort of. He ran the 2.0.19 upgrade via command line and now has the error:

Code Select Expand
Table 'tmlfans4_smf.smf_collapsed_categories' doesn't exist

It looks like a table is missing from the database, smf_collapsed_categories. The op can either readd it from a backup or recreate it as new with this sql query.

CREATE TABLE smf_collapsed_categories (
  id_cat tinyint(4) unsigned NOT NULL default '0',
  id_member mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY (id_cat, id_member)
) ENGINE=MyISAM;

Quote from: Jeff Lewis on September 27, 2022, 03:39:45 PMHe's trying the 2.1.2 upgrade now.

Personally I think it would be best if they upgraded to 2.0.19 first, error free, and then they can proceed with the upgrade to 2.1.2.

Jeff Lewis

Quote from: Doug Heffernan on September 27, 2022, 03:47:13 PMPersonally I think it would be best if they upgraded to 2.0.19 first, error free, and then they can proceed with the upgrade to 2.1.2.

Eh possibly but he's all good now :)
Co-Founder of SMF

Steve

Please do not PM me for support.


Advertisement: