patchphpGroupWare - Patches: patch #5462, Reassigned to another tracker...

 
 

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

patch #5462: Reassigned to another tracker [was: failed install on mysql windows - utf]

Submitter:  Sigurd Nes <sigurdne>
Submitted:  Sat 14 Oct 2006 05:49:29 PM UTC
   
 
Category:  API - phpGWapi Priority:  5 - Normal
Item Group:  SVN trunk (dev code) Status:  None
Privacy:  Public Assigned to:  Caeies
Open/Closed:  Closed

Wed 18 Oct 2006 09:06:03 AM UTC, comment #2: 

THIS ITEM WAS REASSIGNED TO BUG #18046.

Please, do not post any new comments to this item.


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
Sat 14 Oct 2006 05:49:29 PM UTC, original submission:  

THIS ITEM WAS REASSIGNED TO BUG #18046.

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 2 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2006-10-18 Caeies Reassign ItemphpGroupWare, patch #5462 phpGroupWare, bug #18046
2006-10-18 Caeies Carbon-Copy- Added -email is unavailable-

Back to the top

Powered by Savane 3.13-02a9.
Corresponding source code