Drop downs - Unable to save data

[sasben]

Please bear with me.. I have searched for quite a while but have had no luck,

Using Studio buildler, I created a new drop down with values. I then created a field that used that specific drop down.

On the edit screen, i can select values however when I save the item (which reverts back to detail view), the value i set the field to, is lost. When I click edit again, the original value (in this case <blank>) is set.

I tried to create some other drop down fields, but the same issue occurs.

Interestingly, any other text field, or in-build dropdown works fine and retains the set value from the edit screen.

I also added an existing dropdown list ("Industry" - which works in the original field), to a dropdown field that i created and it doesnt retain its set value.

i.e. Accounts view
Industry field (in-built), Industry drop down.. works.
Status field, industry drop down. doesn't save values


Is there a bug? or something I have done wrong? I did it the same way in an older version of Sugar and it worked fine.

[Angel]

Enabled debug logging under Admin > System Settings, repeat the action that causes the problem and then review the sugarcrm.log file in the root Sugar install directory.

Sounds like there might be a problem with the SQL query and the log file should yield that error.

[ros.vol]

Hi,

What version of SugarCRM do u use?

Cheers,

[sasben]

Sugar Updates (5.2.0f)

[ros.vol]

So, it has stop working after upgrade?

[sasben]

I upgraded to the latest, then I started to customize.

Interestingly, I put the sugar log into INFO mode, and found this..

07/16/09 21:07:46 [2764][1][INFO] Query:UPDATE accounts_cstm SET firstname_c='' ,lastname_c='' ,,entity_c='TEST DROPDOWN ENTRY',SA' WHERE id_c='9341bb22-5390-8e90-76dd-4a5f6fc12e10'
07/16/09 21:07:46 [2764][1][INFO] Query Execution Time:0.00022792816162109
07/16/09 21:07:46 [2764][1][ERROR] MySQL error 1054: Unknown column 'firstname_c' in 'field list'

I created a field called firstname_c, however i didnt place it in the layout editor as yet. The field seems to be normal, and the SQL query above seems okay with the null value, but it says "unknown column".

Should I delete the field and retry?

[Angel]

Try using the rebuild option in the Admin Control Panel. That usually resolves those type of issues.

[sasben]

I used Angel's suggestion to turn up logging. I set it to INFO, however you could set it to ERROR

Opened the logfile (use something other than notepad.exe for a better viewing experience), searched for the field value I set, and looked at the next few lines.

I found

ERROR] MySQL error 1054: Unknown column 'firstname_c' in 'field list'

So I deleted that field and re-created it. All fine now.