Page 1 of 1

Possible DB schema bug

Posted: 24 Sep 2012, 18:16
by nrosier

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?

Re: Possible DB schema bug

Posted: 24 Sep 2012, 18:32
by fox
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".