[Phpgroupware-tracker] [Bug #801] CREATE TABLE lang ... Primary Key too long (mysql)

[nobody]

=================== BUG #801: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=801&group_id=509

Changes by: Anonymous user        Date: 2002-Aug-29 01:56

------------------ Additional Follow-up Comments ----------------------------
So it now works??



=================== BUG #801: FULL BUG SNAPSHOT ===================


Submitted by: ummelchen                 Project: phpGroupWare                   
Submitted on: 2002-Jul-04 11:49
Category:  API - Setup                  Bug Group:  0.9.14 release              
Severity:  5 - Major                    Priority:  High                         
Resolution:  None                       Assigned to:  None                      
Status:  Open                           Platform Version:  Linux - Debian       
Reproducibility:  Every Time            

Summary:  CREATE TABLE lang ... Primary Key too long (mysql)

Original Submission:  Setup causes error in CREATE TABLE lang ... 
Therefore following "CREATE TABLE ..." and "INSERT ..." can´t be done correctly.

Bug at File:
phpgroupware/phpgwapi/setup/tables_current.inc.php
line 158: 'pk' => array('message_id', 'app_name', 'lang'),

What Primary Key should be used instead?

Follow-up Comments
*******************

-------------------------------------------------------
Date: 2002-Aug-29 01:56             By: None
So it now works??

-------------------------------------------------------
Date: 2002-Aug-28 20:38             By: None
Yes, i already upgraded.

-------------------------------------------------------
Date: 2002-Aug-28 19:37             By: None
Hi,

>From memory mysql 3.22 allowed smaller primary keys than 3.23.  I think this 
>is what is causing your problem.  Can you upgrade to 3.23.x??  This should fix 
>your problem.

Cheers

skwashd

-------------------------------------------------------
Date: 2002-Aug-28 07:23             By: ummelchen
At Installation time i used mysql 3.22.32-4 (debian potato).

-------------------------------------------------------
Date: 2002-Aug-27 04:29             By: skwashd
What version of mysql are you using???




No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=801&group_id=509