Page 1 of 1

RSS Error

Posted: 18 Jun 2008, 06:52
by Mtwo
I am having an issue with the RSS feeds, none of them work. Whenever I go to one of the feeds, i.e. cats/xml/?t=rss, I receive the following error:

Query Error -- Report to System Administrator ASAP

MySQL Query Failed: Unknown column 'date' in 'field list'

INSERT INTO http_log (
remote_addr,
http_user_agent,
script_filename,
request_method,
query_string,
request_uri,
script_name,
log_type,
site_id,
date
)
VALUES(
'24.15.49.185',
'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) Gecko/20080311 Firefox/2.0.0.13 GoogleToolbarFF',
'/cats/xml/index.php',
'GET',
't=rss',
'/cats/xml/?t=rss',
'/cats/xml/index.php',
1,
988,
'2008-06-18T00:43:01-05:00'
)


Does anyone know what is causing this and how to fix? Thanks ahead of time....

Re: RSS Error

Posted: 18 Jun 2008, 11:22
by RussH
Hiya, Jos is the RSS guy here - he's posted some guidance about digging into the RSS feed over in this thread here - may be a good place to start;

http://www.opencats.org/forums/viewtopi ... &t=16#p165