check the DB table fields_meta_data and the directory custom/Extension/modules//Ext/Vardefs/ If there are files in the latter that resemble: sugarfield__c.php, that are not represented in the former, then removing them should clear up the issue. (from pmcqueen)
Has anyone found the reason why the extra =Null,=NULL,=NULL are included? And how to fix this?
Here is my guess...I tried to create three new fields, but it kept giving a SQL error. Then this error started to appear when I tried to save/update my data. Later, I looked at this a little more and noticed that the original SQL error was because SugarCRM was attempted to modify an existing database column's datatype from date to datetime. There was one record in which the year was 1512 and that year is not allowed as a datetime. Because of all this, it seems that Sugar started to create a new field but was not successful. But now I don't know how to remove these "unsuccessful" columns.
In Admin->Studio, I picked the appropriate Module and noticed that some fields were marked as NULL. Then I opened the file vardefs.ext.php (in the appropriate custom module folder). This file didn't include any data marked as NULL. However, I noticed the field names before and after row in Studio. Then I looked in the file for those two fields...and there was a "field" between the two in the file. I removed the line of text from the file. And saved the file. Refreshing the Studio page in the browser made the NULL fields go away.
Next, I went to the \custom\Extension\modules\moduleName\Ext\Vardefs\ folder and found the file with the same name. I deleted the file.
Finally, I went to admin-repair and did a quick repair and rebuild.
In Admin->Studio, I picked the appropriate Module and noticed that some fields were marked as NULL. Then I opened the file vardefs.ext.php (in the appropriate custom module folder). This file didn't include any data marked as NULL. However, I noticed the field names before and after row in Studio. Then I looked in the file for those two fields...and there was a "field" between the two in the file. I removed the line of text from the file. And saved the file. Refreshing the Studio page in the browser made the NULL fields go away.
Next, I went to the \custom\Extension\modules\moduleName\Ext\Vardefs\ folder and found the file with the same name. I deleted the file.
Finally, I went to admin-repair and did a quick repair and rebuild.
