Integer Field breaks List View in Projects 5.1 Pro

[digitalcoresf]

Adding an integer field in studio breaks the list views.

even if the list view doesn't contain the integer field.

this happens in projects and quotes. So I assume any other module

anyone confirm this?

[nikidinsey]

Hi I can also confim this bug in Sugar GA

I tried adding an int field to accounts which produces the same results as you mention.

I did a little digging and it seems that the new field is not being added to the <module>_cstm table in the database. I added the name of the field as a row in the structure (in my case school_id_c) and the list view appeared to work again.

I'm not too sure ths is all you need to do to fix it, there might be other things that haven't happened in the creation of the field and I'm very new to Sugar.

hope this helps,

regards

Niks

[maschek]

I can confirm this in the latest sugar CE.
You cannot add any integer or decimal field (varchar you can, i didnt test the rest) with studio to any modules!
Sugar will not add it to the _cstm tables thus you will not be able to save them and will cause errors in listviews.

See bug:
http://www.sugarcrm.com/crm/?option=...7-48bec8207083