Dear all,
TT-RSS service is hosted on my private server:
- Ubuntu Server (17.10)
- PostgreSQL (9.6.6)
- Apache 2
I installed Android app (v1.231) and made a search.
The server raised this error:
E_WARNING (2) classes/feeds.php:2151 PDO::query(): SQLSTATE[42703]: Undefined column: 7 ERROR: column "english" does not exist LINE 27: (tsvector_combined @@ to_tsquery(english, 'svalutazione… ^1. classes/feeds.php(2151): query(SELECT DISTINCT
date_entered,
guid,
ttrss_entries.id,ttrss_entries.title,
updated,
label_cache,
tag_cache,
always_display_enclosures,
site_url,
note,
num_comments,
comments,
int_id,
uuid,
lang,
hide_images,
unread,feed_id,marked,published,link,last_read,orig_feed_id,
last_marked, last_published,
ttrss_feeds.title AS feed_title,favicon_avg_color,
content,
author,score
FROM
ttrss_entries LEFT JOIN ttrss_user_entries ON (ref_id = ttrss_entries.id),ttrss_feeds
WHERE
ttrss_user_entries.feed_id = ttrss_feeds.id AND
ttrss_user_entries.owner_uid = ‘2’ AND
(tsvector_combined @@ to_tsquery(english, ‘svalutazione’)) ANDunread = true AND score >= 0 AND date_entered > NOW() - INTERVAL ‘24 hour’ ORDER BY updated DESC
LIMIT 30 OFFSET 0)
2. classes/api.php(705): queryFeedHeadlines(Array)
3. classes/api.php(240): api_get_headlines(-3, 30, 0, , , 1, 1, all_articles, updated DESC, 1, 0, Svalutazione, 1, 1, , 256, 4342, )
4. api/index.php(80): getHeadlines()
I investigated a while and I changed this line in the “include/functions.php” source file:
1384 $search_language = $pdo->quote(“english”);
and it seems solved the issue.
Thanks and best regards,
g.