Bug #16560
closed
Error during creation from table sys_refindex on oracle 10g database
0%
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)
Updated by Michael Stucki almost 18 years ago
HI Karsten,
I believe that the dbal extension cannot deal with this patch I've made recently:
http://lists.netfielders.de/pipermail/typo3-team-core/2006-August/005434.html
For the reporter: The quick fix is to revert this change.
Updated by Michael Stucki over 17 years ago
I'm 99% sure that this is fixed in TYPO3 4.0.3. Otherwise, please reopen.
Updated by Karsten Dambekalns over 17 years ago
Yes, the length specification is gone from the sql file, so this must work again.