ihris-manage-cssc

Checking more than 17 fields in Report View for 4.0.18 - fails in generating report

Bug #893478 reported by josephat mathayo
18
This bug affects 1 person
Affects Status Importance Assigned to Milestone
ihris-manage-cssc
New
Undecided
Unassigned

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

Revision history for this message
josephat mathayo (jmathayo) wrote :

We need to look as well in 4.1 and 4.0.19

Revision history for this message
Carl Leitner (litlfred) wrote :

I am using MariaDB (an alternative to mysql) and did not have any problems running the CREATE TABLE query above.

What version of mysql are you using?

Revision history for this message
Carl Leitner (litlfred) wrote :

Checked in mysql version (5.1.58) installed with Ubuntu 11.10 and it works as well.

Revision history for this message
Carl Leitner (litlfred) wrote : Re: [Bug 893478] Re: Checking more than 17 fields in Report View for 4.0.18 - fails in generating report
Download full text (34.0 KiB)

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_Cust...

Revision history for this message
Carl Leitner (litlfred) wrote :

Mathayo: can you post here the verison of mysql you are using where you are seeing this problem. Please post the ouput of
  mysql -V

Revision history for this message
Carl Leitner (litlfred) wrote :

Can you upload the files /var/log/mysql.log and /var/log/mysql.err on the machine where this is failing?
(Do so my clicking "Add attachment or patch" in the comment section of this bug report)

Revision history for this message
Carl Leitner (litlfred) wrote :

Mathayo: can you post here the verison of mysql you are using where you are seeing this problem. Please post the ouput of
  mysql -V

Revision history for this message
josephat mathayo (jmathayo) wrote :

hris@hris:~$ mysql -v
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 465
Server version: 5.0.67-0ubuntu6.1 (Ubuntu)

Revision history for this message
josephat mathayo (jmathayo) wrote :
Download full text (20.4 KiB)

Today again it happened in southern Zone in 4.0.19
 Inserted 4937 rows
[Mon Dec 05 05:36:51 2011] [error] [client 197.250.212.99]
 Refered by : http://sz.csschris.or.tz/manage-southern/index.php/CustomReports/edit/reports
 I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:469)
       I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:437)
       I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:348)
       I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:133)
       I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Page.php:464)
       I2CE_Page->display (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
       I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/southern/pages/index.php:60)
 Doing INSERT IGNORE INTO `manage_cssc_southern`.`tmp_custom_report_search_people[13]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+residence` as `primary_form+residence`,`base_table`.`primary_form+firstname` as `primary_form+firstname`,`base_table`.`primary_form+relg_affil` as `primary_form+relg_affil`,`base_table`.`primary_form+surname` as `primary_form+surname`,`base_table`.`accident+id` as `accident+id`,`base_table`.`accident+parent` as `accident+parent`,`base_table`.`application+id` as `application+id`,`base_table`.`application+parent` as `application+parent`,`base_table`.`application+position` as `application+position`,`base_table`.`confirmationtoservice+id` as `confirmationtoservice+id`,`base_table`.`confirmationtoservice+parent` as `confirmationtoservice+parent`,`base_table`.`confirmationtoservice+confirmationdate` as `confirmationtoservice+confirmationdate`,`base_table`.`ditrict+id` as `ditrict+id`,`base_table`.`ditrict+parent` as `ditrict+parent`,`base_table`.`ditrict+region` as `ditrict+region`,`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`.`employment_id+tsd_num` as `employment_id+tsd_num`,`base_table`.`last_person_position+id` as `last_person_position+id`,`base_table`.`last_person_position+parent` as `last_person_position+parent`,`base_table`.`last_person_position+start_date` as `last_person_position+start_date`,`base_table`.`last_person_position+position` as `last_person_position+position`,`base_table`.`last_person_position+end_date` as `last_person_position+end_date`,`base_table`.`last_person_position+reason` as `last_person_position+reason`,`base_table`.`person_leave+id` as `person_leave+id`,`base_table`.`person_leave+parent` as `person_leave+parent`,`base_table`.`person_leave+leave_type` as `person_leave+leave_type`,`base_table`.`person_leave+start_date` as `person_leave+start_date`,`base_table`.`primary_ne...

Revision history for this message
josephat mathayo (jmathayo) wrote :

Could not rename temp table:
 MDB2 Error: unknown error
in Southern Zone site the mysql site
hris@hris:~$ sudo mysql -V
mysql Ver 14.12 Distrib 5.0.67, for debian-linux-gnu (i486) using readline 5.2

Revision history for this message
josephat mathayo (jmathayo) wrote :

For Lake Zone

the less /var/log/mysql.err

nothing is displayed even if i do tail /var/log/mysql/log

Revision history for this message
josephat mathayo (jmathayo) wrote :

Have looked into the word Adding person posotion, does this was renamed in 4.0.19.

Revision history for this message
Carl Leitner (litlfred) wrote :

The error for Southern Zone is different. There mysql is giving an error of 1025. However some googling says that this is probably related to foreign keys, but there aren't any here. So still confused why you are getting these errors...

Revision history for this message
josephat mathayo (jmathayo) wrote :

But in southern i do not see the zebra_search people, May could the issue, Can i drop the database and re-do

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.