Search found 135 matches

by AngryChris
26 Sep 2013, 23:36
Forum: Support
Topic: 1.9 to 1.10 - update performance regression
Replies: 22
Views: 5795

Re: 1.9 to 1.10 - update performance regression

I've not monitored CPU usage, but the fan in my server goes high speed a lot more often now, concurrent with feed update runs. I've wondered why and now I know! (I have no plans to "fix" it, however). Pentium 4 HT 3.00 GHz, 3.5 GB of RAM, Ubuntu Server 12.04.3. I don't know how that compar...
by AngryChris
23 Sep 2013, 09:39
Forum: Support
Topic: Getting "UPdate daemon not running" error after upgrading to
Replies: 5
Views: 3693

Re: Getting "UPdate daemon not running" error after upgradin

It's actually called tt-rss.conf and then you can start and stop the service thusly: [email protected]:~$ sudo initctl stop tt-rss tt-rss stop/waiting [email protected]:~$ sudo initctl start tt-rss tt-rss start/running, process 32332 [email protected]:~$ Do keep in mind that the configuration there assumes PostgreSQL...
by AngryChris
23 Sep 2013, 03:16
Forum: Support
Topic: Getting "UPdate daemon not running" error after upgrading to
Replies: 5
Views: 3693

Re: Getting "UPdate daemon not running" error after upgradin

On Ubuntu Server using Upstart, I have this Upstart job running: # tt-rss - Tiny Tiny RSS # # This job runs the feed updater for Tiny Tiny RSS. This is not the main # application itself, this is merely the feed update daemon. description "Tiny Tiny RSS feed updater" start on runlevel [2345...
by AngryChris
20 Sep 2013, 18:59
Forum: Unsupported platforms
Topic: Out of memory issues
Replies: 27
Views: 9262

Re: Out of memory issues

I have 134 feeds with the same 128MB limit and no issues. psql (9.1.9) Type "help" for help. ttrssdb=> select count(*) from ttrss_feeds; count ------- 134 (1 row) ttrssdb=> [email protected]:~$ grep memory_limit /etc/php5/apache2/php.ini memory_limit = 128M [email protected]:~$ That said, the web serv...
by AngryChris
12 Sep 2013, 09:44
Forum: Support
Topic: Feedburner status ?
Replies: 17
Views: 4318

Re: Feedburner status ?

Have you enabled the af_unburn plugin that comes with the software?

Code: Select all

af_unburn   Resolves feedburner and similar feed redirector URLs (requires CURL)   1.00   fox
by AngryChris
11 Sep 2013, 21:08
Forum: Development
Topic: Tiny Tiny RSS iPhone/iPad App
Replies: 68
Views: 33960

Re: Tiny Tiny RSS iPhone/iPad App

Is there a way to force the app to accept a self-signed certificate or is it the operating system that's preventing me from allowing an exception? I can use the TT-RSS Mobile website just fine in Safari (iOS 6), but the app doesn't offer a chance to accept that I know what I'm doing and that my serv...
by AngryChris
10 Sep 2013, 12:12
Forum: Everything else
Topic: Question on MySQL database structure: Why 3 MyISAM tables?
Replies: 21
Views: 9818

Re: Question on MySQL database structure: Why 3 MyISAM table

I would guess if the table is already InnoDB and you do the ALTER TABLE on it to set InnoDB, it will just pop an error. I can't imagine it would break anything.
by AngryChris
10 Sep 2013, 07:17
Forum: Everything else
Topic: Question on MySQL database structure: Why 3 MyISAM tables?
Replies: 21
Views: 9818

Re: Question on MySQL database structure: Why 3 MyISAM table

sleeper_service wrote:isn't there a way to convert a myisam table to innodb?

Hah! I guess you can! I don't touch MySQL and didn't look it up.

Code: Select all

ALTER TABLE table_name ENGINE=InnoDB;

From here: 5.4.3. Converting Tables from MyISAM to InnoDB
by AngryChris
10 Sep 2013, 02:31
Forum: Everything else
Topic: Question on MySQL database structure: Why 3 MyISAM tables?
Replies: 21
Views: 9818

Re: Question on MySQL database structure: Why 3 MyISAM table

Universal diff for ttrss_schema_mysql.sql for TT-RSS version 1.8. You can figure out how to patch your own if you have something different (let this diff be your guide). This sets the 3 "orphaned" tables to InnoDB. You'll need to recreate your database to use this. --- ttrss_schema_mysql.s...
by AngryChris
02 Sep 2013, 21:18
Forum: Feature requests
Topic: Differentiate between marked by "read" and mark as read.
Replies: 11
Views: 3385

Re: Differentiate between marked by "read" and mark as read.

I think the difference the OP is trying to point out here is between "marked as read because I actually read them" and "marked as read because I don't want to read them but 'Mark As Read' is the only button I can use to tell these posts to go away, that I don't care about them, and th...
by AngryChris
27 Aug 2013, 19:49
Forum: Support
Topic: Mark read older than issue?
Replies: 8
Views: 1490

Re: Mark read older than issue?

I think it would be far easier to take solace in the fact that the function will work as expected tomorrow. Meaning, wait 1 day and the problem will resolve itself under the current design. I'm not convinced this issue rises to the level of "must be fixed." I'm not convinced it is an issue.
by AngryChris
17 Aug 2013, 05:23
Forum: Support
Topic: I'm an idiot
Replies: 6
Views: 2299

Re: I'm an idiot

Oh, that's awesome. Thanks for the catch, sleeper_service! I missed that one. I should probably go thwap myself in the other thread before fox does it. ;) I think I figured out why, too. Those tables do not have foreign keys or cascading deletes. The two main pain points for MyISAM tables. So yes, i...
by AngryChris
17 Aug 2013, 02:31
Forum: Support
Topic: I'm an idiot
Replies: 6
Views: 2299

Re: I'm an idiot

Be sure to reference this thread: http://tt-rss.org/forum/viewtopic.php?f=11&t=2534 If the default engine and encoding in your MySQL database is not configured to InnoDB and UTF8 respectively, you may suffer some undesirable effects. I'm confident it will be fixed in trunk (if it's not already, ...
by AngryChris
12 Aug 2013, 04:01
Forum: Everything else
Topic: Question on MySQL database structure: Why 3 MyISAM tables?
Replies: 21
Views: 9818

Re: Question on MySQL database structure: Why 3 MyISAM table

It looks like you found a bug in the ttrss_schema_mysql.sql file. Here's the content where each table is created and the associated ENGINE=InnoDB statements: [email protected]:/var/www/tt-rss/schema$ grep -e "create table" -e "ENGINE=InnoDB" ttrss_schema_mysql.sql create table ttrss_us...
by AngryChris
09 Aug 2013, 23:35
Forum: Themes and plugins
Topic: [1.9] Video preview displays blank black box
Replies: 2
Views: 1631

Re: [1.9] Video preview displays blank black box

I believe you need the videoframes plugin for embedding video directly in tt-rss posts:
https://github.com/tribut/ttrss-videoframes

Go to advanced search