Re: [Postfixadmin-devel] Unable to display mailboxes.

[Christian B. <pos...@cb...>]

Hello,

Am Mittwoch, 29. April 2009 schrieb me...@td...:
> According to the notes in config.inc.php, pfa is supposed to "Show
> used quotas from Dovecot dictionary backend in virtual mailbox
> listing." This is what is not working as far as I can tell. It
> appears to me that this was added by this patch:
> https://sourceforge.net/tracker/index.php?func=detail&aid=2060309&gro
>up_id=191583&atid=937966

Exactly.
(And I have to admit that I don't use dovecot, so I didn't test this.)

> Invalid query: Unknown column 'quota.current' in 'field list'

> $query = "SELECT $table_mailbox.*, $table_vacation.active AS
> v_active, $table_quota.current FROM $table_mailbox [...]

If I get it right, the current quota usage is tracked in the "bytes" 
column.

You can probably fix the problem by modifying the SELECT query.
Replace
    $table_quota.current
with
    $table_quota.bytes as current
and it should work (untested).

> AND $table_quota.path='quota/storage' ORDER BY [...]

See David's comment for this section of the query.

Can you please send some example entries from your quota table? Without 
knowing what is in the table, it's hard to tell how the query should 
look like ;-)

> Should I file a bug in the tracker for this?

For now, just tell me if my fix in the SQL query works ;-)


Regards,

Christian Boltz
-- 
PS: Ich denke, wir unterhalten uns hier
lieber mit Menschen statt mit Mohnbroetchen...
[Thomas Hertweck zu fo_mohnbroetchen(AT)gmx.de in suse-linux]