AnsweredAssumed Answered

Error retrieving Account list via API

Question asked by Pavel Isakov on May 6, 2015
Latest reply on Aug 22, 2015 by sanjaycrm
Error appear when we try to get list of accounts using API

Fri May  1 12:28:08 2015 [2139][24a86274-65c5-8d18-a9cc-522879c58fea][FATAL] Error retrieving Account list:  Query Failed:  SELECT  accounts.* ,accounts_cstm.business_development_manager_c,accounts_cstm.account_manager_c,accounts_cstm.services_c,accounts_cstm.mvp_c,accounts_cstm.billing_email_address_c,accounts_cstm.billing_instructions_c,accounts_cstm.bill_rate_c,accounts_cstm.mvp_account_manager_c,accounts_cstm.contactmap_c,accounts_cstm.mvpversion_c,accounts_cstm.specialinstructions_c,accounts_cstm.mvpedition_c,accounts_cstm.mvpgolive_c,accounts_cstm.annualcontractvalue_c,accounts_cstm.notes_c,accounts_cstm.contractterm_c,accounts_cstm.contractexpiration_c,accounts_cstm.contract_alert_date_c,accounts_cstm.billingfrequency_c,accounts_cstm.nextinvoicedue_c,accounts_cstm.invoicingresponsibility_c,accounts_cstm.mvpcontact_c,accounts_cstm.date_created_c,accounts_cstm.currency_id, jt0.first_name rel_modified_by_name_first_name, jt0.last_name rel_modified_by_name_last_name, jt0.last_name modified_by_name , jt0.created_by modified_by_name_owner  , 'Users' modified_by_name_mod, jt1.first_name rel_created_by_name_first_name, jt1.last_name rel_created_by_name_last_name, jt1.last_name created_by_name , jt1.created_by created_by_name_owner  , 'Users' created_by_name_mod, jt2.first_name rel_assigned_user_name_first_name, jt2.last_name rel_assigned_user_name_last_name, jt2.last_name assigned_user_name , jt2.created_by assigned_user_name_owner  , 'Users' assigned_user_name_mod , ts1.created_by team_count_owner  , 'Teams' team_count_mod, tj.name team_name , tj.created_by team_name_owner  , 'Teams' team_name_mod, jt5.name parent_name , jt5.assigned_user_id parent_name_owner  , 'Accounts' parent_name_mod, jt6.name campaign_name , jt6.assigned_user_id campaign_name_owner  , 'Campaigns' campaign_name_mod, '                                                                                                                                                                                                                                                              ' contacts_accounts_1_name , LTRIM(RTRIM(CONCAT(IFNULL(accounts.first_name,''),' ',IFNULL(accounts.last_name,'')))) as contacts_accounts_1contacts_ida FROM accounts  LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c   LEFT JOIN  users jt0 ON accounts.modified_user_id=jt0.id AND jt0.deleted=0

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

 

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

 

AND jt2.deleted=0  LEFT JOIN  team_sets ts1 ON accounts.team_set_id=ts1.id AND ts1.deleted=0

 

AND ts1.deleted=0  LEFT JOIN  teams tj ON accounts.team_id=tj.id AND tj.deleted=0

 

AND tj.deleted=0  LEFT JOIN  accounts jt5 ON accounts.parent_id=jt5.id AND jt5.deleted=0

 

AND jt5.deleted=0  LEFT JOIN  campaigns jt6 ON accounts.campaign_id=jt6.id AND jt6.deleted=0

 

AND jt6.deleted=0 where accounts.deleted=0 LIMIT 0,101: MySQL error 1054: Unknown column 'accounts.first_name' in 'field list'

Outcomes