Just checked Ubuntu 8.04 running mysql 5.0.x and no problem creating this table. 


Cheers,
-carl 


On Nov 22, 2011, at 14:03, Carl Leitner <email address hidden> wrote:

> Checked in mysql version (5.1.58)  installed with Ubuntu 11.10 and it
> works as well.
> 
> -- 
> You received this bug notification because you are subscribed to ihris-
> manage-cssc.
> https://bugs.launchpad.net/bugs/893478
> 
> Title:
>  Checking more than 17 fields in Report View for 4.0.18  - fails in
>  generating report
> 
> Status in iHRIS Manage @ CSSC Tanzania:
>  New
> 
> Bug description:
>  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
> 
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/ihris-manage-cssc/+bug/893478/+subscriptions