opencats.org

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....

sorry I can't be of more help - I can see that in my test CATS implementation the RSS feed works just fine;

http://www.chasejobs.co.uk/cats/xml/?t=rss

- do you have an unusual setup? i.e. are you running wamp rather than lamp?
- do you actually have a start date listed for all your jobs in the SQL database?
- have you customised the xml template?
- did you populate the jobs directly via the database and therefore miss some of the fields?
- have you directly edited the XmlUI.php module that builds the RSS stream? (/cats/modules/xml/XmlUI.php