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