[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-Sep-04 02:05

------------------ Additional Follow-up Comments ----------------------------
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.



=================== 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-Sep-04 02: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: 2002-Aug-29 08: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 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