ihris-manage-cssc

Employment id issue not saving when you add new Emplyment Id(Check Number and Personal File number) in 4.0.18

Bug #893246 reported by josephat mathayo
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
ihris-manage-cssc
New
Undecided
Unassigned

Bug Description

  iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
 Error getting ids for form employmentid as a child of person|8527@eastern::
 MDB2 Error: syntax error
 _doQuery: [Error message: Could not execute statement]
 [Last executed query: SELECT SQL_CALC_FOUND_ROWS id AS `id` FROM ( SELECT r.id AS id, CONCAT(r.parent_form,'|',r.parent_id) AS parent FROM record r WHERE (( r.form = 58 ) AND (r.parent_form = 'person' AND r.parent_id = 8527@eastern))) AS `employmentid` LIMIT 1]
 [Native code: 1064]
 [Native message: 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 '@eastern))) AS `employmentid` LIMIT 1' at line 1]
Write failed: Broken pipe
limi@limi:~$ ssh hris@196.43.81.171
hris@196.43.81.171's password:
Linux hris 2.6.28-19-server #66-Ubuntu SMP Sat Oct 16 18:11:06 UTC 2010 x86_64

The programs included with the Ubuntu system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by
applicable law.

To access official Ubuntu documentation, please visit:
http://help.ubuntu.com/

  System information as of Mon Nov 21 21:20:01 EAT 2011

  System load: 0.0 Processes: 100
  Usage of /: 4.7% of 70.69GB Users logged in: 1
  Memory usage: 45% IP address for eth0: 196.43.81.171
  Swap usage: 0%

  Graph this data and manage this system at https://landscape.canonical.com/

0 packages can be updated.
0 updates are security updates.

Last login: Mon Nov 21 21:03:18 2011 from 197.250.184.83
hris@hris:~$ sudo /var/lib/iHRIS/lib/4.0.18/I2CE/tools/apache_tail.php 0
[sudo] password for hris:
[Mon Nov 21 21:31:03 2011] [error] [client 197.250.184.83]
 Refered by : http://hq.csschris.or.tz/index.php/magicDataBrowser/show//I2CE/tasks/task_description
 I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Module_CustomReports.php:120)
       I2CE_Module_CustomReports->refreshGenerates (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_ModuleFactory.php:741)
       I2CE_ModuleFactory->_callHooks (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_ModuleFactory.php:728)
       I2CE_ModuleFactory->callHooks (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE.php:636)
       I2CE->bringUpSystem (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE.php:609)
       I2CE->initializeDSN (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49)
 Exceeded max wait time for caching forms (status=in_progress). Forcing
[Mon Nov 21 21:31:03 2011] [error] [client 197.250.184.83]
 Refered by : http://hq.csschris.or.tz/index.php/magicDataBrowser/show//I2CE/tasks/task_description
 I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/BackgroundProcess/I2CE_BackgroundProcess.php:98)
       I2CE_BackgroundProcess->launchBackgroundProcess (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/BackgroundProcess/I2CE_BackgroundProcess.php:163)
       I2CE_BackgroundProcess->launchBackgroundPHPScript (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/BackgroundProcess/I2CE_BackgroundProcess.php:180)
       I2CE_BackgroundProcess->launchBackgroundPage
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       I2CE_Module_CustomReports->launchBackgroundPage (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Module_CustomReports.php:122)
       I2CE_Module_CustomReports->refreshGenerates (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_ModuleFactory.php:741)
       I2CE_ModuleFactory->_callHooks (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_ModuleFactory.php:728)
       I2CE_ModuleFactory->callHooks (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE.php:636)
       I2CE->bringUpSystem (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE.php:609)
       I2CE->initializeDSN (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49)
 Starting background process: (sh -c ''\\''/usr/bin/php5'\\'' '\\''/var/www/manage-central/index.php'\\'' --page=/CustomReports/generate_force --nocheck=1 > '\\''/tmp/I2CE_BackgroundProcess'\\''/process.96247.log 2>&1 &echo $!')
 Working directory is (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages)
 Log file is stored at '/tmp/I2CE_BackgroundProcess'/process.96247.log
