Add column disableindexer-worker in mail_user
Hi!
Adding dovecot_solr currently throws errors because of a missing column. Found the solution here: http://www.marshut.com/irvyzz/fts-solr-body-search-gives-mysql-error.html#iryuzw
Add the column disableindexer-worker
enum('n','y') default 'n' in the table "mail_user".
Edit dovecot-sql.conf (add backticks around "disable%Ls"):
user_query = SELECT email as user, maildir as home, CONCAT('maildir:', maildir, '/Maildir') as mail, uid, gid, CONCAT('*:storage=', quota, 'B') AS quota_rule, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE (login = '%u' OR email = '%u') AND disable%Ls
= 'n'
Also see http://www.howtoforge.com/forums/showthread.php?t=65463