| View previous topic :: View next topic |
| Author |
Message |
Schoko
n00b
Joined: 27 Jun 2002
Posts: 39
Location: Currently anywhere in Europe...
|
 Posted: Wed Dec 28, 2005 12:43 pm Post subject: Problems with eGroupware database |
 |
|
Hi there,
after emerging eGroupware I pointed my browser to http://localhost/egroupware/setup and installed the generated header.inc.php file. Till this point, everything worked fine. After that I wanted to install the database, but during table installation there were a lot of error messages like that:
| Code: | Database error: Invalid SQL: CREATE TABLE phpgw_lang (lang varchar(5) NOT NULL DEFAULT '', app_name varchar(100) NOT NULL DEFAULT 'common', message_id varchar(255) NOT NULL DEFAULT '', content text, PRIMARY KEY(lang,app_name,message_id))
mysql Error: 1071 (Specified key was too long; max key length is 1000 bytes)
Function: schema_proc_mysql::createtable / schema_proc::createtable / schema_proc::executescripts / setup_process::post_process / setup_process::current / setup_process::pass
Database error: Invalid SQL: INSERT INTO phpgw_interserv(server_name,server_host,server_url,trust_level,trust_rel,server_mode) VALUES ('eGW demo',NULL,'http://www.egroupware.org/egroupware/xmlrpc.php',99,0,'xmlrpc')
mysql Error: 1146 (Table 'egroupware.phpgw_interserv' doesn't exist)
Function: schema_proc::query / include / setup_process::default_records / setup_process::pass
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)
mysql Error: 1146 (Table 'egroupware.phpgw_vfs' doesn't exist)
Function: schema_proc::query / include / setup_process::default_records / setup_process::pass
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)
mysql Error: 1146 (Table 'egroupware.phpgw_vfs' doesn't exist)
Function: schema_proc::query / include / setup_process::default_records / setup_process::pass
Error inserting record: phpgw_lang values ('%1 email addresses inserted','common','de','%1 Email Adressen eingefügt')
Error inserting record: phpgw_lang values ('%1 is not executable by the webserver !!!','common','de','%1 ist nicht ausführbar durch den Webserver !!!')
|
With a little eGroupware-based updating and re-checking I can continue, but it isn't possible to install any languages. And, of course, it isn't possible to login. SQL error messages over and over... The values in the header.inc.php should be correct, the database itself is created correctly.
I use the following versions:egroupware-1.0.0.009_p3
php-4.4.0-r4
mod_php-4.4.0-r9
apache-2.0.55
mysql-5.0.17 Thank you very much for any suggestions...
Regards,
Juergen |
|
| Back to top |
|
 |
magic919
Advocate
Joined: 17 Jun 2005
Posts: 2182
Location: Berkshire, UK
|
| Posted: Wed Dec 28, 2005 2:36 pm Post subject: |
|
|
| Quote: | | Specified key was too long; max key length is 1000 bytes |
This is an outstanding MySQL bug as far as I know.
If you've got the database but can't create the tables this isn't gonna fly. Why not try an earlier release of MySQL or some other DB. |
|
| Back to top |
|
|
Schoko
n00b
Joined: 27 Jun 2002
Posts: 39
Location: Currently anywhere in Europe...
|
| Posted: Wed Dec 28, 2005 6:06 pm Post subject: |
|
|
You're so right, man! 
The bug is mentioned here:
http://bugs.mysql.com/bug.php?id=4541
So I replaced all "utf8" with "latin1" in /etc/mysql/my.conf and restarted the mysql daemon. Now I can complete the setup process, even with languages! Well, ... almost: During table installation another error occurred:
| Code: | Database error: Invalid SQL: CREATE TABLE phpgw_history_log (history_id int(11) auto_increment not null, history_record_id int NOT NULL, history_appname varchar(64) NOT NULL, history_owner int NOT NULL, history_status char(2) NOT NULL, history_new_value text NOT NULL, history_timestamp datetime NOT NULL DEFAULT 'now', history_old_value text NOT NULL, PRIMARY KEY(history_id), INDEX(history_appname,history_record_id,history_status,history_timestamp ))
mysql Error: 1067 (Invalid default value for 'history_timestamp')
Function: schema_proc_mysql::createtable / schema_proc::createtable / schema_proc::executescripts / setup_process::post_process / setup_process::current / setup_process::pass
Warning: Cannot modify header information - headers already sent by (output started at /var/www/localhost/htdocs/egroupware/phpgwapi/inc/class.db.inc.php:704) in /var/www/localhost/htdocs/egroupware/phpgwapi/inc/class.setup_html.inc.php on line 117 |
Any ideas? |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Networking & Security
