owncloud-archive / news

:newspaper: News app for ownCloud
GNU Affero General Public License v3.0
290 stars 106 forks source link

old feed items are will not be deleted #1024

Open smoebody opened 7 years ago

smoebody commented 7 years ago

Read and tick the following checkbox after you have created the issue or place an x inside the brackets ;)

Explain the Problem

old news items are not deleted. my database by now is about 500MB (only the items-table) with 91385 items. i count 31 feeds. feeds get updated by owncloud cronjob which runs as php-script every hour without errors.

examining the status i get the following result

SELECT count(status), status FROM `oc_news_items` group by status

count(status)   status  
5621    0   
85751   2   
13  4    

System Information

Contents of owncloud/data/owncloud.log

{"reqId":"uLHk8igMCJOgfox6xwO2","remoteAddr":"178.25.191.165","app":"news","message":"Configuration value \"simplePieCacheDuration\" does not exist. Ignored value.","level":2,"time":"2017-02-19T16:09:17+00:00"}
{"reqId":"zMNXneDKKf\/dbshZMghR","remoteAddr":"178.25.191.165","app":"PHP","message":"Automatically populating $HTTP_RAW_POST_DATA is deprecated and will be removed in a future version. To avoid this warning set 'always_populate_raw_post_data' to '-1' in php.ini and use the php:\/\/input stream instead. at Unknown#0","level":3,"time":"2017-02-19T16:20:45+00:00"}

content of owncloud/data/news/config/config.ini

autoPurgeMinimumInterval = 60
autoPurgeCount = 200
maxRedirects = 10
maxSize = 104857600
exploreUrl = 
feedFetcherTimeout = 60