Sovello

    Unable to populate cached report:
    MDB2 Error: syntax error
    _doQuery: [Error message: Could not execute statement]
    [Last executed query: CREATE TABLE `ihrisudsmdev`.`tmp_custom_report_Tange_Positions[9]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+status` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`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,`current+id` varchar(255),`current+parent` varchar(255),`current+end_date` datetime ,`department+id` varchar(255),`department+parent` varchar(255),`facility+id` varchar(255),`facility+parent` varchar(255),`job+id` varchar(255),`job+parent` varchar(255),`job+cadre` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`job+classification` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`job+code` varchar(255)  CHARACTER SET utf8  COLLATE utf8_bin,`last+id` varchar(255),`last+parent` varchar(255),`last+end_date` datetime ,`cadre+id` varchar(255),`cadre+parent` varchar(255),`classification+id` varchar(255),`classification+parent` varchar(255),last_md5 VARCHAR(32) UNIQUE,md5 VARCHAR(32) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+status` (`primary_form+status` (255)),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 `current+end_date` (`current+end_date`),INDEX `job+cadre` (`job+cadre` (255)),INDEX `job+classification` (`job+classification` (255)),INDEX `job+code` (`job+code` (255)),INDEX `last+end_date` (`last+end_date`),`+current_age` )  ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin]
    [Native code: 1064]
    [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')  ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 1]
[Thu Jan 27 15:31:46 2011] [error] [client 196.44.164.3]
    Refered by : http://196.44.162.26/managedev/index.php/CustomReports/edit/reports
    I2CE: I2CE->raiseError (/var/lib/iHRISdev/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:432)
          I2CE_CustomReport->generateCache (/var/lib/iHRISdev/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
          I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRISdev/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
          I2CE_Page_CustomReports->action (/var/lib/iHRISdev/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
          I2CE_Page->display (/var/lib/iHRISdev/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
          I2CE_Wrangler->wrangle (/var/lib/iHRISdev/sites/managedev/pages/index.php:60)
    Report generation failed for Tange_Positions
[Thu Jan 27 15:31:46 2011] [error] [client 196.44.164.3]
    Refered by : http://196.44.162.26/managedev/index.php/CustomReports/edit/reports
    I2CE: I2CE->raiseError (/var/lib/iHRISdev/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:145)
          I2CE_Page_CustomReports->action (/var/lib/iHRISdev/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
          I2CE_Page->display (/var/lib/iHRISdev/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
          I2CE_Wrangler->wrangle (/var/lib/iHRISdev/sites/managedev/pages/index.php:60)
    Unable to generate report