Tags still in table after removing from post

[Michael Collins]

Hello,

I am using the Most Used Tags application which is showing me the tags used on my forum posts. Through this I have noticed that when a tag is removed from a post it is not being removed from the database table core_tags. I did a clean up manually removing a lot of tags completely in each post, so now there are quite a few tags that are no longer in any forum post but they are still showing as present in the core_tags table.

Can someone tell me why the tags are not being removed from the database table? For more info we are self-hosted and the tags were removed manually by clicking the x next to the tag at the top of a post.

You can see the discussion and trouble shooting I had with the application owner here:

Thanks,

Mike

[Adriano Faria]

Again Mike, your issue has absolutely nothing to do with my app. You have records in core_tags table that are not returning in search (tags) results.

That's all.

[Michael Collins]

Yes as Adriano says, and to be more specific, I think those records should not be present in the table as they appear to be removed in the posts themselves.

[Adriano Faria]

No problem... just saying because probably you will be requested to contact the 3rd-party dev as there is a 3rd-party app involved.

[Marc]

Please could you first of all provide a couple of example tags you believe should not be present? Also ensure all your access details are up to date

[Michael Collins]

@Marc Stridgen "1901 irish census", "1911 irish census", "1915 NY. Census" and "1916 easter irish rising" are all examples of tags that should not be present.

 

[Michael Collins]

@Marc Stridgen, do you need anything else to check this out?

[Marc]

A ticket has been created on this for you. Someone will be in contact as soon as possible.

[Michael Collins]

Hi there, I spoke to someone on a ticket, we couldn't recreate the issue and assumed it wasn't present anymore but needed to clean the database manually of all the old tags.

Now that I've done that I've done some more testing myself and I can see an issue that's still present and may be causing tags to still be in the table with no related post. After I use the moderator actions to delete a post, the tags from that post are still shown in the database.

An example of tags are "2025" and "2026". I added these to two separate posts and then used the moderator actions to delete the posts but they are still present in the database.

[Marc]

Please respond in the ticket if you have any new information there 🙂 

 

[Michael Collins]

I tried to previously but I got an auto-reply to post here because I'm a self hosting customer.

[Marc]

Could I please confirm you are replying to the email sent to you, not trying to send a new email?

[Michael Collins]

Yes, I am replying to the original email thread.

[Marc]

Ive just replied again. Please see if you can respond on that

[Michael Collins]

I've responded again and haven't got an automated rejection email yet so I'm guessing it went through. Thanks @Marc Stridgen

[Marc]

It did come though 🙂