Module Leads manual update problem

[tresfx]

Hello:
I'm a developer in a company that recently both a few licems of sugar for their call ccentrum.
The problem is that the vendor helps configure it to the call centrum user but theres a problem with the module Leads.
Each time we tried to update a lead by hand the program stop dude to a mysql problem.
Concretly is that when updating the query includes a column that dosent exists at the reference table (leads).
This column is product_tm_c. that seens to be referrefered in another table, table products.
the fact is that I've been encourage by admin not to add manually this column to leads....Because we dont know anything of the effects it could make at sugar logic.
This vendor whants more money to see which is the roblem that we think they made because of a bad configuration and we dont want to pay by this issue.
That anyone ever had such a similar problem or exist a different way how to solve this through sugar admin interface?
Thanks in advance and i apologice for my english :-)

[andopes]

Look for the buggy query in sugarcrm.log and share it in your next post.

Cheers

[tresfx]

I must say that this is a test and that fields like primary_address_street are just random typed :-)
Thanks for your help.

15336][1][FATAL] Query Failed:
Update leads set date_modified='2012-01-13 08:55:51', modified_user_id='1', created_by='1', description=null, deleted='0', assigned_use r_id='1', team_id='1', team_set_id='1', salutation=null, first_name='Ernesto', last_name='Locomotion', title=null, department=null, do_not_call='0', phone_home=null, phone_mobile='945123687', p hone_work=null, phone_other=null, phone_fax=null, primary_address_street='dfdsggdfgsdgsh hfghgfh hfghfg hfghfgh fghfghf fghfghg fghfhg dfh ghdfghd dgh', primary_address_city='Prague', primary_a ddress_state='Cz', primary_address_postalcode='14001', primary_address_country='Cz', alt_address_street=null, alt_address_city=null, alt_address_state=null, alt_address_postalcode=null, alt_add ress_country=null, assistant=null, assistant_phone=null, converted='0', refered_by=null, lead_source='CeskaSporitelna', lead_source_description=null, status='New', status_description=null, repo rts_to_id=null, account_name='tototoot', account_description=null, contact_id=null, account_id=null, opportunity_id=null, opportunity_name=null, opportunity_amount=null, campaign_id=null, birth date=null, portal_name=null, portal_app=null, website=null, produkt_tm_c=null WHERE ID = '8586733c-d9bc-8b14-e790-4f0d996783c6'
: MySQL error 1054: Unknown column 'produkt_tm_c' in 'field list'

[tresfx]

Hi
Thanks for your diligence and attention.
But I'm glad to tell that i found in the cache/modules/<ModuleName>/<ModuleName>vardefs.php file the problem.
I commented the key of the array that correspond to the missing column at the mysql query.
So now is working properly.

[tresfx]

I found that the cache is loading again this setting but in vardefs.php at Leads module it looks ok.The field produkt_tm_c dosent't appear. Do you have any idea where can be configured?