'All Articles' always says no articles found to display

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
amit
Bear Rating Trainee
Bear Rating Trainee
Posts: 20
Joined: 12 Jan 2012, 13:13

'All Articles' always says no articles found to display

Postby amit » 03 Feb 2014, 14:07

Hello,

Clicking on 'All Articles' always shows "No articles found to display." This is in adaptive mode. Changing this mode doesn't help too. Selecting 'Unread', for example, shows "No unread articles found to display".

This used to work fine earlier, some update in the last few months broke it (can't remember which).

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

Re: 'All Articles' always says no articles found to display

Postby fox » 03 Feb 2014, 14:21

This is a highly helpful post.

amit
Bear Rating Trainee
Bear Rating Trainee
Posts: 20
Joined: 12 Jan 2012, 13:13

Re: 'All Articles' always says no articles found to display

Postby amit » 03 Feb 2014, 14:47

What debug info can I gather? From where?

BTW there are several (thousands) unread articles in various feeds, but they don't show up in the 'all articles' feed. 'Fresh articles' only shows articles unread which have arrived in the last <configured> hours, and that works as expected.

AngryChris
Bear Rating Master
Bear Rating Master
Posts: 135
Joined: 08 Apr 2013, 02:42

Re: 'All Articles' always says no articles found to display

Postby AngryChris » 03 Feb 2014, 20:42

I'm just curious here, are you by any chance using MySQL with MyIASM tables?

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

Re: 'All Articles' always says no articles found to display

Postby fox » 03 Feb 2014, 21:59

Yeah this looks like some kind of database problem and myisam is the usual culprit.

amit
Bear Rating Trainee
Bear Rating Trainee
Posts: 20
Joined: 12 Jan 2012, 13:13

Re: 'All Articles' always says no articles found to display

Postby amit » 03 Feb 2014, 22:03

Yes, using mysql 5.1 and myisam.

Thanks for narrowing this down.

Is there a recipe for fixing the db?

amit
Bear Rating Trainee
Bear Rating Trainee
Posts: 20
Joined: 12 Jan 2012, 13:13

Re: 'All Articles' always says no articles found to display

Postby amit » 03 Feb 2014, 22:08

Also, everything else seems to be working fine, so I'm curious to know how this would point to a db problem.

amit
Bear Rating Trainee
Bear Rating Trainee
Posts: 20
Joined: 12 Jan 2012, 13:13

Re: 'All Articles' always says no articles found to display

Postby amit » 03 Feb 2014, 22:37

Turns all the tables are innodb, but the myisam files still exist. Must've converted sometime back.

Is mysql + innodb also a problem?

AngryChris
Bear Rating Master
Bear Rating Master
Posts: 135
Joined: 08 Apr 2013, 02:42

Re: 'All Articles' always says no articles found to display

Postby AngryChris » 04 Feb 2014, 03:00

MySQL + InnoDB is fine (as well as can be expected). MyISAM tables are a problem because they do not support (at least) some database operations that TT-RSS relies on. And the failures are silent. One of the most common operations is ON DELETE CASCADE, so when TT-RSS goes to delete a record, all records tied to it with foreign keys (i.e.; in other tables) are also deleted. MyISAM silently fails to do this so the database ends up in an inconsistent state. InnoDB supports it and works.

Due to issues like this (and others, mostly performance related), PostgreSQL is the recommended backend for TT-RSS. The only solution to your MyISAM table problem is to drop the database and start from scratch with the correct storage engine (the current ttrss_scheme_mysql.sql file handles this). There's really no saving the data that's already in there. You'll just get a dump of bad data, so your new instance will be just as screwed up if you use that dump.

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

Re: 'All Articles' always says no articles found to display

Postby fox » 04 Feb 2014, 08:43

There are I think two tables which could be myisam (counter caches). If something like ttrss_entries is not innodb, then you have a problem.

amit
Bear Rating Trainee
Bear Rating Trainee
Posts: 20
Joined: 12 Jan 2012, 13:13

Re: 'All Articles' always says no articles found to display

Postby amit » 04 Feb 2014, 09:47

All the tables are innodb; just re-confirmed.

amit
Bear Rating Trainee
Bear Rating Trainee
Posts: 20
Joined: 12 Jan 2012, 13:13

Re: 'All Articles' always says no articles found to display

Postby amit » 11 Feb 2014, 15:12

I dumped the db and re-updated it; and that has helped.

Thanks for the hint on the database.


Return to “Support”

Who is online

Users browsing this forum: No registered users and 11 guests