Glenn, > I have about 2000 emails in queue, all saying: > (host 127.0.0.1[127.0.0.1] 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. Mark ------------------------------------------------------------------------- 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 http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
