Project

General

Profile

Actions
Copy link

Bug #16560

closed

Error during creation from table sys_refindex on oracle 10g database

Added by Sven Limbach about 18 years ago. Updated over 17 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Karsten Dambekalns
Category:
Install Tool
Target version:
-
Start date:
2006-09-13
Due date:
% Done:

0%

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

Description

During the creation of the table "sys_refindex" the following error occured:

ERROR: Query could not be parsed: "SQL engine parse ERROR: No ) parenthesis in list: near "(199)) ) "". Query: "CREATE TABLE sys_refindex ( hash varchar(32) NOT NULL default '', tablename varchar(40) NOT NULL default '', recuid int(11) NOT NULL default '0', field varchar(40) NOT NULL default '', flexpointer tinytext NOT NULL, softref_key varchar(30) NOT NULL default '', softref_id varchar(40) NOT NULL default '', sorting int(11) NOT NULL default '0', deleted int(11) NOT NULL default '0', ref_table varchar(40) NOT NULL default '', ref_uid int(11) NOT NULL default '0', ref_string varchar(200) NOT NULL default '', PRIMARY KEY (hash), KEY lookup_rec (tablename,recuid), KEY lookup_uid (ref_table,ref_uid), KEY lookup_string (ref_table,ref_string(199)) );"

ORACLE Database Version 10.1.0.4.2
(issue imported from #M4212)

Actions
Copy link

Also available in: Atom PDF