coreBOS OpenSourceBT

View Issue Details Jump to Notes ] Wiki ] Related Changesets ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000177coreBOSBugpublic2014-06-04 08:362018-02-05 11:15
Reporterpolanskiman 
Assigned Tojoebordes 
PrioritynormalSeverityminorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformSynologyOSDSM (Linux version 3.2.40)OS Version5.0-4482
Product Version5.4 
Target VersionFixed in Version5.4 
Summary0000177: Data in the Department field is being truncated
DescriptionAs stated in the summary, the data entered in the Department field is being truncated when there is more than 30 characteres. Changing the typeofdata column in the database doesn't change anything.
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
User avatar (0000160)
joebordes (manager)
2014-06-04 10:35

The size in the table is limited to 30. I have changed it to 230.
You can execute this SQL in your database:

ALTER TABLE `vtiger_contactdetails` CHANGE `department` `department` VARCHAR( 230 ) 
CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ;
User avatar (0000161)
joebordes (manager)
2014-06-04 10:43

Fix committed to master branch. 6fddb9dc5ec663bd97239ebeab05e3ebf9ce8f20
User avatar (0000572)
omar (manager)
2018-02-05 11:15

Fix committed to master branch. 366191fea7bb7fddef60bd2fb980c355baa94847

- Related Changesets
coreBOS: master 0068c9e4
Timestamp: 2014-06-04 10:41:00
Author: joebordes
Details ] Diff ]
fixes 0000177: Data in the Department field is being truncated
mod - schema/DatabaseSchema.xml Diff ] File ]
coreBOS: master 6fddb9dc
Timestamp: 2014-06-04 10:43:30
Author: joebordes
Details ] Diff ]
fixes 0000177: Data in the Department field is being truncated
mod - upgrade2coreBOS.php Diff ] File ]
coreBOS: master 366191fe
Timestamp: 2018-02-05 11:12:27
Author: omar
Details ] Diff ]
fix(Mobile):fix 0000177. Add support to uitype 51 on related search.

We have this uitype value and not uitype 10 on module Contacts and Account point to Accounts module.
Uitype 51 will disapear on the future and we will can remove this code.
mod - modules/Mobile/actions/getRelatedFieldAjax.php Diff ] File ]

- Issue History
Date Modified Username Field Change
2014-06-04 08:36 polanskiman New Issue
2014-06-04 10:35 joebordes Note Added: 0000160
2014-06-04 10:35 joebordes Status new => resolved
2014-06-04 10:35 joebordes Fixed in Version => 5.4
2014-06-04 10:35 joebordes Resolution open => fixed
2014-06-04 10:35 joebordes Assigned To => joebordes
2014-06-04 10:43 joebordes Changeset attached => coreBOS master 0068c9e4
2014-06-04 10:43 joebordes Changeset attached => coreBOS master 6fddb9dc
2014-06-04 10:43 joebordes Note Added: 0000161
2018-02-05 11:15 omar Changeset attached => coreBOS master 366191fe
2018-02-05 11:15 omar Note Added: 0000572


Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker