Not sure if this is a bug or not, but while writing a database view table (as talked about in a previous topic), i notice that there are left over categories that i no longer use and have created again.
As an example i created a category called "Business" in the top categories on my home page when i first started using WSNLinks, then deleted it, then i created it again, and now notice that i have a database entry of "Business" 2 times (although it doesn't show twice, and i don't want it to).
Also as another example, i created a category of "Home & Garden" and since changed it to "Home and Garden" because of the mod_rewrite not showing correctly, but "Home & Garden" is still in there (3 times). Also most categories under "Home and Garden" are showing sub-categories as "Home & Garden" so will i start getting errors (i'm not at the moment).
If you would like to see the database query thing that i have made, let me know, as it just makes it easier to add links when you want to add them to multible categories. Its just a lookup table, but could do with more work, like putting the subcategories under there parent categories. All i have to do is click a link now next to the secondary categories box when in Admin, which is a hell of a lot easier than going to PHPMyAdmin all the time.
Ok fair enough, but can i hard delete without it messing anything up. If i leave them in there and keep creating and changing my mind on categories, surely it will slow the database?
Also is the "Home & Garden part going to cause problems? As i said most of the sub-categories still link to the "Home & Garden" link instead of the newer "Home and Garden". Should i change it in the database?
The theoretically slowing of the database will be so tiny you can't ,measure it, but you can always use phpmyadmin to remove things where the deleted field is 1.
I'm not sure what you mean by subcategories linking. I guess the parents path or something? That'd be updated with a regenerate counters.
0/5
1
2
3
4
5
This thread is closed, so you cannot post a reply.
Comments on Dead Categories in Database
Member
Usergroup: Customer
Joined: Oct 05, 2005
Total Topics: 10
Total Comments: 35
Hi
Not sure if this is a bug or not, but while writing a database view table (as talked about in a previous topic), i notice that there are left over categories that i no longer use and have created again.
As an example i created a category called "Business" in the top categories on my home page when i first started using WSNLinks, then deleted it, then i created it again, and now notice that i have a database entry of "Business" 2 times (although it doesn't show twice, and i don't want it to).
Also as another example, i created a category of "Home & Garden" and since changed it to "Home and Garden" because of the mod_rewrite not showing correctly, but "Home & Garden" is still in there (3 times). Also most categories under "Home and Garden" are showing sub-categories as "Home & Garden" so will i start getting errors (i'm not at the moment).
If you would like to see the database query thing that i have made, let me know, as it just makes it easier to add links when you want to add them to multible categories. Its just a lookup table, but could do with more work, like putting the subcategories under there parent categories. All i have to do is click a link now next to the secondary categories box when in Admin, which is a hell of a lot easier than going to PHPMyAdmin all the time.
To see what i mean above you can take a look at http://www.mrtopsite.co.uk/listcategories.php which should work i think.
Cheers
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Categories are only soft-deleted.
Member
Usergroup: Customer
Joined: Oct 05, 2005
Total Topics: 10
Total Comments: 35
Hi
Ok fair enough, but can i hard delete without it messing anything up. If i leave them in there and keep creating and changing my mind on categories, surely it will slow the database?
Also is the "Home & Garden part going to cause problems? As i said most of the sub-categories still link to the "Home & Garden" link instead of the newer "Home and Garden". Should i change it in the database?
Cheers
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
The theoretically slowing of the database will be so tiny you can't ,measure it, but you can always use phpmyadmin to remove things where the deleted field is 1.
I'm not sure what you mean by subcategories linking. I guess the parents path or something? That'd be updated with a regenerate counters.