[Phpgroupware-tracker] [ 100365 ] New installation

[nobody]

Support Request #100365, was updated on 2002-Jan-29 18:23
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=100365&group_id=509

Category: Bug Report
Status: Open
Priority: 5
Summary: New installation 

By: ziofab
Date: 2002-Jan-29 18:23

Message:
Logged In: YES 
user_id=4873
Browser: Opera/6.0 (Linux 2.2.19pre17 i686; U)  [en]

Debian GNU/Linux 2.2
MySQL 3.22.32
-----
Errors in creation tables.


----------------------------

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))


mysql>  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));
ERROR 1071: Specified key was too long. Max key 
length is 256

NOT USE 'message_id' in KEY or ...

mysql>  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(app_name,lang));
Query OK, 0 rows affected (0.00 sec)

------------------------

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 
(1,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 
(2,0,0,'1970-01-01',NULL,NULL,'Directory','Y',NULL,NULL,'/','home', 
NULL, NULL)



mysql> 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');
ERROR 1146: Table 
'phpgroupware_fs.phpgw_interserv' doesn't exist
mysql> 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 
(1,0,0,'1970-01-01',NULL,NULL,'Directory','Y',NULL,NULL,'/','', 
NULL, NULL);
ERROR 1146: Table 'phpgroupware_fs.phpgw_vfs' 
doesn't exist

No comment
------------------------


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