[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:56:48 -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:56
------------------ Additional Follow-up Comments ----------------------------
Unfortunately iirc you need 3.23.xx
Sorry
Dave Hall aka skwashd
=================== 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: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