Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#139 users are not shown when initial email is not sent

v_2.3
closed-fixed
nobody
Database (41)
9
2009-10-18
2009-05-20
wvolz
No

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";

Discussion

  • (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?

     
    • priority: 5 --> 9
    • summary: New accounts are not shown when welcome email is not sent --> table "quota" not created by upgrade.php
     
  • wvolz
    wvolz
    2009-09-11

    • summary: table "quota" not created by upgrade.php --> users are not shown when initial email is not sent
     
  • Fixed in SVN r730 - thanks for reporting this issue!

     
    • status: open --> closed-fixed