Please describe the issue you're having
If you accept the answer, please mark the topic as [SOLVED] by clicking the tick.

Moderators: RussH, cptr13

Forum rules: Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but respect our space and keep your comments directed to the topic at hand.
By Mtwo
#293
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....
Best Install Platform

I use the OpenCATS Docker Setup. This is currently[…]

removing candidates from job orders

That's an excellent question! While cleaning up se[…]

Hello OpenCATS Community, As someone working on i[…]

Clean export of CATS data and documents

Hello @ RussH, No, they offer the import function[…]