Data Lost - custom fields on new record

[vab3]

When I try to create a new account, the data in my custom fields is not being saved. Let me explain in more detail:

1) I create a new account, enter "TEST Account" as the name. I check the "feedback" checkbox (my custom field) and change the "product line" dropdown (my other custom field).
2) I hit save, when the account comes back up in view mode, neither custom field is set properly. They are just showing the default values.
3) Re-Editing the same fields on the same account has no effect.

This only fails for accounts created from the menu. If I duplicate an old account, or create an account when converting a lead, everything works as expected. I am not sure if this problem has existed or just started in the past few days.

There is no error in the file sugarcrm.log. What can I do to narrow down what is happenning, so that I can report a bug.

I'm using Windows 2003 Server Web Edition, Sugar Suite 4.5.0f, MySQL 4.0.24a, PHP 5.1.6.

[AndrewD]

The same issue with Prospects (targets). Custom fields data are not saved.

Sugar version 4.5f

[vab3]

Same thing happenned on 4.5.0h. I looked at the log, but no errors. What is the next troubleshooting step?

[andydreisch]

Hi vab3, it seems like the data is not being saved for some reason but let's verify that. Can you access the database via PHPMyadmin and check the records in question? You should be able to find them in accounts_cstm.

Can you create a new field and verify that it works? It could be that something occurred that affected only the original fields.

Let us know what you find.

Andy

[vab3]

I created a new custom field called test1, and added it to my detilal and edit forms for Account. Then I created a new account. I checked the "Feedback" custom field, and entered some text into the new test1 field. Neither field was saved.

I checked the accounts_cstm table. A new field, test1_c was there, but a new record was not created. I'm assuming id_c, is supposed to match the id field in the accounts table.

The same is true for leads. When I import leads, the custom fields are saved. However, when I create a lead using the web browser interface the custom fields record is not created. When I create a lead using the Outlook plug-in, the lead is created but the corresponding record in leads_cstm is not created. If I try to edit the lead and change the custom fields, the change is not saved.

I've attached a debug log file. Here's what I did:

1) Created custom field TEST3
2) Added this field to Account Detail, then Account Edit screens
3) Did "create account"
4) Put some text in Account Name, and TEST1, Test2, Test3, Feedback, Product Line custom fields.
5) Hit Save.

It's a big file. If there is a way I can narrow it down to make it more convenient for you let me know.

[vab3]

New Information:

I was mistaken earlier. When I import a lead, and then try to change the custom fields, the change does not occur. The database situation is different, too. One of the fields I import is "product line", one of my custom fields. This field is set correctly on import, and the leads_cstm record exists. But, if I try to edit the lead and change the product line, the change does not take effect.

I'm not able to change custom fields on leads or accounts. There was a case the other day where I was able to get a changet to take effect by doing a duplicate merge with an older record. And I thought on some records I could edit a custom field, but today it does not seem so.

Do you think re-installing sugar from scratch would fix this? Or do I have a data problem. Records with incorrect data are piling up. I need to do something soon.

Thanks,

[mfleeger]

We ultimately discovered that this was due to running mysql with STRICT_TRANS_TABLES.

Basically, because one/some of the custom fields were dates, Sugar was inserting '' and mysql would not interpret this as '00-00-0000 00:00:00' because of that setting (which is in my.ini/my.cnf). This has the effect of rejecting the entire query.

You can track this via Bug #10023, which will be addressed in a future version of Sugar...

Thanks!

[underhillm]

There seems to be an similar problem uing MSSQL 2005 - which I have experienced - but I don't have custom fields which are dates. CRM version is 4.5.1d.

[pblag]

Hi All!

I saw the problems like this.

It can be when you have added custom fields to EditView and these custom fields have no same fields in the database table.

Please check all custom fields located at EditView screen and take a look if each this custom field has column in the database with same name.

Hope it will help you if not please email me and we will fix it.

[underhillm]

Thanks for your response. I have checked all the custom fields and they all match. 2 of them are set as 'checkbox' custom fields and I am not sure what the import file should contain - 0/1 or y/n or true/false.

It is also not importing the Birthdate field (which is in the min Contacts table) though it does import a 'date_entered' value (and all the address details) fine so I have the date formats correct. It is very puzzling. Can you help further?

Mark