> I have about 2000 emails in queue, all saying:
>   (host[] said: 451 4.5.0 Error in processing,
>   id=37705-01-2, sql-enter FAILED: sql exec: err=16, S1000, DBD::mysql::st
>   bind_param failed: Illegal parameter number at (eval 99) line 164,
>   <GEN18> line 24.)
> I've gone through the mysql tweaks that RELEASE_NOTES said.. :-/
> Running: Amavisd-New 2.6.1,1 on FreeBSD 7.0 with Postfix 2.5.1_2,1

Looks like the 'ins_msg' entry in %sql_clause (probably in a config file)
does not match the version of amavisd.

amavisd-new-2.6.0 introduced a new field 'partition_tag' into tables
maddr, msgs, msgrcpt and quarantine. This required a change at three
places: altering SQL tables themselves, adding an extra parameter
in SQL clauses (stored in %sql_clause), and providing an actual
extra parameter in the code (a call to bind_param from amavisd).

Seems to me you had an explicit setting of %sql_clause in your
config file, overriding a built-in default. Now that the default
has changed, you need also change your manual override.


This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
AMaViS-user mailing list

Reply via email to