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

[Miles Lott]

Please upgrade to Mysql 3.23.XX.  THis should get
around that problem.  I am not sure if it is merely
a limitation or a difference in configure defaults.

> Jim Foster wrote:
> 
> 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
> 
> 
> 
> 

-- 

Miles Lott - phpGroupWare
http://www.phpgroupware.org