[Typo3-debian] problem with sql installation

[Tokeiito]

i use mysql 4.1.7 +  Client API version 4.1.8 + PHP5.

Michael Ott wrote:

>Hello Tokeiito!
>  
>
>>#
>>#
>># At the end of this file the static data will be inserted and an admin user
>>will be created.
>>#
>># Table definitions:
>>#
>>#
>>CREATE TABLE be_groups(
>>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 ,
>>title varchar( 20 ) DEFAULT '' NOT NULL ,
>>non_exclude_fields blob NOT NULL ,
>>db_mountpoints varchar( 40 ) DEFAULT '' NOT NULL ,
>>pagetypes_select tinyblob NOT NULL ,
>>tables_select blob NOT NULL ,
>>tables_modify blob NOT NULL ,
>>crdate int( 11 ) unsigned DEFAULT '0' NOT NULL ,
>>cruser_id int( 11 ) unsigned DEFAULT '0' NOT NULL ,
>>groupMods tinyblob NOT NULL ,
>>file_mountpoints varchar( 40 ) DEFAULT '' NOT NULL ,
>>hidden tinyint( 3 ) unsigned DEFAULT '0' NOT NULL ,
>>inc_access_lists tinyint( 3 ) unsigned DEFAULT '0' NOT NULL ,
>>description text NOT NULL ,
>>lockToDomain varchar( 50 ) DEFAULT '' NOT NULL ,
>>deleted tinyint( 3 ) unsigned DEFAULT '0' NOT NULL ,
>>TSconfig blob NOT NULL ,
>>subgroup tinyblob NOT NULL ,
>>hide_in_lists tinyint( 4 ) DEFAULT '0' NOT NULL ,
>>PRIMARY KEY ( uid ) ,
>>KEY parent( pid )
>>) TYPE = MYISAM
>>MMyySSQQLL ssaaiidd::
>>#1067 - Invalid default value for 'uid'
>>
>>how to fix it?
>>    
>>
>Which MySQL-Version do you use?
>
>CU        
>         
>  Michael  
>          
>--                                                       
>           Michael Ott, e-mail: michael at zolnott.de, www.zolnott.de           
>I am registered as user #275453 with the Linux Counter, http://counter.li.org.
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>Typo3-debian mailing list
>Typo3-debian at lists.netfielders.de
>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-debian
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.netfielders.de/pipermail/typo3-debian/attachments/20050117/762ba708/attachment.html