Full error message is: 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+supervisor` (`position+supervisor` (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 [Wed Aug 03 02:57:52 2011] [error] [client 196.46.109.199] Refered by : http://nz.csschris.or.tz/manage-northern/index.php/CustomReports/edit/reports I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469) I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437) I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348) I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143) I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Page.php:464) I2CE_Page->display (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89) I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/northern/pages/index.php:60) Doing INSERT IGNORE INTO `manage_cssc_northern`.`tmp_custom_report_staff_list[21]` 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`.`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+supervisor` as `position+supervisor`,`base_table`.`position+title` as `position+title`,`base_table`.`start_salary+id` as `start_salary+id`,`base_table`.`start_salary+parent` as `start_salary+parent`,`base_table`.`start_salary+start_date` as `start_salary+start_date`,`base_table`.`start_salary+salary` as `start_salary+salary`,`base_table`.`accident+id` as `accident+id`,`base_table`.`accident+parent` as `accident+parent`,`base_table`.`benefit+id` as `benefit+id`,`base_table`.`benefit+parent` as `benefit+parent`,`base_table`.`benefit+amount` as `benefit+amount`,`base_table`.`benefit+source` as `benefit+source`,`base_table`.`benefit+type` as `benefit+type`,`base_table`.`confirmation_date+id` as `confirmation_date+id`,`base_table`.`confirmation_date+parent` as `confirmation_date+parent`,`base_table`.`confirmation_date+confirmationdate` as `confirmation_date+confirmationdate`,`base_table`.`confirmation_date+confirmationletter` as `confirmation_date+confirmationletter`,`base_table`.`contact+id` as `contact+id`,`base_table`.`contact+parent` as `contact+parent`,`base_table`.`contact+email` as `contact+email`,`base_table`.`contact+telephone` as `contact+telephone`,`base_table`.`demographic+id` as `demographic+id`,`base_table`.`demographic+parent` as `demographic+parent`,`base_table`.`demographic+birth_date` as `demographic+birth_date`,`base_table`.`demographic+dependents` as `demographic+dependents`,`base_table`.`demographic+gender` as `demographic+gender`,`base_table`.`demographic+marital_status` as `demographic+marital_status`,`base_table`.`education+id` as `education+id`,`base_table`.`education+parent` as `education+parent`,`base_table`.`education+degree` as `education+degree`,`base_table`.`education+institution` as `education+institution`,`base_table`.`education+location` as `education+location`,`base_table`.`education+major` as `education+major`,`base_table`.`education+year` as `education+year`,`base_table`.`emergency+id` as `emergency+id`,`base_table`.`emergency+parent` as `emergency+parent`,`base_table`.`emergency+address` as `emergency+address`,`base_table`.`emergency+email` as `emergency+email`,`base_table`.`emergency+telephone` as `emergency+telephone`,`base_table`.`employment+id` as `employment+id`,`base_table`.`employment+parent` as `employment+parent`,`base_table`.`employment+company_name` as `employment+company_name`,`base_table`.`employment+reason_for_leaving` as `employment+reason_for_leaving`,`base_table`.`employment+responsibilities` as `employment+responsibilities`,`base_table`.`employment+supervisor` as `employment+supervisor`,`base_table`.`employment_id+id` as `employment_id+id`,`base_table`.`employment_id+parent` as `employment_id+parent`,`base_table`.`employment_id+check_num` as `employment_id+check_num`,`base_table`.`employment_id+pf_num` as `employment_id+pf_num`,`base_table`.`home+id` as `home+id`,`base_table`.`home+parent` as `home+parent`,`base_table`.`home+address` as `home+address`,`base_table`.`home+email` as `home+email`,`base_table`.`home+telephone` as `home+telephone`,`base_table`.`nationality+id` as `nationality+id`,`base_table`.`nationality+parent` as `nationality+parent`,`base_table`.`person_leave+id` as `person_leave+id`,`base_table`.`person_leave+parent` as `person_leave+parent`,`base_table`.`person_leave+duration` as `person_leave+duration`,`base_table`.`person_leave+leave_type` as `person_leave+leave_type`,`base_table`.`person_leave+start_date` as `person_leave+start_date`,`base_table`.`person_photo+id` as `person_photo+id`,`base_table`.`person_photo+parent` as `person_photo+parent`,`base_table`.`person_resume+id` as `person_resume+id`,`base_table`.`person_resume+parent` as `person_resume+parent`,`base_table`.`primary_nextofkin+id` as `primary_nextofkin+id`,`base_table`.`primary_nextofkin+parent` as `primary_nextofkin+parent`,`base_table`.`primary_nextofkin+name` as `primary_nextofkin+name`,`base_table`.`primary_nextofkin+relationship` as `primary_nextofkin+relationship` , `registration`.id as `registration+id`,`registration`.parent as `registration+parent`, 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`,base_table.`start_salary+id`,base_table.`accident+id`,base_table.`benefit+id`,base_table.`confirmation_date+id`,base_table.`contact+id`,base_table.`demographic+id`,base_table.`education+id`,base_table.`emergency+id`,base_table.`employment+id`,base_table.`employment_id+id`,base_table.`home+id`,base_table.`nationality+id`,base_table.`person_leave+id`,base_table.`person_photo+id`,base_table.`person_resume+id`,base_table.`primary_nextofkin+id`,`registration`.id))) AS md5 FROM `manage_cssc_northern`.`tmp_custom_report_staff_list[20]` AS `base_table` LEFT JOIN `manage_cssc_northern`.`hippo_registration` AS `registration` ON ( ( `registration`.parent = `person+id` ) ) [Wed Aug 03 02:57:54 2011] [error] [client 196.46.109.199] Refered by : http://nz.csschris.or.tz/manage-northern/index.php/CustomReports/edit/reports I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475) I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437) I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348) I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143) I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Page.php:464) I2CE_Page->display (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89) I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/northern/pages/index.php:60) Inserted 4026 rows [Wed Aug 03 02:57:54 2011] [error] [client 196.46.109.199] Refered by : http://nz.csschris.or.tz/manage-northern/index.php/CustomReports/edit/reports I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469) I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437) I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348) I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143) I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Page.php:464) I2CE_Page->display (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89) I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/northern/pages/index.php:60) Doing INSERT IGNORE INTO `manage_cssc_northern`.`tmp_custom_report_staff_list[21]` 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`.`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+supervisor` as `position+supervisor`,`base_table`.`position+title` as `position+title`,`base_table`.`start_salary+id` as `start_salary+id`,`base_table`.`start_salary+parent` as `start_salary+parent`,`base_table`.`start_salary+start_date` as `start_salary+start_date`,`base_table`.`start_salary+salary` as `start_salary+salary`,`base_table`.`accident+id` as `accident+id`,`base_table`.`accident+parent` as `accident+parent`,`base_table`.`benefit+id` as `benefit+id`,`base_table`.`benefit+parent` as `benefit+parent`,`base_table`.`benefit+amount` as `benefit+amount`,`base_table`.`benefit+source` as `benefit+source`,`base_table`.`benefit+type` as `benefit+type`,`base_table`.`confirmation_date+id` as `confirmation_date+id`,`base_table`.`confirmation_date+parent` as `confirmation_date+parent`,`base_table`.`confirmation_date+confirmationdate` as `confirmation_date+confirmationdate`,`base_table`.`confirmation_date+confirmationletter` as `confirmation_date+confirmationletter`,`base_table`.`contact+id` as `contact+id`,`base_table`.`contact+parent` as `contact+parent`,`base_table`.`contact+email` as `contact+email`,`base_table`.`contact+telephone` as `contact+telephone`,`base_table`.`demographic+id` as `demographic+id`,`base_table`.`demographic+parent` as `demographic+parent`,`base_table`.`demographic+birth_date` as `demographic+birth_date`,`base_table`.`demographic+dependents` as `demographic+dependents`,`base_table`.`demographic+gender` as `demographic+gender`,`base_table`.`demographic+marital_status` as `demographic+marital_status`,`base_table`.`education+id` as `education+id`,`base_table`.`education+parent` as `education+parent`,`base_table`.`education+degree` as `education+degree`,`base_table`.`education+institution` as `education+institution`,`base_table`.`education+location` as `education+location`,`base_table`.`education+major` as `education+major`,`base_table`.`education+year` as `education+year`,`base_table`.`emergency+id` as `emergency+id`,`base_table`.`emergency+parent` as `emergency+parent`,`base_table`.`emergency+address` as `emergency+address`,`base_table`.`emergency+email` as `emergency+email`,`base_table`.`emergency+telephone` as `emergency+telephone`,`base_table`.`employment+id` as `employment+id`,`base_table`.`employment+parent` as `employment+parent`,`base_table`.`employment+company_name` as `employment+company_name`,`base_table`.`employment+reason_for_leaving` as `employment+reason_for_leaving`,`base_table`.`employment+responsibilities` as `employment+responsibilities`,`base_table`.`employment+supervisor` as `employment+supervisor`,`base_table`.`employment_id+id` as `employment_id+id`,`base_table`.`employment_id+parent` as `employment_id+parent`,`base_table`.`employment_id+check_num` as `employment_id+check_num`,`base_table`.`employment_id+pf_num` as `employment_id+pf_num`,`base_table`.`home+id` as `home+id`,`base_table`.`home+parent` as `home+parent`,`base_table`.`home+address` as `home+address`,`base_table`.`home+email` as `home+email`,`base_table`.`home+telephone` as `home+telephone`,`base_table`.`nationality+id` as `nationality+id`,`base_table`.`nationality+parent` as `nationality+parent`,`base_table`.`person_leave+id` as `person_leave+id`,`base_table`.`person_leave+parent` as `person_leave+parent`,`base_table`.`person_leave+duration` as `person_leave+duration`,`base_table`.`person_leave+leave_type` as `person_leave+leave_type`,`base_table`.`person_leave+start_date` as `person_leave+start_date`,`base_table`.`person_photo+id` as `person_photo+id`,`base_table`.`person_photo+parent` as `person_photo+parent`,`base_table`.`person_resume+id` as `person_resume+id`,`base_table`.`person_resume+parent` as `person_resume+parent`,`base_table`.`primary_nextofkin+id` as `primary_nextofkin+id`,`base_table`.`primary_nextofkin+parent` as `primary_nextofkin+parent`,`base_table`.`primary_nextofkin+name` as `primary_nextofkin+name`,`base_table`.`primary_nextofkin+relationship` as `primary_nextofkin+relationship` , '' AS `registration+id`, NULL AS `registration+parent`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_cssc_northern`.`tmp_custom_report_staff_list[20]` AS `base_table` WHERE md5 NOT IN ( SELECT last_md5 FROM `manage_cssc_northern`.`tmp_custom_report_staff_list[21]`) [Wed Aug 03 02:57:54 2011] [error] [client 196.46.109.199] Refered by : http://nz.csschris.or.tz/manage-northern/index.php/CustomReports/edit/reports I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475) I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437) I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348) I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143) I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Page.php:464) I2CE_Page->display (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89) I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/northern/pages/index.php:60) Inserted 0 rows [Wed Aug 03 02:57:54 2011] [error] [client 196.46.109.199] Refered by : http://nz.csschris.or.tz/manage-northern/index.php/CustomReports/edit/reports I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469) I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437) I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348) I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143) I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Page.php:464) I2CE_Page->display (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89) I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/northern/pages/index.php:60) Doing DROP TABLE IF EXISTS `manage_cssc_northern`.`tmp_custom_report_staff_list[20]` [Wed Aug 03 02:57:54 2011] [error] [client 196.46.109.199] Refered by : http://nz.csschris.or.tz/manage-northern/index.php/CustomReports/edit/reports I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469) I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437) I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348) I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143) I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Page.php:464) I2CE_Page->display (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89) I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/northern/pages/index.php:60) Doing DROP TABLE IF EXISTS `manage_cssc_northern`.`tmp_custom_report_staff_list[22]` [Wed Aug 03 02:57:54 2011] [error] [client 196.46.109.199] Refered by : http://nz.csschris.or.tz/manage-northern/index.php/CustomReports/edit/reports I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469) I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437) I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348) I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143) I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Page.php:464) I2CE_Page->display (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89) I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/northern/pages/index.php:60) Doing CREATE TABLE `manage_cssc_northern`.`tmp_custom_report_staff_list[22]` ( `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,`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+supervisor` 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,`accident+id` varchar(255) DEFAULT '',`accident+parent` varchar(255),`benefit+id` varchar(255) DEFAULT '',`benefit+parent` varchar(255),`benefit+amount` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`benefit+source` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`benefit+type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`confirmation_date+id` varchar(255) DEFAULT '',`confirmation_date+parent` varchar(255),`confirmation_date+confirmationdate` datetime ,`confirmation_date+confirmationletter` longblob ,`contact+id` varchar(255) DEFAULT '',`contact+parent` varchar(255),`contact+email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`contact+telephone` 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` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`demographic+marital_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`education+id` varchar(255) DEFAULT '',`education+parent` varchar(255),`education+degree` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`education+institution` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`education+location` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`education+major` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`education+year` datetime ,`emergency+id` varchar(255) DEFAULT '',`emergency+parent` varchar(255),`emergency+address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`emergency+email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`emergency+telephone` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`employment+id` varchar(255) DEFAULT '',`employment+parent` varchar(255),`employment+company_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`employment+reason_for_leaving` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`employment+responsibilities` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`employment+supervisor` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`employment_id+id` varchar(255) DEFAULT '',`employment_id+parent` varchar(255),`employment_id+check_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`employment_id+pf_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`home+id` varchar(255) DEFAULT '',`home+parent` varchar(255),`home+address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`home+email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`home+telephone` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`nationality+id` varchar(255) DEFAULT '',`nationality+parent` varchar(255),`person_leave+id` varchar(255) DEFAULT '',`person_leave+parent` varchar(255),`person_leave+duration` int(11) ,`person_leave+leave_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person_leave+start_date` datetime ,`person_photo+id` varchar(255) DEFAULT '',`person_photo+parent` varchar(255),`person_resume+id` varchar(255) DEFAULT '',`person_resume+parent` varchar(255),`primary_nextofkin+id` varchar(255) DEFAULT '',`primary_nextofkin+parent` varchar(255),`primary_nextofkin+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_nextofkin+relationship` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`registration+id` varchar(255) DEFAULT '',`registration+parent` varchar(255),`seconary_nextofkin+id` varchar(255) DEFAULT '',`seconary_nextofkin+parent` varchar(255),`seconary_nextofkin+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`seconary_nextofkin+relationship` 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 `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+supervisor` (`position+supervisor` (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 [Wed Aug 03 02:57:54 2011] [error] [client 196.46.109.199] Refered by : http://nz.csschris.or.tz/manage-northern/index.php/CustomReports/edit/reports I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:471) I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437) I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348) I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143) I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Page.php:464) I2CE_Page->display (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89) I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/northern/pages/index.php:60) Unable to populate cached report: MDB2 Error: unknown error _doQuery: [Error message: Could not execute statement] [Last executed query: CREATE TABLE `manage_cssc_northern`.`tmp_custom_report_staff_list[22]` ( `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,`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+supervisor` 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,`accident+id` varchar(255) DEFAULT '',`accident+parent` varchar(255),`benefit+id` varchar(255) DEFAULT '',`benefit+parent` varchar(255),`benefit+amount` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`benefit+source` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`benefit+type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`confirmation_date+id` varchar(255) DEFAULT '',`confirmation_date+parent` varchar(255),`confirmation_date+confirmationdate` datetime ,`confirmation_date+confirmationletter` longblob ,`contact+id` varchar(255) DEFAULT '',`contact+parent` varchar(255),`contact+email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`contact+telephone` 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` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`demographic+marital_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`education+id` varchar(255) DEFAULT '',`education+parent` varchar(255),`education+degree` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`education+institution` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`education+location` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`education+major` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`education+year` datetime ,`emergency+id` varchar(255) DEFAULT '',`emergency+parent` varchar(255),`emergency+address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`emergency+email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`emergency+telephone` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`employment+id` varchar(255) DEFAULT '',`employment+parent` varchar(255),`employment+company_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`employment+reason_for_leaving` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`employment+responsibilities` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`employment+supervisor` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`employment_id+id` varchar(255) DEFAULT '',`employment_id+parent` varchar(255),`employment_id+check_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`employment_id+pf_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`home+id` varchar(255) DEFAULT '',`home+parent` varchar(255),`home+address` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`home+email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`home+telephone` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`nationality+id` varchar(255) DEFAULT '',`nationality+parent` varchar(255),`person_leave+id` varchar(255) DEFAULT '',`person_leave+parent` varchar(255),`person_leave+duration` int(11) ,`person_leave+leave_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`person_leave+start_date` datetime ,`person_photo+id` varchar(255) DEFAULT '',`person_photo+parent` varchar(255),`person_resume+id` varchar(255) DEFAULT '',`person_resume+parent` varchar(255),`primary_nextofkin+id` varchar(255) DEFAULT '',`primary_nextofkin+parent` varchar(255),`primary_nextofkin+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_nextofkin+relationship` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`registration+id` varchar(255) DEFAULT '',`registration+parent` varchar(255),`seconary_nextofkin+id` varchar(255) DEFAULT '',`seconary_nextofkin+parent` varchar(255),`seconary_nextofkin+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`seconary_nextofkin+relationship` 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 `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+supervisor` (`position+supervisor` (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: 1118] [Native message: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs] [Wed Aug 03 02:57:54 2011] [error] [client 196.46.109.199] Refered by : http://nz.csschris.or.tz/manage-northern/index.php/CustomReports/edit/reports I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:439) I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348) I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143) I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Page.php:464) I2CE_Page->display (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89) I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/northern/pages/index.php:60) Report generation failed for staff_list [Wed Aug 03 02:57:54 2011] [error] [client 196.46.109.199] Refered by : http://nz.csschris.or.tz/manage-northern/index.php/CustomReports/edit/reports I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:145) I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Page.php:464) I2CE_Page->display (/var/lib/iHRIS/lib/4.0.15/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89) I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/northern/pages/index.php:60) Unable to generate report