Search found 7 matches

by k0OAhV
10 Feb 2015, 00:35
Forum: Support
Topic: Undo mark all read
Replies: 16
Views: 8641

Re: Undo mark all read

Code: Select all

UPDATE "public"."ttrss_user_entries"
SET "unread" = 't'
WHERE "ttrss_user_entries"."last_read" = '2015..'


This worked for me, :D
by k0OAhV
22 Jun 2014, 22:30
Forum: Unsupported platforms
Topic: Starred/Published Article Count
Replies: 13
Views: 5776

Re: Starred/Published Article Count

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:
by k0OAhV
22 Jun 2014, 22:04
Forum: Unsupported platforms
Topic: Starred/Published Article Count
Replies: 13
Views: 5776

Re: Starred/Published Article Count

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 !!
by k0OAhV
22 Jun 2014, 21:15
Forum: Unsupported platforms
Topic: Starred/Published Article Count
Replies: 13
Views: 5776

Re: Starred/Published Article Count

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
by k0OAhV
22 Jun 2014, 20:54
Forum: Unsupported platforms
Topic: Starred/Published Article Count
Replies: 13
Views: 5776

Re: Starred/Published Article Count

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...
by k0OAhV
22 Jun 2014, 20:21
Forum: Unsupported platforms
Topic: Starred/Published Article Count
Replies: 13
Views: 5776

Re: Starred/Published Article Count

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 reinst...
by k0OAhV
22 Jun 2014, 18:46
Forum: Unsupported platforms
Topic: Starred/Published Article Count
Replies: 13
Views: 5776

Starred/Published Article Count

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 but...

Go to advanced search