Please,help find where is SQL syntax error

Please, help me to find syntax error in SQL generated after calling get_full_list method. Here is my SQL

Query Failed:  SELECT  cases.* ,cases_cstm.phone_c,cases_cstm.biz_email_c,cases_cstm.processor_address_c,cases_cstm.funder_dba_name_c,cases_cstm.case_state_c,cases_cstm.note_name_c,cases_cstm.reminder_descr_c,cases_cstm.plaint_affid_title_c,cases_cstm.judg_amount_less_pay_c,cases_cstm.county_of_filing_c,cases_cstm.date_of_judgement_c,cases_cstm.duplicate_name_c,cases_cstm.date_of_default_c,cases_cstm.merchant_zip_c,cases_cstm.ftid_c,cases_cstm.sender_phone_c,cases_cstm.delivery_method_c,cases_cstm.merchant_id_c,cases_cstm.ssn_c,cases_cstm.business_name_abbr_c,cases_cstm.attorney_name_c,cases_cstm.note_descr_c,cases_cstm.merchant_address_c,cases_cstm.jjwg_maps_lng_c,cases_cstm.owner_state_c,cases_cstm.created_by_contact_c,cases_cstm.legal_fee_prcnt_c,cases_cstm.bank_department_c,cases_cstm.payback_amount_c,cases_cstm.owed_c,cases_cstm.leg_fee_written_c,cases_cstm.funder_abbr_c,cases_cstm.jjwg_maps_lat_c,cases_cstm.advance_amount_c,cases_cstm.jjwg_address_cache_id_c,cases_cstm.bank_city_zip_c,cases_cstm.merchant_city_c,cases_cstm.five_days_after_today_c,cases_cstm.jjwg_maps_geocode_status_c,cases_cstm.turn_stale_case_c,cases_cstm.plaint_affid_county_c,cases_cstm.bal_with_fees_c,cases_cstm.bank_name_c,cases_cstm.method_of_submission_c,cases_cstm.tot_pay_rcvd_c,cases_cstm.owner_name_c,cases_cstm.plaint_affid_signer_c,cases_cstm.merch_agree_date_c,cases_cstm.curr_date_c,cases_cstm.file_names_c,cases_cstm.sender_name_c,cases_cstm.rtr_c,cases_cstm.plaint_address_c,cases_cstm.jjwg_maps_address_c,cases_cstm.reminder_switcher_c,cases_cstm.coj_date_c,cases_cstm.judg_amount_c,cases_cstm.owner_address_c,cases_cstm.default_fee_c,cases_cstm.owner_name_abbr_c,cases_cstm.sender_email_c,cases_cstm.amount_purchased_c,cases_cstm.merchant_state_c,cases_cstm.case_reminder_c,cases_cstm.plaint_affid_state_c,cases_cstm.duplicate_number_c,cases_cstm.index_number_c,cases_cstm.merchant_dba_name_c,cases_cstm.bank_str_address_c,cases_cstm.legal_fee_calc_c , jt0.user_name modified_by_name , jt0.created_by modified_by_name_owner  , 'Users' modified_by_name_mod , jt1.user_name created_by_name , jt1.created_by created_by_name_owner  , 'Users' created_by_name_mod , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner  , 'Users' assigned_user_name_mod , accounts.name account_name , accounts.assigned_user_id account_name_owner  , 'Accounts' account_name_mod, jt4.name processor_name_c , '                                                                                                                                                                                                                                                              ' cases_cases_1_name , '                                    '  cases_cases_1cases_idb  FROM cases  LEFT JOIN cases_cstm ON cases.id = cases_cstm.id_c   LEFT JOIN  users jt0 ON cases.modified_user_id=jt0.id AND jt0.deleted=0

 AND jt0.deleted=0  LEFT JOIN  users jt1 ON cases.created_by=jt1.id AND jt1.deleted=0

 AND jt1.deleted=0  LEFT JOIN  users jt2 ON cases.assigned_user_id=jt2.id AND jt2.deleted=0

 AND jt2.deleted=0  LEFT JOIN  accounts accounts ON cases.account_id=accounts.id AND accounts.deleted=0

 AND accounts.deleted=0 LEFT JOIN accounts jt4 ON cases_cstm. = jt4.id AND jt4.deleted=0  where (cases.date_modified <= '2016-10-29 13:29:01' AND cases_cstm.case_state_c <> 'Duplicate' AND cases_cstm.case_state_c <> 'Declined' AND cases_cstm.case_state_c <> 'Returned' AND cases_cstm.case_state_c <> 'Bankruptcy' AND cases_cstm.case_state_c <> 'Payment_Plan' AND cases_cstm.case_state_c <> 'Local_Counsel' AND cases.state = 'Open') AND cases.deleted=0: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= jt4.id AND jt4.deleted=0  where (cases.date_modified <= '2016-10-29 13:29:01' ' at line 9
AND accounts.deleted=0 LEFT JOIN accounts jt4 ON cases_cstm. = jt4.id AND jt4.deleted=0  where (cases.date_modified 

look like it could be a missing configuration on a custom Accounts relationship with Cases??

1 Like

Yes, now i see the problem! Thank you! This code is generated by CRM when i use get_full_list method to find all cases. So how i can fix this issue?Please, help