[Phpgroupware-tracker] [Bug #1668] Failed to Create MySQL Database Tables

[nobody]

=================== BUG #1668: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1668&group_id=509

Submitted by: None                      Project: phpGroupWare                   
Submitted on: 2002-Nov-09 16:00
Category:  API - Setup                  Bug Group:  0.9.14 release              
Severity:  5 - Major                    Priority:  None                         
Resolution:  None                       Assigned to:  None                      
Status:  Open                           Component Version:  BZIP2               
Platform Version:  BSD                  Reproducibility:  Every Time            

Summary:  Failed to Create MySQL Database Tables

Original Submission:  Hi,

after i setup phpgroupware i get the follwing errors. it seems that the setup 
script did not create all tables.

anybody an idea how to fix that. is there the possibility to create the missing 
tables without script. or is there a sql script??

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




No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1668&group_id=509