Fix for trends count beeing not deleted

claudehohl / Stikked

An advanced and beautiful pastebin written in PHP

992 stars 220 forks source link

Open PJanisio opened 3 months ago

PJanisio commented 3 months ago

together with paste deletion stikked should also delete trends count as a trending table can grow ultra large!

To fix remainings in your database before this fix is implemented you can use this query:

DELETE FROM `trending` WHERE NOT EXISTS (
    SELECT *
    FROM `pastes`
    WHERE pid=trending.paste_id
);