[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