Simple Machines Community Forum

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/communityunnamed.jpg

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

error.png

Have you tried restarting the upgrade?

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.

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

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!

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

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.

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

Quote from: Jeff Lewis on September 27, 2022, 06:22:56 PMhe's all good now

Marking solved then.

Quote from: Jeff Lewis on September 27, 2022, 06:22:56 PMEh possibly but he's all good now :)

Glad to hear that :)