[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: Lachner Andreas <address@hidden>
Date: 2002-Aug-29 12:27 (GMT)

------------------ Additional Follow-up Comments ----------------------------
Ok, i changed the primary key.
I removed one of the keys of the primary key. This was according to a hack i 
found in news. Then it worked.

But of course this is not for future.

Does the upgrade to version .14 or newer change the primary key so it works? 
(changes the database table?)
Meanwhile i use mysql  Ver 11.16 Distrib 3.23.49, for pc-linux-gnu (i686) - 
Debian Woody.

CU
Andreas Lachner



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


Submitted by: ummelchen                 Project: phpGroupWare                   
Submitted on: 2002-Jul-04 15: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 12:27             By: ummelchen
Ok, i changed the primary key.
I removed one of the keys of the primary key. This was according to a hack i 
found in news. Then it worked.

But of course this is not for future.

Does the upgrade to version .14 or newer change the primary key so it works? 
(changes the database table?)
Meanwhile i use mysql  Ver 11.16 Distrib 3.23.49, for pc-linux-gnu (i686) - 
Debian Woody.

CU
Andreas Lachner

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

-------------------------------------------------------
Date: 2002-Aug-29 00:38             By: None
Yes, i already upgraded.

-------------------------------------------------------
Date: 2002-Aug-28 23: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 11:23             By: ummelchen
At Installation time i used mysql 3.22.32-4 (debian potato).

-------------------------------------------------------
Date: 2002-Aug-27 08: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