[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: Ralf Becker <address@hidden>
Date: Fri 03/21/03 at 02:36 (Europe/Berlin)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Wont Fix
         Assigned to | None                      | ralfbecker
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
we need all of them as primary key, so you have to upgrade.



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


Submitted by: ummelchen               Project: phpGroupWare                 
Submitted on: Thu 07/04/02 at 17:49
Category:  API - Setup                Bug Group:  0.9.14 release            
Severity:  5 - Major                  Priority:  High                       
Resolution:  Wont Fix                 Assigned to:  ralfbecker              
Status:  Closed                       Component Version:  None              
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: Fri 03/21/03 at 02:36         By: ralfbecker
we need all of them as primary key, so you have to upgrade.

-------------------------------------------------------
Date: Wed 09/04/02 at 08:05         By: None
Andreas,

I am not sure.  I have .10, .12 and .14 from RC2 onwards with mysql 3.23.x(not 
accessible at the moment).  I only use english lang file.  I have not had this 
problem.

The problem you had *may* have been caused by trying to install using mySQL 
3.22.x .  I don't think the upgrade will fix the problem.  Is it possible for 
you to try a new install.  

Grab the .14 tarball from phpgroupware.org, then run a cvs update:
1) cd /path/to/phpgroupware
2) cvs -z3 update -dP

There have been a couple of post release fixes for .14 ... its probably best to 
grab them before running the new install.

Cheers

skwashd

PS - Sorry about the delay in responding to you ... my inbox has overflowed and 
caused bouces a couple of time in the last week ... i didn't get your follow up.

-------------------------------------------------------
Date: Thu 08/29/02 at 14: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: Thu 08/29/02 at 07:56         By: None
So it now works??

-------------------------------------------------------
Date: Thu 08/29/02 at 02:38         By: None
Yes, i already upgraded.

-------------------------------------------------------
Date: Thu 08/29/02 at 01: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: Wed 08/28/02 at 13:23         By: ummelchen
At Installation time i used mysql 3.22.32-4 (debian potato).

-------------------------------------------------------
Date: Tue 08/27/02 at 10:29         By: skwashd
What version of mysql are you using???


CC list is empty


No files currently attached


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