Re: process-quarantine-sub.pl fatal error

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


On Mar 27, 2007, at 7:19 PM, Gary Casterline wrote:

> Hello,
>
> I've moved our maia installation to a new server and
> have most things working. 
/var/amavisd/maia/scripts/configtest.pl
> runs without error, however, when I run
process-quarantine.pl
> I get these errors:
>
> DBD::mysql::st execute failed: 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 '4.75' at
> line 1 at
/var/amavisd/maia/scripts/process-quarantine-sub.pl line  
> 529.

It would appear that you have an invalid limit... it's
trying to do  
this query:

521                        "SELECT maia_mail.id, "
.
522 	                     "maia_mail.contents, "
.
523 	                     "maia_mail.subject " .
524 	              "FROM maia_mail,
maia_mail_recipients " .
525 	              "WHERE maia_mail.id =
maia_mail_recipients.mail_id  
" .
526 	              "AND maia_mail_recipients.type = 'C'
LIMIT " .  
$limit;

So I'm guessing somehow it's getting a 4.75 as a limit. 
Check your  
maia.conf file.  (Should be an integer)


David Morton
Maia Mailguard http://www.maiamailguard
.com
mortondadgrmm.net



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (Darwin)

iD8DBQFGCf05Uy30ODPkzl0RAtlHAJwNXyFgcdXfLz0ZEt5NivPk2YYiHwCg
swhR
OVrhX7f25XiTYjTQaD97Bic=
=t0mL
-----END PGP SIGNATURE-----
_______________________________________________
Maia-users mailing list
Maia-usersrenaissoft.com
http://www.renaissoft.com/mailman/listinfo/maia-users