Logujemy się do phpmyadmina albo bezpośrednio do SQL i uruchamiamy:
|
1 2 |
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; |
|
1 |
UPDATE `ttrss_user_entries` SET `unread` = 0; |
|
1 2 |
DELETE FROM ttrss_cat_counters_cache; DELETE FROM ttrss_counters_cache; |