Project

General

Profile

Actions
Copy link

Bug #15587

closed

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

Added by Harald Klotzberg almost 19 years ago. Updated over 18 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Ingmar Schlecht
Category:
Install Tool
Target version:
-
Start date:
2006-02-07
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.0
PHP Version:
4
Tags:
Complexity:
Is Regression:
Sprint Focus:

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 2 (0 open — 2 closed)

Related to TYPO3 Core - Bug #15725: DB Check -> Manage Reference Table doesn't check if table 'sys_refindex' existsClosed2006-02-27

Actions
Is duplicate of TYPO3 Core - Bug #15772: "NOT NULL" removed from SQL gives error with MySQL 3.23.52ClosedMichael Stucki2006-03-06

Actions
Actions
Copy link

Also available in: Atom PDF