Re: [OPT-general] FW: OPT Error!

[Bogdan S. <mg...@fx...>]

Nah, that's not it. You had a problem with OPT parsing the e-mails, Tom 
has a problem with executing an SQL.

Tom, please use a terminal to get to /tmp/OPT (or wherever the temp OPT 
mail files are stored on your server). You are going to see a list of 
files such as OPT_incoming_mail0, OPT_incoming_mail_1 etc. (probably 
five files in total). These are the original e-mails in raw format. If 
you also get ~OPT_incoming_mail# then mail no. # has already been 
parsed. If you also get !OPT_incoming_mail# then mail no. # has errors 
and WILL NOT BE PARSED BY OPT AGAIN (this is what Shridhar is talking 
about). What you should do is look into those files, see which one is 
the one causing problems (the one containing "Greg, Mike, and Kyle, on 
Friday I talked with Dave" etc) and create a file with the same name but 
with a preceding exclamation mark. Then check OPT to see if you get that 
error any more. Please don't delete the original file - we are going to 
need it for debugging!

Bogdan

Shridhar Daithankar wrote:

>On 17 May 2002 at 8:02, Tom Arnold wrote:
>
>>So in effect, there is a "bad message" queued up that OPT seems to not be able
>>to parse and/or insert into the DB, with the result that it never gets past it
>>and never processes any other pending messages in the directory. Who knows, if
>>I delete that message maybe it will happen with the next one too.
>>
>
>I have seen such messages when I was playing with postfix config. I believe 
>such a message will tell you to delete two files corresponding to that mail. 
>That should solve the problem.
>
>May be you can take those two files, mutate them properly and post to list for 
>further investigation.
>
>Bye
> Shridhar
>
>--
>Creditor, n.:	A man who has a better memory than a debtor.
>
>