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