[Top][All Lists]
[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:22:55 -0500 |
=================== BUG #1668: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=1668&group_id=509
Changes by: Dave Hall <address@hidden>
Date: 2002-Nov-10 08:22 (Australia/Melbourne)
What | Removed | Added
---------------------------------------------------------------------------
Assigned to | None | skwashd
------------------ Additional Follow-up Comments ----------------------------
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
=================== BUG #1668: FULL BUG SNAPSHOT ===================
Submitted by: None Project: phpGroupWare
Submitted on: 2002-Nov-10 08: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-10 08: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