Help! Error Messages on "add" categories

[momzone]

Hi! In the Admin area Somehow a new subcategory and the parent category got deleted when I edited the category, yet it is still showing in the total number of categories.... I also cannot click on the "add categories" or "add links" it tries to bring it up as I get this message:
Fatal error: Maximum execution time of 30 seconds exceeded in /home/mysiteusername/public_html/lib/category.class.php on line 310

[Hart_House]

when you delete a category you have to make sure you delete the subcategory first or the subcategories will become a main category and your total category count will remain high or even higher.

Try refreshing the admin section, log-out and log back in. This might solve your problem.


Hart

[momzone]

thanks :-) but I actually didn't delete the category - it just disappeared when I went in to edit the graphic that shows by it.

I've tried logging out and back in, refreshing etc and I'm still getting the error. We thought that maybe the MySQL database needed a fix so I did that with the system we have in our control panel for web hosts... and that didn't work either... the message still keeps coming up. I'm sure it is probably corrupt but have no idea how to fix it

[romcio]

I have just try to load part of odp (dmoz) about 30 000 categories.
As admin I can't do nothing with ad or edit categories.
The category.class.php try to show all category_id,parent_id,name, the same problem is with View Hierarchy.
...
$category_list .= \"<OPTION T=\'".$this->GetCategoryPath($cat_id).\"' VALUE='$cat_id' \";


Regards

Roman

[dody]

The problem occur because the category structure is not well formed. You may assign parent id to its child (sub category), so it will cause forever loop. So be careful when add/modify category.

I have just try to load part of odp (dmoz) about 30 000 categories.

Well I must say that INDEXU is not designed to be able to handle such a lot of data. When indexu hold more than 2000 categories, the performance is down. It caused by the complex computation for building category's tree. We do not yet optimize it.