Closed Spam Cleaning does not clear unfurl table

[briansol]

Affected version

2.3.10

re: https://xenforo.com/community/threa...t-no-source-in-posts-or-conversations.236673/

the xf_unfurl_result table does not get cleaned up when the post it is attached to does.
Further, there is little referential integrity to the post in that table (no postid, etc) to link it back to a cleaned/deleted post.


This table should purge records from related posts on delete/spam clean.

 

[Chromaniac]

iirc this has been discussed before and devs said that it leaves so little data residue that it was not worth looking into. i cannot find the specific post because searching for unfurl basically show all posts with links lol.

i think the main issue is that by design, you cannot just purge the data from the database. unfurled links only work if they exist in the table. the row needs to exist for xenforo to fetch the data. they would need to track every instance of the link on the forum to decide if a link needs to be purged from database when you delete a post with a link i imagine.

this might be it: https://xenforo.com/community/threads/if-a-url-is-not-able-to-be-unfurled.161342/post-1327715

or this lol: https://xenforo.com/community/threads/two-issues-related-to-unfurling-urls.197908/post-1535168

 

[XF Bug Bot]

Automated triage: Design issue

Thank you for reporting this issue. Link preview data is stored once per URL and shared by all content that uses it. It is recorded when a message is prepared, before it is saved, and is not owned by any single post, so it is not removed when a post is deleted or spam-cleaned. Changing that would be a design change rather than a bug fix.

This is an automated assessment. A member of staff may review and update it.