discuss.answer
-
- 24,544 Posts
Yes, it looks like one of your upgrades failed to add the 'rank' column to the modx_categories table. Running setup might fix it for you (if the setup folder is no longer there, be sure to upload one from the exact same version of Revolution).
You could add the column yourself in PhpMyAdmin. It should have these characteristics.
Type: int(11)
Null: no
Default: 0
Other fields: leave blank
Set the rank to 0 for all categories
While you're in the DB, see if the modx_context table has a 'name' field. That's another thing that's sometimes missed in upgrades that jump too many versions. If it's missing, it can cause other problems. It should have these characteristics:
It should have these characteristics.
Type: varchar(255)
Null: Yes
Default: Yes
Collation: Same as the other two text fields
Other fields: leave blank
Create a name for each context based on the key that describes it very briefly. It can be the same as the key. It's not used for anything except the display in the contexts grid in the Manager.
-
- 6 Posts
Hi BobRay,
My setup directory was present, but empty so I added the columns as you suggested and it did the trick.
Thanks a lot!