Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.81 KB | None | 0 0
  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 ') AND (activity_type_value.visibility_id IS NULL OR activity_visibility_value.n' at line 38, 1064
  2. Additional Details:
  3. Array
  4. (
  5. [callback] => Array
  6. (
  7. [0] => CRM_Core_Error
  8. [1] => handle
  9. )
  10.  
  11. [code] => -2
  12. [message] => DB Error: syntax error
  13. [mode] => 16
  14. [debug_info] =>
  15. SELECT
  16. DISTINCT civicrm_activity.id AS id,
  17. civicrm_activity.`subject` AS title,
  18. civicrm_activity.`activity_date_time` AS start,
  19. activity_type_value.label AS activityType,
  20. priority_value.label AS priority,
  21. DATE_ADD(`activity_date_time`, INTERVAL COALESCE (`duration`, 15) MINUTE) AS `end`,
  22. civicrm_activity_contact.contact_id,
  23. contact.display_name,
  24. contact.contact_type,
  25. contact.image_URL
  26.  
  27. FROM `civicrm_activity`
  28.  
  29. JOIN `civicrm_activity_contact` ON civicrm_activity_contact.activity_id = civicrm_activity.id
  30. LEFT JOIN `civicrm_case_activity` ON civicrm_case_activity.activity_id = civicrm_activity.id
  31. LEFT JOIN `civicrm_option_group` AS priority_group ON priority_group.name = "priority"
  32. LEFT JOIN `civicrm_option_value` AS priority_value
  33. ON (priority_value.option_group_id = priority_group.id AND civicrm_activity.priority_id = priority_value.value)
  34.  
  35. LEFT JOIN `civicrm_option_group` AS activity_type_group ON activity_type_group.name = "activity_type"
  36. LEFT JOIN `civicrm_option_value` AS activity_type_value
  37. ON (activity_type_value.option_group_id = activity_type_group.id AND civicrm_activity.activity_type_id = activity_type_value.value )
  38.  
  39. LEFT JOIN `civicrm_option_group` AS activity_visibility_group ON activity_visibility_group.name = "activity_visibility"
  40. LEFT JOIN `civicrm_option_value` AS activity_visibility_value
  41. ON (activity_visibility_value.option_group_id = activity_visibility_group.id AND activity_visibility_value.value = activity_type_value.visibility_id)
  42.  
  43. LEFT JOIN civicrm_contact AS contact
  44. ON contact.id = civicrm_activity_contact.contact_id
  45. WHERE TRUE
  46. AND civicrm_activity_contact.contact_id IN (2)
  47. AND civicrm_activity.is_deleted = 0
  48. AND civicrm_activity.activity_date_time
  49. BETWEEN "1970-01-01 00:00:00"
  50. AND "1970-01-01 00:00:00"
  51. AND civicrm_case_activity.activity_id IS NULL
  52. AND civicrm_activity.activity_type_id NOT IN () AND (activity_type_value.visibility_id IS NULL OR activity_visibility_value.name = "visibility") [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 ') AND (activity_type_value.visibility_id IS NULL OR activity_visibility_value.n' at line 38]
  53. [type] => DB_Error
  54. [user_info] =>
  55. SELECT
  56. DISTINCT civicrm_activity.id AS id,
  57. civicrm_activity.`subject` AS title,
  58. civicrm_activity.`activity_date_time` AS start,
  59. activity_type_value.label AS activityType,
  60. priority_value.label AS priority,
  61. DATE_ADD(`activity_date_time`, INTERVAL COALESCE (`duration`, 15) MINUTE) AS `end`,
  62. civicrm_activity_contact.contact_id,
  63. contact.display_name,
  64. contact.contact_type,
  65. contact.image_URL
  66.  
  67. FROM `civicrm_activity`
  68.  
  69. JOIN `civicrm_activity_contact` ON civicrm_activity_contact.activity_id = civicrm_activity.id
  70. LEFT JOIN `civicrm_case_activity` ON civicrm_case_activity.activity_id = civicrm_activity.id
  71. LEFT JOIN `civicrm_option_group` AS priority_group ON priority_group.name = "priority"
  72. LEFT JOIN `civicrm_option_value` AS priority_value
  73. ON (priority_value.option_group_id = priority_group.id AND civicrm_activity.priority_id = priority_value.value)
  74.  
  75. LEFT JOIN `civicrm_option_group` AS activity_type_group ON activity_type_group.name = "activity_type"
  76. LEFT JOIN `civicrm_option_value` AS activity_type_value
  77. ON (activity_type_value.option_group_id = activity_type_group.id AND civicrm_activity.activity_type_id = activity_type_value.value )
  78.  
  79. LEFT JOIN `civicrm_option_group` AS activity_visibility_group ON activity_visibility_group.name = "activity_visibility"
  80. LEFT JOIN `civicrm_option_value` AS activity_visibility_value
  81. ON (activity_visibility_value.option_group_id = activity_visibility_group.id AND activity_visibility_value.value = activity_type_value.visibility_id)
  82.  
  83. LEFT JOIN civicrm_contact AS contact
  84. ON contact.id = civicrm_activity_contact.contact_id
  85. WHERE TRUE
  86. AND civicrm_activity_contact.contact_id IN (2)
  87. AND civicrm_activity.is_deleted = 0
  88. AND civicrm_activity.activity_date_time
  89. BETWEEN "1970-01-01 00:00:00"
  90. AND "1970-01-01 00:00:00"
  91. AND civicrm_case_activity.activity_id IS NULL
  92. AND civicrm_activity.activity_type_id NOT IN () AND (activity_type_value.visibility_id IS NULL OR activity_visibility_value.name = "visibility") [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 ') AND (activity_type_value.visibility_id IS NULL OR activity_visibility_value.n' at line 38]
  93. [to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::handle prefix="" info="
  94. SELECT
  95. DISTINCT civicrm_activity.id AS id,
  96. civicrm_activity.`subject` AS title,
  97. civicrm_activity.`activity_date_time` AS start,
  98. activity_type_value.label AS activityType,
  99. priority_value.label AS priority,
  100. DATE_ADD(`activity_date_time`, INTERVAL COALESCE (`duration`, 15) MINUTE) AS `end`,
  101. civicrm_activity_contact.contact_id,
  102. contact.display_name,
  103. contact.contact_type,
  104. contact.image_URL
  105.  
  106. FROM `civicrm_activity`
  107.  
  108. JOIN `civicrm_activity_contact` ON civicrm_activity_contact.activity_id = civicrm_activity.id
  109. LEFT JOIN `civicrm_case_activity` ON civicrm_case_activity.activity_id = civicrm_activity.id
  110. LEFT JOIN `civicrm_option_group` AS priority_group ON priority_group.name = "priority"
  111. LEFT JOIN `civicrm_option_value` AS priority_value
  112. ON (priority_value.option_group_id = priority_group.id AND civicrm_activity.priority_id = priority_value.value)
  113.  
  114. LEFT JOIN `civicrm_option_group` AS activity_type_group ON activity_type_group.name = "activity_type"
  115. LEFT JOIN `civicrm_option_value` AS activity_type_value
  116. ON (activity_type_value.option_group_id = activity_type_group.id AND civicrm_activity.activity_type_id = activity_type_value.value )
  117.  
  118. LEFT JOIN `civicrm_option_group` AS activity_visibility_group ON activity_visibility_group.name = "activity_visibility"
  119. LEFT JOIN `civicrm_option_value` AS activity_visibility_value
  120. ON (activity_visibility_value.option_group_id = activity_visibility_group.id AND activity_visibility_value.value = activity_type_value.visibility_id)
  121.  
  122. LEFT JOIN civicrm_contact AS contact
  123. ON contact.id = civicrm_activity_contact.contact_id
  124. WHERE TRUE
  125. AND civicrm_activity_contact.contact_id IN (2)
  126. AND civicrm_activity.is_deleted = 0
  127. AND civicrm_activity.activity_date_time
  128. BETWEEN "1970-01-01 00:00:00"
  129. AND "1970-01-01 00:00:00"
  130. AND civicrm_case_activity.activity_id IS NULL
  131. AND civicrm_activity.activity_type_id NOT IN () AND (activity_type_value.visibility_id IS NULL OR activity_visibility_value.name = "visibility") [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 ') AND (activity_type_value.visibility_id IS NULL OR activity_visibility_value.n' at line 38]"]
  132. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement