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

  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]