Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sep 02 03:42:38 [info] $Fatal Error Details = Array
- (
- [callback] => Array
- (
- [0] => CRM_Core_Error
- [1] => handle
- )
- [code] => -19
- [message] => DB Error: no such field
- [mode] => 16
- [debug_info] => SELECT a.status_id as status, count(*) as count FROM civicrm_contact c
- JOIN civicrm_email email ON email.contact_id = c.id and email.is_primary = 1
- JOIN civicrm_activity_contact ac_o ON ac_o.contact_id = c.id
- JOIN civicrm_activity a ON ac_o.activity_id = a.id
- JOIN civicrm_activity_contact ac_a ON ac_a.activity_id = a.id
- WHERE ac_o.record_type_id = 3
- AND ac_a.record_type_id = 1
- AND iac_a.contact_id = 8990
- GROUP BY a.status_id; [nativecode=1054 ** Unknown column 'iac_a.contact_id' in 'where clause']
- [type] => DB_Error
- [user_info] => SELECT a.status_id as status, count(*) as count FROM civicrm_contact c
- JOIN civicrm_email email ON email.contact_id = c.id and email.is_primary = 1
- JOIN civicrm_activity_contact ac_o ON ac_o.contact_id = c.id
- JOIN civicrm_activity a ON ac_o.activity_id = a.id
- JOIN civicrm_activity_contact ac_a ON ac_a.activity_id = a.id
- WHERE ac_o.record_type_id = 3
- AND ac_a.record_type_id = 1
- AND iac_a.contact_id = 8990
- GROUP BY a.status_id; [nativecode=1054 ** Unknown column 'iac_a.contact_id' in 'where clause']
- [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
- JOIN civicrm_email email ON email.contact_id = c.id and email.is_primary = 1
- JOIN civicrm_activity_contact ac_o ON ac_o.contact_id = c.id
- JOIN civicrm_activity a ON ac_o.activity_id = a.id
- JOIN civicrm_activity_contact ac_a ON ac_a.activity_id = a.id
- WHERE ac_o.record_type_id = 3
- AND ac_a.record_type_id = 1
- AND iac_a.contact_id = 8990
- GROUP BY a.status_id; [nativecode=1054 ** Unknown column 'iac_a.contact_id' in 'where clause']"]
- )
- 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)
- #1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
- #2 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
- #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 ...")
- #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 ...")
- #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)
- #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'")
- #7 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
- #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 ...")
- #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 ...")
- #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 ...")
- #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 ...")
- #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)
- #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 ...")
- #14 /Users/jameslimpiado/Documents/james/projects/hy/sites/all/modules/hy_training_program/interviewees/interviewees_controller.php(9): get_interviewees(NULL, 1, 1)
- #15 [internal function](): list_interviewees()
- #16 /Users/jameslimpiado/Documents/james/projects/hy/includes/menu.inc(517): call_user_func_array("list_interviewees", (Array:0))
- #17 /Users/jameslimpiado/Documents/james/projects/hy/index.php(23): menu_execute_active_handler()
- #18 {main}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement