Bug #15587

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

Added by Harald Klotzberg over 9 years ago. Updated almost 9 years ago.

Status:Closed Start date:2006-02-07
Priority:Should have Due date:
Assigned To:Ingmar Schlecht % Done:

0%
Category:Install Tool Spent time: -
Target version:-
TYPO3 Version:4.0 Is Regression:
PHP Version:4 Sprint Focus:
Complexity:

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

#1171 - All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
(issue imported from #M2511)

Related issues

related to Core - Bug #15725: DB Check -> Manage Reference Table doesn't check if table... Closed 2006-02-27
duplicates Core - Bug #15772: "NOT NULL" removed from SQL gives error with MySQL 3.23.52 Closed 2006-03-06

History

#1 Updated by Harald Klotzberg over 9 years ago

4beta1 has NOT NULL behind each statement and this of course works:

CREATE TABLE sys_refindex(
hash varchar( 32 ) DEFAULT '' NOT NULL ,
tablename varchar( 40 ) DEFAULT '' NOT NULL ,
recuid int( 11 ) DEFAULT '0' NOT NULL ,
field varchar( 40 ) DEFAULT '' NOT NULL ,
flexpointer tinytext NOT NULL ,
softref_key varchar( 30 ) DEFAULT '' NOT NULL ,
softref_id varchar( 40 ) DEFAULT '' NOT NULL ,
sorting int( 11 ) DEFAULT '0' NOT NULL ,
ref_table varchar( 40 ) DEFAULT '' NOT NULL ,
ref_uid int( 11 ) DEFAULT '0' NOT NULL ,
ref_string varchar( 40 ) DEFAULT '' NOT NULL ,
PRIMARY KEY ( hash ) ,
KEY lookup_rec( tablename, recuid ) ,
KEY lookup_uid( ref_table, ref_uid ) ,
KEY lookup_string( ref_table, ref_string )
)

#2 Updated by Sebastian Kurfuerst over 9 years ago

Hi,
I think this was broken by one of your patches. Could you have a look?
Thanks for your great work,
Sebastian

#3 Updated by Ingmar Schlecht over 9 years ago

Steffen Sach hat auf der deutschen mailingliste geschrieben:

wenn ich unter Typo3 RC2 eine neue Seite anlegen möchte, dann erhalte ich
folgenden Error:
2: SQL error: 'Column 'TSconfig' cannot be null' (pages:NEW442902c1e9316)

Jemand ne Ahnung, woran das liegen könnte? Hab ich etwas vergessen
einzustellen?

Und kurz darauf:

Wenn ich die Extension "dbal" entferne, kommt der Error nicht mehr.

cheers
Ingmar

Also available in: Atom PDF