Gossamer Forum
Home : General : Databases and SQL :

LSQL install causes crash MySQL v4.1.10

Quote Reply
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:
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...
Quote Reply
Re: [webmaster33] LSQL install causes crash MySQL v4.1.10 In reply to
Fixed the problem.

If MySQL v4.1 has
default-storage-engine=INNODB
set in my.ini, and has no enough space to create the innodb files (10-20 mb), then crash will happen.

MySQL v4.1 comes with
default-storage-engine=INNODB
enabled.


So be careful, when you don't have enough space with MySQL v4.1...

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