AnsweredAssumed Answered

Unknown column error in custom module search engine

Question asked by ikeith ikeith on Nov 19, 2014
Latest reply on Sep 18, 2017 by Asaf Army
Does anyone encounter this? Please let me know there's an error in sugarcrm.log

Thu Nov 20 11:09:15 2014 [31358][2][FATAL]  Query Failed:  SELECT  job_purchase_orders.id ,job_purchase_orders_cstm.total_inc_tax_c,job_purchase_orders_cstm.reference_c,job_purchase_orders_cstm.po_sent_c,job_purchase_orders_cstm.po_viewed_c, job_purchase_orders.account_id_c, jt0.name supplier , job_purchase_orders.name , job_purchase_orders.job_jobs_id_c, jt1.name job , job_purchase_orders.po_date , job_purchase_orders.total , job_purchase_orders.total_billed , job_purchase_orders.total_remaining , job_purchase_orders.required_by  , LTRIM(RTRIM(CONCAT(IFNULL(jt2.first_name,''),' ',IFNULL(jt2.last_name,'')))) created_by_name , jt2.created_by created_by_name_owner  , 'Users' created_by_name_mod, job_purchase_orders.actions , job_purchase_orders.assigned_user_id  , sfav.id is_favorite  FROM job_purchase_orders  LEFT JOIN job_purchase_orders_cstm ON job_purchase_orders.id = job_purchase_orders_cstm.id_c  LEFT JOIN accounts jt0 ON job_purchase_orders.account_id_c = jt0.id AND jt0.deleted=0  LEFT JOIN job_jobs jt1 ON job_purchase_orders.job_jobs_id_c = jt1.id AND jt1.deleted=0   LEFT JOIN  users jt2 ON job_purchase_orders.created_by=jt2.id AND jt2.deleted=0



 AND jt2.deleted=0 LEFT JOIN  sugarfavorites sfav ON sfav.module ='job_purchase_orders' AND sfav.record_id=job_purchase_orders.id AND sfav.created_by='2' AND sfav.deleted=0  where ((jt1.name_purchase_orders.name like '0%')) AND job_purchase_orders.deleted=0 ORDER BY supplier ASC LIMIT 0,51: MySQL error 1054: Unknown column 'jt1.name_purchase_orders.name' in 'where clause'

All fields in the search are not working, but it work recently,
try to repair and rebuild and repair relationship, chown. but it still don't work.

Outcomes