bugphpGroupWare - Bugs: bug #18046, failed install on mysql windows -...

 
 

You are not allowed to post comments on this tracker with your current authentification level.

bug #18046: failed install on mysql windows - utf

Submitted by:  Sigurd Nes <sigurdne>
Submitted on:  Wed 18 Oct 2006 09:06:03 AM UTC  
 
Item Group: NoneCategory: None
Severity: 3 - NormalPriority: 5 - Normal
Status: In ProgressPrivacy: Public
Assigned to: Caeies <Caeies>Open/Closed: Open
Component Version: NoneOperating System: None
Reproducibility: NonePlanned Release: None
Fixed Release: 

Wed 18 Oct 2006 11:13:02 AM UTC, comment #4:

I am generally opposed to just moding the existing setup/tables* scripts, unless it causes real breakages.

I ran an upgrade of an acceptance testing environment earlier today and it didn't seem to break.

If it needs to be done, then we have no choice but to do it, otherwise just add another upgrade to it.

Benoit it is your code, so it is your call.

Dave Hall <skwashd>
Project Administrator
Wed 18 Oct 2006 09:28:51 AM UTC, comment #3:

Fields sounds ok.

I think that since no one else has complained about this issue - and it is a fearly new feature in HEAD - and it has'nt broken anything - it should be sufficient to edit the definitions in phpgwapi/setup/tables_current.inc.php

Regards

Sigurd

Sigurd Nes <sigurdne>
Project Member
Wed 18 Oct 2006 09:06:03 AM UTC, comment #2:

This item has been reassigned from the project phpGroupWare patch tracker to your tracker.

The original report is still available at patch #5462

Following are the information included in the original report:

[field #0] Item ID: 5462
[field #1] Group ID: 509
[field #2] Open/Closed: Open
[field #3] Severity: 3 - Normal
[field #4] Privacy: Public
[field #6] Category: API - phpGWapi
[field #7] Submitted by: sigurdne
[field #8] Assigned to: Caeies
[field #9] Submitted on: samedi 14.10.2006 à 17:49
[field #10] Summary: failed install on mysql windows - utf
[field #11] Original Submission: please consider redusing phpgw_mapping.ext_user to varchar (20) and phpgw_mapping.account_lid to varchar (25).

The primary key has a maximum lenght of 1000 and - as I understand it - each charater in utf8 counts as 3

Regards

Sigurd
[field #13] Item Group: CVS HEAD (aka development code base)
[field #14] Status: None
[field #15] Component Version: None
[field #16] Operating System: None
[field #17] Reproducibility: None
[field #18] Size (loc): None
[field #19] Fixed Release: None
[field #20] Planned Release: None
[field #21] Effort: 0.00
[field #25] Priority: 5 - Normal
[field #28] Percent Complete: 0%
[field #30] Release: None
[field #55] Custom Select Box #1: None
[field #56] Custom Select Box #2: None
[field #57] Custom Select Box #3: None
[field #58] Custom Select Box #4: None
[field #59] Custom Select Box #5: None
[field #60] Custom Select Box #6: None
[field #61] Custom Select Box #7: None
[field #62] Custom Select Box #8: None
[field #63] Custom Select Box #9: None
[field #64] Custom Select Box #10: None

Caeies <Caeies>
Project AdministratorIn charge of this item.
Wed 18 Oct 2006 09:06:01 AM UTC, comment #1:

Hi Sigurd

We can't really reduce that much ... an email adresse for example is more than 20 caracters ...

So reducing account_lid is ok to 25 since it's the phpgw_account.account_lid size ...

So I propose :

200 for location, 100 for ext_user and 25 for account_lid

If I understand your problem that's 200 3 + 100 3 + 25 * 3 < 1000 so should be ok.

Should I AlterTable in the setup process for update ? (I guess yes) Or your were not able to update, so you need to modify the file ?

Regards.

Caeies

Caeies <Caeies>
Project AdministratorIn charge of this item.
Wed 18 Oct 2006 09:06:03 AM UTC, original submission:

please consider redusing phpgw_mapping.ext_user to varchar (20) and phpgw_mapping.account_lid to varchar (25).

The primary key has a maximum lenght of 1000 and - as I understand it - each charater in utf8 counts as 3

Regards

Sigurd

Sigurd Nes <sigurdne>
Project Member

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Mon 23 Oct 2006 01:12:44 PM UTCCaeiesStatusNone=>In Progress
  Assigned toNone=>Caeies
Wed 18 Oct 2006 09:06:03 AM UTCCaeiesReassign itemphpGroupWare, patch #5462=>phpGroupWare, bug #18046

Back to the top


Powered by Savane 3.1-cleanup