Starred/Published Article Count

If you run tt-rss on an officially unsupported platform (shared hosting, Windows, etc.) post here
k0OAhV
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 22 Jun 2014, 18:29

Starred/Published Article Count

Postby k0OAhV » 22 Jun 2014, 18:46

Hi, thank you for the software,, and for reading this.

I have a problem with the latest version -- if you see the attachments, I have a few articles I'm archiving as starred and published.

The button to load starred articles displays a count of one article, when there are about 10.
The published button displays a count of one published article and only displays one article.

Additionally--
The feeds for each category work ok, though I can't find the marker for either category in phpmyadmin. >> I' want to create some kind of export script for interesting articles. just a txt of urls.
Would you be able to tell me how starred and published articles are distinguished from others ??


Thank you,,



(2987) Tiny Tiny RSS 2014-06-22 15-25-11.png
starred articles showing count of one.
(2987) Tiny Tiny RSS 2014-06-22 15-25-11.png (41.29 KiB) Viewed 6177 times


(2987) Tiny Tiny RSS 2014-06-22 15-25-55.png
published articles displaying count of one, and only displaying one of about 10.
(2987) Tiny Tiny RSS 2014-06-22 15-25-55.png (21.74 KiB) Viewed 6177 times

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

Re: Starred/Published Article Count

Postby fox » 22 Jun 2014, 20:15

this sounds like myisam.

k0OAhV
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 22 Jun 2014, 18:29

Re: Starred/Published Article Count

Postby k0OAhV » 22 Jun 2014, 20:21

fox wrote:this sounds like myisam.


Hosting is OpenShift with

PHP 5.4
MySQL 5.5
PostgreSQL 9.2
phpMyAdmin 4.0
Cron 1.4


I installed using the OpenShift quickstarter package, then updated to the latest version.
I switched from PostgreSQL to MySQL when updating because I wanted to use phpMyAdmin.

Should I reinstall ??


Thanks

JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: Starred/Published Article Count

Postby JustAMacUser » 22 Jun 2014, 20:39

k0OAhV wrote:I switched from PostgreSQL to MySQL when updating because I wanted to use phpMyAdmin.

Should I reinstall ??


You moved from PostgreSQL to MySQL without reinstalling? If so, yes, reinstall. The SQL dump and import certainly would have caused issues.

Also, there are web interfaces for PostgreSQL so if that was your sole reason, it was unnecessary. Plus, how much time will you spend administrating your database versus using the app? I ask because PostgreSQL has a noticeable performance advantage for tt-rss.

e: Listing the software and their versions helps. But it doesn't answer the question of whether you're using MyISAM or InnoDB. Use phpMyAdmin to show the tables and look for the Engine being used for each table.

k0OAhV
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 22 Jun 2014, 18:29

Re: Starred/Published Article Count

Postby k0OAhV » 22 Jun 2014, 20:54

JustAMacUser wrote:
k0OAhV wrote:I switched from PostgreSQL to MySQL when updating because I wanted to use phpMyAdmin.

Should I reinstall ??


You moved from PostgreSQL to MySQL without reinstalling? If so, yes, reinstall. The SQL dump and import certainly would have caused issues.

Also, there are web interfaces for PostgreSQL so if that was your sole reason, it was unnecessary. Plus, how much time will you spend administrating your database versus using the app? I ask because PostgreSQL has a noticeable performance advantage for tt-rss.



Yes, although it was a clean install before updating and moving to MySQL -- I didn't import any data to the new install. I reinitialised the database, created a new config, logged in, added feeds and started reading.

There was an issue with the config to do with SPHINX, I had to add a new line:
define('SPHINX_ENABLED', false);
before everything worked.


Likely 95% or more time using the app. I will certainly start using PostgreSQL if it is faster, I'd just like a way to export the best articles outside of the database for archiving and i figured I'd use phpMyAdmin to check how articles are defined as starred.

Could you recommend an interface for PostgreSQL ?


Thanks



edit:
The engine type is InnoDB.


Thanks again

JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: Starred/Published Article Count

Postby JustAMacUser » 22 Jun 2014, 21:06

http://stackoverflow.com/questions/5725216/postgresql-visual-interface-similar-to-phpmyadmin

It sounds like your install was new when you moved. Still, it's best to start clean if you're moving back to PostgreSQL.

As for saving articles long-term: You could just star them or actually mark them as "archive". There's a column in the database called "marked" in the ttrss_user_entries that stores the starred value (boolean/integer). Starring is a good way to go since it's easy, readily visible in the interface and prevents the articles from being purged. Archiving does much the same but starring would be my preference for various reasons.

k0OAhV
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 22 Jun 2014, 18:29

Re: Starred/Published Article Count

Postby k0OAhV » 22 Jun 2014, 21:15

OK I will reinstall with PostgreSQL. Thanks for the info.

I think this will fix the count values, will let you know when I know.


cheers !!

:D

k0OAhV
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 22 Jun 2014, 18:29

Re: Starred/Published Article Count

Postby k0OAhV » 22 Jun 2014, 22:04

Success with running on PostgreSQL, article counts are working, system seems faster.

OpenShift doesn't yet support interfaces for PostgreSQL, but I think there is ssh functionality for that.

Thanks for the help !!

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Starred/Published Article Count

Postby sleeper_service » 22 Jun 2014, 22:26

k0OAhV wrote:
fox wrote:this sounds like myisam.


I switched from PostgreSQL to MySQL when updating because I wanted to use phpMyAdmin.


I hereby nominate this for the "stupidest reason *EVER*" award.

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Starred/Published Article Count

Postby sleeper_service » 22 Jun 2014, 22:29

k0OAhV wrote:OpenShift doesn't yet support interfaces for PostgreSQL, but I think there is ssh functionality for that.

it's not called openshit for nothing. :lol:

k0OAhV
Bear Rating Trainee
Bear Rating Trainee
Posts: 7
Joined: 22 Jun 2014, 18:29

Re: Starred/Published Article Count

Postby k0OAhV » 22 Jun 2014, 22:30

sleeper_service wrote:
k0OAhV wrote:
fox wrote:this sounds like myisam.


I switched from PostgreSQL to MySQL when updating because I wanted to use phpMyAdmin.


I hereby nominate this for the "stupidest reason *EVER* award.



I'd like a medal :mrgreen:

SOV
Bear Rating Trainee
Bear Rating Trainee
Posts: 15
Joined: 13 Jun 2014, 02:41

Re: Starred/Published Article Count

Postby SOV » 22 Jun 2014, 23:40

k0OAhV wrote:I'd like a medal :mrgreen:


Image

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

Re: Starred/Published Article Count

Postby fox » 23 Jun 2014, 00:00

nice!

michalurban
Bear Rating Trainee
Bear Rating Trainee
Posts: 8
Joined: 01 Jun 2014, 20:49

Re: Starred/Published Article Count

Postby michalurban » 23 Jun 2014, 01:43

SOV wrote:
k0OAhV wrote:I'd like a medal :mrgreen:


Image


Thats simply greaty! :D


Return to “Unsupported platforms”

Who is online

Users browsing this forum: Google [Bot] and 1 guest