[Typo3] lz-gallery error creating table in db

[Allan Jacobsen]

Most likely you have the same problem as several others, and it has been 
described(with solution) many times: you are using mysql version 4.1.
Delete the "default '0'" part of the uid definition, than it will work.

Best regards
Allan Jacobsen
On Friday 04 February 2005 16:07, Rob De Vries wrote:
> 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
> _______________________________________________
> Typo3-english mailing list
> Typo3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>