[Typo3] lz-gallery error creating table in db
Rob De Vries
spam_this at pandora.be
Fri Feb 4 16:07:15 CET 2005
Heya listers,
When i like to install the lz-gallery ext. all seems to go ok.
But i'm not able to create a gallery.
When i go look in the db, the tx_lzgallery_galleries table seems to be
missing.
When i try to create this table in phpmyadmin, i get the following error:
#1067 - Invalid default value for 'uid'
this is the sql:
CREATE TABLE tx_lzgallery_galleries(
uid int( 11 ) unsigned DEFAULT '0' NOT NULL AUTO_INCREMENT ,
pid int( 11 ) unsigned 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 ,
deleted tinyint( 4 ) unsigned DEFAULT '0' NOT NULL ,
sorting int( 10 ) 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 ,
title varchar( 255 ) DEFAULT '' NOT NULL ,
descr_short varchar( 255 ) DEFAULT '' NOT NULL ,
descr_long text NOT NULL ,
startdate int( 11 ) DEFAULT '0' NOT NULL ,
enddate int( 11 ) DEFAULT '0' NOT NULL ,
location varchar( 255 ) DEFAULT '' NOT NULL ,
fe_user blob NOT NULL ,
fe_group_owner int( 11 ) unsigned DEFAULT '0' NOT NULL ,
path varchar( 255 ) DEFAULT '' NOT NULL ,
preview blob NOT NULL ,
subgalleries blob NOT NULL ,
setup blob NOT NULL ,
PRIMARY KEY ( uid ) ,
KEY parent( pid )
) TYPE = MYISAM
Any idea what this could cause?
tnx
Rob
More information about the TYPO3-english
mailing list