Error Executing Query 1017

General eFa discussion
Post Reply
EFAUser1
Posts: 17
Joined: 22 Dec 2014 18:56

Error Executing Query 1017

Post 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?
EFAUser1
Posts: 17
Joined: 22 Dec 2014 18:56

Re: Error Executing Query 1017

Post 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
User avatar
shawniverson
Posts: 3783
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: Error Executing Query 1017

Post 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.
User avatar
pdwalker
Posts: 1583
Joined: 18 Mar 2015 09:16

Re: Error Executing Query 1017

Post by pdwalker »

Did you resolve your problem?
Post Reply