Page 1 of 1

Error Executing Query 1017

Posted: 03 Nov 2016 14:15
by EFAUser1
When trying to drill down and view any email message I receive:
"Error executing query:
1017: Can't find file: 'audit_log' (erno: 2)"

Not finding anything in the forums regarding this error. Anybody ever seen it before?

Re: Error Executing Query 1017

Posted: 04 Nov 2016 22:40
by EFAUser1
Anybody? At a minimum, has anybody ever seen a file named audit_log? Searching through EFA's files via WinSCP but no luck yet on finding audit_log.

Unable to check any email (clicking the # sign) without getting this error.

Edit: /var/lib/mysql/mailscanner, I see three audit log files: audit_log.frm, audit_log.myd, audit_log.myi

Re: Error Executing Query 1017

Posted: 13 Nov 2016 00:04
by shawniverson
That error is very strange. Audit logs are stored in mysql. It is not a file, it is a database.

This may indicate that something is wrong with your mysql and/or audit log table in the mailwatch db.

Re: Error Executing Query 1017

Posted: 25 Apr 2017 05:21
by pdwalker
Did you resolve your problem?