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

[Jim Foster]

To Miles and Chris:

Thank you, gents, for both of your input. May I request one more piece of
advice from either/both of you?

I sent an e-mail to my ISP yesterday after I read what both of you had
advised. The initial response went like this:

"We don't currently have any plans to upgrade our mysql, as the jdbc
connector we
use relies on the current version.  If we can get 3.23 to work with our JDBC
connector, then we will upgrade."

To which I responded with the need to be ANSI SQL compliant, as both of you
had made clear.

The ISP has asked another question to which I am in no position to answer:


    "What functions do you need that are unsupported?"


May I tug on your expertise cape and ask how I should respond?

Much thanks, again!

Jim

----- Original Message -----
From: "Chris Weiss" <address@hidden>
To: <address@hidden>
Sent: Tuesday, March 05, 2002 7:23 AM
Subject: Re: [Phpgroupware-developers] Installation problem - phpgwapi and
lang table


> 3.23 fixes several limitations that are against ANSI SQL in 3.22.  I don't
recall
> any problems upgrading from 3.22 to 3.23, but it was quite a while ago.
IMO, using
> 3.22 is like staying with WinNT Sp4, it's just old and will cost nothing
but a
> small amout of scheduled downtime to upgrade and the benifits are
numerous.
>
> Miles Lott (address@hidden) wrote*:
> >
> >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
> >
>
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>