Tiny Tiny RSS – wyczyszczenie starych wpisów RSS
Logujemy się do phpmyadmina albo bezpośrednio do SQL i uruchamiamy:
DELETE FROM ttrss_user_entries USING ttrss_entries, ttrss_user_entries WHERE id = ref_id AND date_entered < DATE_SUB(NOW(), INTERVAL 14 DAY) AND marked = FALSE; DELETE FROM ttrss_entries WHERE (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0;
UPDATE `ttrss_user_entries` SET `unread` = 0;
DELETE FROM ttrss_cat_counters_cache; DELETE FROM ttrss_counters_cache;
