ry+end_date`,`base_table`.`current_salary+salary` as `current_salary+salary`,`base_table`.`current_salary+start_date` as `current_salary+start_date`,`base_table`.`person+id` as `person+id`,`base_table`.`person+parent` as `person+parent`,`base_table`.`person+nationality` as `person+nationality`,`base_table`.`person+firstname` as `person+firstname`,`base_table`.`person+othername` as `person+othername`,`base_table`.`person+relg_affil` as `person+relg_affil`,`base_table`.`person+residence` as `person+residence`,`base_table`.`person+surname` as `person+surname` , `position`.id as `position+id`,`position`.parent as `position+parent`,`position`.`department` AS `position+department` ,`position`.`facility` AS `position+facility` ,`position`.`job` AS `position+job` ,`position`.`employer` AS `position+employer` ,`position`.`pos_type` AS `position+pos_type` ,`position`.`status` AS `position+status` ,`position`.`title` AS `position+title` , base_table.md5 AS last_md5 , UNHEX(MD5(CONCAT_WS('',base_table.`primary_form+id`,base_table.`current_salary+id`,base_table.`person+id`,`position`.id))) AS md5 FROM `manage_cssc_lake`.`tmp_custom_report_staff_list[3]` AS `base_table` LEFT JOIN `manage_cssc_lake`.`hippo_position` as `position` ON ( ( `primary_form+position` = `position`.`id` ) )
[Tue Nov 22 02:44:30 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Inserted 3612 rows
[Tue Nov 22 02:44:30 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Doing INSERT IGNORE INTO `manage_cssc_lake`.`tmp_custom_report_staff_list[4]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+end_date` as `primary_form+end_date`,`base_table`.`primary_form+position` as `primary_form+position`,`base_table`.`primary_form+start_date` as `primary_form+start_date`,`base_table`.`primary_form+reason` as `primary_form+reason`,`base_table`.`current_salary+id` as `current_salary+id`,`base_table`.`current_salary+parent` as `current_salary+parent`,`base_table`.`current_salary+end_date` as `current_salary+end_date`,`base_table`.`current_salary+salary` as `current_salary+salary`,`base_table`.`current_salary+start_date` as `current_salary+start_date`,`base_table`.`person+id` as `person+id`,`base_table`.`person+parent` as `person+parent`,`base_table`.`person+nationality` as `person+nationality`,`base_table`.`person+firstname` as `person+firstname`,`base_table`.`person+othername` as `person+othername`,`base_table`.`person+relg_affil` as `person+relg_affil`,`base_table`.`person+residence` as `person+residence`,`base_table`.`person+surname` as `person+surname` , '' AS `position+id`, NULL AS `position+parent`, NULL AS `position+department`, NULL AS `position+facility`, NULL AS `position+job`, NULL AS `position+employer`, NULL AS `position+pos_type`, NULL AS `position+status`, NULL AS `position+title`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_cssc_lake`.`tmp_custom_report_staff_list[3]` AS `base_table` WHERE md5 NOT IN ( SELECT last_md5 FROM `manage_cssc_lake`.`tmp_custom_report_staff_list[4]`)
[Tue Nov 22 02:44:30 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Inserted 0 rows
[Tue Nov 22 02:44:30 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Doing DROP TABLE IF EXISTS `manage_cssc_lake`.`tmp_custom_report_staff_list[3]`
[Tue Nov 22 02:44:30 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Doing DROP TABLE IF EXISTS `manage_cssc_lake`.`tmp_custom_report_staff_list[5]`
[Tue Nov 22 02:44:30 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Doing CREATE TABLE `manage_cssc_lake`.`tmp_custom_report_staff_list[5]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+end_date` datetime ,`primary_form+position` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+start_date` datetime ,`primary_form+reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current_salary+id` varchar(255) DEFAULT '',`current_salary+parent` varchar(255),`current_salary+end_date` datetime ,`current_salary+salary` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current_salary+start_date` datetime ,`person+id` varchar(255) DEFAULT '',`person+parent` varchar(255),`person+nationality` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+othername` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+relg_affil` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+residence` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+surname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+id` varchar(255) DEFAULT '',`position+parent` varchar(255),`position+department` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+facility` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+job` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+employer` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+pos_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`start_salary+id` varchar(255) DEFAULT '',`start_salary+parent` varchar(255),`start_salary+start_date` datetime ,`start_salary+salary` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+end_date` (`primary_form+end_date`),INDEX `primary_form+parent` (`primary_form+parent` (255)),INDEX `primary_form+position` (`primary_form+position` (255)),INDEX `primary_form+start_date` (`primary_form+start_date`),INDEX `primary_form+reason` (`primary_form+reason` (255)),INDEX `current_salary+end_date` (`current_salary+end_date`),INDEX `current_salary+salary` (`current_salary+salary` (255)),INDEX `current_salary+start_date` (`current_salary+start_date`),INDEX `person+nationality` (`person+nationality` (255)),INDEX `person+firstname` (`person+firstname` (255)),INDEX `person+othername` (`person+othername` (255)),INDEX `person+relg_affil` (`person+relg_affil` (255)),INDEX `person+residence` (`person+residence` (255)),INDEX `person+surname` (`person+surname` (255)),INDEX `position+department` (`position+department` (255)),INDEX `position+facility` (`position+facility` (255)),INDEX `position+job` (`position+job` (255)),INDEX `position+employer` (`position+employer` (255)),INDEX `position+pos_type` (`position+pos_type` (255)),INDEX `position+status` (`position+status` (255)),INDEX `position+title` (`position+title` (255)),INDEX `start_salary+start_date` (`start_salary+start_date`),INDEX `start_salary+salary` (`start_salary+salary` (255))) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
[Tue Nov 22 02:44:30 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Doing INSERT IGNORE INTO `manage_cssc_lake`.`tmp_custom_report_staff_list[5]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+end_date` as `primary_form+end_date`,`base_table`.`primary_form+position` as `primary_form+position`,`base_table`.`primary_form+start_date` as `primary_form+start_date`,`base_table`.`primary_form+reason` as `primary_form+reason`,`base_table`.`current_salary+id` as `current_salary+id`,`base_table`.`current_salary+parent` as `current_salary+parent`,`base_table`.`current_salary+end_date` as `current_salary+end_date`,`base_table`.`current_salary+salary` as `current_salary+salary`,`base_table`.`current_salary+start_date` as `current_salary+start_date`,`base_table`.`person+id` as `person+id`,`base_table`.`person+parent` as `person+parent`,`base_table`.`person+nationality` as `person+nationality`,`base_table`.`person+firstname` as `person+firstname`,`base_table`.`person+othername` as `person+othername`,`base_table`.`person+relg_affil` as `person+relg_affil`,`base_table`.`person+residence` as `person+residence`,`base_table`.`person+surname` as `person+surname`,`base_table`.`position+id` as `position+id`,`base_table`.`position+parent` as `position+parent`,`base_table`.`position+department` as `position+department`,`base_table`.`position+facility` as `position+facility`,`base_table`.`position+job` as `position+job`,`base_table`.`position+employer` as `position+employer`,`base_table`.`position+pos_type` as `position+pos_type`,`base_table`.`position+status` as `position+status`,`base_table`.`position+title` as `position+title` , `start_salary`.id as `start_salary+id`,`start_salary`.parent as `start_salary+parent`,`start_salary`.`start_date` AS `start_salary+start_date` ,`start_salary`.`salary` AS `start_salary+salary` , base_table.md5 AS last_md5 , UNHEX(MD5(CONCAT_WS('',base_table.`primary_form+id`,base_table.`current_salary+id`,base_table.`person+id`,base_table.`position+id`,`start_salary`.id))) AS md5 FROM `manage_cssc_lake`.`tmp_custom_report_staff_list[4]` AS `base_table` LEFT JOIN `manage_cssc_lake`.`hippo_salary` AS `start_salary` ON ( ( `start_salary`.parent = `primary_form+id` ) ) WHERE (( `start_salary`.`start_date` = (SELECT DISTINCT `start_date` AS `start_date` FROM `manage_cssc_lake`.`hippo_salary` WHERE (( `manage_cssc_lake`.`hippo_salary`.parent = `primary_form+id` )) ORDER BY `start_date` ASC LIMIT 0, 1)))
[Tue Nov 22 02:44:32 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Inserted 3612 rows
[Tue Nov 22 02:44:32 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Doing INSERT IGNORE INTO `manage_cssc_lake`.`tmp_custom_report_staff_list[5]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+end_date` as `primary_form+end_date`,`base_table`.`primary_form+position` as `primary_form+position`,`base_table`.`primary_form+start_date` as `primary_form+start_date`,`base_table`.`primary_form+reason` as `primary_form+reason`,`base_table`.`current_salary+id` as `current_salary+id`,`base_table`.`current_salary+parent` as `current_salary+parent`,`base_table`.`current_salary+end_date` as `current_salary+end_date`,`base_table`.`current_salary+salary` as `current_salary+salary`,`base_table`.`current_salary+start_date` as `current_salary+start_date`,`base_table`.`person+id` as `person+id`,`base_table`.`person+parent` as `person+parent`,`base_table`.`person+nationality` as `person+nationality`,`base_table`.`person+firstname` as `person+firstname`,`base_table`.`person+othername` as `person+othername`,`base_table`.`person+relg_affil` as `person+relg_affil`,`base_table`.`person+residence` as `person+residence`,`base_table`.`person+surname` as `person+surname`,`base_table`.`position+id` as `position+id`,`base_table`.`position+parent` as `position+parent`,`base_table`.`position+department` as `position+department`,`base_table`.`position+facility` as `position+facility`,`base_table`.`position+job` as `position+job`,`base_table`.`position+employer` as `position+employer`,`base_table`.`position+pos_type` as `position+pos_type`,`base_table`.`position+status` as `position+status`,`base_table`.`position+title` as `position+title` , '' AS `start_salary+id`, NULL AS `start_salary+parent`, NULL AS `start_salary+start_date`, NULL AS `start_salary+salary`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_cssc_lake`.`tmp_custom_report_staff_list[4]` AS `base_table` WHERE md5 NOT IN ( SELECT last_md5 FROM `manage_cssc_lake`.`tmp_custom_report_staff_list[5]`)
[Tue Nov 22 02:44:32 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Inserted 0 rows
[Tue Nov 22 02:44:32 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Doing DROP TABLE IF EXISTS `manage_cssc_lake`.`tmp_custom_report_staff_list[4]`
[Tue Nov 22 02:44:32 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Doing DROP TABLE IF EXISTS `manage_cssc_lake`.`tmp_custom_report_staff_list[6]`
[Tue Nov 22 02:44:32 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Doing CREATE TABLE `manage_cssc_lake`.`tmp_custom_report_staff_list[6]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+end_date` datetime ,`primary_form+position` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+start_date` datetime ,`primary_form+reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current_salary+id` varchar(255) DEFAULT '',`current_salary+parent` varchar(255),`current_salary+end_date` datetime ,`current_salary+salary` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current_salary+start_date` datetime ,`person+id` varchar(255) DEFAULT '',`person+parent` varchar(255),`person+nationality` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+othername` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+relg_affil` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+residence` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+surname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+id` varchar(255) DEFAULT '',`position+parent` varchar(255),`position+department` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+facility` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+job` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+employer` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+pos_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`start_salary+id` varchar(255) DEFAULT '',`start_salary+parent` varchar(255),`start_salary+start_date` datetime ,`start_salary+salary` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`demographic+id` varchar(255) DEFAULT '',`demographic+parent` varchar(255),`demographic+birth_date` datetime ,`demographic+dependents` int(11) ,`demographic+gender` text CHARACTER SET utf8 COLLATE utf8_bin,`demographic+marital_status` text CHARACTER SET utf8 COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+end_date` (`primary_form+end_date`),INDEX `primary_form+parent` (`primary_form+parent` (255)),INDEX `primary_form+position` (`primary_form+position` (255)),INDEX `primary_form+start_date` (`primary_form+start_date`),INDEX `primary_form+reason` (`primary_form+reason` (255)),INDEX `current_salary+end_date` (`current_salary+end_date`),INDEX `current_salary+salary` (`current_salary+salary` (255)),INDEX `current_salary+start_date` (`current_salary+start_date`),INDEX `person+nationality` (`person+nationality` (255)),INDEX `person+firstname` (`person+firstname` (255)),INDEX `person+othername` (`person+othername` (255)),INDEX `person+relg_affil` (`person+relg_affil` (255)),INDEX `person+residence` (`person+residence` (255)),INDEX `person+surname` (`person+surname` (255)),INDEX `position+department` (`position+department` (255)),INDEX `position+facility` (`position+facility` (255)),INDEX `position+job` (`position+job` (255)),INDEX `position+employer` (`position+employer` (255)),INDEX `position+pos_type` (`position+pos_type` (255)),INDEX `position+status` (`position+status` (255)),INDEX `position+title` (`position+title` (255)),INDEX `start_salary+start_date` (`start_salary+start_date`),INDEX `start_salary+salary` (`start_salary+salary` (255))) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
[Tue Nov 22 02:44:32 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:471)
I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Unable to populate cached report:
MDB2 Error: can not create
_doQuery: [Error message: Could not execute statement]
[Last executed query: CREATE TABLE `manage_cssc_lake`.`tmp_custom_report_staff_list[6]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+end_date` datetime ,`primary_form+position` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+start_date` datetime ,`primary_form+reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current_salary+id` varchar(255) DEFAULT '',`current_salary+parent` varchar(255),`current_salary+end_date` datetime ,`current_salary+salary` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current_salary+start_date` datetime ,`person+id` varchar(255) DEFAULT '',`person+parent` varchar(255),`person+nationality` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+othername` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+relg_affil` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+residence` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person+surname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+id` varchar(255) DEFAULT '',`position+parent` varchar(255),`position+department` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+facility` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+job` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+employer` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+pos_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`start_salary+id` varchar(255) DEFAULT '',`start_salary+parent` varchar(255),`start_salary+start_date` datetime ,`start_salary+salary` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`demographic+id` varchar(255) DEFAULT '',`demographic+parent` varchar(255),`demographic+birth_date` datetime ,`demographic+dependents` int(11) ,`demographic+gender` text CHARACTER SET utf8 COLLATE utf8_bin,`demographic+marital_status` text CHARACTER SET utf8 COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+end_date` (`primary_form+end_date`),INDEX `primary_form+parent` (`primary_form+parent` (255)),INDEX `primary_form+position` (`primary_form+position` (255)),INDEX `primary_form+start_date` (`primary_form+start_date`),INDEX `primary_form+reason` (`primary_form+reason` (255)),INDEX `current_salary+end_date` (`current_salary+end_date`),INDEX `current_salary+salary` (`current_salary+salary` (255)),INDEX `current_salary+start_date` (`current_salary+start_date`),INDEX `person+nationality` (`person+nationality` (255)),INDEX `person+firstname` (`person+firstname` (255)),INDEX `person+othername` (`person+othername` (255)),INDEX `person+relg_affil` (`person+relg_affil` (255)),INDEX `person+residence` (`person+residence` (255)),INDEX `person+surname` (`person+surname` (255)),INDEX `position+department` (`position+department` (255)),INDEX `position+facility` (`position+facility` (255)),INDEX `position+job` (`position+job` (255)),INDEX `position+employer` (`position+employer` (255)),INDEX `position+pos_type` (`position+pos_type` (255)),INDEX `position+status` (`position+status` (255)),INDEX `position+title` (`position+title` (255)),INDEX `start_salary+start_date` (`start_salary+start_date`),INDEX `start_salary+salary` (`start_salary+salary` (255))) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin]
[Native code: 1005]
[Native message: Can't create table './manage_cssc_lake/tmp_custom_report_staff_list[6].frm' (errno: 121)]
[Tue Nov 22 02:44:32 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:439)
I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
I2CE_Page_CustomReports->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)
Report generation failed for staff_list
[Tue Nov 22 02:44:32 2011] [error] [client 196.43.77.135]
Refered by : http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.18/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:145)
I2CE_Page_CustomReports->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)
Unable to generate report
We need to look as well in 4.1 and 4.0.19