SHARE
TWEET

Untitled

a guest Jun 18th, 2019 61 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 ') 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. )
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