Error 1146: Table 'sugarcrm.TABLE_cstm' doesn't exist

[ftorres]

Hello.

I'm having problems with the popular error 1146. I did a search but I don't find any info with my particular problem. I'm using Version 6.0.1 (Build 4143) and the data is from version 4.5.1. This error started with the Targets table. Then I google the error and the recommendations where to make a rebuilt. After the rebuilt other errors started to come up. For example...

error 1146: Table 'sugarcrm.leads_cstm' doesn't exist
Retrieving record by id leads:bda6c9f1-fcf1-b74b-c27d-4cbc5c9865e1 found Query Failed:SELECT leads.*,leads_cstm.* FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c WHERE leads.id = 'bda6c9f1-fcf1-b74b-c27d-4cbc5c9865e1' AND leads.deleted=0 LIMIT 0,1::MySQL error 1146: Table 'sugarcrm.leads_cstm' doesn't exist

error 1146: Table 'sugarcrm.prospects_cstm' doesn't exist
Error retrieving ProspectList list: Query Failed (SELECT prospects.id , prospects_cstm.sic_code_c, prospects_cstm.line_of_business_c, prospects_cstm.sales_volume_c, prospects_cstm.employees_c, prospects.first_name , prospects.last_name , CONCAT(IFNULL(prospects.first_name,''),' ',IFNULL(prospects.last_name,'')) as full_name, prospects.title , prospects.phone_work , prospects.assigned_user_id , 'prospects' panel_name FROM prospects LEFT JOIN prospects_cstm ON prospects.id = prospects_cstm.id_c INNER JOIN prospect_lists_prospects ON (prospects.id=prospect_lists_prospects.related_id AND prospect_lists_prospects.prospect_list_id= '250ec7fb-32b8-6443-79ba-45894ef055b5' AND prospect_lists_prospects.related_type='Prospects') where ( prospect_lists_prospects.deleted=0 AND prospects.deleted=0) AND prospects.deleted=0) ORDER BY prospects.last_name asc LIMIT 0,10::MySQL error 1146: Table 'sugarcrm.prospects_cstm' doesn't exist


I have installed several SugarCRM versions and on the DB none have tables with the name *_cstm...

[internete]

I am receiving same error message after an upgrade. Also, all leads are not showing up although these are in the leads table.

.leads_cstm' doesn't exist

Please let us know what needs to be done.

[davidboris]

Hello,

It seems you have traces of custom fields created for leads module in fields_meta_data. To check that

 SELECT * FROM  `fields_meta_data` WHERE  `custom_module` =  'Leads'; 
  

If you have fields and dont need them, mark it as deleted. And if you need those fields, create leads_cstm table and create those fields.