Issue: Random tags on Attachment pages

Issue Tools
- View Changes

July 3, 2018 1:05 PM

Alfa1

Distinguished Member

Random tags on Attachment pages

See: wiki/7db6ba7284fb07228fe65c75d81faadd_jpg
Like all attachment pages I checked, this page has many random tags. I cant figure out how this happened because there is no relation between the tags and there are also no other pages, forum threads with a combination of those tags.

Is there any way to remove all tags from attachment pages?
This is bad for SEO.

Issue Details

Issue Number 5431

Issue Type Bug

Project VaultWiki 4.x Series

Category Attachments

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 4.0.23

Fixed Version 4.0.24

Milestone (none)

Software DependencyXenForo 1.x

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

July 3, 2018 5:56 PM
pegasus

VaultWiki Team
You can get more information about the tags from your database's xf_tag_content table.

Code:

SELECT tag_content.*, tag.tag, tag.use_count FROM vw_route AS i LEFT JOIN xf_tag_content AS tag_content ON (i.routeid = tag_content.content_id AND tag_content.content_type = 'vwpage') LEFT JOIN xf_tag AS tag ON (tag.tag_id = tag_content.tag_id) WHERE i.itemkey = 'PATHNAME OF AFFECTED PAGE'

For PATHNAME OF AFFECTED PAGE, make sure to enter the name of the affected attachment.

The main point of interest is which users allegedly added these tags. If it was you, then these tags were probably imported from VW3. If it is another user, and the user has done a lot of these, then it might be a SPAM account. If it was a guest user, then it's probably SPAM.
Reply
July 6, 2018 10:29 AM

pegasus

VaultWiki Team

With a brief look, I only see one or two pages on your site that are like this. While it is possible it was spammers, I believe this was caused by a period you went through where you installed, imported, uninstalled, reinstalled, reimported, uninstalled, reinstalled etc. I see that existing tagged content is not removed when VaultWiki is uninstalled, so if you reinstall later, you will eventually get an ID that matches one that had tags before (especially for sites that create different content each re-install). So the problem here is that tags on wiki content are not deleted when uninstalling.

Unfortunately there would be no way for a script to tell the difference whether a page had the tags added manually or had the tags inherited from a previous installation, since the underlying bug has no association to your current content in a meaningful way. The only way would be for a human to notice that the tags don't belong, or to remove all tags.

Confirmed due to the uninstall issue.

Reply
July 6, 2018 12:05 PM

pegasus

VaultWiki Team

Fixed in the next release. If you uninstall the next version or higher, content-tags on wiki content should be removed by the uninstaller. This issue had only affected XenForo; the vBulletin uninstaller was already removing content-tags.

Reply
July 6, 2018 12:39 PM

Alfa1

Distinguished Member

Is there a way to remove all tags from specific content types? For example: attachments, templates.

Reply
July 6, 2018 1:37 PM
pegasus

VaultWiki Team
The following query should delete all tags from attachments. But your tag statistics for the affected tags will be wrong forever if you do it this way (XenForo does not include an admin-tool to mass-rebuild the tag cache); the only way to avoid this is to update the tagged content one by one.

Code:

DELETE tc FROM xf_tag_content AS tc INNER JOIN vw_route AS i ON (i.routeid = tc.content_id) INNER JOIN vw_attachment AS a ON (i.itemid = a.pageid) INNER JOIN vw_nodetype AS t ON (t.id = i.itemtypeid) WHERE t.accesskey = 'Page' AND tc.content_type = 'vwpage'

To affect templates, change the vw_attachment reference to vw_template.
Reply

+ Reply

All times are GMT -4. The time now is 5:47 PM.

This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Random tags on Attachment pages

Issue Tools