Tiny Tiny RSS: Community

[SOLVED] Android search doesn't work (error 500)


#1

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’)) AND

unread = 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.


#2

thanks, should be fixed in trunk.