[Mimedefang] Re: sql integration of quarentine and others

[Jeff Rife]

On 16 Apr 2007 at 10:11, Danny Kjærgaard wrote:

> I got my sql integration working, but i have an odd error. I first do an md5
> hash of the body, and insert that into mysql, afterwards i insert the body
> and the header into mysql. The hash works every time. But the entiremail
> insertion, breaks every now and then, 1 out of 10 i think. I use a prepared
> statement with the placeholders, but since the md5hash works and the
> sqlinsertion dont, i might think that i have to escape something in the
> header or body. Does any one know what this might be?

What's the error message?  I got bit by not allocating a big enough 
field in the database to hold some of the things I was grabbing out of 
the e-mail.  That seems a lot more likely if you are trying to store 
the entire body.


--
Jeff Rife |  Sam: Hey, how's life treating you there, Norm? 
          |  
          | Norm: Beats me...then it kicks me and leaves me 
          |       for dead.