Problem with moving Categories in admin

[Guest]

Hello,

I had one large category with several sub categories. I decided to split up this category and make each of the sub-categories their own root level category. So I used the "move" feature in the admin to move them to the "top". Now the categories that I moved (the ones that used to be sub categories) don't display their subcategories properly when viewing their category.

 

The old categories (which I did not change) all seem to be fine, it's just the ones which have been moved. I've tried creating new categories, and then adding sub categories to them, but they dont show sub categories either.

 

One additional piece of information that may be interesting, is that I deleted the original category which used to house the sub categories.

 

I think it's a problem with the mysql database... but im not really qualified to solve this. I would really appreciate anyone to look into this for me. If you accept donations please contact me on msn messenger ([email protected]), if you are able to straighten this out I will be willing to send you a donation. My plans were to launch within the next few days, but without this being fixed they have been delayed indefinitely. :(

 

Thanks.

[moonstone]

Hello,

I had one large category with several sub categories. I decided to split up this category and make each of the sub-categories their own root level category. So I used the "move" feature in the admin to move them to the "top". Now the categories that I moved (the ones that used to be sub categories) don't display their subcategories properly when viewing their category.

 

The old categories (which I did not change) all seem to be fine, it's just the ones which have been moved. I've tried creating new categories, and then adding sub categories to them, but they dont show sub categories either.

 

One additional piece of information that may be interesting, is that I deleted the original category which used to house the sub categories.

 

I think it's a problem with the mysql database... but im not really qualified to solve this. I would really appreciate anyone to look into this for me. If you accept donations please contact me on msn messenger ([email protected]), if you are able to straighten this out I will be willing to send you a donation. My plans were to launch within the next few days, but without this being fixed they have been delayed indefinitely. :(

 

Thanks.

<{POST_SNAPBACK}>

 

It will be much easier if you have a backup of the original database. The one before you deleted the original category.

 

What you need to do is simply go into phpMyAdmin and replace the parent_id of the sub category (which you want to make it a main category) to 0. Having no parent category, this sub category will automatically become a main category with all descendents intact.

 

Hope this helps. :blush:

 

If you need further assistance, you may look me up on MSN Messenger.