API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 1st, 2019
160
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.67 KB | None | 0 0
raw download clone embed print report
  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. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!