[Phpgroupware-developers] Installation problem - phpgwapi and lang table

[Jim Foster]

Hello, all!

 

I have the phpgroupware-0.9.14.RC2.zip package from the download page of www.phpgroupware.org.

 

I have been working with phpGW since 9.9, so I have been through this upgrade process a few times, however, I seem to have run into a problem that I can't resolve on my own.

 

Since I consider .14 a quantum - rather than incremental - step over .12 (with the 3-layer design), I decided to work from scratch, hence I wiped the db clean before attempting the steps with Setup/Config Admin.

 

So here is the situation:

 

1) header.inc.php created just fine

2) fresh (as in empty) MySQL 3.22.23b (PHP version 4.0.1pl2, Apache/1.3.6)

3) I go to the "phpGroupWare version 0.9.13.018 Setup III" screen.

4) Step 1 tells me "Your database is working, but you dont have any applications installed"

5) I hit the Install button.

6) Screen fills up with Database errors, the first of which is

 

===============================================

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))
===============================================

 

7) I note that phpMyAdmin indicates that just the following 10 tables were created, where the phpgwapi/setup.inc.php file indicates that 20 should be created:

 

languages
phpgw_access_log
phpgw_accounts
phpgw_acl
phpgw_app_sessions
phpgw_applications
phpgw_config
phpgw_hooks
phpgw_preferences
phpgw_sessions

 

8) Obviously, install choked when it got to creating the lang table, so I copied the CREATE TABLE ... statement above to the clipboard, go back to phpMyAdmin, paste the statement into the phpMyAdmin "Run SQL query/queries" text box to try it manually.

 

9) It comes back with the following:

===============================================

Error

SQL-query : 

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));

MySQL said:

Specified key was too long. Max key length is 256

===============================================

 

 

It is at this point that I find myself at an impass and turn to the group for some assist.

 

Much thanks, in advance.

 

Jim