LSQL install causes crash MySQL v4.1.10
LSQL v2.2.1 and 2.99beta install is causing MySQL v4.1.10 crash under Windows XP.
As I remember I had no such problem, when I used MySQL v3.23.
I tried to track down the problem, and it seems the following SQL statement is causing the problem:
Username CHAR(50) NOT NULL,
Password CHAR(25) BINARY NOT NULL,
Email CHAR(75) NOT NULL,
Name CHAR(75),
Validation CHAR(20),
Status ENUM('Not Validated','Registered','Administrator') DEFAULT 'Registered' NOT NULL,
ReceiveMail ENUM('No','Yes') DEFAULT 'Yes' NOT NULL,
Newsletter ENUM('No','Yes') DEFAULT 'Yes' NOT NULL,
PRIMARY KEY (Username)
);
Best regards,
Webmaster33
Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
As I remember I had no such problem, when I used MySQL v3.23.
I tried to track down the problem, and it seems the following SQL statement is causing the problem:
Code:
CREATE TABLE lsql_Users ( Username CHAR(50) NOT NULL,
Password CHAR(25) BINARY NOT NULL,
Email CHAR(75) NOT NULL,
Name CHAR(75),
Validation CHAR(20),
Status ENUM('Not Validated','Registered','Administrator') DEFAULT 'Registered' NOT NULL,
ReceiveMail ENUM('No','Yes') DEFAULT 'Yes' NOT NULL,
Newsletter ENUM('No','Yes') DEFAULT 'Yes' NOT NULL,
PRIMARY KEY (Username)
);
Best regards,
Webmaster33
Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...
LSQL install causes crash MySQL v4.1.10