SHARE
TWEET

Untitled

a guest Jan 1st, 2019 79 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Database Error Code: 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 'FROM civicrm_case INNER JOIN civicrm_case_contact ON civicrm_c' at line 16, 1064
  2. Additional Details:
  3.  
  4. Array
  5. (
  6.     [callback] => Array
  7.         (
  8.             [0] => CRM_Core_Error
  9.             [1] => handle
  10.         )
  11.  
  12.     [code] => -2
  13.     [message] => DB Error: syntax error
  14.     [mode] => 16
  15.     [debug_info] => SELECT
  16. civicrm_case.id as case_id,
  17. civicrm_case.subject as case_subject,
  18. civicrm_contact.id as contact_id,
  19. civicrm_contact.sort_name as sort_name,
  20. civicrm_phone.phone as phone,
  21. civicrm_contact.contact_type as contact_type,
  22. civicrm_contact.contact_sub_type as contact_sub_type,
  23. t_act.activity_type_id,
  24. c_type.title as case_type,
  25. civicrm_case.case_type_id as case_type_id,
  26. cov_status.label as case_status,
  27. cov_status.label as case_status_name,
  28. t_act.status_id,
  29. civicrm_case.start_date as case_start_date,
  30. case_relation_type.label_b_a as case_role,  FROM civicrm_case
  31.                   INNER JOIN civicrm_case_contact ON civicrm_case.id = civicrm_case_contact.case_id
  32.                   INNER JOIN civicrm_contact ON civicrm_case_contact.contact_id = civicrm_contact.id
  33.         ON t_act.case_id = civicrm_case.id
  34.  LEFT JOIN civicrm_phone ON (civicrm_phone.contact_id = civicrm_contact.id AND civicrm_phone.is_primary=1)
  35.  LEFT JOIN civicrm_relationship case_relationship
  36.  ON ( case_relationship.contact_id_a = civicrm_case_contact.contact_id AND case_relationship.contact_id_b = Array
  37.       AND case_relationship.case_id = civicrm_case.id )
  38.  
  39.  LEFT JOIN civicrm_relationship_type case_relation_type
  40.  ON ( case_relation_type.id = case_relationship.relationship_type_id
  41.       AND case_relation_type.id = case_relationship.relationship_type_id )
  42.  
  43.  LEFT JOIN civicrm_case_type c_type
  44.  ON civicrm_case.case_type_id = c_type.id
  45.  
  46.  LEFT JOIN civicrm_option_group cog_status
  47.  ON cog_status.name = 'case_status'
  48.  
  49.  LEFT JOIN civicrm_option_value cov_status
  50.  ON ( civicrm_case.status_id = cov_status.value
  51.       AND cog_status.id = cov_status.option_group_id )
  52.  WHERE (1)  AND civicrm_case.is_deleted = 0 AND civicrm_contact.is_deleted <> 1 AND case_relationship.contact_id_b = Array   [nativecode=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 'FROM civicrm_case
  53.                   INNER JOIN civicrm_case_contact ON civicrm_c' at line 16]
  54.     [type] => DB_Error
  55.     [user_info] => SELECT
  56. civicrm_case.id as case_id,
  57. civicrm_case.subject as case_subject,
  58. civicrm_contact.id as contact_id,
  59. civicrm_contact.sort_name as sort_name,
  60. civicrm_phone.phone as phone,
  61. civicrm_contact.contact_type as contact_type,
  62. civicrm_contact.contact_sub_type as contact_sub_type,
  63. t_act.activity_type_id,
  64. c_type.title as case_type,
  65. civicrm_case.case_type_id as case_type_id,
  66. cov_status.label as case_status,
  67. cov_status.label as case_status_name,
  68. t_act.status_id,
  69. civicrm_case.start_date as case_start_date,
  70. case_relation_type.label_b_a as case_role,  FROM civicrm_case
  71.                   INNER JOIN civicrm_case_contact ON civicrm_case.id = civicrm_case_contact.case_id
  72.                   INNER JOIN civicrm_contact ON civicrm_case_contact.contact_id = civicrm_contact.id
  73.         ON t_act.case_id = civicrm_case.id
  74.  LEFT JOIN civicrm_phone ON (civicrm_phone.contact_id = civicrm_contact.id AND civicrm_phone.is_primary=1)
  75.  LEFT JOIN civicrm_relationship case_relationship
  76.  ON ( case_relationship.contact_id_a = civicrm_case_contact.contact_id AND case_relationship.contact_id_b = Array
  77.       AND case_relationship.case_id = civicrm_case.id )
  78.  
  79.  LEFT JOIN civicrm_relationship_type case_relation_type
  80.  ON ( case_relation_type.id = case_relationship.relationship_type_id
  81.       AND case_relation_type.id = case_relationship.relationship_type_id )
  82.  
  83.  LEFT JOIN civicrm_case_type c_type
  84.  ON civicrm_case.case_type_id = c_type.id
  85.  
  86.  LEFT JOIN civicrm_option_group cog_status
  87.  ON cog_status.name = 'case_status'
  88.  
  89.  LEFT JOIN civicrm_option_value cov_status
  90.  ON ( civicrm_case.status_id = cov_status.value
  91.       AND cog_status.id = cov_status.option_group_id )
  92.  WHERE (1)  AND civicrm_case.is_deleted = 0 AND civicrm_contact.is_deleted <> 1 AND case_relationship.contact_id_b = Array   [nativecode=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 'FROM civicrm_case
  93.                   INNER JOIN civicrm_case_contact ON civicrm_c' at line 16]
  94.     [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT
  95. civicrm_case.id as case_id,
  96. civicrm_case.subject as case_subject,
  97. civicrm_contact.id as contact_id,
  98. civicrm_contact.sort_name as sort_name,
  99. civicrm_phone.phone as phone,
  100. civicrm_contact.contact_type as contact_type,
  101. civicrm_contact.contact_sub_type as contact_sub_type,
  102. t_act.activity_type_id,
  103. c_type.title as case_type,
  104. civicrm_case.case_type_id as case_type_id,
  105. cov_status.label as case_status,
  106. cov_status.label as case_status_name,
  107. t_act.status_id,
  108. civicrm_case.start_date as case_start_date,
  109. case_relation_type.label_b_a as case_role,  FROM civicrm_case
  110.                   INNER JOIN civicrm_case_contact ON civicrm_case.id = civicrm_case_contact.case_id
  111.                   INNER JOIN civicrm_contact ON civicrm_case_contact.contact_id = civicrm_contact.id
  112.         ON t_act.case_id = civicrm_case.id
  113.  LEFT JOIN civicrm_phone ON (civicrm_phone.contact_id = civicrm_contact.id AND civicrm_phone.is_primary=1)
  114.  LEFT JOIN civicrm_relationship case_relationship
  115.  ON ( case_relationship.contact_id_a = civicrm_case_contact.contact_id AND case_relationship.contact_id_b = Array
  116.       AND case_relationship.case_id = civicrm_case.id )
  117.  
  118.  LEFT JOIN civicrm_relationship_type case_relation_type
  119.  ON ( case_relation_type.id = case_relationship.relationship_type_id
  120.       AND case_relation_type.id = case_relationship.relationship_type_id )
  121.  
  122.  LEFT JOIN civicrm_case_type c_type
  123.  ON civicrm_case.case_type_id = c_type.id
  124.  
  125.  LEFT JOIN civicrm_option_group cog_status
  126.  ON cog_status.name = 'case_status'
  127.  
  128.  LEFT JOIN civicrm_option_value cov_status
  129.  ON ( civicrm_case.status_id = cov_status.value
  130.       AND cog_status.id = cov_status.option_group_id )
  131.  WHERE (1)  AND civicrm_case.is_deleted = 0 AND civicrm_contact.is_deleted <> 1 AND case_relationship.contact_id_b = Array   [nativecode=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 'FROM civicrm_case
  132.                   INNER JOIN civicrm_case_contact ON civicrm_c' at line 16]"]
  133. )
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top