Gossamer Forum
Home : Products : Gossamer Mail : Discussion :

2.0.2 install bug?

Quote Reply
2.0.2 install bug?
when I install GM 2.0.2 in my Windows 2000 PC for a test, I found a problem.
During create database tables, it failed:

Creating users table .. failed (Failed to execute query: '
CREATE TABLE users (
userid INT unsigned NOT NULL AUTO_INCREMENT,
user CHAR(255) NOT NULL DEFAULT '',
password CHAR(16) BINARY NOT NULL DEFAULT '',
users_status ENUM('Not Validated','Validated','Suspended') DEFAULT 'Validated' NOT NULL,
users_last_login INT DEFAULT '',
users_space_used FLOAT(12,2) DEFAULT '0.00' NOT NULL,
users_space_allowed FLOAT(12,2) DEFAULT '0.00' NOT NULL,
users_max_pop INT DEFAULT '5' NOT NULL,
users_pass_phrase VARCHAR(255),
users_pass_answer VARCHAR(255),
users_join_time INT DEFAULT '0' NOT NULL,
users_default_template CHAR(255) DEFAULT 'default',
INDEX users_pass_ndx (ARRAY(0x1f89514)),
UNIQUE userunique (user),
PRIMARY KEY (userid)
)
' Reason: You have an error in your SQL syntax near '0x1f89514)),
UNIQUE userunique (user),
PRIMARY KEY (userid)
' at line 15)


Below is my solution:

change line 242 of file admin/GMail/Admin/Setup.pm
$c->index( users_pass_ndx => ['password'] );
to:
$c->index( { users_pass_ndx => ['password'], });

It seems OK now.


Alex, is it a bug? is my solution right?

Quote Reply
Re: 2.0.2 install bug? In reply to
Hi,

This is a bug, I've updated out copy and will put it up on the server tonight.

Cheers,

Scott