Panic: lib-sql: Too many bind args

Joseph D Wagner joe at josephdwagner.info
Thu Aug 12 03:08:02 EEST 2021


On 8/11/21 2:48 PM, dovecot at ptld.com wrote:
>> On 08-11-2021 5:39 pm, Joseph D Wagner wrote:
>> dovecot[51153]: dict(51395): Panic: lib-sql: Too many bind args (2)
>> for statement: SELECT attr_name FROM attributes WHERE attr_name LIKE
>> AND username = ?
>
> No idea if this is the only problem, but the sql query has invalid 
> syntax.
>
>     SELECT attr_name FROM attributes WHERE attr_name LIKE  AND 
> username = ?
>
> Did you replace the "?" or is that the real query? That is invalid.
> And there is nothing after "LIKE", should at minimum have 'quotes'.
>
>     SELECT attr_name FROM attributes WHERE attr_name LIKE 'something%' 
> AND username = '?'
>
> Would be at least syntax valid.

Dovecot generated the syntax.

Maybe there's something wrong with my "map" configuration, which led to 
the improper syntax (see original email), but it's Dovecot that 
generated the syntax.

Joseph D. Wagner



More information about the dovecot mailing list