[Dovecot] Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause'

Hi List, I have a problem with dovecot 2.2.12 and sieve-filter call: su -c 'sieve-filter -D -v -W -C -u acco...@domain.tld /var/vmail/domain.tld/account/.sieve INBOX.Refilter' vmail gives me sieve-filter(vmail): Error: user acco...@domain.tld: Auth USER lookup failed sieve-filter(vmail): Fatal:

Re: [Dovecot] Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause'

I would add some informations: auth lookup works fine with doveadm: $ doveadm auth lookup acco...@domain.tld passdb: acco...@domain.tld user : acco...@domain.tld Any Ideas? Thomas Am 17.02.2014 16:31, schrieb Thomas Creutz: > Hi List, > > I have a problem with dovecot 2.2.12

Re: [Dovecot] Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause'

r, '/.sieve') as sieve FROM mail_user WHERE (login = '%u' OR email = '%u') AND disable%Ls = 'n' iterate_query = SELECT email as user FROM mail_user - >From where comes the disablesieve-filter? Thomas Am 18.02.2014 11:10, schrieb Michael Cramer: &

Re: [Dovecot] Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause'

the - is a error for its own. http://stackoverflow.com/questions/885497/hyphens-in-column-names-in-mysql-db Thomas Am 20.02.2014 15:04, schrieb Thomas Creutz: > Ok, today I did the debug test: > > Feb 20 14:57:59 mail1 dovecot: auth: Debug: master in: > USER#0111#011acco...@domain.

Re: [Dovecot] Warning: mysql: Query failed, retrying: Unknown column 'filter' in 'where clause'

your database you need to set this in 'AND > `disable%Ls` ' to allow a column name with the minus sign. > > Zitat von Thomas Creutz : > >> Ok, today I did the debug test: >> >> Feb 20 14:57:59 mail1 dovecot: auth: Debug: master in: >> USER#0111#011acco..