Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
[issue] Cateogory Tree Corruption
I starting nesting sub-categories inside a parent category “web”, then later changed the name of “web” to “web design”. Doing so broke the tree, and I couldn’t see any of the nested categories any more. I messed around in phpMyAdmin for a while, but couldn’t get them to resurface (probably needed to ditch all lft and rgt values, then rebuild the trees).
Eventually, I had to delete all categories and start again. I’d call this a bug :)
VC#72, waiting patiently for /section/category/article-title/ based URLs :)
Offline
#2 2004-08-03 15:26:26
- marco
- Member
- From: Montreal
- Registered: 2004-02-24
- Posts: 62
Re: [issue] Cateogory Tree Corruption
This is a typical case of a database update anomaly. It happens when the database integrity rules are not implemented properly or when the table relationships are not properly enforced via primary key references.
This problem and its solution were pointed out before in this forum (but the issue does not seem to be fixed).
Offline
Re: [issue] Cateogory Tree Corruption
is this something that’s fixed with _update.php?
Offline
Re: [issue] Cateogory Tree Corruption
this is still a bug, as of 4.0.2 (albeit not that serious – it doesn’t corrupt the listing totally). try to make category C a subcategory of X. then rename X to B and at the same time make it a subcategory of A. all the C-level categories are now no longer listed under B but here and there in the tree (can’t see the logic visually).
expected behaviour:
<code>- A
— B (renamed from X)
—- C
…</code>
actual behaviour:
<code>- A
— B
…
- C</code>
Last edited by Anton (2005-11-25 07:37:34)
Offline