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

[Jim Foster]

Miles:

Thank you for your response, however, this is the version that my ISP
supports...I have no control over it.

Any other words of wisdom?

Jim


----- Original Message -----
From: "Miles Lott" <address@hidden>
To: <address@hidden>
Sent: Tuesday, March 05, 2002 6:21 AM
Subject: Re: [Phpgroupware-developers] Installation problem - phpgwapi and
lang table


> 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
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>