not working v1.0.6 with mysql

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
seb

not working v1.0.6 with mysql

Postby seb » 24 Oct 2005, 23:50

Get that display on left in place of rss feed list that text !!!
Query SELECT count(id) as num_starred FROM ttrss_entries WHERE marked = true AND unread = true failed: Unknown column 'true' in 'where clause'

????
so display on right "No feed selected."

seb

install tt-rss-20051024 but same issue

Postby seb » 25 Oct 2005, 00:19

Get messages :

refetch_callback: backend did not return expected XML object

Query UPDATE ttrss_entries SET last_read = NOW(),unread = false
failed: Unknown column 'false' in 'field list'

Query SELECT tag_name,count(ttrss_entries.id) AS count FROM ttrss_tags,ttrss_entries WHERE post_id = ttrss_entries.id AND unread = true GROUP BY tag_name UNION select tag_name,0 as count FROM ttrss_tags failed:
Unknown column 'true' in 'where clause'

some idea??

seb

SQL syntax to adapt to MYSQL??

Postby seb » 25 Oct 2005, 00:57

pour plus de precision

PHP Version 4.3.10
Apache/2.0.51
mysql Client API version 3.23.58

Query SELECT *, (SELECT count(id) FROM ttrss_entries WHERE feed_id = ttrss_feeds.id) AS total, (SELECT count(id) FROM ttrss_entries WHERE feed_id = ttrss_feeds.id AND unread = 'true') as unread FROM ttrss_feeds ORDER BY title failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT count(id) FROM ttrss_entries WHERE feed_id = ttrss

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Postby fox » 25 Oct 2005, 09:19

cue README:
b) MySQL (InnoDB and server version 4.1+ required)


Return to “Support”

Who is online

Users browsing this forum: No registered users and 9 guests