Audit Log 1064 Error

Quote

switchblade1984 VIP

Total posts: 132
16 Apr 2014 17:22

I have the latest version of Cobalt 8 installed on 2 website and when I try to view Audit Lgos I get the same error on both.

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY a.event' at line 3 SQL=SELECT a.event, count(event) as total FROM klp20_js_res_audit_log AS a WHERE a.type_id IN (1,0) AND a.section_id IN () GROUP BY a.event

any ideas?

Last Modified: 22 Apr 2014

Quote

Sergey

Total posts: 13,748
17 Apr 2014 08:36

This is strange. There is a condition not to use sections if section variable is empty. Anyway I have applied some changes to make better check.

Quote

switchblade1984 VIP

Total posts: 132
20 Apr 2014 18:27

Hello, I upgraded Cobalt and now I get a slighty different Error.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY a.user_id' at line 4 SQL=SELECT a.user_id, count(a.user_id) as total,u.name, u.username FROM tl3rg_js_res_audit_log AS a LEFT JOIN tl3rg_users AS u ON u.id = a.user_id WHERE a.type_id IN (1,0) AND a.section_id IN () GROUP BY a.user_id

Quote

Sergey

Total posts: 13,748
21 Apr 2014 07:31

Please give me your site access credentials and I'll check it there.

Quote