Dear all

It is cconnected to UPS and Power Stabilizer.

what about if we upgrade the mysql 5.0.67 to the next version. I am
using mysql 5.0.67 to all CSSC site, APHFTA & BAKWATA.


But my worry is, if i upgrade to another version above 5.x may affect
the php 5.x and apache 2.0

Your comment can help me to see if i can upgrade due to your experience!!





On 2/13/12, Carl Leitner <email address hidden> wrote:
> It could be power cuts.  Is it on a UPS?
>
> Cheers,
> -carl
>
> On Feb 13, 2012, at 5:24 AM, josephat mathayo
> <email address hidden> wrote:
>
>> Let us see what we can learn now. I asked IT Technician to turn off
>> using command line shutdown -h now
>>
>> I will update you.
>>
>> On 2/10/12, Carl Leitner <email address hidden> wrote:
>>> No this is not because of 4.0.19.
>>>
>>> Is this the same machine that it happened on before?
>>>
>>> Maybe the machine is not getting powered off correctly which is causing
>>> the database to be corrupted.
>>>
>>> Cheers.
>>> -carl
>>>
>>> On 01/10/2012 12:08 PM, josephat mathayo wrote:
>>>> Public bug reported:
>>>>
>>>>          I2CE_Wrangler->wrangle
>>>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>>>    Skipping cached table for job as it is not dirty
>>>> [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>>    I2CE: I2CE->raiseError
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
>>>>          I2CE_CachedForm->generateCachedTable
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:422)
>>>>          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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Skipping cached table for cadre as it is not dirty
>>>> [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>>    I2CE: I2CE->raiseError
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
>>>>          I2CE_CachedForm->generateCachedTable
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:422)
>>>>          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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Skipping cached table for classification as it is not dirty
>>>> [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>>    I2CE: I2CE->raiseError
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
>>>>          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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Successfully cached all forms
>>>> [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>>    I2CE: I2CE->raiseError
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:599)
>>>>          I2CE_FormRelationship->getFunctionDetails
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:511)
>>>>          I2CE_CustomReport->getReportedFunctions
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:533)
>>>>          I2CE_CustomReport->setupQueries
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:464)
>>>>          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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Getting details on days_open
>>>> [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>>    I2CE: I2CE->raiseError
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:639)
>>>>          I2CE_FormRelationship->getFunctionDetails
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:511)
>>>>          I2CE_CustomReport->getReportedFunctions
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:533)
>>>>          I2CE_CustomReport->setupQueries
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:464)
>>>>          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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Returning sorted function details on days_open
>>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Doing DROP TABLE IF EXISTS
>>>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]`
>>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Doing CREATE TABLE
>>>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]` (
>>>> `primary_form+id` varchar(255),`primary_form+parent`
>>>> varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8
>>>> COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET
>>>> utf8
>>>> COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8
>>>> COLLATE utf8_bin,`primary_form+posted_date` datetime
>>>> ,`primary_form+code`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE
>>>> utf8_bin,`primary_form+employer`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE
>>>> utf8_bin,`primary_form+pos_type`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,last_md5 BINARY(16)
>>>> UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX
>>>> `primary_form+department` (`primary_form+department` (255)),INDEX
>>>> `primary_form+facility` (`primary_form+facility` (255)),INDEX
>>>> `primary_form+job` (`primary_form+job` (255)),INDEX
>>>> `primary_form+posted_date` (`primary_form+posted_date`),INDEX
>>>> `primary_form+code` (`primary_form+code` (255)),INDEX
>>>> `primary_form+employer` (`primary_form+employer` (255)),INDEX
>>>> `primary_form+pos_type` (`primary_form+pos_type` (255)),INDEX
>>>> `primary_form+status` (`primary_form+status` (255)),INDEX
>>>> `primary_form+title` (`primary_form+title` (255)))  ENGINE=InnoDB
>>>> DEFAULT
>>>> CHARSET=utf8 COLLATE=utf8_bin
>>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Doing INSERT INTO
>>>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]`
>>>>  SELECT `position`.id as `primary_form+id`,`position`.parent as
>>>> `primary_form+parent`,`position`.`department`  AS
>>>> `primary_form+department` ,`position`.`facility`  AS
>>>> `primary_form+facility` ,`position`.`job`  AS `primary_form+job`
>>>> ,`position`.`posted_date`  AS `primary_form+posted_date`
>>>> ,`position`.`code`  AS `primary_form+code` ,`position`.`employer`  AS
>>>> `primary_form+employer` ,`position`.`pos_type`  AS
>>>> `primary_form+pos_type`
>>>> ,`position`.`status`  AS `primary_form+status` ,`position`.`title`  AS
>>>> `primary_form+title` ,NULL AS last_md5, UNHEX(MD5(`position`.id)) AS md5
>>>> FROM `manage_cssc_lake`.`hippo_position` AS `position`
>>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>>    I2CE: I2CE->raiseError
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
>>>>          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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Inserted 3761 rows
>>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Doing DROP TABLE IF EXISTS
>>>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]`
>>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Doing CREATE TABLE
>>>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]` (
>>>> `primary_form+id` varchar(255),`primary_form+parent`
>>>> varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8
>>>> COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET
>>>> utf8
>>>> COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8
>>>> COLLATE utf8_bin,`primary_form+posted_date` datetime
>>>> ,`primary_form+code`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE
>>>> utf8_bin,`primary_form+employer`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE
>>>> utf8_bin,`primary_form+pos_type`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`current+id`
>>>> varchar(255) DEFAULT '',`current+parent` varchar(255),`current+end_date`
>>>> datetime ,`current+start_date` datetime ,last_md5 BINARY(16) UNIQUE,md5
>>>> BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX
>>>> `primary_form+department`
>>>> (`primary_form+department` (255)),INDEX `primary_form+facility`
>>>> (`primary_form+facility` (255)),INDEX `primary_form+job`
>>>> (`primary_form+job` (255)),INDEX `primary_form+posted_date`
>>>> (`primary_form+posted_date`),INDEX `primary_form+code`
>>>> (`primary_form+code` (255)),INDEX `primary_form+employer`
>>>> (`primary_form+employer` (255)),INDEX `primary_form+pos_type`
>>>> (`primary_form+pos_type` (255)),INDEX `primary_form+status`
>>>> (`primary_form+status` (255)),INDEX `primary_form+title`
>>>> (`primary_form+title` (255)),INDEX `current+end_date`
>>>> (`current+end_date`),INDEX `current+start_date` (`current+start_date`))
>>>> ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
>>>> [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Doing INSERT  IGNORE  INTO
>>>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]`   SELECT
>>>> `base_table`.`primary_form+id` as
>>>> `primary_form+id`,`base_table`.`primary_form+parent` as
>>>> `primary_form+parent`,`base_table`.`primary_form+department` as
>>>> `primary_form+department`,`base_table`.`primary_form+facility` as
>>>> `primary_form+facility`,`base_table`.`primary_form+job` as
>>>> `primary_form+job`,`base_table`.`primary_form+posted_date` as
>>>> `primary_form+posted_date`,`base_table`.`primary_form+code` as
>>>> `primary_form+code`,`base_table`.`primary_form+employer` as
>>>> `primary_form+employer`,`base_table`.`primary_form+pos_type` as
>>>> `primary_form+pos_type`,`base_table`.`primary_form+status` as
>>>> `primary_form+status`,`base_table`.`primary_form+title` as
>>>> `primary_form+title` , `current`.id  as `current+id`,`current`.parent
>>>> as
>>>> `current+parent`,`current`.`end_date`  AS `current+end_date`
>>>> ,`current`.`start_date`  AS `current+start_date` , base_table.md5 AS
>>>> last_md5 ,
>>>> UNHEX(MD5(CONCAT_WS('',base_table.`primary_form+id`,`current`.id))) AS
>>>> md5
>>>> FROM  `manage_cssc_lake`.`tmp_custom_report_position_list[1]` AS
>>>> `base_table` LEFT JOIN   `manage_cssc_lake`.`hippo_person_position` AS
>>>> `current`   ON ( ( `current`.`position` = `primary_form+id`  ) )  WHERE
>>>> ((
>>>> ( ISNULL( `current`.`end_date`) OR `current`.`end_date` = '0000-00-00
>>>> 00:00:00' )))
>>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>>    I2CE: I2CE->raiseError
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
>>>>          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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Inserted 3755 rows
>>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Doing INSERT IGNORE INTO
>>>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]`  SELECT
>>>> `base_table`.`primary_form+id` as
>>>> `primary_form+id`,`base_table`.`primary_form+parent` as
>>>> `primary_form+parent`,`base_table`.`primary_form+department` as
>>>> `primary_form+department`,`base_table`.`primary_form+facility` as
>>>> `primary_form+facility`,`base_table`.`primary_form+job` as
>>>> `primary_form+job`,`base_table`.`primary_form+posted_date` as
>>>> `primary_form+posted_date`,`base_table`.`primary_form+code` as
>>>> `primary_form+code`,`base_table`.`primary_form+employer` as
>>>> `primary_form+employer`,`base_table`.`primary_form+pos_type` as
>>>> `primary_form+pos_type`,`base_table`.`primary_form+status` as
>>>> `primary_form+status`,`base_table`.`primary_form+title` as
>>>> `primary_form+title` , '' AS `current+id`, NULL AS `current+parent`,
>>>> NULL
>>>> AS `current+end_date`, NULL AS `current+start_date`,base_table.md5 AS
>>>> md5,
>>>> base_table.md5 AS last_md5 FROM
>>>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]` AS `base_table`
>>>> WHERE md5 NOT IN ( SELECT last_md5 FROM
>>>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]`)
>>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>>    I2CE: I2CE->raiseError
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
>>>>          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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Inserted 6 rows
>>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Doing DROP TABLE IF EXISTS
>>>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]`
>>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Doing DROP TABLE IF EXISTS
>>>> `manage_cssc_lake`.`tmp_custom_report_position_list[3]`
>>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Doing CREATE TABLE
>>>> `manage_cssc_lake`.`tmp_custom_report_position_list[3]` (
>>>> `primary_form+id` varchar(255),`primary_form+parent`
>>>> varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8
>>>> COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET
>>>> utf8
>>>> COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8
>>>> COLLATE utf8_bin,`primary_form+posted_date` datetime
>>>> ,`primary_form+code`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE
>>>> utf8_bin,`primary_form+employer`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE
>>>> utf8_bin,`primary_form+pos_type`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`current+id`
>>>> varchar(255) DEFAULT '',`current+parent` varchar(255),`current+end_date`
>>>> datetime ,`current+start_date` datetime ,`department+id` varchar(255)
>>>> DEFAULT '',`department+parent` varchar(255),`department+name` text
>>>> CHARACTER SET utf8  COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5
>>>> BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX
>>>> `primary_form+department`
>>>> (`primary_form+department` (255)),INDEX `primary_form+facility`
>>>> (`primary_form+facility` (255)),INDEX `primary_form+job`
>>>> (`primary_form+job` (255)),INDEX `primary_form+posted_date`
>>>> (`primary_form+posted_date`),INDEX `primary_form+code`
>>>> (`primary_form+code` (255)),INDEX `primary_form+employer`
>>>> (`primary_form+employer` (255)),INDEX `primary_form+pos_type`
>>>> (`primary_form+pos_type` (255)),INDEX `primary_form+status`
>>>> (`primary_form+status` (255)),INDEX `primary_form+title`
>>>> (`primary_form+title` (255)),INDEX `current+end_date`
>>>> (`current+end_date`),INDEX `current+start_date` (`current+start_date`))
>>>> ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
>>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>>    I2CE: I2CE->pearError
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:471)
>>>>          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:143)
>>>>          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/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_position_list[3]` (
>>>> `primary_form+id` varchar(255),`primary_form+parent`
>>>> varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8
>>>> COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET
>>>> utf8
>>>> COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8
>>>> COLLATE utf8_bin,`primary_form+posted_date` datetime
>>>> ,`primary_form+code`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE
>>>> utf8_bin,`primary_form+employer`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE
>>>> utf8_bin,`primary_form+pos_type`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title`
>>>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`current+id`
>>>> varchar(255) DEFAULT '',`current+parent` varchar(255),`current+end_date`
>>>> datetime ,`current+start_date` datetime ,`department+id` varchar(255)
>>>> DEFAULT '',`department+parent` varchar(255),`department+name` text
>>>> CHARACTER SET utf8  COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5
>>>> BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX
>>>> `primary_form+department`
>>>> (`primary_form+department` (255)),INDEX `primary_form+facility`
>>>> (`primary_form+facility` (255)),INDEX `primary_form+job`
>>>> (`primary_form+job` (255)),INDEX `primary_form+posted_date`
>>>> (`primary_form+posted_date`),INDEX `primary_form+code`
>>>> (`primary_form+code` (255)),INDEX `primary_form+employer`
>>>> (`primary_form+employer` (255)),INDEX `primary_form+pos_type`
>>>> (`primary_form+pos_type` (255)),INDEX `primary_form+status`
>>>> (`primary_form+status` (255)),INDEX `primary_form+title`
>>>> (`primary_form+title` (255)),INDEX `current+end_date`
>>>> (`current+end_date`),INDEX `current+start_date` (`current+start_date`))
>>>> ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin]
>>>>    [Native code: 1005]
>>>>    [Native message: Can't create table
>>>> './manage_cssc_lake/tmp_custom_report_position_list[3].frm' (errno:
>>>> 121)]
>>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>>    I2CE: I2CE->raiseError
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:439)
>>>>          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:143)
>>>>          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/lake/pages/index.php:60)
>>>>    Report generation failed for position_list
>>>> [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>>>    Refered by :
>>>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>>>    I2CE: I2CE->raiseError
>>>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:145)
>>>>          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/lake/pages/index.php:60)
>>>>    Unable to generate report
>>>>
>>>> ** Affects: i2ce
>>>>      Importance: Undecided
>>>>          Status: New
>>>>
>>>
>>> --
>>> You received this bug notification because you are subscribed to the bug
>>> report.
>>> https://bugs.launchpad.net/bugs/914185
>>>
>>> Title:
>>>  Position list report - Fails to generate ( The same happened, I
>>>  dropped the database and restored then it worked) Does this because of
>>>  4.0.19
>>>
>>> To manage notifications about this bug go to:
>>> https://bugs.launchpad.net/i2ce/+bug/914185/+subscriptions
>>>
>>
>>
>> --
>> --
>> Best Regard,
>> Mathayo Josephat
>> CSSC Tanzania Human Resource Capacity Project
>> P.O Box 9433 Dar es Salaam, Tanzania
>> Cell: 255 754 940 636 | 712 191 192
>> Tel:  255 22 211 2918 | 255 22 213 5070
>>
>> <email address hidden> | <email address hidden>
>>
>> -------------------------------------------------
>>
>> --
>> You received this bug notification because you are subscribed to I2CE.
>> https://bugs.launchpad.net/bugs/914185
>>
>> Title:
>>  Position list report - Fails to generate ( The same happened, I
>>  dropped the database and restored then it worked) Does this because of
>>  4.0.19
>>
>> Status in IntraHealth Informatics Core Engine:
>>  New
>>
>> Bug description:
>>            I2CE_Wrangler->wrangle
>> (/var/lib/iHRIS/cssc_zonal_deploy/sites/lake/pages/index.php:60)
>>      Skipping cached table for job as it is not dirty
>>  [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>      I2CE: I2CE->raiseError
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
>>            I2CE_CachedForm->generateCachedTable
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:422)
>>            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:143)
>>            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/lake/pages/index.php:60)
>>      Skipping cached table for cadre as it is not dirty
>>  [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>      I2CE: I2CE->raiseError
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
>>            I2CE_CachedForm->generateCachedTable
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:422)
>>            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:143)
>>            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/lake/pages/index.php:60)
>>      Skipping cached table for classification as it is not dirty
>>  [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>      I2CE: I2CE->raiseError
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
>>            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:143)
>>            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/lake/pages/index.php:60)
>>      Successfully cached all forms
>>  [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>      I2CE: I2CE->raiseError
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:599)
>>            I2CE_FormRelationship->getFunctionDetails
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:511)
>>            I2CE_CustomReport->getReportedFunctions
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:533)
>>            I2CE_CustomReport->setupQueries
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:464)
>>            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:143)
>>            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/lake/pages/index.php:60)
>>      Getting details on days_open
>>  [Tue Jan 10 05:06:10 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>      I2CE: I2CE->raiseError
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:639)
>>            I2CE_FormRelationship->getFunctionDetails
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:511)
>>            I2CE_CustomReport->getReportedFunctions
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:533)
>>            I2CE_CustomReport->setupQueries
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:464)
>>            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:143)
>>            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/lake/pages/index.php:60)
>>      Returning sorted function details on days_open
>>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/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:143)
>>            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/lake/pages/index.php:60)
>>      Doing DROP TABLE IF EXISTS
>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]`
>>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/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:143)
>>            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/lake/pages/index.php:60)
>>      Doing CREATE TABLE
>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]` (
>> `primary_form+id` varchar(255),`primary_form+parent`
>> varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8
>> COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET utf8
>> COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8
>> COLLATE utf8_bin,`primary_form+posted_date` datetime ,`primary_form+code`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+employer`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+pos_type`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,last_md5 BINARY(16)
>> UNIQUE,md5 BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX
>> `primary_form+department` (`primary_form+department` (255)),INDEX
>> `primary_form+facility` (`primary_form+facility` (255)),INDEX
>> `primary_form+job` (`primary_form+job` (255)),INDEX
>> `primary_form+posted_date` (`primary_form+posted_date`),INDEX
>> `primary_form+code` (`primary_form+code` (255)),INDEX
>> `primary_form+employer` (`primary_form+employer` (255)),INDEX
>> `primary_form+pos_type` (`primary_form+pos_type` (255)),INDEX
>> `primary_form+status` (`primary_form+status` (255)),INDEX
>> `primary_form+title` (`primary_form+title` (255)))  ENGINE=InnoDB DEFAULT
>> CHARSET=utf8 COLLATE=utf8_bin
>>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/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:143)
>>            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/lake/pages/index.php:60)
>>      Doing INSERT INTO
>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]`   SELECT
>> `position`.id as `primary_form+id`,`position`.parent as
>> `primary_form+parent`,`position`.`department`  AS
>> `primary_form+department` ,`position`.`facility`  AS
>> `primary_form+facility` ,`position`.`job`  AS `primary_form+job`
>> ,`position`.`posted_date`  AS `primary_form+posted_date`
>> ,`position`.`code`  AS `primary_form+code` ,`position`.`employer`  AS
>> `primary_form+employer` ,`position`.`pos_type`  AS `primary_form+pos_type`
>> ,`position`.`status`  AS `primary_form+status` ,`position`.`title`  AS
>> `primary_form+title` ,NULL AS last_md5, UNHEX(MD5(`position`.id)) AS md5
>> FROM `manage_cssc_lake`.`hippo_position` AS `position`
>>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>      I2CE: I2CE->raiseError
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
>>            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:143)
>>            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/lake/pages/index.php:60)
>>      Inserted 3761 rows
>>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/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:143)
>>            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/lake/pages/index.php:60)
>>      Doing DROP TABLE IF EXISTS
>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]`
>>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/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:143)
>>            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/lake/pages/index.php:60)
>>      Doing CREATE TABLE
>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]` (
>> `primary_form+id` varchar(255),`primary_form+parent`
>> varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8
>> COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET utf8
>> COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8
>> COLLATE utf8_bin,`primary_form+posted_date` datetime ,`primary_form+code`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+employer`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+pos_type`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`current+id`
>> varchar(255) DEFAULT '',`current+parent` varchar(255),`current+end_date`
>> datetime ,`current+start_date` datetime ,last_md5 BINARY(16) UNIQUE,md5
>> BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+department`
>> (`primary_form+department` (255)),INDEX `primary_form+facility`
>> (`primary_form+facility` (255)),INDEX `primary_form+job`
>> (`primary_form+job` (255)),INDEX `primary_form+posted_date`
>> (`primary_form+posted_date`),INDEX `primary_form+code`
>> (`primary_form+code` (255)),INDEX `primary_form+employer`
>> (`primary_form+employer` (255)),INDEX `primary_form+pos_type`
>> (`primary_form+pos_type` (255)),INDEX `primary_form+status`
>> (`primary_form+status` (255)),INDEX `primary_form+title`
>> (`primary_form+title` (255)),INDEX `current+end_date`
>> (`current+end_date`),INDEX `current+start_date` (`current+start_date`))
>> ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
>>  [Tue Jan 10 05:06:11 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/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:143)
>>            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/lake/pages/index.php:60)
>>      Doing INSERT  IGNORE  INTO
>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]`   SELECT
>> `base_table`.`primary_form+id` as
>> `primary_form+id`,`base_table`.`primary_form+parent` as
>> `primary_form+parent`,`base_table`.`primary_form+department` as
>> `primary_form+department`,`base_table`.`primary_form+facility` as
>> `primary_form+facility`,`base_table`.`primary_form+job` as
>> `primary_form+job`,`base_table`.`primary_form+posted_date` as
>> `primary_form+posted_date`,`base_table`.`primary_form+code` as
>> `primary_form+code`,`base_table`.`primary_form+employer` as
>> `primary_form+employer`,`base_table`.`primary_form+pos_type` as
>> `primary_form+pos_type`,`base_table`.`primary_form+status` as
>> `primary_form+status`,`base_table`.`primary_form+title` as
>> `primary_form+title` , `current`.id  as `current+id`,`current`.parent  as
>> `current+parent`,`current`.`end_date`  AS `current+end_date`
>> ,`current`.`start_date`  AS `current+start_date` , base_table.md5 AS
>> last_md5 ,
>> UNHEX(MD5(CONCAT_WS('',base_table.`primary_form+id`,`current`.id))) AS md5
>>  FROM  `manage_cssc_lake`.`tmp_custom_report_position_list[1]` AS
>> `base_table` LEFT JOIN   `manage_cssc_lake`.`hippo_person_position` AS
>> `current`   ON ( ( `current`.`position` = `primary_form+id`  ) )  WHERE ((
>> ( ISNULL( `current`.`end_date`) OR `current`.`end_date` = '0000-00-00
>> 00:00:00' )))
>>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>      I2CE: I2CE->raiseError
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
>>            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:143)
>>            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/lake/pages/index.php:60)
>>      Inserted 3755 rows
>>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/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:143)
>>            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/lake/pages/index.php:60)
>>      Doing INSERT IGNORE INTO
>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]`  SELECT
>> `base_table`.`primary_form+id` as
>> `primary_form+id`,`base_table`.`primary_form+parent` as
>> `primary_form+parent`,`base_table`.`primary_form+department` as
>> `primary_form+department`,`base_table`.`primary_form+facility` as
>> `primary_form+facility`,`base_table`.`primary_form+job` as
>> `primary_form+job`,`base_table`.`primary_form+posted_date` as
>> `primary_form+posted_date`,`base_table`.`primary_form+code` as
>> `primary_form+code`,`base_table`.`primary_form+employer` as
>> `primary_form+employer`,`base_table`.`primary_form+pos_type` as
>> `primary_form+pos_type`,`base_table`.`primary_form+status` as
>> `primary_form+status`,`base_table`.`primary_form+title` as
>> `primary_form+title` , '' AS `current+id`, NULL AS `current+parent`, NULL
>> AS `current+end_date`, NULL AS `current+start_date`,base_table.md5 AS md5,
>> base_table.md5 AS last_md5 FROM
>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]` AS `base_table`
>> WHERE md5 NOT IN ( SELECT last_md5 FROM
>> `manage_cssc_lake`.`tmp_custom_report_position_list[2]`)
>>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>      I2CE: I2CE->raiseError
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:475)
>>            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:143)
>>            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/lake/pages/index.php:60)
>>      Inserted 6 rows
>>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/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:143)
>>            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/lake/pages/index.php:60)
>>      Doing DROP TABLE IF EXISTS
>> `manage_cssc_lake`.`tmp_custom_report_position_list[1]`
>>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/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:143)
>>            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/lake/pages/index.php:60)
>>      Doing DROP TABLE IF EXISTS
>> `manage_cssc_lake`.`tmp_custom_report_position_list[3]`
>>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/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:143)
>>            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/lake/pages/index.php:60)
>>      Doing CREATE TABLE
>> `manage_cssc_lake`.`tmp_custom_report_position_list[3]` (
>> `primary_form+id` varchar(255),`primary_form+parent`
>> varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8
>> COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET utf8
>> COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8
>> COLLATE utf8_bin,`primary_form+posted_date` datetime ,`primary_form+code`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+employer`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+pos_type`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`current+id`
>> varchar(255) DEFAULT '',`current+parent` varchar(255),`current+end_date`
>> datetime ,`current+start_date` datetime ,`department+id` varchar(255)
>> DEFAULT '',`department+parent` varchar(255),`department+name` text
>> CHARACTER SET utf8  COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5
>> BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+department`
>> (`primary_form+department` (255)),INDEX `primary_form+facility`
>> (`primary_form+facility` (255)),INDEX `primary_form+job`
>> (`primary_form+job` (255)),INDEX `primary_form+posted_date`
>> (`primary_form+posted_date`),INDEX `primary_form+code`
>> (`primary_form+code` (255)),INDEX `primary_form+employer`
>> (`primary_form+employer` (255)),INDEX `primary_form+pos_type`
>> (`primary_form+pos_type` (255)),INDEX `primary_form+status`
>> (`primary_form+status` (255)),INDEX `primary_form+title`
>> (`primary_form+title` (255)),INDEX `current+end_date`
>> (`current+end_date`),INDEX `current+start_date` (`current+start_date`))
>> ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
>>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>      I2CE: I2CE->pearError
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:471)
>>            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:143)
>>            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/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_position_list[3]` (
>> `primary_form+id` varchar(255),`primary_form+parent`
>> varchar(255),`primary_form+department` varchar(255)  CHARACTER SET utf8
>> COLLATE utf8_bin,`primary_form+facility` varchar(255)  CHARACTER SET utf8
>> COLLATE utf8_bin,`primary_form+job` varchar(255)  CHARACTER SET utf8
>> COLLATE utf8_bin,`primary_form+posted_date` datetime ,`primary_form+code`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+employer`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+pos_type`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+status`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`primary_form+title`
>> varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`current+id`
>> varchar(255) DEFAULT '',`current+parent` varchar(255),`current+end_date`
>> datetime ,`current+start_date` datetime ,`department+id` varchar(255)
>> DEFAULT '',`department+parent` varchar(255),`department+name` text
>> CHARACTER SET utf8  COLLATE utf8_bin,last_md5 BINARY(16) UNIQUE,md5
>> BINARY(16) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+department`
>> (`primary_form+department` (255)),INDEX `primary_form+facility`
>> (`primary_form+facility` (255)),INDEX `primary_form+job`
>> (`primary_form+job` (255)),INDEX `primary_form+posted_date`
>> (`primary_form+posted_date`),INDEX `primary_form+code`
>> (`primary_form+code` (255)),INDEX `primary_form+employer`
>> (`primary_form+employer` (255)),INDEX `primary_form+pos_type`
>> (`primary_form+pos_type` (255)),INDEX `primary_form+status`
>> (`primary_form+status` (255)),INDEX `primary_form+title`
>> (`primary_form+title` (255)),INDEX `current+end_date`
>> (`current+end_date`),INDEX `current+start_date` (`current+start_date`))
>> ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin]
>>      [Native code: 1005]
>>      [Native message: Can't create table
>> './manage_cssc_lake/tmp_custom_report_position_list[3].frm' (errno: 121)]
>>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>      I2CE: I2CE->raiseError
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:439)
>>            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:143)
>>            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/lake/pages/index.php:60)
>>      Report generation failed for position_list
>>  [Tue Jan 10 05:06:12 2012] [error] [client 196.46.109.151]
>>      Refered by :
>> http://lz.csschris.or.tz/manage-lake/index.php/CustomReports/edit/reports
>>      I2CE: I2CE->raiseError
>> (/var/lib/iHRIS/lib/4.0.19/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:145)
>>            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/lake/pages/index.php:60)
>>      Unable to generate report
>>
>> To manage notifications about this bug go to:
>> https://bugs.launchpad.net/i2ce/+bug/914185/+subscriptions
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/914185
>
> Title:
>   Position list report - Fails to generate ( The same happened, I
>   dropped the database and restored then it worked) Does this because of
>   4.0.19
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/i2ce/+bug/914185/+subscriptions
>


-- 
-- 
Best Regard,
Mathayo Josephat
CSSC Tanzania Human Resource Capacity Project
P.O Box 9433 Dar es Salaam, Tanzania
Cell: 255 754 940 636 | 712 191 192
Tel:  255 22 211 2918 | 255 22 213 5070

<email address hidden> | <email address hidden>

-------------------------------------------------