|
From: SourceForge.net <no...@so...> - 2009-09-11 01:16:03
|
Bugs item #2794247, was opened at 2009-05-20 01:41 Message generated for change (Settings changed) 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: 9 Private: No Submitted By: wizard (wvolz) Assigned to: Nobody/Anonymous (nobody) >Summary: users are not shown when initial 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"; ---------------------------------------------------------------------- >Comment By: wizard (wvolz) Date: 2009-09-10 19:16 Message: The initial title was correct. If a email is not sent to a newly created account the user does not show up in postfixadmin even though they exist in the database. There is a thread on the mailing list where users are talking about this as well, see https://sourceforge.net/mailarchive/message.php?msg_name=alpine.LFD.2.00.0904270925190.4731%40tigger.tntechs.com. ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2009-08-24 17:14 Message: (original summary was: "New accounts are not shown when welcome email is not sent") The table "quota" is not created by upgrade.php - it's hidden in DOCUMENTS/DOVECOT.txt. Create database in mysql: create table quota ( username varchar(255) not null, path varchar(100) not null, current integer, primary key (username, path) ); IMHO this query should be changed/extended a bit to avoid the usual problems: CREATE TABLE {IF_NOT_EXISTS} `quota` ( `username` VARCHAR(255) {LATIN1} NOT NULL, `path` VARCHAR(100) {LATIN1} NOT NULL, `current` BIGINT(20), # allow quota > 2 GB PRIMARY KEY `username_path` (username, path) ) TYPE=MyISAM ; GingerDog, what's the query for postgresql? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937964&aid=2794247&group_id=191583 |
