Re: [AMaViS-user] 8 bind variables when 9 are needed?

Glenn,

> > May 18 19:30:25 caduceus amavis[9024]: (09024-01) (!) WARN
> > save_info_final: sql execute failed within transaction, err=-1, S1000,
> > DBD::mysql::st execute failed: called with 8 bind variables when 9 are
> > needed at (eval 53) line 138, <GEN6> line 374. at (eval 53) line 153,
> > <GEN6> line 374.
>
> This looks like it:

Actually, line 153 within package Amavis::Out::SQL::Log is:

# insert recipient record
$conn_h->execute($ins_rcp,
$mail_id, untaint($rid),
# $msginfo->rx_time,
substr($d,0,1), ' ',
$r->recip_blacklisted_sender ? 'Y' : 'N',
$r->recip_whitelisted_sender ? 'Y' : 'N',
!defined($spam_level) ? undef :
untaint($spam_level + $r->recip_score_boost),
untaint($resp) );

refering to:

'ins_rcp' =>
'INSERT INTO msgrcpt (mail_id, rid, time_num,'.
' ds, rs, bl, wl, bspam_level, smtp_resp) VALUES (?,?,?,?,?,?,?,?,?)',

but your 'ins_rcp' contains time_num which only showed in some of
the pre-releases:

'ins_msg' =>
'INSERT INTO msgs (mail_id, secret_id, am_id, time_num, time_iso, sid,'.
' policy, client_addr, size, host) VALUES (?,?,?,?,?,?,?,?,?,?)',


amavisd-new-2.4.0 release notes:
(compatibility note with pre-releases of 2.4.0: there were added fields
msgrcpt.time_num and quarantine.time_num in pre-release versions of 2.4.0,
which are now dropped in favor of FOREIGN KEY constraint; these fields
are no longer set by the program and should not be relied-on when purging
records, they may be removed from tables);


Mark





-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=...057&dat=121642
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/