1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
|
% FAQ
### General
#### I managed to lock myself out of tt-rss
This assumes you can't simply reset your password via email (login form - forgot my password).
If you have OTP (2FA) enabled and know your password but can't provide an OTP token, you can disable OTP via SQL:
```
UPDATE ttrss_users SET otp_enabled = false WHERE login = 'you'
```
If you don't remember your password run the following query:
```
UPDATE ttrss_users
SET pwd_hash = 'SHA1:5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', salt = '', otp_enabled = false
WHERE login = 'you'
```
This sets your password back to default (``password``) and disables OTP.
#### I have HTTP authentication enabled and get “Your access level is insufficient to run this script” error on login
The problem is that if you have auth\_remote enabled in config.php tt-rss tries to automatically log you in as the user specified by the server using HTTP authentication, which may not have administrative privileges.
You will need to either temporarily disable auth\_remote (replace it with auth\_internal in config.php), temporarily disable HTTP authenticati on, or give yourself administrative permissions using SQL client:
```sql
update ttrss_users set access_level = 10 where login = 'you';
```
### UI
#### I'm using lastpass and stuff is broken
Lastpass arbitrarily breaks tt-rss forms preventing stuff like saving settings from functioning properly.
#### UI is missing CSS or is otherwise visibly broken
- Try opening tt-rss using a clean browser profile or an incognito window (a different browser would also work)
- Unless you're using SSL, try a different network connection in case your ISP is MITMing you
- Some values of ``Content-Security-Policy`` header may break tt-rss, if you have this header set in your httpd config, try disabling it temporarily
- Check for any files in ``(tt-rss)/themes`` not known to Git (especially ``default.php`` or ``default.css`` - formerly default CSS themes for tt-rss, now removed), try temporarily removing all third party themes from ``themes.local``
See also:
- <https://discourse.tt-rss.org/t/no-css-loaded-on-main-page/1957/4>
- <https://discourse.tt-rss.org/t/drop-down-menus-have-text-not-arrows/1703/5>
- <https://discourse.tt-rss.org/t/drop-down-menus-have-text-not-arrows/1703/6>
- <https://discourse.tt-rss.org/t/panels-and-menu-messed-up/2208/3>
- <https://discourse.tt-rss.org/t/ttrss-not-rendering-properly-missing-css/2359/26>
#### Third party theme broke after update making the UI unusable
You can open tt-rss with ``ignore-theme`` URL parameter to temporarily force default theme:
```
https://example.com/tt-rss/prefs.php?ignore-theme=1
```
Alternatively, either delete or rename offending CSS file in ``themes.local``.
### Database
#### What should I use - MySQL or PostgreSQL?
tt-rss is developed with PostgreSQL in mind, MySQL support is an afterthought.
If possible, consider using PostgreSQL for tt-rss. MySQL is supported but some minor features may be exclusive to Postgres and you're going to see worse performance (because InnoDB is slow).
#### MySQL/MariaDB is complaining about SQL errors in ``counters.php``
<https://community.tt-rss.org/t/troubleshoot-problems-updating-to-last-version-c0f689a58f/3344/7?u=fox>
#### I want to migrate my data but I can't use a database dump
One common use case for this is moving from MySQL to PostgreSQL.
If you don't want to migrate your stored articles, export and import your feeds via OPML, which would also
migrate your tt-rss settings and filters.
If you want to migrate your articles, use this plugin: <https://git.tt-rss.org/fox/ttrss-data-migration/wiki>
#### Schema upgrade fails on MySQL 5.7 (and newer)
Error message: <code>Invalid default value for 'last_updated'</code>
See this thread/post for instructions: <https://srv.tt-rss.org/oldforum/viewtopic.php@f=1&t=3871&p=22884.html#p22884>
### Updating
#### Feeds stop updating for users who rarely login
See this thread: <https://srv.tt-rss.org/oldforum/viewtopic.php@f=1&t=2909&p=23459.html#p17145>
#### I have used update daemon before, but switched away from it. However, the UI keeps nagging me about the daemon not running or not updating feeds or whatever.
Find and delete daemon lock file in <code>LOCK\_DIRECTORY</code>.
Usually, it’s <code>lock/update\_daemon.lock</code>. You can also remove
<code>update\_daemon.stamp</code>.
#### I have questions about article purging / I don't think purging works.
In short, you may and will see articles with date older than the cutoff
for purging. Here’s why:
- starred articles are not purged;
- purging is done based on import date internal to tt-rss which
could be different from the timestamp specified by the feed (i.e.
article says it was published on 01-01-1970 but it was imported today);
- tt-rss bumps import date every time article is encountered in the feed, otherwise
it will get purged and imported again on every feed update causing constantly reappearing duplicates;
- purging is performed after feed was updated hence disabled updates = no purging;
See also:
- <http://tt-rss.org/oldforum/viewtopic.php@f=1&t=792.html>
You can see article import date if you mouse over displayed date in
tt-rss web UI.
Related question:
#### I archive or delete articles manually and I get duplicates. Why?
Because the articles are still in the feed XML and get pulled in (again) on next feed update.
See also: [ArchivedFeed](wiki/ArchivedFeed)
### Integration
#### I need an URL I can call to subscribe to feed to integrate with some third party browser extension/application.
<code>https://example.com/tt-rss/public.php?op=subscribe&feed\_url=%s</code>
If feed URL is empty (or not given) tt-rss will display feed subscription dialog.
#### I want to check how tt-rss renders my feed / the feed I'm trying to use is parsed incorrectly
You can run any RSS/Atom feed through tt-rss parser [here](https://tt-rss.org/myfeedsucks/).
See this thread for more information / feedback: <https://community.tt-rss.org/t/my-feed-doesnt-parse-properly-or-does-it-myfeedsucks/30>
#### I need to get the number of unread articles in the simplest way.
<code>https://example.com/tt-rss/backend.php?op=getUnread&login=LOGIN</code>
No password required. In single user mode, use “admin” for login.
|