LinkBack URL
About LinkBacksI have run into the issue of database schema changes. Will Changing the length of a varchar in the Sugar database cause issues within the application?
Sugar Community Member
Changing Varchar length
I have run into the issue of database schema changes. Will Changing the length of a varchar in the Sugar database cause issues within the application?
SugarCRM PS Engineer
Re: Changing Varchar length
Not if you change the size in the vardefs.php file and let 'Repair Database' take care of the sql changes.Originally Posted by eaho
Kenneth Brill - Help Forum Moderator
I do not respond to 'Private Messages'. Please email me directly instead
When asking for help, PLEASE give us your Server Information and Version Numbers as asked for on the 'Post New Message' screen as well as any JavaScript errors shown at the bottom of the browser window.
Help us Help You
Sugar Community Member
Re: Changing Varchar length
In a related question. If I add columns into a table, will the database cleanup tool for SugarCRM leave the new columns alone? And then the same question for adding tables to the database.
SugarCRM PS Engineer
Re: Changing Varchar length
Only if you add those fields in teh vardefs.php file too. The database cleanup tool uses this file to decide if the table needs changing.
Kenneth Brill - Help Forum Moderator
I do not respond to 'Private Messages'. Please email me directly instead
When asking for help, PLEASE give us your Server Information and Version Numbers as asked for on the 'Post New Message' screen as well as any JavaScript errors shown at the bottom of the browser window.
Help us Help You
Sugar Community Member
Re: Changing Varchar length
The database repair tool, at least before 4.5, never drops columns - it only adds or updates columns that are defined in the vardefs.php files.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks