TAG showing used 1 time when not being used

Macondiana · August 14, 2015 at 6:44 PM

Just spotted something when browing tags and clicked one that said not used, so went into admin cp and arranged tags by least used at top and it doesn't show up as being used 0 times.

Here is the tag clicked showing no results.

Here is the tag showing used 1 time in admin cp.

I remember the topic that TAG was added with, but that topic was deleted ages ago. And I'm pretty sure before I deleted the topic later is was renamed and that tag removed from it at time (due to renaming the title). So that tag wasn't even attached with the topic when deleted later on.

Macondiana · August 15, 2015 at 4:42 PM

Seeing this problem happen more again. I just removed a topic posted earlier with 3 or 4 tags added to it. Went into tags expecting to find some with 0 showing to delete and none are listed. Even run some cron jobs such as daily and hourly clean up, emptied all cache. Run all maintenance tasks and still the tags left over from that topic show 1 listed topic being used with, when they are being used with none now.

Knoow for a fact the tag "Russian SU-35" wasn't being used with any other topics, lol

Any idea why this might be happening. As it showed tags before 0, unlinked with topics deleted.

**Tim Düsterhus** · August 16, 2015 at 2:10 AM Official Post

Hi

is the thread still in trash or completely gone?

Macondiana · August 16, 2015 at 10:59 AM

Completely gone, first sent to trash and then hard deleted second time. Same thing done in both instances.

**Tim Düsterhus** · August 16, 2015 at 9:06 PM Official Post

Hi

can you please execute the following SQL query and provide me the result? It will show the objects that are assigned to the tag with ID 113 (the one in your screenshot):

SQL

SELECT    t2o.*, ot.objectType, thread.topic
FROM      wcf1_tag_to_object t2o
LEFT JOIN wcf1_object_type ot USING (objectTypeID)
LEFT JOIN wbb1_thread thread ON thread.threadID = t2o.objectID
WHERE     tagID = 113;

Macondiana · August 16, 2015 at 9:23 PM

That tag has since been deleted because knew there was no topic using it, even though it said 1 topic still. So don't think running that query will do much good now, the tag is gone.

**Tim Düsterhus** · August 16, 2015 at 9:56 PM Official Post

Hi

I cannot dig further at the moment. If it happens again execute the query with the ID of the tag (as seen in the first column) and provide me the result.

Macondiana · August 16, 2015 at 10:25 PM

ok

Macondiana · August 20, 2015 at 10:40 PM

Just spotted another tag. "get a life" tag, showed no results linked with it. So went into admin cp and searched that tag and it shows 1 result still.

Ran the query you said on that Tag ID number and here is the result.

Black Rider · August 20, 2015 at 10:44 PM

Try it with removing the last ;. It seems that phpMyAdmin does add own query parts at the end of the query.

Macondiana · August 20, 2015 at 10:50 PM

Now I get this removing that.

Macondiana · August 20, 2015 at 10:51 PM

Sorry. I used 113 instead of changing it to 88

Let me do it again

Macondiana · August 20, 2015 at 10:55 PM

OK, after running the query again on TAG ID 88, I can see it lists it as being linked with a topic I highlighted in yellow. But that topic "was deleted" yesterday. First it was sent to trashcan, then deleted a second time as (hard deleted). And this seems to be what is happening. If I delete a topic the tags was used with, those tags are still showing as used with 1 topic when they are not anymore.

These are not topics sent into trashcan waiting so many days before trashcan is emptied. They always get hard deleted by doing it a second time. I have to delete 2 times, because 1st time only offers you option of send to trashcan, so you then have to do it again to hard delete the topic.

So it's not like the topic is sitting in trashcan only getting deleted (emptied) 10 days from now (my setting for it). Why the tag might still be linked with it. That topic is gone, hard deleted.. same as other one was.

Macondiana · August 20, 2015 at 11:23 PM

Oh No!

You will have to ignore what I said above. Seems the topic is still listed after all, it was not deleted. Think I might know what I've been overlooking. I was logged out as a guest when clicking the tag and it showed no results, but that topic is posted on a private forum that guests cannot read. Hence why I got no results showed to me for the tag.

Dear me.....

But, even though I've made a mistake with this one now. The first post in this topic. That thread was made an Announcement topic and was posted on a public viewable forum that all could see. So I'll just have to keep an eye on it and make sure next time if it happens again, it's not a topic posted on a private forum only members can read (and I'm not clicking the tag as a guest).

Macondiana · August 23, 2015 at 11:37 PM

OK, this one shows the fault now. This TAG called RULES was attached to a topic that was posted as an Announcement before (then deleted later on). On my localhost Wamp install, and same thing is seen on my live site install also. Both have the tag linked to no topic.

These screenshots was taken from locahost wamp install. TAG shows used with 1 topic still.

This picture after running the query in database shows it's linked with no topic. Maybe it might have something to do with the fact the topic was posted as an Announcement?

**Tim Düsterhus** · August 24, 2015 at 12:07 AM Official Post

Hi

Thanks, I'll have a look.

Macondiana · August 24, 2015 at 12:10 AM

Just to confirm, found another tag that was linked to that announcement topic and same thing again.

tag itself

query run

**Tim Düsterhus** · August 26, 2015 at 2:01 PM Official Post

Hi

this issue will be fixed with the next version and dangling tags (as well as a few other entries) should be removed as well.

Participate now!