Answered Missing Category folders after upgrading to (MODX Revolution 2.3.3-pl)

Hi,

After upgrading MODX website, I now cannot see my category folders for templates, chunks and TV's. I also cannot create a new category, it just gives me an error stating I cannot creating a new category! The site is working so the missing templates, chunks and TV's are still there! Also I can see the missing templates in the pulldown menu of a resource using them. I had a look using phpMyAdmin and I can see them in the table mdx_site_templates the templates are in there! I also ran Sitecheck plugin from Bob Ray and got errors but these in particular

Elements with a nonexistent category
[2015-09-09 15:24:22] (ERROR @ /core/components/sitecheck/index.php)

Error 42S22 executing statement:
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'modCategory.rank' in 'field list'

It said this type of error for all my missing templates, chunks and TV's.

I am no mysql, php expert so I don't quite know what this all means. an explanation from a more knowledgeable person would be greatly appreciated. It looks like something obviously got deleted or corrupted in the update.

The upgrade was supposed to add a new column (rank) to the category table, but it looks like it didn't happen. This happens sometimes when you make too big a jump in versions. Setup is supposed to apply all the intermediate upgrades, but sometimes it doesn't happen.

Quote from: BobRay at Sep 10, 2015, 09:21 PM

The upgrade was supposed to add a new column (rank) to the category table, but it looks like it didn't happen. This happens sometimes when you make too big a jump in versions. Setup is supposed to apply all the intermediate upgrades, but sometimes it doesn't happen.

thanks for answering back. That site check plugin of your is great would never have known that was wrong without it! Is it possible to add that column (rank) to the table myself manually, and what would the contents of that field/column be anyway

Hi, I have same problem. I have two identical MODx installations; dev and production Site. After update dev-site manager worked ok, but production-site didn't. All the categories are missing. I don't think the reason is too big jump in versions.
I also noticed that Package Providers are missing and i can't create new one.
Any idea how to fix this?

The upgrade was supposed to add a new column (rank) to the category table, but it looks like it didn't happen.

Which table is the "Category table"?

Sorry, I mis-wrote. The name field was added to the context table (modx_context). That shouldn't be affecting your categories. The category table (modx_categories) should have a 'rank' field, which you may be able to add manually.

Did you copy the dev site to production recently by exporting and importing specific tables? Maybe the category IDs and provider IDs don't match.

The category table is modx_categories.

Every element has a 'category' field which is supposed to match the 'id' field of the category it belongs to.

Similarly, in the modx_transport_packages table the 'provider' field should match the 'id' field of the provider.

Typically, the provider table only has one record with an ID of 1, and all transport packages that come from the Repo should have a 1 in their 'provider' field. [ed. note: BobRay last edited this post 8 years, 6 months ago.]

I'm glad you got it sorted.

The category table (modx_categories) should have a 'rank' field, which you may be able to add manually.

Your info has also helped me, thank you very much!
Best regards