#15587SQL-Error while updating to 4beta2 (create table sys_refindex)
Description
Install Tool can´t create Table sys_refindex while updating in 4beta2 caused by an SQL Error:
CREATE TABLE sys_refindex (
hash varchar(32) default ‘’,
tablename varchar(40) default ‘’,
recuid int(11) default ‘0’,
field varchar(40) default ‘’,
flexpointer tinytext,
softref_key varchar(30) default ‘’,
softref_id varchar(40) default ‘’,
sorting int(11) default ‘0’,
ref_table varchar(40) default ‘’,
ref_uid int(11) default ‘0’,
ref_string varchar(40) default ‘’,
PRIMARY KEY (hash),
KEY lookup_rec (tablename,recuid),
KEY lookup_uid (ref_table,ref_uid),
KEY lookup_string (ref_table,ref_string)
);
mySQL Version 3.23.52
- - All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
(issue imported from #M2511)
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.