Starred article feed not showing articles

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
acidburns
Bear Rating Trainee
Bear Rating Trainee
Posts: 5
Joined: 29 Mar 2013, 18:02

Starred article feed not showing articles

Postby acidburns » 07 Jul 2015, 10:01

Hey there,

I've been using tt-rss since almost 3 years now and I'm very grateful for your work here! It's a very good program :D

However since a few days ago the starred article feed stopped showing articles. (It says no articles to show.)
I'm using the newest firefox with noscript, windows defender and windows firewall... I also tried showing the feeds with an out of the box google chrome.
Settings are: Show all articles, newest first. There are no errors shown in the php update_daemon2 or anywhere on the apache logs.

TinyRSS is running on my x86 Linux Server (QNAP) at home, the server hasn't been changed or updated for month. The MySQL Database is on a usb 3 SSD drive, so I/O Problems should not occur.
I think the feed may hav been broken by a faulty article or some unexpected (unicode?) chars.

Is there any way to fix this? I've been archiving some important research articles by starring and really don't want to loose/empty the database.

Sincerely,

Acid

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Starred article feed not showing articles

Postby fox » 07 Jul 2015, 10:16

update to latest trunk first? i'm not sure how anyone could help you with this otherwise

"i have a nonspecified version of tt-rss running on my nas which i'm not going to tell you anything about, and it stopped working mysteriously, please help"

think about it for a second

User avatar
id242
Bear Rating Trainee
Bear Rating Trainee
Posts: 16
Joined: 25 Mar 2013, 14:04
Location: Los Angeles, CA
Contact:

Re: Starred article feed not showing articles

Postby id242 » 07 Jul 2015, 11:33

1. Go to the "Actions" drop-down menu.
2. Toggle "(Un)hide read feeds"
Your "Starred articles" and other special groupings will now be displayed.

Running latest 2015-07-06 trunk/master bits. But that most probably doesnt matter.

acidburns
Bear Rating Trainee
Bear Rating Trainee
Posts: 5
Joined: 29 Mar 2013, 18:02

Re: Starred article feed not showing articles

Postby acidburns » 07 Jul 2015, 16:12

I'm already running the latest git version, I forgot to mention that updating was the second step after checking the mysql db with "mysqlcheck --repair" and before rebooting.

Read articles are already unhidden, toggling the action back and forth with reloading the page (STRG+F5 to also purge the cache) doesn't bring anything back.

The full system specifications are:
Tiny Tiny RSS v1.15.3.2374294 <-- just did a git pull again a few minutes ago and restarted everything
PHP Version: 5.5.25
APACHE Version: 2.2.29 ; Build: 22.05.2015
MYSQL Version: 5.1.36 ; Protocol Version: 10 ; Platform: i686
The System is a Qnap TS 569L running on the newest QTS4.1.4

I knew that the information was pretty thin, but I'm not quite sure which information you need to determine the problem. I also couldn't find any logfiles worth attaching; just a two line php errorlog, which says that magic_quotes is not supported in php 5.3 and above... Unfortunately no file name or line is given.
The server is also running owncloud 8.0.3 but with a different mysql user (which has no rights in the tinytinyrss database) in a different apache virtual host; so interference between those two could be excluded.

Sincerely,

Acid

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Starred article feed not showing articles

Postby fox » 07 Jul 2015, 16:19

you can try checking if the stuff is actually in the database, i.e. run something like

Code: Select all

ttrss_db=> select owner_uid, count(ref_id) from ttrss_entries, ttrss_user_entries where marked = true and ref_id = id group by owner_uid;


you should see the amount of starred articles next to your UID. i'm sort of not sure what could be going on here, unless there's something with database integrity i.e. you were running on myisam tables (there's a thread on the forums which you can use to check this).

e: https://tt-rss.org/forum/viewtopic.php? ... sam#p16425

if all else fails you can try dumping and emailing me your database, i'll take a look. it helped before a few times with really obscure bugs.

acidburns
Bear Rating Trainee
Bear Rating Trainee
Posts: 5
Joined: 29 Mar 2013, 18:02

Re: Starred article feed not showing articles

Postby acidburns » 07 Jul 2015, 16:38

The stuff is there:

Code: Select all

mysql> use ttrss;
Database changed
mysql> select owner_uid, count(ref_id) from ttrss_entries, ttrss_user_entries where marked = true and ref_id = id group by owner_uid;
+-----------+---------------+
| owner_uid | count(ref_id) |
+-----------+---------------+
|         2 |          9947 |
+-----------+---------------+
1 row in set (0.43 sec)

The number is also displayed next to the starred articles on the webpage.

I just did a myisamchk (should be the same as mysqlcheck but without a running mysql server):

Code: Select all

myisamchk --silent --force --fast --update-state \
          --key_buffer_size=64M --sort_buffer_size=64M \
          --read_buffer_size=1M --write_buffer_size=1M \
          /share/external/DEV3304_1/var/tinyrss/*.MYI

It finished without any errors, so the database should be clean.
Last edited by acidburns on 07 Jul 2015, 16:57, edited 2 times in total.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Starred article feed not showing articles

Postby fox » 07 Jul 2015, 16:46

are the tables on innodb engine?

acidburns
Bear Rating Trainee
Bear Rating Trainee
Posts: 5
Joined: 29 Mar 2013, 18:02

Re: Starred article feed not showing articles

Postby acidburns » 07 Jul 2015, 16:58

well, I dunno what to say, but a second reboot of the complete machine somehow fixed it... I don't know who or what was the culprit, but I guess it had something to do with the swapping and or temp folders which I just cleared before rebooting.
:roll: Sorry for any inconvenience I caused

I guess at least the innodb tables are there now :)

For the record all the steps I did:
- Reboot apache and mysql
- fix myql tables with mysqlcheck
- pull newest version
- reboot whole machine
--- a few days later
- reboot apache and mysql
- try different browsers (chrome)
- try differenc pc (ubuntu based with firefox)
- another git pull
- myiamchk of the powered off mysql db
- clean tmp files (/tmp, etc)
- shutdown and manually power on after a few min.

Hope it helps once anyone else has the same problem


Return to “Support”

Who is online

Users browsing this forum: No registered users and 12 guests