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

[Chris Weiss]

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
>