bugphpGroupWare - Bugs: bug #1668, Failed to Create MySQL Database...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #1668: Failed to Create MySQL Database Tables

Submitted by:  None
Submitted on:  Sat 09 Nov 2002 09:00:20 PM UTC  
 
Item Group: 0.9.14 releaseCategory: API - Setup
Severity: 3 - NormalPriority: 5 - Normal
Status: NonePrivacy: Public
Assigned to: Dave Hall <skwashd>Open/Closed: Closed
Component Version: BZIP2Operating System: *BSD
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Sat 09 Nov 2002 10:06:52 PM UTC, comment #5:

np ... will close this one ... good luck with the request

Dave Hall <skwashd>
Project AdministratorIn charge of this item.
Sat 09 Nov 2002 09:59:52 PM UTC, comment #4:

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

Kai

Anonymous
Sat 09 Nov 2002 09:56:47 PM UTC, comment #3:

Unfortunately iirc you need 3.23.xx

Sorry

Dave Hall aka skwashd

Anonymous
Sat 09 Nov 2002 09:51:38 PM UTC, comment #2:

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.

Anonymous
Sat 09 Nov 2002 09:22:55 PM UTC, comment #1:

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

Dave Hall <skwashd>
Project AdministratorIn charge of this item.
Sat 09 Nov 2002 09:00:20 PM UTC, 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)

Anonymous

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 2 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Sat 09 Nov 2002 10:06:52 PM UTCskwashdOpen/ClosedOpen=>(Error - Not Found)
Sat 09 Nov 2002 09:22:55 PM UTCskwashdAssigned toNone=>NA

Back to the top


Powered by Savane 3.1-cleanup1