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

 
 

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

bug #18046: failed install on mysql windows - utf

Submitter:  Sigurd Nes <sigurdne>
Submitted:  Wed 18 Oct 2006 09:06:03 AM UTC
   
 
Category:  None Item Group:  None
Severity:  3 - Normal Priority:  5 - Normal
Status:  In Progress Privacy:  Public
Assigned to:  Caeies Open/Closed:  Open
Component Version:  None Operating System:  None
Reproducibility:  None Planned 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>
Group 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>
Group 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>
Group administrator
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>
Group administrator
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>
Group Member

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 3 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2006-10-23 Caeies StatusNone In Progress
    Assigned toNone Caeies
2006-10-18 Caeies Reassign itemphpGroupWare, patch #5462 phpGroupWare, bug #18046

Back to the top

Powered by Savane 3.13-4448.
Corresponding source code