|
From: SourceForge.net <no...@so...> - 2009-05-20 07:41:12
|
Bugs item #2794247, was opened at 2009-05-20 01:41 Message generated for change (Tracker Item Submitted) made by wvolz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2794247&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Database Group: v 2.3 Status: Open Resolution: None Priority: 5 Private: No Submitted By: wizard (wvolz) Assigned to: Nobody/Anonymous (nobody) Summary: New accounts are not shown when welcome email is not sent Initial Comment: The database query used when "vacation_control_admin" and "used_quotas" are enabled will not show a new user if the admin unchecks the send welcome email option. In particular the issue is that "quota/storage" doesn't exist. Query for reference: $query = "SELECT $table_mailbox.*, $table_vacation.active AS v_active, $table_quota.current FROM $table_mailbox LEFT JOIN $table_vacation ON $table_mailbox.username=$table_vacation.email LEFT JOIN $table_quota ON $table_mailbox.username=$table_quota.username WHERE $table_mailbox.domain ='$fDomain' AND $table_quota.path='quota/storage' ORDER BY $table_mailbox.username LIMIT $page_size OFFSET $fDisplay"; ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2794247&group_id=191583 |
