tests/include/database/bug_60870_text.txt

   1 Error exporting Accounts: <BR>.SELECT
   2                                 accounts.*,email_addresses.email_address email_address,
   3                                 accounts.name as account_name,
   4                                 users.user_name as assigned_user_name , teams.name AS team_name ,accounts_cstm.selected_c FROM accounts INNER JOIN (select tst.team_set_id from team_sets_teams tst INNER JOIN team_memberships team_memberships ON tst.team_id = team_memberships.team_id
   5                                         AND team_memberships.user_id = '986ab3e3-8713-1677-bd67-510c34e929a1'
   6                                         AND team_memberships.deleted=0 group by tst.team_set_id) accounts_tf on accounts_tf.team_set_id  = accounts.team_set_id LEFT JOIN users
   7                                         ON accounts.assigned_user_id=users.id  LEFT JOIN  team_sets ts ON accounts.team_set_id=ts.id  AND ts.deleted=0
   8                 LEFT JOIN  teams teams ON teams.id=ts.id AND teams.deleted=0 AND teams.deleted=0  LEFT JOIN  email_addr_bean_rel on accounts.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module='Accounts' and email_addr_bean_rel.deleted=0 and email_addr_bean_rel.primary_address=1  LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id  LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c where ( accounts.deleted IS NULL OR accounts.deleted=0 ) ORDER BY accounts.id, email_addr_bean_rel.primary_address DESC Query Failed: SELECT DISTINCT                                 accounts.*,email_addresses.email_address email_address,
   9                                 accounts.name as account_name,
  10                                 users.user_name as assigned_user_name , teams.name AS team_name ,accounts_cstm.select DISTINCT d_c FROM accounts  INNER JOIN team_sets_teams tst ON tst.team_set_id = accounts.team_set_id INNER JOIN team_memberships team_memberships ON tst.team_id = team_memberships.team_id
  11                                         AND team_memberships.user_id = '986ab3e3-8713-1677-bd67-510c34e929a1'
  12                                         AND team_memberships.deleted=0  LEFT JOIN users
  13                                         ON accounts.assigned_user_id=users.id  LEFT JOIN  team_sets ts ON accounts.team_set_id=ts.id  AND ts.deleted=0
  14                 LEFT JOIN  teams teams ON teams.id=ts.id AND teams.deleted=0 AND teams.deleted=0  LEFT JOIN  email_addr_bean_rel on accounts.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module='Accounts' and email_addr_bean_rel.deleted=0 and email_addr_bean_rel.primary_address=1  LEFT JOIN email_addresses on email_addresses.id = email_addr_bean_rel.email_address_id  LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c where ( accounts.deleted IS NULL OR accounts.deleted=0 ) ORDER BY accounts.id, email_addr_bean_rel.primary_address DESC: 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 'DISTINCT d_c FROM accounts  INNER JOIN team_sets_teams tst ON tst.team_set_id =' at line 3