Advertisement
ihris

Untitled

Dec 7th, 2010
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 52.53 KB | None | 0 0
  1. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  2. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  3. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:398)
  4. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  5. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  6. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  7. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  8. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  9. Attempting to cache the required forms for the report establishment_2010_var:
  10. establishment,facility,job,position
  11. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  12. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  13. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
  14. I2CE_CachedForm->generateCachedTable (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:415)
  15. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  16. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  17. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  18. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  19. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  20. Skipping cached table for establishment as it is not dirty
  21. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  22. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  23. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
  24. I2CE_CachedForm->generateCachedTable (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:415)
  25. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  26. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  27. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  28. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  29. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  30. Skipping cached table for facility as it is not dirty
  31. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  32. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  33. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
  34. I2CE_CachedForm->generateCachedTable (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:415)
  35. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  36. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  37. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  38. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  39. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  40. Skipping cached table for job as it is not dirty
  41. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  42. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  43. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
  44. I2CE_CachedForm->generateCachedTable (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:415)
  45. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  46. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  47. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  48. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  49. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  50. Skipping cached table for position as it is not dirty
  51. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  52. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  53. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:423)
  54. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  55. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  56. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  57. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  58. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  59. Successfully cached all forms
  60. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  61. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  62. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:599)
  63. I2CE_FormRelationship->getFunctionDetails (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:494)
  64. I2CE_CustomReport->getReportedFunctions (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:516)
  65. I2CE_CustomReport->setupQueries (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:447)
  66. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  67. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  68. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  69. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  70. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  71. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  72. Gettuing details on filled_positions,variance
  73. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  74. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  75. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  76. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  77. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  78. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  79. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  80. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  81. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  82. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[1]`
  83. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  84. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  85. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  86. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  87. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  88. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  89. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  90. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  91. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  92. Doing CREATE TABLE `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[1]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+establishment_period` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+location` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+job_cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+amount` int(11) ,last_md5 VARCHAR(32) UNIQUE,md5 VARCHAR(32) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+establishment_period` (`primary_form+establishment_period` (255)),INDEX `primary_form+location` (`primary_form+location` (255)),INDEX `primary_form+job_cadre` (`primary_form+job_cadre` (255)),INDEX `primary_form+amount` (`primary_form+amount`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  93. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  94. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  95. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  96. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  97. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  98. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  99. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  100. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  101. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  102. Doing INSERT INTO `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[1]` SELECT `establishment`.id as `primary_form+id`,`establishment`.parent as `primary_form+parent`,`establishment`.`establishment_period` AS `primary_form+establishment_period` ,`establishment`.`location` AS `primary_form+location` ,`establishment`.`job_cadre` AS `primary_form+job_cadre` ,`establishment`.`amount` AS `primary_form+amount` ,NULL AS last_md5, MD5(`establishment`.id) AS md5 FROM `manage_4_0_dev`.`hippo_establishment` AS `establishment` WHERE (( `establishment`.`establishment_period` = 'establishment_period|2010'))
  103. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  104. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  105. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  106. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  107. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  108. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  109. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  110. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  111. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  112. Inserted 10 rows
  113. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  114. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  115. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  116. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  117. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  118. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  119. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  120. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  121. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  122. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[2]`
  123. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  124. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  125. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  126. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  127. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  128. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  129. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  130. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  131. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  132. Doing CREATE TABLE `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[2]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+establishment_period` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+location` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+job_cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+amount` int(11) ,`facility+id` varchar(255),`facility+parent` varchar(255),`facility+facility_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`facility+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,last_md5 VARCHAR(32) UNIQUE,md5 VARCHAR(32) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+establishment_period` (`primary_form+establishment_period` (255)),INDEX `primary_form+location` (`primary_form+location` (255)),INDEX `primary_form+job_cadre` (`primary_form+job_cadre` (255)),INDEX `primary_form+amount` (`primary_form+amount`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  133. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  134. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  135. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  136. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  137. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  138. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  139. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  140. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  141. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  142. Doing UPDATE `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[1]` set md5= NULL
  143. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  144. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  145. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  146. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  147. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  148. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  149. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  150. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  151. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  152. Doing INSERT INTO `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[2]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+establishment_period` as `primary_form+establishment_period`,`base_table`.`primary_form+location` as `primary_form+location`,`base_table`.`primary_form+job_cadre` as `primary_form+job_cadre`,`base_table`.`primary_form+amount` as `primary_form+amount` , `facility`.id as `facility+id`,`facility`.parent as `facility+parent`,`facility`.`facility_type` AS `facility+facility_type` ,`facility`.`name` AS `facility+name` , base_table.md5 AS last_md5 , MD5(CONCAT(IF(ISNULL(base_table.`primary_form+id`),'',base_table.`primary_form+id`),IF(ISNULL(`facility`.id),'',`facility`.id))) AS md5 FROM `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[1]` AS `base_table` LEFT JOIN `manage_4_0_dev`.`hippo_facility` as `facility` ON ( ( `primary_form+location` = `facility`.`id` ) )
  153. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  154. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  155. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  156. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  157. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  158. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  159. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  160. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  161. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  162. Inserted 10 rows
  163. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  164. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  165. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  166. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  167. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  168. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  169. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  170. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  171. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  172. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[1]`
  173. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  174. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  175. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  176. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  177. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  178. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  179. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  180. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  181. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  182. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[3]`
  183. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  184. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  185. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  186. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  187. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  188. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  189. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  190. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  191. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  192. Doing CREATE TABLE `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[3]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+establishment_period` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+location` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+job_cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+amount` int(11) ,`facility+id` varchar(255),`facility+parent` varchar(255),`facility+facility_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`facility+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+id` varchar(255),`job+parent` varchar(255),`job+cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,last_md5 VARCHAR(32) UNIQUE,md5 VARCHAR(32) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+establishment_period` (`primary_form+establishment_period` (255)),INDEX `primary_form+location` (`primary_form+location` (255)),INDEX `primary_form+job_cadre` (`primary_form+job_cadre` (255)),INDEX `primary_form+amount` (`primary_form+amount`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  193. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  194. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  195. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  196. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  197. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  198. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  199. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  200. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  201. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  202. Doing UPDATE `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[2]` set md5= NULL
  203. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  204. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  205. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  206. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  207. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  208. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  209. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  210. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  211. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  212. Doing INSERT INTO `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[3]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+establishment_period` as `primary_form+establishment_period`,`base_table`.`primary_form+location` as `primary_form+location`,`base_table`.`primary_form+job_cadre` as `primary_form+job_cadre`,`base_table`.`primary_form+amount` as `primary_form+amount`,`base_table`.`facility+id` as `facility+id`,`base_table`.`facility+parent` as `facility+parent`,`base_table`.`facility+facility_type` as `facility+facility_type`,`base_table`.`facility+name` as `facility+name` , `job`.id as `job+id`,`job`.parent as `job+parent`,`job`.`cadre` AS `job+cadre` ,`job`.`title` AS `job+title` , base_table.md5 AS last_md5 , MD5(CONCAT(IF(ISNULL(base_table.`primary_form+id`),'',base_table.`primary_form+id`),IF(ISNULL(base_table.`facility+id`),'',base_table.`facility+id`),IF(ISNULL(`job`.id),'',`job`.id))) AS md5 FROM `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[2]` AS `base_table` LEFT JOIN `manage_4_0_dev`.`hippo_job` as `job` ON ( ( `primary_form+job_cadre` = `job`.`id` ) )
  213. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  214. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  215. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  216. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  217. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  218. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  219. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  220. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  221. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  222. Inserted 10 rows
  223. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  224. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  225. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  226. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  227. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  228. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  229. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  230. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  231. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  232. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[2]`
  233. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  234. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  235. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  236. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  237. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  238. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  239. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  240. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  241. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  242. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[4]`
  243. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  244. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  245. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  246. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  247. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  248. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  249. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  250. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  251. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  252. Doing CREATE TABLE `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[4]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+establishment_period` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+location` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+job_cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+amount` int(11) ,`facility+id` varchar(255),`facility+parent` varchar(255),`facility+facility_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`facility+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+id` varchar(255),`job+parent` varchar(255),`job+cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+id` varchar(255),`position+parent` varchar(255),last_md5 VARCHAR(32) UNIQUE,md5 VARCHAR(32) UNIQUE,KEY (`primary_form+id`),INDEX `primary_form+establishment_period` (`primary_form+establishment_period` (255)),INDEX `primary_form+location` (`primary_form+location` (255)),INDEX `primary_form+job_cadre` (`primary_form+job_cadre` (255)),INDEX `primary_form+amount` (`primary_form+amount`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  253. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  254. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  255. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  256. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  257. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  258. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  259. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  260. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  261. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  262. Doing UPDATE `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[3]` set md5= NULL
  263. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  264. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  265. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  266. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  267. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  268. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  269. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  270. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  271. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  272. Doing INSERT INTO `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[4]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+establishment_period` as `primary_form+establishment_period`,`base_table`.`primary_form+location` as `primary_form+location`,`base_table`.`primary_form+job_cadre` as `primary_form+job_cadre`,`base_table`.`primary_form+amount` as `primary_form+amount`,`base_table`.`facility+id` as `facility+id`,`base_table`.`facility+parent` as `facility+parent`,`base_table`.`facility+facility_type` as `facility+facility_type`,`base_table`.`facility+name` as `facility+name`,`base_table`.`job+id` as `job+id`,`base_table`.`job+parent` as `job+parent`,`base_table`.`job+cadre` as `job+cadre`,`base_table`.`job+title` as `job+title` , `position`.id as `position+id`,`position`.parent as `position+parent`, base_table.md5 AS last_md5 , MD5(CONCAT(IF(ISNULL(base_table.`primary_form+id`),'',base_table.`primary_form+id`),IF(ISNULL(base_table.`facility+id`),'',base_table.`facility+id`),IF(ISNULL(base_table.`job+id`),'',base_table.`job+id`),IF(ISNULL(`position`.id),'',`position`.id))) AS md5 FROM `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[3]` AS `base_table` LEFT JOIN `manage_4_0_dev`.`hippo_facility` as `facility` ON `facility`.`id` = `base_table`.`facility+id` LEFT JOIN `manage_4_0_dev`.`hippo_position` AS `position` ON ( ( `position`.`facility` = `facility+id` ) AND (`position`.`job` = `job+id` ) )
  273. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  274. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  275. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  276. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  277. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  278. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  279. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  280. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  281. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  282. Inserted 98 rows
  283. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  284. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  285. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  286. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  287. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  288. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  289. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  290. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  291. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  292. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[3]`
  293. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  294. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  295. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  296. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  297. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  298. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  299. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  300. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  301. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  302. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[5]`
  303. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  304. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  305. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  306. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  307. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  308. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  309. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  310. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  311. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  312. Doing CREATE TABLE `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[5]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+establishment_period` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+location` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+job_cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+amount` int(11) ,`facility+id` varchar(255),`facility+parent` varchar(255),`facility+facility_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`facility+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+id` varchar(255),`job+parent` varchar(255),`job+cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+id` varchar(255),`position+parent` varchar(255),KEY (`primary_form+id`),INDEX `primary_form+establishment_period` (`primary_form+establishment_period` (255)),INDEX `primary_form+location` (`primary_form+location` (255)),INDEX `primary_form+job_cadre` (`primary_form+job_cadre` (255)),INDEX `primary_form+amount` (`primary_form+amount`),`+filled_positions` int( 11 ) default NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  313. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  314. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  315. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  316. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  317. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  318. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  319. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  320. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  321. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  322. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[5]` SELECT `primary_form+id`,`primary_form+parent`,`primary_form+establishment_period`,`primary_form+location`,`primary_form+job_cadre`,`primary_form+amount`,`facility+id`,`facility+parent`,`facility+facility_type`,`facility+name`,`job+id`,`job+parent`,`job+cadre`,`job+title`,NULL AS `position+id`,NULL AS `position+parent`, count(`position+id`) AS `+filled_positions`FROM `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[4]` GROUP BY `primary_form+id`,`primary_form+parent`,`primary_form+establishment_period`,`primary_form+location`,`primary_form+job_cadre`,`primary_form+amount`,`facility+id`,`facility+parent`,`facility+facility_type`,`facility+name`,`job+id`,`job+parent`,`job+cadre`,`job+title`,`position+parent`
  323. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  324. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  325. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  326. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  327. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  328. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  329. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  330. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  331. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  332. Inserted 10 rows
  333. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  334. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  335. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  336. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  337. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  338. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  339. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  340. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  341. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  342. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[4]`
  343. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  344. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  345. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  346. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  347. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  348. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  349. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  350. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  351. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  352. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[6]`
  353. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  354. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  355. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  356. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  357. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  358. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  359. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  360. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  361. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  362. Doing CREATE TABLE `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[6]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+establishment_period` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+location` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+job_cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+amount` int(11) ,`facility+id` varchar(255),`facility+parent` varchar(255),`facility+facility_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`facility+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+id` varchar(255),`job+parent` varchar(255),`job+cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`position+id` varchar(255),`position+parent` varchar(255),KEY (`primary_form+id`),INDEX `primary_form+establishment_period` (`primary_form+establishment_period` (255)),INDEX `primary_form+location` (`primary_form+location` (255)),INDEX `primary_form+job_cadre` (`primary_form+job_cadre` (255)),INDEX `primary_form+amount` (`primary_form+amount`),`+filled_positions` int( 11 ) default NULL,`+variance` int( 11 ) default NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  363. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  364. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  365. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  366. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  367. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  368. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  369. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  370. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  371. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  372. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[6]` SELECT `primary_form+id`,`primary_form+parent`,`primary_form+establishment_period`,`primary_form+location`,`primary_form+job_cadre`,`primary_form+amount`,`facility+id`,`facility+parent`,`facility+facility_type`,`facility+name`,`job+id`,`job+parent`,`job+cadre`,`job+title`,`position+id`,`position+parent`,`+filled_positions`, `primary_form+amount`- `+filled_positions` AS `+variance`FROM `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[5]`
  373. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  374. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  375. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  376. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  377. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  378. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  379. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  380. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  381. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  382. Inserted 10 rows
  383. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  384. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  385. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  386. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  387. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  388. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  389. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  390. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  391. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  392. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_establishment_2010_var[5]`
  393. [Tue Dec 07 09:02:00 2010] [error] [client ::1]
  394. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  395. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:435)
  396. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  397. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  398. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  399. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  400. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  401. Report generation succeeded for establishment_2010_var
  402. ^A
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement