Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Won't Do
-
Affects Version/s: HR-1.2
-
Fix Version/s: None
-
Component/s: Jobs
-
Labels:None
Description
Unable to save mandatory job details - screen freezes with a DB error message (see screenshot).
Backlog report:
$backTrace =
#0 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/CRM/Core/Error.php(770): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "INSERT INTO civicrm_hrjob (contact_id , position , title , is_tied_to_funding...")
#4 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "INSERT INTO civicrm_hrjob (contact_id , position , title , is_tied_to_funding...")
#5 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "INSERT INTO civicrm_hrjob (contact_id , position , title , is_tied_to_funding...", "DB_Error", TRUE)
#6 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'notice_amount' in 'field list'")
#7 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("INSERT INTO civicrm_hrjob (contact_id , position , title , is_tied_to_funding...")
#9 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("INSERT INTO civicrm_hrjob (contact_id , position , title , is_tied_to_funding...")
#10 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(1055): DB_DataObject->_query("INSERT INTO civicrm_hrjob (contact_id , position , title , is_tied_to_funding...")
#11 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/CRM/Core/DAO.php(278): DB_DataObject->insert()
#12 /var/www/civihr.farmafrica.org/httpdocs/sites/all/extensions/civihr/hrjob/CRM/HRJob/BAO/HRJob.php(48): CRM_Core_DAO->save()
#13 [internal function](): CRM_HRJob_BAO_HRJob::create((Array:19))
#14 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/api/v3/utils.php(1047): call_user_func_array((Array:2), (Array:1))
#15 /var/www/civihr.farmafrica.org/httpdocs/sites/all/extensions/civihr/hrjob/api/v3/HRJob.php(49): _civicrm_api3_basic_create("CRM_HRJob_BAO_HRJob", (Array:19))
#16 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/api/api.php(87): civicrm_api3_h_r_job_create((Array:19))
#17 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/CRM/Utils/REST.php(360): civicrm_api("HRJob", "create", (Array:19))
#18 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/CRM/Utils/REST.php(593): CRM_Utils_REST::process((Array:3), (Array:17))
#19 [internal function](): CRM_Utils_REST::ajax((Array:3))
#20 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(289): call_user_func((Array:2), (Array:3))
#21 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:12))
#22 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#23 /var/www/civihr.farmafrica.org/httpdocs/sites/all/modules/civicrm/drupal/civicrm.module(456): CRM_Core_Invoke::invoke((Array:3))
#24 [internal function](): civicrm_invoke("ajax", "rest")
#25 /var/www/civihr.farmafrica.org/httpdocs/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:2))
#26 /var/www/civihr.farmafrica.org/httpdocs/index.php(21): menu_execute_active_handler()
#27
Additional detail:
The Installation step has done.
Firstly, the site was CiviCRM 4.4.4 with CiviHR 1.2 beta.
Then I upgraded CiviHR to 1.2 stable by without notice of CiviHR 1.2 stable need CiviCRM 4.4.5.
Then lastly I upgraded CiviCRM 4.4.4 to 4.4.5.
The error happens after then.
Chanun Chirattikanon
On behalf of Compucorp Ltd.