no data being saved in custom fields

[vaineh]

hi there

can anybody help me?

ive added custom fields to accounts and leads but no data entered into the custom fields are being saved. all the standard fields seem to save data fine. but the custom fields are having problems.

ive enabled debug logging and when making a change to a record i get:

Tue Mar 31 15:06:06 2009,975 [5675] INFO SugarCRM - Query:UPDATE accounts_cstm SET total_rooms_c=NULL ,kitchens_c=NULL ,bathrooms_c=NULL ,bedrooms_c=NULL ,t
otal_persons_c=NULL ,pets_c='0' ,smoke_c='0' ,property_type_c='' ,client_number_c=1 WHERE id_c='dd94bd28-0464-57d7-fb2b-49d1ef272924'
Tue Mar 31 15:06:06 2009,976 [5675] INFO SugarCRM - Query Execution Time:0.000134
Tue Mar 31 15:06:06 2009,976 [5675] ERROR SugarCRM - MySQL error 1054:

after the 1054 error code its just blank.

[vaineh]

sorry im using sugar 5.0.0h

[vaineh]

just browsed the database and the fields its trying to update such as "client number" are not even in the table accounts_cstm.

Ive ran the repair database tools from admin panel but doesnt appear to have changed anything

[mvngti]

Here is something you can try. Use the "Export Customizations" feature to make an export of the customizations and then install that package on your own system. It should create the fields found in the package.

Otherwise - just create the columns on your own using phpmyadmin or the mysql cmd line client.

[crmsiva]

Check the fields listed in studio for accounts module. Check whether the field client_number_c is there or not. Try Quick repair for accounts module. If it still don't work, create a new field with name client_number_c in accounts_cstm table.

I hope this helps

[vaineh]

thanks guys.

exporting and then importing over the top of the current system creates the necessary fields in the table.