getting errors into the system log of OTRS

[inderjohar2287]

I am getting below error into the "system log" of OTRS. Kindly suggest what needs to be change to fix it?

Unknown column 'calendar_name' in 'field list', SQL: 'SELECT id, name, valid_id, create_time, create_by, change_time, change_by, calendar_name, first_response_time, first_response_notify, update_time, update_notify, solution_time, solution_notify FROM ticket_priority WHERE id = ? LIMIT 1'

[Rooobaaat]

have you modified your sql database? it meens that the column 'calender_name' isn't there....

[reneeb]

Your SELECT is for the wrong table. Replace ticket_priority with sla. The logs should show a stacktrace, so you should know where to change the code.

[inderjohar2287]

I have not done any changes in the code.
Anyways let me know what exactly changes I need to do from admin panel?

[jojo]

this is not an OTRS error. So you might have installed a:
- third party module with this error
- trying to use this SQL in the SQL Select Box

[reneeb]

[...]The logs should show a stacktrace, so you should know where to change the code.

Please show us the stacktrace...

[inderjohar2287]

Where to see stack trace?

[reneeb]

It should be in the log files...

[inderjohar2287]

It's not giving now any error. Surprise. It it's all fixed.