Re: [Postfixadmin-devel] postfixadmin-devel@lists.sourceforge.net

[MailingLists <mai...@st...>]

Christian Boltz wrote:
> Hello,
>
> Am Sonntag, 20. Juli 2008 schrieb MailingLists:
>   
>> I sometimes get errors in my mail.log as follows:
>>
>> Jul 20 16:36:12 stoned-hacker amavis[14077]: (14077-07)
>> lookup_sql_field(id) (WARN: no such field in the SQL table),
>> "mai...@st..." result=undef
>>     
>
>   
>> root@stoned-hacker:/var/log# cat /etc/amavis/conf.d/50-user
>>     
> ...
>   
>> $sql_select_policy = 'SELECT domain FROM domain WHERE
>> CONCAT("@",domain) IN (%k)';
>>     
>
> I'm not sure if this is really the cause of the problem. Anyway, you can 
> try    SELECT domain, 1 as id FROM domain WHERE ...
>
> If this doesn't help, grep your whole amavis config for "id".
>
>
> Regards,
>
> Christian Boltz
>   
Well I tried that syntax and I still get the errors :-[

I have ran a grep "id" mail.log for the full errors with debuy log level
turned on in amavis, you may see this log here:

http://stoned-hacker.co.uk/log.txt

Any ideas ?

Thanks for the prompt reply.


Dusty.