Webmastersite.net
Register Log In

Dead Categories in Database
changed names and categories still there

Comments on Dead Categories in Database

spiceworld
Member

Usergroup: Customer
Joined: Oct 05, 2005

Total Topics: 10
Total Comments: 35
Posted Nov 04, 2005 - 10:03 AM:

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
Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Nov 05, 2005 - 5:27 AM:

Categories are only soft-deleted.
spiceworld
Member

Usergroup: Customer
Joined: Oct 05, 2005

Total Topics: 10
Total Comments: 35
Posted Nov 05, 2005 - 5:45 AM:

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

Paul
developer

Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California

Total Topics: 61
Total Comments: 7868
Paul
Posted Nov 06, 2005 - 6:50 AM:

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.
Search thread for
Download thread as
  • 0/5
  • 1
  • 2
  • 3
  • 4
  • 5



This thread is closed, so you cannot post a reply.