[TYPO3-UG Frankfurt] SQL-Error bei Installation von Extension a21glossary

[Marianne Hansen]

Hallo,

ich brauche dringend Hilfe bei der Installation der a21glossary.
Folgendes Phänomen:
Möchte ich die heruntergeladene, aktuelle Version installieren bekomme 
ich den Fehler:

ERROR: Query could not be parsed: "SQL engine parse ERROR: Field type 
unknown in parseFieldDef()!: near "I8 NOTNULL NOQUOTE, pid I8 NOTNULL 
default '0' NOQ"". Query: "CREATE TABLE tx_a21glossary_main ( uid I8 
NOTNULL NOQUOTE, pid I8 NOTNULL default '0' NOQUOTE, tstamp I8 unsigned 
NOTNULL default '0' NOQUOTE, crdate I8 unsigned NOTNULL default '0' 
NOQUOTE, cruser_id I8 unsigned NOTNULL default '0' NOQUOTE, t3ver_oid I8 
unsigned NOTNULL default '0' NOQUOTE, t3ver_id I8 unsigned NOTNULL 
default '0' NOQUOTE, t3ver_label C 60 NOTNULL default "''" NOQUOTE, 
sys_language_uid I8 NOTNULL default '0' NOQUOTE, l18n_parent I8 NOTNULL 
default '0' NOQUOTE, l18n_diffsource B NOTNULL DEFAULT "''" NOQUOTE, 
deleted I8 unsigned NOTNULL default '0' NOQUOTE, hidden I8 unsigned 
NOTNULL default '0' NOQUOTE, starttime I8 unsigned NOTNULL default '0' 
NOQUOTE, endtime I8 unsigned NOTNULL default '0' NOQUOTE, fe_group I8 
NOTNULL default '0' NOQUOTE, short XL NOTNULL DEFAULT "''" NOQUOTE, 
shortcut XL NOTNULL DEFAULT "''" NOQUOTE, longversion XL NOTNULL DEFAULT 
"''" NOQUOTE, shorttype XL NOTNULL DEFAULT "''" NOQUOTE, language C 4 
NOTNULL default "''" NOQUOTE, description XL NOTNULL DEFAULT "''" 
NOQUOTE, link XL NOTNULL DEFAULT "''" NOQUOTE, exclude I8 NOTNULL 
default '0' NOQUOTE, PRIMARY KEY (uid), KEY parent (pid) );"

Mich macht schon stutzig, dass im Backend als Befehl folgendes angezeigt 
wird:
> CREATE TABLE tx_a21glossary_main (
> uid I8 NOTNULL NOQUOTE,
> pid I8 NOTNULL default '0' NOQUOTE,
> tstamp I8 unsigned NOTNULL default '0' NOQUOTE,
> crdate I8 unsigned NOTNULL default '0' NOQUOTE,
> cruser_id I8 unsigned NOTNULL default '0' NOQUOTE,
> t3ver_oid I8 unsigned NOTNULL default '0' NOQUOTE,
> t3ver_id I8 unsigned NOTNULL default '0' NOQUOTE,
> t3ver_label C 60 NOTNULL default "''" NOQUOTE,
> sys_language_uid I8 NOTNULL default '0' NOQUOTE,
> l18n_parent I8 NOTNULL default '0' NOQUOTE,
> l18n_diffsource B NOTNULL DEFAULT "''" NOQUOTE,
> deleted I8 unsigned NOTNULL default '0' NOQUOTE,
> hidden I8 unsigned NOTNULL default '0' NOQUOTE,
> starttime I8 unsigned NOTNULL default '0' NOQUOTE,
> endtime I8 unsigned NOTNULL default '0' NOQUOTE,
> fe_group I8 NOTNULL default '0' NOQUOTE,
> short XL NOTNULL DEFAULT "''" NOQUOTE,
> shortcut XL NOTNULL DEFAULT "''" NOQUOTE,
> longversion XL NOTNULL DEFAULT "''" NOQUOTE,
> shorttype XL NOTNULL DEFAULT "''" NOQUOTE,
> language C 4 NOTNULL default "''" NOQUOTE,
> description XL NOTNULL DEFAULT "''" NOQUOTE,
> link XL NOTNULL DEFAULT "''" NOQUOTE,
> exclude I8 NOTNULL default '0' NOQUOTE,
> PRIMARY KEY (uid),
> KEY parent (pid)
> );
Das kann ja nicht funktionieren. In der ext_tables.sql steht auch etwas 
ganz anderes. Nämlich
> #
> # Table structure for table 'tx_a21glossary_main'
> #
> CREATE TABLE tx_a21glossary_main (
>     uid int(11)  NOT NULL auto_increment,
>     pid int(11) DEFAULT '0' NOT NULL,
>     tstamp int(11) unsigned DEFAULT '0' NOT NULL,
>     crdate int(11) unsigned DEFAULT '0' NOT NULL,
>     cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
>     t3ver_oid int(11) unsigned DEFAULT '0' NOT NULL,
>     t3ver_id int(11) unsigned DEFAULT '0' NOT NULL,
>     t3ver_label varchar(30) DEFAULT '' NOT NULL,
>     sys_language_uid int(11) DEFAULT '0' NOT NULL,
>     l18n_parent int(11) DEFAULT '0' NOT NULL,
>     l18n_diffsource mediumblob NOT NULL,
>     deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
>     hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
>     starttime int(11) unsigned DEFAULT '0' NOT NULL,
>     endtime int(11) unsigned DEFAULT '0' NOT NULL,
>     fe_group int(11) DEFAULT '0' NOT NULL,
>     short tinytext NOT NULL,
>     shortcut tinytext NOT NULL,
>     longversion tinytext NOT NULL,
>     shorttype tinytext NOT NULL,
>     language char(2) DEFAULT '' NOT NULL,
>     description text NOT NULL,
>     link tinytext NOT NULL,
>     exclude tinyint(3) DEFAULT '0' NOT NULL,
>
>     PRIMARY KEY (uid),
>     KEY parent (pid)
> );

Mein TYPO3 ist ein 4.5.3, mein a21glossary ein 0.4.11 und der 
MYSQL-Server hat die Version 5.1.49-3.

Kann mir jemand helfen, da ich das gleiche Problem auch mit einer 
zweiten Extension    habe.
Vielen Dank
Viele Grüße
Marianne




---
avast! Antivirus: Ausgehende Nachricht sauber.
Virus-Datenbank (VPS): 110707-1, 07.07.2011
Getestet um: 08.07.2011 10:23:04
avast! - copyright (c) 1988-2011 AVAST Software.
http://www.avast.com