| Description | When installing LS 3.0.1 a sql error is thrown "SQLSTATE[HY000]: General error: 20018 Could not create constraint. See previous errors. [20018] (severity 16".
The offending statement in create-database.php is:
$oDB->createCommand()->createTable('{{groups}}', array(
'gid' => "autoincrement",
'sid' => "integer NOT NULL default '0'",
'group_name' => "string(100) NOT NULL default ''",
'group_order' => "integer NOT NULL default '0'",
'description' => "text",
'language' => "string(20) default 'en'",
'randomization_group' => "string(20) NOT NULL default ''",
'grelevance' => "text NULL",
'composite_pk' => array('gid', 'language')
which in my setup (mssql,dblib) translates to
CREATE TABLE [groups] (
[gid] integer NOT NULL IDENTITY (1,1),
[sid] int NOT NULL default '0',
[group_name] nvarchar(100) NOT NULL default '',
[group_order] int NOT NULL default '0',
[description] nvarchar(max) NULL,
[language] nvarchar(20) default 'en' NULL,
[randomization_group] nvarchar(20) NOT NULL default '',
[grelevance] nvarchar(max) NULL,
PRIMARY KEY ([gid], [language]).
You see the problem here, language may not be NULLable being part of the primary key. |
|---|
