Possible DB schema bug

Support requests, bug reports, etc. go here. Dedicated servers / VDS hosting only
nrosier
Bear Rating Trainee
Bear Rating Trainee
Posts: 2
Joined: 11 Aug 2012, 18:36

Possible DB schema bug

Postby nrosier » 24 Sep 2012, 18:16

Hi,

noticed following in my Postgres logs:

Code: Select all

2012-09-24 14:00:05.443 GMT,"ttrss","ttrss",52525,"2001:xxxx::xxxx:53628",50606762.cd2d,1,"",2012-09-24 14:00:02 GMT,3/389,0,ERROR,42703,"column ""date_updated"" does not exist",,,,,,"SELECT int_id FROM ttrss_user_entries               WHERE date_updated>[email protected]_reindex",47,,""


Check the schema but at no time do I find a version where ttrss_user_entries has a column date_update, only ttrss_entries has one. Is this a bug in the code or in the schema?

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

Re: Possible DB schema bug

Postby fox » 24 Sep 2012, 18:32

The field in question is in ttrss_entries. It might help if you figure out what were you doing when this happened, because I can't grep this query in the source. Also, I have no idea wtf is "@last_reindex".


Return to “Support”

Who is online

Users browsing this forum: No registered users and 5 guests