HELP. Upgrade stuck

[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?

[Jeff Lewis]

Have 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.

[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:

Code Select Expand

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!

[Doug Heffernan]

Thanks Doug

You are welcome

the 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

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.

Code Select Expand

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;

He'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]

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.

Eh possibly but he's all good now

[Steve]

he's all good now

Marking solved then.

[Doug Heffernan]

Eh possibly but he's all good now

Glad to hear that