[Mon Nov 21 21:31:18 2011] [error] [client 197.250.184.83]
 Refered by : http://hq.csschris.or.tz/index.php/CustomReports/view/reportViews
 I2CE: SELECT SQL_CALC_FOUND_ROWS `primary_table`.`primary_form+id` AS `primary_form+id`,`primary_table`.`last_position+id` AS `last_position+id`,`primary_table`.`last_person_position+id` AS `last_person_position+id`,`primary_table`.`last_facility+id` AS `last_facility+id`,`primary_table`.`confirmationtoservice+id` AS `confirmationtoservice+id`,`primary_table`.`primary_form+firstname` AS `primary_form+firstname`,`primary_table`.`primary_form+surname` AS `primary_form+surname`,`primary_table`.`last_position+title` AS `last_position+title`,`primary_table`.`last_position+employer` AS `last_position+employer`,`primary_table`.`last_position+pos_type` AS `last_position+pos_type`,`primary_table`.`last_person_position+start_date` AS `last_person_position+start_date`,`primary_table`.`last_facility+name` AS `last_facility+name`,`primary_table`.`last_facility+facility_type` AS `last_facility+facility_type`,`primary_table`.`+employee_status` AS `+employee_status`,`primary_table`.`confirmationtoservice+confirmationdate` AS `confirmationtoservice+confirmationdate`,`primary_table`.`last_facility+diocese` AS `last_facility+diocese`,`primary_table`.`last_person_position+reason` AS `last_person_position+reason`,`primary_table`.`primary_form+relg_affil` AS `primary_form+relg_affil`,`primary_table`.`primary_form+residence` AS `primary_form+residence`,`primary_table`.`confirmationtoservice+parent` AS `confirmationtoservice+parent`,`primary_table`.`last_facility+parent` AS `last_facility+parent`,`primary_table`.`last_person_position+parent` AS `last_person_position+parent`,`primary_table`.`last_position+parent` AS `last_position+parent`,`primary_table`.`primary_form+parent` AS `primary_form+parent` FROM `manage_cssc_central`.`zebra_search_people` AS primary_table ORDER BY `primary_form+surname`,`primary_form+firstname` LIMIT 50 OFFSET 0
