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

Mark Martinec said the following on 5/18/2006 9:00 PM:
> Actually, line 153 within package Amavis::Out::SQL::Log is:
> (much snippage of helpful stuff)

Thanks for your help, Mark.. so if I read this correctly, I have to
change ins_rcp and ins_msg to be:

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

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

Or am I not getting what you're saying here?

(Edit: Nope, now the error is "10 bind variables when 9 are needed at
line 153.. *headdesk*.. so obviously I'm missing something obvious here.
*sigh* Sorry to be clueless on this. I'm great at things like automation
and such, but there are days that SQL just reads like 60's stereo
instructions to me.. :( )

On an aside, trying to add the FOREIGN KEY constraint makes my mysql
server decide to freeze up. I'm looking into that...

Best,
--Glenn
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
~Benjamin Franklin, Historical Review of Pennsylvania, 1759


-------------------------------------------------------
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/