Custom Decimal Fields Playing Up

[Deland01]

For some strange reason I’ve noticed that the custom fields I made have started to do usual things. This is only happening on the Leads module with the custom Decimal fields. At first when you enter numbers into them then tried to save the changes the numbers you entered just disappeared. So I ran a “repair Custom Fields” and now when I enter numbers into them half of the fields still don’t save the data & the other half convert the numbers into strange values.

As an example I have a field called “Fame DSO:” and when I enter the following number of 564676877866546 then save the number turns into 5.64677e+014

The max size value for this field is 15 characters but when ever you enter 7 characters or more it converts the numbers & adds e+ in there. Any less than 7 characters and it looks to be ok.

Has anyone come across this before?


.

[Deland01]

Ok so I did a bit of digging an some one suggested changing the number fields to decimals.... but they already are decimals...

I've just upgraded Sugar from 4.50h to 4.51b which seams to have sorted the text for symbol substitution out but now I find If I enter a number larger than 8 characters long only the last 8 characters are displayed. I've also tried changing the "Max Size" value & then adding the field back onto the page. Still no luck.


.

[Deland01]

One thing I did notice though was if you open a Lead and change the value of the custom field, as an example I changed the number from 12345678 to 12345678910 and saved the changes. Nothing appears to happen but if you click the "View Change Log" option the numbers display correctly in the log. No matter what you change the number to the change log picks all the settings up fine.

[Meyer]

If you look closely at the database, you will see the field values. if you enter a number with more characters sugar wont update, so go to custom field and increase the field size. the only other problem that i experiance is if i change the back end - sql 2005 to fe 25.2 the data shows correct in sugar. but when you repair custom fields sugar changes it back to 25.4?

[Deland01]

Thanks for that, when you repair the field codes I believe it uses the vardefs.php as detailed in the following post:

http://www.sugarcrm.com/forums/showthread.php?t=22219

But I checked /modules/Leads/vardefs.php for my custom fields but couldn’t find any.

Don’t know if this helps you out at all.

[Deland01]

Mayer,

I just changed my custom number fields from char(10) to char(15) in SQL using phpmyadmin. I then ran a "repair fields" option in sugar and have some even stranger results.

My custom number fields are all set to allow 15 chara max in the module editor but I can enter no more than 12 char into each field if I want the data to save????

The max character variable must be set in one of the php files or in another variable somewhere.

The strange thing is after I ran the repair fields it didn't change the SQL database values back to char(10) as I thought it would?