Html input maxlength changes

[BrianSteffens]

Hello,

I've put the sugar database in a MySQL cluster, and was required to shorten some field lengths (varchar sizes) to accommodate the ndb storage engine's 8k row size limit. It only affected a few tables, but I'm wondering where I'd start to fix up the front end php code to reflect these changes. Basically I'm looking for whatever controls the maxlength variable in input type="text" html tags that are generated. Where might I look to find these things?

Thank you

[julian]

Hello BrianSteffens,

It may be easiest to use the Studio (found in Admin) to make these changes. Using the Studio will ensure that the changes are upgrade-safe.

If you'd like to search through the metadata files to find these fields, check in vardefs.php files-- this controls the properties of the fields. Here's an example from ./modules/Accounts/vardefs.php (or ./cache/modules/Accounts/Accountvardefs.php):

   'sic_code' =>
  array (
    'name' => 'sic_code',
    'vname' => 'LBL_SIC_CODE',
    'type' => 'varchar',
    'len' => 10,
    'comment' => 'SIC code of the account',
 
    'merge_filter' => 'enabled',
 
  ), 
  

In this case, 'len' controls the size of the VARCHAR field created in the accounts table.

[BrianSteffens]

Great, thank you very much!

Does that len variable also control the maxlength variable in the html tag that comes out when viewing a page?

[andopes]

Hi, BrianSteffens

The maxlength is defined by the controller of the text field in the SugarCRM's MVC.

So for modifying it you must create a customCode into the fields definition at the editviewdefs.php

Cheers

--
André Lopes
Lâmpada Global Services
Rua Bela Cintra, 299 conjunto. 51
São Paulo, SP 01415-000
tel1. 55 11 3237-3110
cel. 55 11 7636-5859
e-mail: info@lampadacrm.com.br

[nbiondi]

Ya that is one of the first problems we found using SugarCRM with a mysql cluster. We finally scrapped the whole project due the fact that the mysql cluster could not handle the obscene amount of joins that the crm seems to make. This made for extremely slowed performance at a level that would never work for any real production environement.