On 10/07/07, Frank Church <voipfc@googlemail.com> wrote:
I think I got to the bottom of the problem, which probably is the result of too much dependency on howtos and not enough RTFMing. I have an empty blog named 'howtos considered harmful' , and this will provide a good article.
It appears that I changed my dovecot/sql.conf from one with a separate user_query and password_query to one with just the password_query in conjunction with the prefetch scheme, which did not include the quota setting. I will add " concat('dirsize:storage=', quota) AS userdb_quota " to the password_query to see if it will fix the problem.
Update:
After modifying the password_query to include concat('dirsize:storage=', quota) AS userdb_quota, moving mails between mailboxes works.
Another thing to note is that the quota snippet in the SQL requires a cast and should be concat('dirsize:storage=', cast(quota as char)) AS userdb_quota