Hi there ,

I have a huge category table with a lot of categories and deep levels. The levels vary from 2 to 7. The thing is, a category with quite a bit of sub-categories in it, was not at the right place, so I moved it to the correct category using the Admin panels. That was about two weeks ago. Today I implemented a feature that utilizes the Full_Name field of the Category Table, and while I was testing it, the categories ,which I moved two weeks ago, still has the same Full_Name value in them, instead of the updated Full_Name.

for example, lets say I have "Africa" as a category, and inside "Africa" there is a category named "Maldives". That would mean that the Full_Name value of "Maldives" should be "Africa/Maldives", and all its sub-categories' Full_Names should have "Africa/Maldives/XXXX" as a Full_Name value.

Now, "Maldives" is actually supposed to be under "Asia". So I move "Maldives" using the Admin panels to "Asia". The Full_Name of the moved categories should be something like "Asia/Maldives/XXXX". But it isn't. It never updated and is still "Africa/Maldives/XXXX" even though it is moved to Asia.

How should I go about to fix this?

Ezfrag

---

Sacrifice is not about what you lose,
it is about what you gain in the process.