phpgroupware-tracker
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: nobody
Subject: [Phpgroupware-tracker] [Bug #1668] Failed to Create MySQL Database Tables
Date: Sat, 09 Nov 2002 16:59:52 -0500

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

Changes by: Anonymous user        Date: 2002-Nov-09 16:59

------------------ Additional Follow-up Comments ----------------------------
ok, thank you for your help. now i´ve to ask my provider for update :-)

Kai




=================== BUG #1668: FULL BUG SNAPSHOT ===================


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


Follow-up Comments
*******************

-------------------------------------------------------
Date: 2002-Nov-09 16:59             By: None
ok, thank you for your help. now i´ve to ask my provider for update :-)

Kai


-------------------------------------------------------
Date: 2002-Nov-09 16:56             By: None
Unfortunately iirc you need 3.23.xx

Sorry

Dave Hall aka skwashd

-------------------------------------------------------
Date: 2002-Nov-09 16:51             By: None
Hi,

i´ve tried it, but the same result. i´m searching with mysql version are 
supported, because my provider have an 3.22.xx version installed.

-------------------------------------------------------
Date: 2002-Nov-09 16:22             By: skwashd
Try running a cvs update:

# cd /path/to/phpgroupware
# cvs -z6 update -Pd

Delete you header and database.  Try again from the start ... I have not heard 
of this before ... so starting over may help.

Let me know how you go

Cheers


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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]