Project

General

Profile

Actions
Copy link

Bug #15366

closed

Error installing static_info-tables

Added by Frank Benkart over 18 years ago. Updated almost 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Xavier Perseguers
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2006-01-05
Due date:
% Done:

0%

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

Description

When installing static_info_table i get to following message in the extension manager:

ERROR: Query could not be parsed: "SQL engine parse ERROR: Field type unknown in parseFieldDef()!: near "uid (uid) ) "". Query: "CREATE TABLE static_countries ( uid int(11) unsigned NOT NULL auto_increment, pid int(11) unsigned NOT NULL default '0', cn_iso_2 char(2) NOT NULL default '', cn_iso_3 char(3) NOT NULL default '', cn_iso_nr int(11) unsigned NOT NULL default '0', cn_official_name_local varchar(45) NOT NULL default '', cn_official_name_en varchar(45) NOT NULL default '', cn_capital varchar(45) NOT NULL default '', cn_tldomain char(2) NOT NULL default '', cn_currency_iso_3 char(3) NOT NULL default '', cn_currency_iso_nr int(10) unsigned NOT NULL default '0', cn_phone int(10) unsigned NOT NULL default '0', cn_eu_member tinyint(3) unsigned NOT NULL default '0', cn_address_format tinyint(3) unsigned NOT NULL default '0', cn_zone_flag tinyint(4) NOT NULL default '0', cn_short_local varchar(45) NOT NULL default '', cn_short_en varchar(45) NOT NULL default '', cn_short_dk varchar(45) NOT NULL default '', cn_short_de varchar(45) NOT NULL default '', PRIMARY KEY (uid), UNIQUE uid (uid) );"

(issue imported from #M2186)

Files

Download all files
2186_core.diff (1.79 KB) 2186_core.diff Administrator Admin, 2010-05-01 23:02
2186_dbal.diff (1.29 KB) 2186_dbal.diff Administrator Admin, 2010-05-01 23:03
Actions
Copy link
 #1

Updated by Frank Benkart over 18 years ago

This error occures at any extension installation.

Actions
Copy link
 #2

Updated by Karsten Dambekalns over 18 years ago

Not at any installation, but only when using UNIQUE and/or named keys - I have to check this.

Actions
Copy link
 #3

Updated by Xavier Perseguers almost 14 years ago

Problem comes again when performing a fresh TYPO3 4.4 (pre-beta2) install using the recent integration of DBAL in 1-2-3 installer.

When using Oracle (at least), the third step that imports the whole database automatically crashes after having successfully created tables with

ERROR: Query could not be parsed: "SQL engine parse ERROR: Field type unknown in parseFieldDef()!: near "uid (uid) "". Query: "ALTER TABLE static_territories ADD UNIQUE uid (uid);"

Actions
Copy link
 #4

Updated by Xavier Perseguers almost 14 years ago

Committed _core:
- TYPO3 trunk (rev. 7499)
- TYPO3 4-3 (rev. 7500)

Committed _dbal:
- DBAL trunk (rev. 32844)
- DBAL_1-1 (rev. 32845)
- DBAL_1-0 (rev. 32846)

Actions
Copy link

Also available in: Atom PDF