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
|