Issue Bug Closed

#15587SQL-Error while updating to 4beta2 (create table sys_refindex)

Harald Klotzberg 02/07/06, 08:12 updated 08/12/06, 14:16

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

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