Problem with custom fields in contact module

[moschap]

Hi everyone,

I have a peculiar problem with my supported sugarcrm deployment. The initial installation of sugarcrm in my site was sugarcrm 4.2.1b, when i was about to carry out the upgrade i noticed that contact module on the live system which had a couple of custom feilds were not saving the edits on any of the values entered in any of the custom fields (but when you create a record it saves for all of the values default and custom field), but it saves data entered in the fields that ships with sugarcrm. The happens for all the records in contacts module except for one particular record, where editing the values in the custom fields saves to the database. My problem now is that after the upgrade i still have the problem, Please has anyone experienced this problem and what are possible solutions, thanks

Mysql server 5.0
php 5
Sugarcrm 4.5.1i

[Angel]

Try logging in as Admin, then go the admin control panel and run a Rebuild.

[moschap]

Hi Angel,

Thanks for your reply, but then sorry if i am asking an obvious question, but which of the repairs do i run. I am guessing the rebuild extensions Link.

[Angel]

My apologies, I missed the part about you being on 4.5.1.

Try the Repair Database option and also, go back to the Admin control panel, click Studio, then click Repair Custom Fields.

I believe the latter is the one that is of most relevance here, but give both options a try.

[moschap]

Thanks Angel, but the problem has been fixed. The problem was there was a custom field created that is repesented as a checkbox, it is supposed to take either a zero or one (tinyint) at the database but somehow the table allows null values for all the newly created records, so when there is an update on the table there is an error by Mysql that it cannot save the null value for that column, so i altered the table and gave a default of zero's for that coulmn and it worked.