| Warning |
|---|
This will destroy your system completely.. not for the faint hearted. |
Find out about categories in the categories table but NOT in the nested tree model. This is probably pretty harmless (unless you appear to be mmissing categories all of a sudden) but can cause 3.x versions of FarCry to fail when trying to render the category picker.
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
UPDATE nested_tree_objects SET parentid='--some UUID of valid parent--' WHERE objectid IN (select objectid from nested_tree_objects where parentid NOT IN (select objectid from nested_tree_objects)) AND (parentid is not null or parentid <> '') |