[Mon Nov 21 21:31:33 2011] [error] [client 197.250.184.83]
 Refered by : http://hq.csschris.or.tz/index.php/CustomReports/show/search_people
 I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418)
       I2CE_FormStorage_DB->getIdsAsChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1213)
       I2CE_FormStorage->getChildIds
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->getChildIds (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1274)
       I2CE_FormStorage->populateChild
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1305)
       I2CE_FormStorage->populateChildren
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateChildren (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:101)
       iHRIS_PageView->addChildForms (/var/lib/iHRIS/lib/4.0.18/ihris-manage/modules/Confirmation/lib/iHRIS_Module_Confirmation.php:46)
       iHRIS_Module_Confirmation->action_confirmation
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_confirmation (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
 Error getting ids for form confirmation as a child of person|8527@eastern::
 MDB2 Error: syntax error
 _doQuery: [Error message: Could not execute statement]
 [Last executed query: SELECT SQL_CALC_FOUND_ROWS id AS `id` FROM ( SELECT r.id AS id, CONCAT(r.parent_form,'|',r.parent_id) AS parent FROM record r WHERE (( r.form = 55 ) AND (r.parent_form = 'person' AND r.parent_id = 8527@eastern))) AS `confirmation` ]
 [Native code: 1064]
 [Native message: 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 '@eastern))) AS `confirmation`' at line 1]
[Mon Nov 21 21:31:33 2011] [error] [client 197.250.184.83]
 Refered by : http://hq.csschris.or.tz/index.php/CustomReports/show/search_people
 I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/ihris-manage/modules/ManagePersonPosition/lib/iHRIS_Module_PersonPosition.php:367)
       iHRIS_Module_PersonPosition->action_person_position
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_person_position (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
 Adding person posotion
[Mon Nov 21 21:31:33 2011] [error] [client 197.250.184.83]
 Refered by : http://hq.csschris.or.tz/index.php/CustomReports/show/search_people
 I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418)
       I2CE_FormStorage_DB->getIdsAsChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1146)
       I2CE_FormStorage->populateLast
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateLast (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:107)
       iHRIS_PageView->addLastChildForm (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/modules/Resume/lib/iHRIS_Module_Resume.php:48)
       iHRIS_Module_Resume->action_person_resume
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_person_resume (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
 Error getting ids for form person_resume as a child of person|8527@eastern::
 MDB2 Error: syntax error
 _doQuery: [Error message: Could not execute statement]
 [Last executed query: SELECT SQL_CALC_FOUND_ROWS id AS `id` FROM ( SELECT r.id AS id, CONCAT(r.parent_form,'|',r.parent_id) AS parent FROM record r WHERE (( r.form = 56 ) AND (r.parent_form = 'person' AND r.parent_id = 8527@eastern))) AS `person_resume` LIMIT 1]
 [Native code: 1064]
 [Native message: 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 '@eastern))) AS `person_resume` LIMIT 1' at line 1]
[Mon Nov 21 21:31:33 2011] [error] [client 197.250.184.83]
 Refered by : http://hq.csschris.or.tz/index.php/CustomReports/show/search_people
 I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418)
       I2CE_FormStorage_DB->getIdsAsChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1146)
       I2CE_FormStorage->populateLast
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateLast (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:107)
       iHRIS_PageView->addLastChildForm (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/modules/PersonPhoto/lib/iHRIS_Module_PersonPassport.php:48)
       iHRIS_Module_PersonPassport->action_person_photo_passport
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_person_photo_passport (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
 Error getting ids for form person_photo_passport as a child of person|8527@eastern::
 MDB2 Error: syntax error
 _doQuery: [Error message: Could not execute statement]
 [Last executed query: SELECT SQL_CALC_FOUND_ROWS id AS `id` FROM ( SELECT r.id AS id, CONCAT(r.parent_form,'|',r.parent_id) AS parent FROM record r WHERE (( r.form = 57 ) AND (r.parent_form = 'person' AND r.parent_id = 8527@eastern))) AS `person_photo_passport` LIMIT 1]
 [Native code: 1064]
 [Native message: 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 '@eastern))) AS `person_photo_passport` LIMIT 1' at line 1]
[Mon Nov 21 21:31:33 2011] [error] [client 197.250.184.83]
 Refered by : http://hq.csschris.or.tz/index.php/CustomReports/show/search_people
 I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418)
       I2CE_FormStorage_DB->getIdsAsChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1213)
       I2CE_FormStorage->getChildIds
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->getChildIds (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1274)
       I2CE_FormStorage->populateChild
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1305)
       I2CE_FormStorage->populateChildren
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateChildren (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:101)
       iHRIS_PageView->addChildForms (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/modules/RecordStatus/lib/iHRIS_Module_RecordStatus.php:51)
       iHRIS_Module_RecordStatus->action_person_record_status
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_person_record_status (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
 Error getting ids for form person_record_status as a child of person|8527@eastern::
 MDB2 Error: syntax error
 _doQuery: [Error message: Could not execute statement]
 [Last executed query: SELECT SQL_CALC_FOUND_ROWS id AS `id` FROM ( SELECT r.id AS id, CONCAT(r.parent_form,'|',r.parent_id) AS parent FROM record r WHERE (( r.form = 64 ) AND (r.parent_form = 'person' AND r.parent_id = 8527@eastern))) AS `person_record_status` ]
 [Native code: 1064]
 [Native message: 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 '@eastern))) AS `person_record_status`' at line 1]
[Mon Nov 21 21:31:33 2011] [error] [client 197.250.184.83]
 Refered by : http://hq.csschris.or.tz/index.php/CustomReports/show/search_people
 I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418)
       I2CE_FormStorage_DB->getIdsAsChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1213)
       I2CE_FormStorage->getChildIds
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->getChildIds (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1274)
       I2CE_FormStorage->populateChild
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1305)
       I2CE_FormStorage->populateChildren
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateChildren (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:101)
       iHRIS_PageView->addChildForms (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/modules/NextOfKin/lib/iHRIS_Module_NextOfKin.php:47)
       iHRIS_Module_NextOfKin->show_nextofkin
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_nextofkin (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
 Error getting ids for form nextofkin as a child of person|8527@eastern::
 MDB2 Error: syntax error
 _doQuery: [Error message: Could not execute statement]
 [Last executed query: SELECT SQL_CALC_FOUND_ROWS id AS `id` FROM ( SELECT r.id AS id, CONCAT(r.parent_form,'|',r.parent_id) AS parent FROM record r WHERE (( r.form = 65 ) AND (r.parent_form = 'person' AND r.parent_id = 8527@eastern))) AS `nextofkin` ]
 [Native code: 1064]
 [Native message: 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 '@eastern))) AS `nextofkin`' at line 1]
[Mon Nov 21 21:31:33 2011] [error] [client 197.250.184.83]
 Refered by : http://hq.csschris.or.tz/index.php/CustomReports/show/search_people
 I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418)
       I2CE_FormStorage_DB->getIdsAsChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1213)
       I2CE_FormStorage->getChildIds
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->getChildIds (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1274)
       I2CE_FormStorage->populateChild
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1305)
       I2CE_FormStorage->populateChildren
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateChildren (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:101)
       iHRIS_PageView->addChildForms (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/modules/Dependents/lib/iHRIS_Module_Dependents.php:44)
       iHRIS_Module_Dependents->show_dependents
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_dependent (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
 Error getting ids for form dependent as a child of person|8527@eastern::
 MDB2 Error: syntax error
 _doQuery: [Error message: Could not execute statement]
 [Last executed query: SELECT SQL_CALC_FOUND_ROWS id AS `id` FROM ( SELECT r.id AS id, CONCAT(r.parent_form,'|',r.parent_id) AS parent FROM record r WHERE (( r.form = 66 ) AND (r.parent_form = 'person' AND r.parent_id = 8527@eastern))) AS `dependent` ]
 [Native code: 1064]
 [Native message: 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 '@eastern))) AS `dependent`' at line 1]
[Mon Nov 21 21:31:33 2011] [error] [client 197.250.184.83]
 Refered by : http://hq.csschris.or.tz/index.php/CustomReports/show/search_people
 I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418)
       I2CE_FormStorage_DB->getIdsAsChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1213)
       I2CE_FormStorage->getChildIds
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->getChildIds (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1274)
       I2CE_FormStorage->populateChild
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1305)
       I2CE_FormStorage->populateChildren
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateChildren (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:101)
       iHRIS_PageView->addChildForms (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/modules/ArchivalScans/lib/iHRIS_Module_ArchivedScan.php:48)
       iHRIS_Module_ArchivedScan->action_person_archive_scan
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_person_archive_scan (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
 Error getting ids for form person_archive_scan as a child of person|8527@eastern::
 MDB2 Error: syntax error
 _doQuery: [Error message: Could not execute statement]
 [Last executed query: SELECT SQL_CALC_FOUND_ROWS id AS `id` FROM ( SELECT r.id AS id, CONCAT(r.parent_form,'|',r.parent_id) AS parent FROM record r WHERE (( r.form = 67 ) AND (r.parent_form = 'person' AND r.parent_id = 8527@eastern))) AS `person_archive_scan` ]
 [Native code: 1064]
 [Native message: 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 '@eastern))) AS `person_archive_scan`' at line 1]
[Mon Nov 21 21:31:33 2011] [error] [client 197.250.184.83]
 Refered by : http://hq.csschris.or.tz/index.php/CustomReports/show/search_people
 I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418)
       I2CE_FormStorage_DB->getIdsAsChild (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1146)
       I2CE_FormStorage->populateLast
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       CSSC_Person->populateLast (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:107)
       iHRIS_PageView->addLastChildForm (/var/lib/iHRIS/cssc_zonal_deploy/modules/EmploymentID/lib/iHRIS_Module_EmploymentID.php:47)
       iHRIS_Module_EmploymentID->action_employmentid
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_employmentid (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
 Error getting ids for form employmentid as a child of person|8527@eastern::
 MDB2 Error: syntax error
 _doQuery: [Error message: Could not execute statement]
 [Last executed query: SELECT SQL_CALC_FOUND_ROWS id AS `id` FROM ( SELECT r.id AS id, CONCAT(r.parent_form,'|',r.parent_id) AS parent FROM record r WHERE (( r.form = 58 ) AND (r.parent_form = 'person' AND r.parent_id = 8527@eastern))) AS `employmentid` LIMIT 1]
 [Native code: 1064]
 [Native message: 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 '@eastern))) AS `employmentid` LIMIT 1' at line 1]

Revision history for this message
Carl Leitner (litlfred) wrote :

Par of the error message above (see below) should be fixed with revision 2650:
  http://bazaar.launchpad.net/~intrahealth+informatics/i2ce/4.0-dev/revision/2650

The error message is:
   Error getting ids for form employmentid as a child of person|8527@eastern::
   MDB2 Error: syntax error
   _doQuery: [Error message: Could not execute statement]
   [Last executed query: SELECT SQL_CALC_FOUND_ROWS id AS `id` FROM ( SELECT r.id AS id, CONCAT(r.parent_form,'|',r.parent_id) AS parent FROM record r WHERE (( r.form = 58 ) AND (r.parent_form = 'person' AND r.parent_id = 8527@eastern))) AS `employmentid` LIMIT 1]

Revision history for this message
Carl Leitner (litlfred) wrote :

The relevant error appears to be in bug 893980:
  https://bugs.launchpad.net/i2ce/+bug/893980
which says:
[Wed Nov 23 07:43:42 2011] [error] [client 196.43.68.201]
 Refered by : http://lz.csschris.or.tz/manage-lake/index.php/contact?contact_type=work
 I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:128)
       iHRIS_PageView->appendChildTemplate (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:108)
       iHRIS_PageView->addLastChildForm (/var/lib/iHRIS/cssc_zonal_deploy/modules/EmploymentID/lib/iHRIS_Module_EmploymentID.php:47)
       iHRIS_Module_EmploymentID->action_employmentid
       call_user_func_array (/var/lib/iHRIS/lib/4.0.18/I2CE/lib/I2CE_Fuzzy.php:57)
       I2CE_Fuzzy->__call
       iHRIS_PageView->action_employmentid (/var/lib/iHRIS/lib/4.0.18/ihris-common/modules/Person/lib/iHRIS_PageView.php:81)
       iHRIS_PageView->action (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
 Do not know where to add child form employmentid

This is caused when there is no <div id="employmentid"> to put the employmentid form on. This probably needs to be added to the view.html page.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.