first a BIG THX for the Project
I have a little problem,
after the Update to 3.1.0.3 from 3.1.0.1 the Users don´t become a Report
when i execute the /usr/local/bin/mailwatch/tools/Cron_jobs/quarantine_report.php
i become the error
Code: Select all
=== Generating report for XXXXX type=A
==== huflejt has empty e-mail recipient address, skipping...
=== Generating report for XXXXXxX@XXXX.XX type=U
==== Recipient e-mail address is XXXXXxX@XXXX.XX
==== Building list for XXXXXxX@XXXX.XX
<B>Error executing query: </B><BR><BR>1054: Unknown column 'isaspam' in 'where clause'<BR><BR><B>SQL:</B><BR><PRE>
SELECT DISTINCT
a.id AS id,
DATE_FORMAT(timestamp,'%d/%m/%y <br/>%H:%i:%s') AS datetime,
a.to_address AS to_address,
a.from_address AS from_address,
a.subject AS subject,
CASE
WHEN a.virusinfected>0 THEN 'Virus'
WHEN a.nameinfected>0 THEN 'Bad Content'
WHEN a.otherinfected>0 THEN 'Infected'
WHEN a.ishighspam>0 THEN 'Spam'
WHEN a.issaspam>0 THEN 'Spam'
WHEN a.isrblspam>0 THEN 'Spam'
WHEN a.spamblacklisted>0 THEN 'Blacklisted'
WHEN a.isspam THEN 'Spam'
WHEN a.ismcp>0 THEN 'Policy'
WHEN a.ishighmcp>0 THEN 'Policy'
WHEN a.issamcp>0 THEN 'Policy'
WHEN a.mcpblacklisted>0 THEN 'Policy'
WHEN a.isspam>0 THEN 'Spam'
ELSE 'UNKNOWN'
END AS reason
FROM
maillog a
WHERE
a.quarantined = 1
AND
((to_address='XXXXX@XXXXXXXX) OR (to_domain='XXXXX@XXXX.de'))
AND
a.date >= DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
AND
isspam>0
AND
(
virusinfected>0
OR
nameinfected>0
OR
otherinfected>0
OR
ishighspam>0
OR
isaspam>0
OR
isrblspam>0
OR
spamblacklisted>0
OR
isspam>0
OR
ismcp>0
OR
ishighmcp>0
OR
issamcp>0
OR
ismcpblacklisted>0
OR
isspam>0
)
ORDER BY a.date DESC, a.time DESC</PRE>[root@spam ~]#
Sorry for my bad English
Big thanx
Daniel