How can I increase field size?

[sv2k]

Hello.

I've adjusted the sic_code field (in the Accounts) for our needs and we stored other codes in it.
Now It's become necessary to increase the length from 10 to 12.
I increased the varchar field size in the db, but in the interface there are maxlength set to 10 left.
Why it isn't pick up? What's the folly?
How can I solve the problem?

Thanks in advace.

[lvangool]

That's because there is a double definition. There's a mysql definition, and Sugar has it's own...You have to modify modules/Accounts/vardefs.php and increase the size there. Also, you have to modify Accounts/EditView.html and increase the maxlength value over there. You might also have to repair the database in the Configuration tab.

Note that you will lose upgrading options here. Future releases might undo your changes and corrupt your install.

[HomeTeam]

I had the same concern so I made the necessary changes to vardefs and editview.html.. Now I am bale to ENTER in the needed 25 characters, only to have the input truncated upon saving.. any ideas? How do I repair things in the configuration tab?? Do you mean the admin tab?? Please advise.... Thanks again for all the great input.

HOMETEAM

[andydreisch]

Hi HomeTeam, it's Admin -> Repair ... Database. And I'm not certain that this will actually increase the storage size in the DB. I just don't know off the top.

If not then you can use the ALTER TABLE statement to stretch out the DB columns in MySQL.

Andy

[lvangool]

Andy is right, it's the Repair DB option in the Admin->Repair module. It should increase the size.

Be warned that Andy's alternative method is bad...mmmkay? If you do it anyway, just don't try to migrate/upgrade SugarCRM after that...