Loading...
 
Skip to main content

Features / Usability


Directory categories undeletable

In my original dabbling into directories, I created some directory categories (and some with no name, by mistake) that I eventually deleted or moved under other parent categories. When created, these directory categories were set to the site category of my user group. Now that they are deleted from the directory categories they no longer show up under directories but if I do a find for everything (site) categorized as my user group they still show up. Clicking on them takes me to the directory page- but its empty, with no records. A look in the database at the directory_categories table shows no sign of these deleted categories, either. Even a search of the category_objects table for things with a categId matching my user group returns the correct number and does not include these deleted/moved directory categories. How can I get rid of these ghost directory categories?!?

I take it back, after narrowing down items specifically in my user group, I can see in the category_objects table that I cannot find in the site. I'd remove them manually from the category_objects and categorized_objects but I'm cautious as I'm not immediately sure what other tables might reference the category_objects/categorized objects I delete.

Its also clear that the delete/modify sql used in the directories pages has an error as it does not seem to be updating at the very least these tables.


Did you clear the cache ? (tiki-admin_system.php) and log-out/log-in
FYI directory categories have nothing to do with categories
(tiki_category_sites/tiki_directory_categories) versus (tiki_category_objects tiki_categorized_objects)
sylvie

Thank you for the feedback

Did you clear the cache ? (tiki-admin_system.php) and log-out/log-in
Yes, this is one of the first things I did.

FYI directory categories have nothing to do with categories
True, other than directory categories are objects that can be categorized (and thus have permissions applied to them), which is why I specified (site) categorized and directory categories. When I do a site level search for objects in my user category, directory objects are included in the return. Somewhere directory_categories are linked to categorized_objects and it seems, somehow, removing a directory category didn't remove the corresponding categorized object.


Ok, I poked into the database some more and working my way back from categories->categId to categorized_object-> catObjectID to objectId-> objects I can see that there are rows in this table of type directory that do not show up in directory_categories (or directory_sites), although I am having trouble finding the relationship between directory tables to their corresponding object tables. These, of course, would be the directory categories that I deleted and no longer show up under directories but still show up under (site) category searches in tiki-directory_browse.php.

This seems like proof of concept to me that removing a directory category does remove it from directory_categories but does not remove its corresponding entries in the objects and categories tables and that I should file a bug. I'm more than willing to pursue this further to help troubleshoot, with guidance. I'd prefer this to tearing in to the PHP with my unskilled fingers.

What is the proper protocol for filing a bug?

Also, is there a relationship diagram or suggested (Linux) tool that I can use to create one?