GBlack does not have any add-ons for sale.

• Searching Field Status

  Support January 19th, 2022 @ 9:50 am
  

  Hi , I installed this plugin and its failing in serching tasks.

  ERROR: Query Failed: ( SELECT count(*) c FROM tasks LEFT JOIN tasks_cstm ON tasks.id = tasks_cstm.id_c INNER JOIN ssi_vessels_tasks_1_c ON tasks.id=ssi_vessels_tasks_1_c.ssi_vessels_tasks_1tasks_idb AND ssi_vessels_tasks_1_c.ssi_vessels_tasks_1ssi_vessels_ida='2dd4dd60-6d11-99bf-fbc5-5f7736b86d85' AND ssi_vessels_tasks_1_c.deleted=0

  where ( tasks_cstm.service_status_c NOT IN ('Complete') AND tasks.id IN (SELECT tasks.id FROM tasks LEFT JOIN tasks_cstm ON tasks.id = tasks_cstm.id_c LEFT JOIN ssi_vessels_tasks_1_c jtl0 ON tasks.id=jtl0.ssi_vessels_tasks_1tasks_idb AND jtl0.deleted=0

  LEFT JOIN ssi_vessels jt0 ON jt0.id=jtl0.ssi_vessels_tasks_1ssi_vessels_ida AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN ssi_vendors_tasks_1_c jtl1 ON tasks.id=jtl1.ssi_vendors_tasks_1tasks_idb AND jtl1.deleted=0

  LEFT JOIN ssi_vendors jt1 ON jt1.id=jtl1.ssi_vendors_tasks_1ssi_vendors_ida AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN users jt2 ON tasks.assigned_user_id=jt2.id AND jt2.deleted=0

  AND jt2.deleted=0 where (((tasks.name like 'salt%' ) OR ( tasks.name like '%salt%' ) OR ( tasks.name like '%salt' ) OR ( ( contacts.first_name like 'salt%' OR contacts.last_name like 'salt%' ) ) OR ( ( contacts.first_name like '%salt%' OR contacts.last_name like '%salt%' ) ) OR ( ( contacts.first_name like '%salt' OR contacts.last_name like '%salt' ) ) OR ( tasks.date_entered LIKE 'salt%' ) OR ( tasks.date_entered LIKE '%salt' ) OR ( tasks.date_modified LIKE 'salt%' ) OR ( tasks.date_modified LIKE '%salt' ) OR ( tasks.modified_user_id LIKE 'salt%' ) OR ( tasks.modified_user_id LIKE '%salt' ) OR ( tasks.created_by LIKE 'salt%' ) OR ( tasks.created_by LIKE '%salt' ) OR ( tasks.description LIKE 'salt%' ) OR ( tasks.description LIKE '%salt' ) OR ( tasks.assigned_user_id LIKE 'salt%' ) OR ( tasks.assigned_user_id LIKE '%salt' ) OR ( tasks.status LIKE 'salt%' ) OR ( tasks.status LIKE '%salt' ) OR ( tasks.date_due LIKE 'salt%' ) OR ( tasks.date_due LIKE '%salt' ) OR ( tasks.date_start LIKE 'salt%' ) OR ( tasks.date_start LIKE '%salt' ) OR ( tasks.parent_type LIKE 'salt%' ) OR ( tasks.parent_type LIKE '%salt' ) OR ( tasks.priority LIKE 'salt%' ) OR ( tasks.priority LIKE '%salt' ) OR ( tasks.rt_list_id LIKE 'salt%' ) OR ( tasks.rt_list_id LIKE '%salt' ) OR ( tasks.calendar_id_c LIKE 'salt%' ) OR ( tasks.calendar_id_c LIKE '%salt' ) OR ( tasks.rt_gtask_id LIKE 'salt%' ) OR ( tasks.rt_gtask_id LIKE '%salt' ) OR ( tasks.rt_gtask_parentid LIKE 'salt%' ) OR ( tasks.rt_gtask_parentid LIKE '%salt' ) OR ( tasks.rt_list_name LIKE 'salt%' ) OR ( tasks.rt_list_name LIKE '%salt' ) OR ( tasks.rt_gevent_id LIKE 'salt%' ) OR ( tasks.rt_gevent_id LIKE '%salt' ) OR ( tasks.rt_calendar_type LIKE 'salt%' ) OR ( tasks.rt_calendar_type LIKE '%salt' ) OR ( tasks_cstm.billing_c LIKE 'salt%' ) OR ( tasks_cstm.billing_c LIKE '%salt' ) OR ( tasks_cstm.service_status_c LIKE 'salt%' ) OR ( tasks_cstm.service_status_c LIKE '%salt' ) OR ( tasks_cstm.owners_comments_c LIKE 'salt%' ) OR ( tasks_cstm.owners_comments_c LIKE '%salt' ) OR ( tasks_cstm.service_notes_c LIKE 'salt%' ) OR ( tasks_cstm.service_notes_c LIKE '%salt' ) OR ( tasks_cstm.service_type_c LIKE 'salt%' ) OR ( tasks_cstm.service_type_c LIKE '%salt' ) OR ( tasks_cstm.type_c LIKE 'salt%' ) OR ( tasks_cstm.type_c LIKE '%salt' ) OR ( tasks_cstm.service_id_number_c LIKE 'salt%' ) OR ( tasks_cstm.service_id_number_c LIKE '%salt'))) AND tasks.deleted=0 ) ) AND tasks.deleted=0 ): MySQL error 1054: Unknown column 'contacts.first_name' in 'where clause'

  View Comment
  
  

GBlack has not rated any add-ons.

GBlack has not verified any add-ons.

GBlack has not created any Wanted Add-ons.