report generation bug
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| ihris-manage-cssc |
New
|
Undecided
|
Unassigned | ||
Bug Description
[Thu Mar 01 15:59:04 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Attempting to update/enable the following out of date modules: CSSC_nextOfKin
[Thu Mar 01 15:59:04 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
The following modules class paths are being added:
accident,
[Thu Mar 01 15:59:04 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Trying to enable the following required:
CSSC_nextOfKin
[Thu Mar 01 15:59:04 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Trying to enable the following optional:
[Thu Mar 01 15:59:04 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Trying to enable the following:
CSSC_nextOfKin
[Thu Mar 01 15:59:05 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Previously processed config data for CSSC_nextOfKin with version <= 4.0.12.0. New version is 4.0.12.2012.03.01
[Thu Mar 01 15:59:05 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Found localized config files for CSSC_nextOfKin: en_US
[Thu Mar 01 15:59:05 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Processing config for (CSSC_nextOfKin) with version (4.0.12.0)
[Thu Mar 01 15:59:05 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Reading in config values for version >= 4.0.12.0
[Thu Mar 01 15:59:05 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Processing config for (CSSC_nextOfKin) on locale (en_US) with version (4.0.12.0)
[Thu Mar 01 15:59:05 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Reading in config values for version >= 4.0.12.0
[Thu Mar 01 15:59:05 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Loaded in magic data for CSSC_nextOfKin to memory
[Thu Mar 01 15:59:05 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Enabling/updating CSSC_nextOfKin
[Thu Mar 01 15:59:05 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Updating hooks/methods for CSSC_nextOfKin
[Thu Mar 01 15:59:07 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Pre-Upgrading module CSSC_nextOfKin from version 4.0.12.0 to 4.0.12.2012.03.01
[Thu Mar 01 15:59:07 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Upgrading module CSSC_nextOfKin from version 4.0.12.0 to 4.0.12.2012.03.01
[Thu Mar 01 15:59:07 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Post Updating module CSSC_nextOfKin from version 4.0.12.0 to 4.0.12.2012.03.01
[Thu Mar 01 15:59:07 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Enabled Modules: accident,
[Thu Mar 01 15:59:09 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Exceeded max wait time for caching forms (status=
[Thu Mar 01 15:59:09 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Starting background process: (sh -c ''\\''/
Working directory is (/var/lib/
Log file is stored at '/tmp/I2CE_
[Thu Mar 01 15:59:37 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: SELECT SQL_CALC_FOUND_ROWS `primary_
[Thu Mar 01 15:59:46 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->pearError (/var/lib/
Error getting ids for form confirmation as a child of person|
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(
[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]
[Thu Mar 01 15:59:46 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->raiseError (/var/lib/
Adding person posotion
[Thu Mar 01 15:59:46 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->pearError (/var/lib/
Error getting ids for form person_resume as a child of person|
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(
[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]
[Thu Mar 01 15:59:46 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->pearError (/var/lib/
Error getting ids for form person_
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(
[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_
[Thu Mar 01 15:59:46 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->pearError (/var/lib/
Error getting ids for form person_
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(
[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_
[Thu Mar 01 15:59:47 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->pearError (/var/lib/
Error getting ids for form nextofkin as a child of person|
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(
[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]
[Thu Mar 01 15:59:47 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->pearError (/var/lib/
Error getting ids for form dependent as a child of person|
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(
[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]
[Thu Mar 01 15:59:47 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->pearError (/var/lib/
Error getting ids for form person_archive_scan as a child of person|
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(
[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_
[Thu Mar 01 15:59:47 2012] [error] [client 196.43.77.74]
Refered by : http://
I2CE: I2CE->pearError (/var/lib/
Error getting ids for form employmentid as a child of person|
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(
[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]
[Thu Mar 01 15:59:48 2012] [error] [client 196.43.77.74]
Refered by http://
I2CE: FIX THIS
Task person_
| Carl Leitner (litlfred) wrote | #1 |
| Brad Crittenden (bac) wrote | #2 |
| Carl Leitner (litlfred) wrote | #3 |
| summary: |
- [Thu Mar 01 15:59:04 2012] [error] [client 196.43.77.74] Refered - by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:580) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Attempting to update/enable the following out of date modules: - CSSC_nextOfKin [Thu Mar 01 15:59:04 2012] [error] [client 196.43.77.74] - Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:584) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - The following modules class paths are being added: - accident,admin,BackgroundProcess,BinField,CachedForms,CEUs,ColorPicker,Contact,cssc- - contact,CSSC-CustomReports,cssc-facility,cssc-person,cssc-person- - position,cssc-position,cssc-task- - fxup,CSSC_FacilityStats,cssc_spouse,Currency,CustomReports,CustomReports_Export,CustomReports_PDF,CustomReports_PieChart,DatePicker,deleteRecord,dependents,disciplinary_action,DisplayData,Document,EmploymentID,establishment,exportReport,Facility,FacilityCategory,FacilityContact,field- - limits,Fields,FileDump,form- - limits,formDocumentor,formRelationships,forms,forms-storage,forms- - storage-entry,forms-storage-eval,forms-storage-magicdata,forms-storage- - multiflat,FormWorm,geographic-cssc-division,geographic-cssc- - region,geographic-cssc-village,geographic-cssc-ward,geographic-cssc- - zone,Geography,I2CE,ihris-common,ihris-common-Cadre,ihris-common- - Job,ihris-common-RecentForm,ihris-common-Search,ihris-manage,ihris- - manage-Application,ihris-manage-Benefit,ihris-manage-confirmation,ihris- - manage-ConfirmationAttachment,ihris-manage-cssc,ihris-manage-cssc-data- - cadre,ihris-manage-cssc-data-country,ihris-manage-cssc-data- - cssc_zone,ihris-manage-cssc-data-currency,ihris-manage-cssc-data- - degree,ihris-manage-cssc-data-district,ihris-manage-cssc-data- - edu_type,ihris-manage-cssc-data-employer,ihris-manage-cssc-data- - facility_type,ihris-manage-cssc-data-gender,ihris-manage-cssc-data- - id_type,ihris-manage-cssc-data-job,ihris-manage-cssc-data- - marital_status,ihris-manage-cssc-data-position_type,ihris-manage-cssc- - data-pos_change_reason,ihris-manage-cssc-data-region,ihris-manage-cssc- - data-salary_source,ihris-manage-cssc-data-title,ihris-manage- - CustomReports,ihris-manage-CustomReports-facility-reports,ihris-manage- - CustomReports-FilledPositions,ihris-manage-CustomReports-position- - reports,ihris-manage-CustomReports-search-people,ihris-manage- - CustomReports-staff-reports,ihris-manage-help,ihris-manage-Job,ihris- - manage-Person,ihris-manage-PersonDemographic,ihris-manage- - PersonPosition,ihris-manage-Salary,ihris-manage-site- - central,isco-88,isco-88-major-00,isco-88-major-01,isco-88-major-02,isco-88-major-03,isco-88-major-04,isco-88-major-05,isco-88-major-06,isco-88-major-07,isco-88-major-08,isco-88-major-09,jumper,Lists,LocaleForm,LoginPage,maani- - charts,magicDataBrowser,magicDataExport,manage-training-course,manage- - training-institution,manage-training-simple- - competency,ManageRegistration,menu_select,messageBox,messageHandler,messageNotice,MimeTypes,MooTools,MooTools-I2CE,nextOfKin,Options,pages,Person,person- - simple- - competency,PersonArchivedScan,PersonContact,PersonDemographic,PersonEducation,PersonEmployment,PersonID,PersonLanguage,PersonNotes,PersonPassportPhoto,PersonResume,Photo,pmoralg- - ConfirmationToService,pmoralg-Leave,RecordStatus,simple- - competency,StretchPage,stub,swissConfig,swissfactory,Tags,tasks- - roles,tcpdf,template-data,textlayout,training-course,training- - institution,training-simple- - competency,TreeSelect,user,UserAccess,UserForm [Thu Mar 01 15:59:04 - 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:598) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Trying to enable the following required: CSSC_nextOfKin [Thu Mar - 01 15:59:04 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:599) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Trying to enable the following optional: [Thu Mar 01 15:59:04 2012] - [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:600) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Trying to enable the following: CSSC_nextOfKin [Thu Mar 01 - 15:59:05 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:891) - I2CE_Updater->loadModuleMagicData - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:722) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Previously processed config data for CSSC_nextOfKin with version <= - 4.0.12.0. New version is 4.0.12.2012.03.01 [Thu Mar 01 15:59:05 2012] - [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Configurator.php:436) - I2CE_Configurator->importLocalizedTemplates - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:896) - I2CE_Updater->loadModuleMagicData - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:722) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Found localized config files for CSSC_nextOfKin: en_US [Thu Mar 01 - 15:59:05 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Configurator.php:497) - I2CE_Configurator->processConfig - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:910) - I2CE_Updater->loadModuleMagicData - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:722) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Processing config for (CSSC_nextOfKin) with version (4.0.12.0) [Thu Mar - 01 15:59:05 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Configurator.php:500) - I2CE_Configurator->processConfig - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:910) - I2CE_Updater->loadModuleMagicData - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:722) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Reading in config values for version >= 4.0.12.0 [Thu Mar 01 15:59:05 - 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Configurator.php:495) - I2CE_Configurator->processConfig - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:910) - I2CE_Updater->loadModuleMagicData - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:722) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Processing config for (CSSC_nextOfKin) on locale (en_US) with version - (4.0.12.0) [Thu Mar 01 15:59:05 2012] [error] [client 196.43.77.74] - Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Configurator.php:500) - I2CE_Configurator->processConfig - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:910) - I2CE_Updater->loadModuleMagicData - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:722) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Reading in config values for version >= 4.0.12.0 [Thu Mar 01 15:59:05 - 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:928) - I2CE_Updater->loadModuleMagicData - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:722) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Loaded in magic data for CSSC_nextOfKin to memory [Thu Mar 01 15:59:05 - 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_ModuleFactory.php:606) - I2CE_ModuleFactory->enable - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:937) - I2CE_Updater->preUpgradeModule - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:732) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Enabling/updating CSSC_nextOfKin [Thu Mar 01 15:59:05 2012] [error] - [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_ModuleFactory.php:328) - I2CE_ModuleFactory->updateHooks - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_ModuleFactory.php:616) - I2CE_ModuleFactory->enable - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:937) - I2CE_Updater->preUpgradeModule - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:732) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Updating hooks/methods for CSSC_nextOfKin [Thu Mar 01 15:59:07 2012] - [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:944) - I2CE_Updater->preUpgradeModule - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:732) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Pre-Upgrading module CSSC_nextOfKin from version 4.0.12.0 to - 4.0.12.2012.03.01 [Thu Mar 01 15:59:07 2012] [error] [client - 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:960) - I2CE_Updater->upgradeModule - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:749) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Upgrading module CSSC_nextOfKin from version 4.0.12.0 to - 4.0.12.2012.03.01 [Thu Mar 01 15:59:07 2012] [error] [client - 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:973) - I2CE_Updater->postUpdateModule - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:757) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Post Updating module CSSC_nextOfKin from version 4.0.12.0 to - 4.0.12.2012.03.01 [Thu Mar 01 15:59:07 2012] [error] [client - 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:775) - I2CE_Updater->_updateModules - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:387) - I2CE_Updater->updateOutOfDateConfigFiles - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:198) - I2CE_Updater->_updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Updater.php:100) - I2CE_Updater->updateSite - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:600) - I2CE->initializeDSN - (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49) - Enabled Modules: - accident,admin,BackgroundProcess,BinField,CachedForms,CEUs,ColorPicker,Contact,cssc- - contact,CSSC-CustomReports,cssc-facility,cssc-person,cssc-person- - position,cssc-position,cssc-task- - fxup,CSSC_FacilityStats,CSSC_nextOfKin,cssc_spouse,Currency,CustomReports,CustomReports_Export,CustomReports_PDF,CustomReports_PieChart,DatePicker,deleteRecord,dependents,disciplinary_action,DisplayData,Document,EmploymentID,establishment,exportReport,Facility,FacilityCategory,FacilityContact,field- - limits,Fields,FileDump,form- - limits,formDocumentor,formRelationships,forms,forms-storage,forms- - storage-entry,forms-storage-eval,forms-storage-magicdata,forms-storage- - multiflat,FormWorm,geographic-cssc-division,geographic-cssc- - region,geographic-cssc-village,geographic-cssc-ward,geographic-cssc- - zone,Geography,I2CE,ihris-common,ihris-common-Cadre,ihris-common- - Job,ihris-common-RecentForm,ihris-common-Search,ihris-manage,ihris- - manage-Application,ihris-manage-Benefit,ihris-manage-confirmation,ihris- - manage-ConfirmationAttachment,ihris-manage-cssc,ihris-manage-cssc-data- - cadre,ihris-manage-cssc-data-country,ihris-manage-cssc-data- - cssc_zone,ihris-manage-cssc-data-currency,ihris-manage-cssc-data- - degree,ihris-manage-cssc-data-district,ihris-manage-cssc-data- - edu_type,ihris-manage-cssc-data-employer,ihris-manage-cssc-data- - facility_type,ihris-manage-cssc-data-gender,ihris-manage-cssc-data- - id_type,ihris-manage-cssc-data-job,ihris-manage-cssc-data- - marital_status,ihris-manage-cssc-data-position_type,ihris-manage-cssc- - data-pos_change_reason,ihris-manage-cssc-data-region,ihris-manage-cssc- - data-salary_source,ihris-manage-cssc-data-title,ihris-manage- - CustomReports,ihris-manage-CustomReports-facility-reports,ihris-manage- - CustomReports-FilledPositions,ihris-manage-CustomReports-position- - reports,ihris-manage-CustomReports-search-people,ihris-manage- - CustomReports-staff-reports,ihris-manage-help,ihris-manage-Job,ihris- - manage-Person,ihris-manage-PersonDemographic,ihris-manage- - PersonPosition,ihris-manage-Salary,ihris-manage-site- - central,isco-88,isco-88-major-00,isco-88-major-01,isco-88-major-02,isco-88-major-03,isco-88-major-04,isco-88-major-05,isco-88-major-06,isco-88-major-07,isco-88-major-08,isco-88-major-09,jumper,Lists,LocaleForm,LoginPage,maani- - charts,magicDataBrowser,magicDataExport,manage-training-course,manage- - training-institution,manage-training-simple- - competency,ManageRegistration,menu_select,messageBox,messageHandler,messageNotice,MimeTypes,MooTools,MooTools-I2CE,nextOfKin,Options,pages,Person,person- - simple- - competency,PersonArchivedScan,PersonContact,PersonDemographic,PersonEducation,PersonEmployment,PersonID,PersonLanguage,PersonNotes,PersonPassportPhoto,PersonResume,Photo,pmoralg- - ConfirmationToService,pmoralg-Leave,RecordStatus,simple- - competency,StretchPage,stub,swissConfig,swissfactory,Tags,tasks- - roles,tcpdf,template-data,textlayout,training-course,training- - institution,training-simple- - competency,TreeSelect,user,UserAccess,UserForm [Thu Mar 01 15:59:09 - 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Module_CustomReports.php:120) - I2CE_Module_CustomReports->refreshGenerates - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_ModuleFactory.php:741) - I2CE_ModuleFactory->_callHooks - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_ModuleFactory.php:728) - I2CE_ModuleFactory->callHooks - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:636) - I2CE->bringUpSystem (/var/lib/iHRIS/lib/4.0.19/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 - [Thu Mar 01 15:59:09 2012] [error] [client 196.43.77.74] Refered - by : - http://hq.csschris.or.tz/index.php/update.php?request=%2Findex.php%2Fhome - I2CE: I2CE->raiseError - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/BackgroundProcess/I2CE_BackgroundProcess.php:98) - I2CE_BackgroundProcess->launchBackgroundProcess - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/BackgroundProcess/I2CE_BackgroundProcess.php:163) - I2CE_BackgroundProcess->launchBackgroundPHPScript - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/BackgroundProcess/I2CE_BackgroundProcess.php:180) - I2CE_BackgroundProcess->launchBackgroundPage - call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call - I2CE_Module_CustomReports->launchBackgroundPage - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Module_CustomReports.php:122) - I2CE_Module_CustomReports->refreshGenerates - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_ModuleFactory.php:741) - I2CE_ModuleFactory->_callHooks - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_ModuleFactory.php:728) - I2CE_ModuleFactory->callHooks - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE.php:636) - I2CE->bringUpSystem (/var/lib/iHRIS/lib/4.0.19/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.31374.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.31374.log [Thu Mar 01 - 15:59:37 2012] [error] [client 196.43.77.74] 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 [Thu - Mar 01 15:59:46 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/CustomReports/show/search_people - I2CE: I2CE->pearError - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418) - I2CE_FormStorage_DB->getIdsAsChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1213) - I2CE_FormStorage->getChildIds call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->getChildIds - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1274) - I2CE_FormStorage->populateChild call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1305) - I2CE_FormStorage->populateChildren call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateChildren - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:101) - iHRIS_PageView->addChildForms (/var/lib/iHRIS/lib/4.0.19/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.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call iHRIS_PageView->action_confirmation - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:81) - iHRIS_PageView->action - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464) - I2CE_Page->display - (/var/lib/iHRIS/lib/4.0.19/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] [Thu Mar 01 15:59:46 - 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/CustomReports/show/search_people - I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/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.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call iHRIS_PageView->action_person_position - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:81) - iHRIS_PageView->action - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464) - I2CE_Page->display - (/var/lib/iHRIS/lib/4.0.19/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 [Thu Mar 01 15:59:46 2012] [error] [client - 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/CustomReports/show/search_people - I2CE: I2CE->pearError - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418) - I2CE_FormStorage_DB->getIdsAsChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1146) - I2CE_FormStorage->populateLast call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateLast - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:107) - iHRIS_PageView->addLastChildForm (/var/lib/iHRIS/lib/4.0.19/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.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call iHRIS_PageView->action_person_resume - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:81) - iHRIS_PageView->action - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464) - I2CE_Page->display - (/var/lib/iHRIS/lib/4.0.19/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] [Thu Mar - 01 15:59:46 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/CustomReports/show/search_people - I2CE: I2CE->pearError - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418) - I2CE_FormStorage_DB->getIdsAsChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1146) - I2CE_FormStorage->populateLast call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateLast - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:107) - iHRIS_PageView->addLastChildForm (/var/lib/iHRIS/lib/4.0.19/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.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call - iHRIS_PageView->action_person_photo_passport - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:81) - iHRIS_PageView->action - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464) - I2CE_Page->display - (/var/lib/iHRIS/lib/4.0.19/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] [Thu Mar 01 15:59:46 2012] [error] [client 196.43.77.74] - Refered by : - http://hq.csschris.or.tz/index.php/CustomReports/show/search_people - I2CE: I2CE->pearError - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418) - I2CE_FormStorage_DB->getIdsAsChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1213) - I2CE_FormStorage->getChildIds call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->getChildIds - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1274) - I2CE_FormStorage->populateChild call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1305) - I2CE_FormStorage->populateChildren call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateChildren - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:101) - iHRIS_PageView->addChildForms (/var/lib/iHRIS/lib/4.0.19/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.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call - iHRIS_PageView->action_person_record_status - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:81) - iHRIS_PageView->action - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464) - I2CE_Page->display - (/var/lib/iHRIS/lib/4.0.19/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] [Thu Mar 01 - 15:59:47 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/CustomReports/show/search_people - I2CE: I2CE->pearError - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418) - I2CE_FormStorage_DB->getIdsAsChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1213) - I2CE_FormStorage->getChildIds call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->getChildIds - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1274) - I2CE_FormStorage->populateChild call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1305) - I2CE_FormStorage->populateChildren call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateChildren - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:101) - iHRIS_PageView->addChildForms (/var/lib/iHRIS/lib/4.0.19/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.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call iHRIS_PageView->action_nextofkin - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:81) - iHRIS_PageView->action - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464) - I2CE_Page->display - (/var/lib/iHRIS/lib/4.0.19/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] [Thu - Mar 01 15:59:47 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/CustomReports/show/search_people - I2CE: I2CE->pearError - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418) - I2CE_FormStorage_DB->getIdsAsChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1213) - I2CE_FormStorage->getChildIds call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->getChildIds - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1274) - I2CE_FormStorage->populateChild call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1305) - I2CE_FormStorage->populateChildren call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateChildren - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:101) - iHRIS_PageView->addChildForms (/var/lib/iHRIS/lib/4.0.19/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.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call iHRIS_PageView->action_dependent - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:81) - iHRIS_PageView->action - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464) - I2CE_Page->display - (/var/lib/iHRIS/lib/4.0.19/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] [Thu - Mar 01 15:59:47 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/CustomReports/show/search_people - I2CE: I2CE->pearError - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418) - I2CE_FormStorage_DB->getIdsAsChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1213) - I2CE_FormStorage->getChildIds call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->getChildIds - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1274) - I2CE_FormStorage->populateChild call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1305) - I2CE_FormStorage->populateChildren call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateChildren - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:101) - iHRIS_PageView->addChildForms (/var/lib/iHRIS/lib/4.0.19/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.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call - iHRIS_PageView->action_person_archive_scan - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:81) - iHRIS_PageView->action - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464) - I2CE_Page->display - (/var/lib/iHRIS/lib/4.0.19/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] [Thu Mar 01 - 15:59:47 2012] [error] [client 196.43.77.74] Refered by : - http://hq.csschris.or.tz/index.php/CustomReports/show/search_people - I2CE: I2CE->pearError - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage_DB.php:418) - I2CE_FormStorage_DB->getIdsAsChild - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormStorage/lib/I2CE_FormStorage.php:1146) - I2CE_FormStorage->populateLast call_user_func_array - (/var/lib/iHRIS/lib/4.0.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call CSSC_Person->populateLast - (/var/lib/iHRIS/lib/4.0.19/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.19/I2CE/lib/I2CE_Fuzzy.php:57) - I2CE_Fuzzy->__call iHRIS_PageView->action_employmentid - (/var/lib/iHRIS/lib/4.0.19/ihris- - common/modules/Person/lib/iHRIS_PageView.php:81) - iHRIS_PageView->action - (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464) - I2CE_Page->display - (/var/lib/iHRIS/lib/4.0.19/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] [Thu Mar 01 - 15:59:48 2012] [error] [client 196.43.77.74] Refered by - http://hq.csschris.or.tz/index.php/CustomReports/show/search_people - I2CE: FIX THIS Task person_can_view_child_from_benefit does not have a - task_description set! + report generation bug |
Next time, please a short descriptive title for the bug report. It is very hard to read.
The error that you see:
SELECT SQL_CALC_FOUND_ROWS id AS `id` FROM ( SELECT r.id AS id, CONCAT(
should already be fixed with version 4.0.21 of the software.