[Phpgroupware-tracker] [ 100691 ] Installation failes because of sql-stat.

[nobody]

Support Request #100691, was updated on 2002-Apr-03 09:41
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100691&group_id=509

Category: Bug Report
Status: Open
Priority: 5
Summary: Installation failes because of sql-stat.

By: phpgroupware
Date: 2002-Apr-03 09:41

Message:
Logged In: NO 
Browser: Mozilla/4.0 (compatible; MSIE 5.0; Linux) Opera 6.0  [en]

While running setup/index.php I got the following 
errors:
Database error: Invalid SQL: CREATE TABLE lang 
(message_id varchar(255) NOT NULL,
app_name varchar(100) NOT NULL DEFAULT 
'common',
lang varchar(5) NOT NULL,
content text,
PRIMARY KEY(message_id,app_name,lang))
Database error: Invalid SQL: INSERT INTO 
phpgw_interserv(server_name,server_host,server_url,trust_level,trust_rel,server_mode)
 
VALUES ('phpGW 
cvsdemo',NULL,'http://www.phpgroupware.org/cvsdemo/xmlrpc.php',99,0,'xmlrpc')
Database error: Invalid SQL: INSERT INTO phpgw_vfs 
(owner_id, createdby_id, modifiedby_id, created, 
modified, size, mime_type, deleteable, comment, app, 
directory, name, link_directory, link_name) VALUES 
(0,0,0,'1970-01- 
01',NULL,NULL,'Directory','Y',NULL,NULL,'/','', 
NULL, NULL)
Database error: Invalid SQL: INSERT INTO phpgw_vfs 
(owner_id, createdby_id, modifiedby_id, created, 
modified, size, mime_type, deleteable, comment, app, 
directory, name, link_directory, link_name) VALUES 
(0,0,0,'1970-01- 
01',NULL,NULL,'Directory','Y',NULL,NULL,'/','home', 
NULL, NULL)

I checked the statements:
the first statement e. g.  results with the following
error -> ERROR 1071: Specified key was too long. 
Max key length is 256

I'm running mysql  3.22.32, is this version too old?
Perhaps I didn't get it in the docs... :)

----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100691&group_id=509