Current SVN Version SQL Error

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
jd2066
Bear Rating Trainee
Bear Rating Trainee
Posts: 22
Joined: 09 Apr 2007, 13:37

Current SVN Version SQL Error

Postby jd2066 » 06 Sep 2007, 07:06

Hi,
I just upgraded my ttrss install to the latest SVN version and now get the following sql error when loading:
Query SELECT count(int_id) AS unread FROM ttrss_user_entries,ttrss_feeds,ttrss_entries WHERE ttrss_user_entries.feed_id = ttrss_feeds.id AND ttrss_user_entries.ref_id = ttrss_entries.id AND ttrss_feeds.hidden = false AND ttrss_entries.date_entered > NOW() - INTERVAL 'COUNTERS_MAX_AGE days' AND unread = true AND (marked = true) AND ttrss_user_entries.owner_uid = 1 failed []: ERROR: invalid input syntax for type interval: "COUNTERS_MAX_AGE days"

If that is caused by the SVN version being broken somehow I'll just restore a backup copy of my database and ttrss version.
Justin

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

Postby fox » 06 Sep 2007, 08:21

When using snapshots, always check config.php-dist and schema for any changes.

jd2066
Bear Rating Trainee
Bear Rating Trainee
Posts: 22
Joined: 09 Apr 2007, 13:37

Postby jd2066 » 06 Sep 2007, 21:25

fox wrote:When using snapshots, always check config.php-dist and schema for any changes.

I just checked config.php-dist and found I needed "define('COUNTERS_MAX_AGE', 365);" in my config.php.
I had assumed that if the config changed that ttrss would say so as it always did before but I guess that doesn't always apply for development versions.
Justin

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

Postby fox » 06 Sep 2007, 22:02

Yep, unfortunately this doesn't work for snapshots. This is actually mentioned here.

P.S. don't forget to report any found bugs in trunk code. :)


Return to “Support”

Who is online

Users browsing this forum: No registered users and 32 guests