Advertisement
Guest User

Untitled

a guest
Sep 2nd, 2015
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.35 KB | None | 0 0
  1. Sep 02 03:42:38 [info] $Fatal Error Details = Array
  2. (
  3. [callback] => Array
  4. (
  5. [0] => CRM_Core_Error
  6. [1] => handle
  7. )
  8.  
  9. [code] => -19
  10. [message] => DB Error: no such field
  11. [mode] => 16
  12. [debug_info] => SELECT a.status_id as status, count(*) as count FROM civicrm_contact c
  13. JOIN civicrm_email email ON email.contact_id = c.id and email.is_primary = 1
  14. JOIN civicrm_activity_contact ac_o ON ac_o.contact_id = c.id
  15. JOIN civicrm_activity a ON ac_o.activity_id = a.id
  16. JOIN civicrm_activity_contact ac_a ON ac_a.activity_id = a.id
  17. WHERE ac_o.record_type_id = 3
  18. AND ac_a.record_type_id = 1
  19. AND iac_a.contact_id = 8990
  20.  
  21. GROUP BY a.status_id; [nativecode=1054 ** Unknown column 'iac_a.contact_id' in 'where clause']
  22. [type] => DB_Error
  23. [user_info] => SELECT a.status_id as status, count(*) as count FROM civicrm_contact c
  24. JOIN civicrm_email email ON email.contact_id = c.id and email.is_primary = 1
  25. JOIN civicrm_activity_contact ac_o ON ac_o.contact_id = c.id
  26. JOIN civicrm_activity a ON ac_o.activity_id = a.id
  27. JOIN civicrm_activity_contact ac_a ON ac_a.activity_id = a.id
  28. WHERE ac_o.record_type_id = 3
  29. AND ac_a.record_type_id = 1
  30. AND iac_a.contact_id = 8990
  31.  
  32. GROUP BY a.status_id; [nativecode=1054 ** Unknown column 'iac_a.contact_id' in 'where clause']
  33. [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT a.status_id as status, count(*) as count FROM civicrm_contact c
  34. JOIN civicrm_email email ON email.contact_id = c.id and email.is_primary = 1
  35. JOIN civicrm_activity_contact ac_o ON ac_o.contact_id = c.id
  36. JOIN civicrm_activity a ON ac_o.activity_id = a.id
  37. JOIN civicrm_activity_contact ac_a ON ac_a.activity_id = a.id
  38. WHERE ac_o.record_type_id = 3
  39. AND ac_a.record_type_id = 1
  40. AND iac_a.contact_id = 8990
  41.  
  42. GROUP BY a.status_id; [nativecode=1054 ** Unknown column 'iac_a.contact_id' in 'where clause']"]
  43. )
  44.  
  45.  
  46. Sep 02 03:42:38 [info] $backTrace = #0 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/CRM/Core/Error.php(197): CRM_Core_Error::backtrace("backTrace", TRUE)
  47. #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
  48. #2 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
  49. #3 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "SELECT a.status_id as status, count(*) as count FROM civicrm_contact c\n ...")
  50. #4 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "SELECT a.status_id as status, count(*) as count FROM civicrm_contact c\n ...")
  51. #5 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "SELECT a.status_id as status, count(*) as count FROM civicrm_contact c\n ...", "DB_Error", TRUE)
  52. #6 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'iac_a.contact_id' in 'where clause'")
  53. #7 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
  54. #8 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT a.status_id as status, count(*) as count FROM civicrm_contact c\n ...")
  55. #9 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("SELECT a.status_id as status, count(*) as count FROM civicrm_contact c\n ...")
  56. #10 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("SELECT a.status_id as status, count(*) as count FROM civicrm_contact c\n ...")
  57. #11 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/CRM/Core/DAO.php(160): DB_DataObject->query("SELECT a.status_id as status, count(*) as count FROM civicrm_contact c\n ...")
  58. #12 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/CRM/Core/DAO.php(907): CRM_Core_DAO->query("SELECT a.status_id as status, count(*) as count FROM civicrm_contact c\n ...", TRUE)
  59. #13 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/hy_training_program/interviewees/interviewees_controller.php(63): CRM_Core_DAO::executeQuery("SELECT a.status_id as status, count(*) as count FROM civicrm_contact c\n ...")
  60. #14 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/hy_training_program/interviewees/interviewees_controller.php(9): get_interviewees(NULL, 1, 1)
  61. #15 [internal function](): list_interviewees()
  62. #16 /Users/jameslimpiado/Documents/james/projects/hy/includes/menu.inc(517): call_user_func_array("list_interviewees", (Array:0))
  63. #17 /Users/jameslimpiado/Documents/james/projects/hy/index.php(23): menu_execute_active_handler()
  64. #18 {main}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement