API tools faq
paste
Advertisement
ihris

Untitled

ihris
Nov 30th, 2010
112
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 109.47 KB | None | 0 0
raw download clone embed print report
  1. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.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 position_list:
  10. position,person_position,department,facility,job,classification,cadre
  11. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.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 position as it is not dirty
  21. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.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 person_position as it is not dirty
  31. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.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 department as it is not dirty
  41. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.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 facility as it is not dirty
  51. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.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/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
  54. I2CE_CachedForm->generateCachedTable (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:415)
  55. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  56. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  57. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  58. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  59. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  60. Skipping cached table for job as it is not dirty
  61. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  62. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  63. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
  64. I2CE_CachedForm->generateCachedTable (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:415)
  65. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  66. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  67. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  68. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  69. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  70. Skipping cached table for classification as it is not dirty
  71. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  72. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  73. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:353)
  74. I2CE_CachedForm->generateCachedTable (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:415)
  75. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  76. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  77. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  78. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  79. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  80. Skipping cached table for cadre as it is not dirty
  81. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  82. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  83. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:423)
  84. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  85. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  86. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  87. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  88. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  89. Successfully cached all forms
  90. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  91. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  92. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:600)
  93. I2CE_FormRelationship->getFunctionDetails (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:494)
  94. I2CE_CustomReport->getReportedFunctions (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:516)
  95. I2CE_CustomReport->setupQueries (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:447)
  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. Gettuing details on days_open
  103. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.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/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:582)
  106. I2CE_FormRelationship->_getFunctionDetails (/home/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:548)
  107. I2CE_FormRelationship->getFunctionDetailsWalker (/home/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:609)
  108. I2CE_FormRelationship->getFunctionDetails (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:494)
  109. I2CE_CustomReport->getReportedFunctions (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:516)
  110. I2CE_CustomReport->setupQueries (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:447)
  111. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  112. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  113. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  114. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  115. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  116. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  117. Array
  118. (
  119. [qry] => DATEDIFF( IFNULL( `current+start_date`, NOW() ), IFNULL( `last+end_date`, `primary_form+posted_date`))
  120. [type] => int( 11 ) default NULL
  121. [required_fields] => Array
  122. (
  123. [0] => current+start_date
  124. [1] => last+end_date
  125. [2] => primary_form+posted_date
  126. )
  127. [field] => I2CE_FormField_INT Object
  128. (
  129. [name:protected] => days_open
  130. [options:protected] => Array
  131. (
  132. [in_db] => 1
  133. [required] =>
  134. [unique] =>
  135. )
  136. [value:protected] =>
  137. [headers:protected] => Array
  138. (
  139. )
  140. [href:protected] =>
  141. [container:protected] =>
  142. [history:protected] => Array
  143. (
  144. )
  145. [history_idx:protected] => 0
  146. [attributes:protected] => Array
  147. (
  148. )
  149. [invalid:protected] =>
  150. [__methodCache:I2CE_Fuzzy:private] =>
  151. [postfix] =>
  152. )
  153. [aggregate] =>
  154. [dependents] => Array
  155. (
  156. )
  157. )
  158. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  159. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  160. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:611)
  161. I2CE_FormRelationship->getFunctionDetails (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:494)
  162. I2CE_CustomReport->getReportedFunctions (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:516)
  163. I2CE_CustomReport->setupQueries (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:447)
  164. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  165. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  166. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  167. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  168. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  169. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  170. Array
  171. (
  172. [days_open] => Array
  173. (
  174. [qry] => DATEDIFF( IFNULL( `current+start_date`, NOW() ), IFNULL( `last+end_date`, `primary_form+posted_date`))
  175. [type] => int( 11 ) default NULL
  176. [required_fields] => Array
  177. (
  178. [0] => current+start_date
  179. [1] => last+end_date
  180. [2] => primary_form+posted_date
  181. )
  182. [field] => I2CE_FormField_INT Object
  183. (
  184. [name:protected] => days_open
  185. [options:protected] => Array
  186. (
  187. [in_db] => 1
  188. [required] =>
  189. [unique] =>
  190. )
  191. [value:protected] =>
  192. [headers:protected] => Array
  193. (
  194. )
  195. [href:protected] =>
  196. [container:protected] =>
  197. [history:protected] => Array
  198. (
  199. )
  200. [history_idx:protected] => 0
  201. [attributes:protected] => Array
  202. (
  203. )
  204. [invalid:protected] =>
  205. [__methodCache:I2CE_Fuzzy:private] =>
  206. [postfix] =>
  207. )
  208. [aggregate] =>
  209. [dependents] => Array
  210. (
  211. )
  212. )
  213. )
  214. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  215. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  216. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/Forms/modules/FormRelationship/lib/I2CE_FormRelationship.php:635)
  217. I2CE_FormRelationship->getFunctionDetails (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:494)
  218. I2CE_CustomReport->getReportedFunctions (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:516)
  219. I2CE_CustomReport->setupQueries (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:447)
  220. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  221. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  222. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  223. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  224. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  225. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  226. Array
  227. (
  228. [days_open] => Array
  229. (
  230. [qry] => DATEDIFF( IFNULL( `current+start_date`, NOW() ), IFNULL( `last+end_date`, `primary_form+posted_date`))
  231. [type] => int( 11 ) default NULL
  232. [required_fields] => Array
  233. (
  234. [0] => current+start_date
  235. [1] => last+end_date
  236. [2] => primary_form+posted_date
  237. )
  238. [field] => I2CE_FormField_INT Object
  239. (
  240. [name:protected] => days_open
  241. [options:protected] => Array
  242. (
  243. [in_db] => 1
  244. [required] =>
  245. [unique] =>
  246. )
  247. [value:protected] =>
  248. [headers:protected] => Array
  249. (
  250. )
  251. [href:protected] =>
  252. [container:protected] =>
  253. [history:protected] => Array
  254. (
  255. )
  256. [history_idx:protected] => 0
  257. [attributes:protected] => Array
  258. (
  259. )
  260. [invalid:protected] =>
  261. [__methodCache:I2CE_Fuzzy:private] =>
  262. [postfix] =>
  263. )
  264. [aggregate] =>
  265. [dependents] => Array
  266. (
  267. )
  268. )
  269. )
  270. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  271. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  272. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  273. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  274. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  275. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  276. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  277. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  278. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  279. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_position_list[1]`
  280. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  281. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  282. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  283. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  284. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  285. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  286. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  287. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  288. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  289. Doing CREATE TABLE `manage_4_0_dev`.`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+status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+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+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+status` (`primary_form+status` (255)),INDEX `primary_form+title` (`primary_form+title` (255))) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  290. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  291. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  292. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  293. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  294. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  295. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  296. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  297. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  298. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  299. Doing INSERT INTO `manage_4_0_dev`.`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`.`status` AS `primary_form+status` ,`position`.`title` AS `primary_form+title` ,NULL AS last_md5, MD5(`position`.id) AS md5 FROM `manage_4_0_dev`.`hippo_position` AS `position`
  300. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  301. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  302. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  303. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  304. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  305. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  306. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  307. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  308. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  309. Inserted 1001 rows
  310. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  311. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  312. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  313. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  314. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  315. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  316. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  317. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  318. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  319. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_position_list[2]`
  320. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  321. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  322. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  323. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  324. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  325. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  326. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  327. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  328. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  329. Doing CREATE TABLE `manage_4_0_dev`.`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+status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current+id` varchar(255),`current+parent` varchar(255),`current+end_date` datetime ,`current+start_date` datetime ,last_md5 VARCHAR(32) UNIQUE,md5 VARCHAR(32) 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+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
  330. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  331. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  332. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  333. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  334. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  335. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  336. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  337. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  338. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  339. Doing INSERT IGNORE INTO `manage_4_0_dev`.`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+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 , MD5(CONCAT(IF(ISNULL(base_table.`primary_form+id`),'',base_table.`primary_form+id`),IF(ISNULL(`current`.id),'',`current`.id))) AS md5 FROM `manage_4_0_dev`.`tmp_custom_report_position_list[1]` AS `base_table` LEFT JOIN `manage_4_0_dev`.`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' )))
  340. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  341. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  342. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  343. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  344. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  345. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  346. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  347. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  348. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  349. Inserted 997 rows
  350. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  351. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  352. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  353. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  354. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  355. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  356. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  357. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  358. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  359. Doing INSERT IGNORE INTO `manage_4_0_dev`.`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+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_4_0_dev`.`tmp_custom_report_position_list[1]` AS `base_table`
  360. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  361. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  362. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  363. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  364. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  365. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  366. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  367. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  368. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  369. Inserted 4 rows
  370. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  371. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  372. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  373. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  374. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  375. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  376. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  377. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  378. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  379. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_position_list[3]`
  380. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  381. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  382. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  383. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  384. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  385. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  386. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  387. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  388. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  389. Doing CREATE TABLE `manage_4_0_dev`.`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+status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current+id` varchar(255),`current+parent` varchar(255),`current+end_date` datetime ,`current+start_date` datetime ,`department+id` varchar(255),`department+parent` varchar(255),`department+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+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+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
  390. [Tue Nov 30 11:03:34 2010] [error] [client 127.0.0.1]
  391. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  392. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  393. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  394. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  395. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  396. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  397. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  398. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  399. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[3]` 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+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title`,`base_table`.`current+id` as `current+id`,`base_table`.`current+parent` as `current+parent`,`base_table`.`current+end_date` as `current+end_date`,`base_table`.`current+start_date` as `current+start_date` , `department`.id as `department+id`,`department`.parent as `department+parent`,`department`.`name` AS `department+name` , base_table.md5 AS last_md5 , MD5(CONCAT(IF(ISNULL(base_table.`primary_form+id`),'',base_table.`primary_form+id`),IF(ISNULL(base_table.`current+id`),'',base_table.`current+id`),IF(ISNULL(`department`.id),'',`department`.id))) AS md5 FROM `manage_4_0_dev`.`tmp_custom_report_position_list[2]` AS `base_table` LEFT JOIN `manage_4_0_dev`.`hippo_department` as `department` ON ( ( `primary_form+department` = `department`.`id` ) )
  400. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  401. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  402. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  403. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  404. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  405. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  406. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  407. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  408. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  409. Inserted 1001 rows
  410. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  411. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  412. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  413. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  414. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  415. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  416. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  417. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  418. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  419. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[3]` 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+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title`,`base_table`.`current+id` as `current+id`,`base_table`.`current+parent` as `current+parent`,`base_table`.`current+end_date` as `current+end_date`,`base_table`.`current+start_date` as `current+start_date` , '|' AS `department+id`, NULL AS `department+parent`, NULL AS `department+name`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_4_0_dev`.`tmp_custom_report_position_list[2]` AS `base_table`
  420. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  421. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  422. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  423. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  424. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  425. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  426. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  427. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  428. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  429. Inserted 0 rows
  430. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  431. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  432. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  433. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  434. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  435. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  436. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  437. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  438. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  439. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_position_list[4]`
  440. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  441. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  442. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  443. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  444. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  445. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  446. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  447. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  448. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  449. Doing CREATE TABLE `manage_4_0_dev`.`tmp_custom_report_position_list[4]` ( `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+status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current+id` varchar(255),`current+parent` varchar(255),`current+end_date` datetime ,`current+start_date` datetime ,`department+id` varchar(255),`department+parent` varchar(255),`department+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`facility+id` varchar(255),`facility+parent` varchar(255),`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+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+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
  450. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  451. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  452. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  453. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  454. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  455. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  456. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  457. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  458. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  459. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[4]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+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+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title`,`base_table`.`current+id` as `current+id`,`base_table`.`current+parent` as `current+parent`,`base_table`.`current+end_date` as `current+end_date`,`base_table`.`current+start_date` as `current+start_date`,`base_table`.`department+id` as `department+id`,`base_table`.`department+parent` as `department+parent`,`base_table`.`department+name` as `department+name` , `facility`.id as `facility+id`,`facility`.parent as `facility+parent`,`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(base_table.`current+id`),'',base_table.`current+id`),IF(ISNULL(base_table.`department+id`),'',base_table.`department+id`),IF(ISNULL(`facility`.id),'',`facility`.id))) AS md5 FROM `manage_4_0_dev`.`tmp_custom_report_position_list[3]` AS `base_table` LEFT JOIN `manage_4_0_dev`.`hippo_facility` as `facility` ON ( ( `primary_form+facility` = `facility`.`id` ) )
  460. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  461. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  462. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  463. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  464. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  465. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  466. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  467. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  468. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  469. Inserted 1001 rows
  470. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  471. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  472. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  473. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  474. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  475. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  476. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  477. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  478. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  479. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[4]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+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+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title`,`base_table`.`current+id` as `current+id`,`base_table`.`current+parent` as `current+parent`,`base_table`.`current+end_date` as `current+end_date`,`base_table`.`current+start_date` as `current+start_date`,`base_table`.`department+id` as `department+id`,`base_table`.`department+parent` as `department+parent`,`base_table`.`department+name` as `department+name` , '|' AS `facility+id`, NULL AS `facility+parent`, NULL AS `facility+name`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_4_0_dev`.`tmp_custom_report_position_list[3]` AS `base_table`
  480. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  481. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  482. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  483. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  484. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  485. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  486. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  487. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  488. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  489. Inserted 0 rows
  490. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  491. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  492. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  493. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  494. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  495. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  496. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  497. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  498. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  499. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_position_list[5]`
  500. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  501. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  502. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  503. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  504. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  505. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  506. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  507. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  508. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  509. Doing CREATE TABLE `manage_4_0_dev`.`tmp_custom_report_position_list[5]` ( `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+status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current+id` varchar(255),`current+parent` varchar(255),`current+end_date` datetime ,`current+start_date` datetime ,`department+id` varchar(255),`department+parent` varchar(255),`department+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`facility+id` varchar(255),`facility+parent` varchar(255),`facility+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+id` varchar(255),`job+parent` varchar(255),`job+classification` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`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+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+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`),INDEX `job+classification` (`job+classification` (255)),INDEX `job+cadre` (`job+cadre` (255)),INDEX `job+title` (`job+title` (255))) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  510. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  511. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  512. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  513. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  514. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  515. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  516. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  517. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  518. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  519. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[5]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+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+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title`,`base_table`.`current+id` as `current+id`,`base_table`.`current+parent` as `current+parent`,`base_table`.`current+end_date` as `current+end_date`,`base_table`.`current+start_date` as `current+start_date`,`base_table`.`department+id` as `department+id`,`base_table`.`department+parent` as `department+parent`,`base_table`.`department+name` as `department+name`,`base_table`.`facility+id` as `facility+id`,`base_table`.`facility+parent` as `facility+parent`,`base_table`.`facility+name` as `facility+name` , `job`.id as `job+id`,`job`.parent as `job+parent`,`job`.`classification` AS `job+classification` ,`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.`current+id`),'',base_table.`current+id`),IF(ISNULL(base_table.`department+id`),'',base_table.`department+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_position_list[4]` AS `base_table` LEFT JOIN `manage_4_0_dev`.`hippo_job` as `job` ON ( ( `primary_form+job` = `job`.`id` ) )
  520. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  521. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  522. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  523. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  524. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  525. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  526. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  527. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  528. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  529. Inserted 1001 rows
  530. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  531. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  532. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  533. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  534. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  535. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  536. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  537. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  538. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  539. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[5]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+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+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title`,`base_table`.`current+id` as `current+id`,`base_table`.`current+parent` as `current+parent`,`base_table`.`current+end_date` as `current+end_date`,`base_table`.`current+start_date` as `current+start_date`,`base_table`.`department+id` as `department+id`,`base_table`.`department+parent` as `department+parent`,`base_table`.`department+name` as `department+name`,`base_table`.`facility+id` as `facility+id`,`base_table`.`facility+parent` as `facility+parent`,`base_table`.`facility+name` as `facility+name` , '|' AS `job+id`, NULL AS `job+parent`, NULL AS `job+classification`, NULL AS `job+cadre`, NULL AS `job+title`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_4_0_dev`.`tmp_custom_report_position_list[4]` AS `base_table`
  540. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  541. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  542. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  543. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  544. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  545. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  546. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  547. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  548. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  549. Inserted 0 rows
  550. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  551. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  552. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  553. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  554. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  555. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  556. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  557. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  558. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  559. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_position_list[6]`
  560. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  561. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  562. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  563. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  564. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  565. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  566. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  567. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  568. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  569. Doing CREATE TABLE `manage_4_0_dev`.`tmp_custom_report_position_list[6]` ( `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+status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current+id` varchar(255),`current+parent` varchar(255),`current+end_date` datetime ,`current+start_date` datetime ,`department+id` varchar(255),`department+parent` varchar(255),`department+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`facility+id` varchar(255),`facility+parent` varchar(255),`facility+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+id` varchar(255),`job+parent` varchar(255),`job+classification` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last+id` varchar(255),`last+parent` varchar(255),`last+end_date` datetime ,last_md5 VARCHAR(32) UNIQUE,md5 VARCHAR(32) 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+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`),INDEX `job+classification` (`job+classification` (255)),INDEX `job+cadre` (`job+cadre` (255)),INDEX `job+title` (`job+title` (255)),INDEX `last+end_date` (`last+end_date`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  570. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  571. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  572. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  573. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  574. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  575. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  576. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  577. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  578. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  579. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[6]` 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+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title`,`base_table`.`current+id` as `current+id`,`base_table`.`current+parent` as `current+parent`,`base_table`.`current+end_date` as `current+end_date`,`base_table`.`current+start_date` as `current+start_date`,`base_table`.`department+id` as `department+id`,`base_table`.`department+parent` as `department+parent`,`base_table`.`department+name` as `department+name`,`base_table`.`facility+id` as `facility+id`,`base_table`.`facility+parent` as `facility+parent`,`base_table`.`facility+name` as `facility+name`,`base_table`.`job+id` as `job+id`,`base_table`.`job+parent` as `job+parent`,`base_table`.`job+classification` as `job+classification`,`base_table`.`job+cadre` as `job+cadre`,`base_table`.`job+title` as `job+title` , `last`.id as `last+id`,`last`.parent as `last+parent`,`last`.`end_date` AS `last+end_date` , base_table.md5 AS last_md5 , MD5(CONCAT(IF(ISNULL(base_table.`primary_form+id`),'',base_table.`primary_form+id`),IF(ISNULL(base_table.`current+id`),'',base_table.`current+id`),IF(ISNULL(base_table.`department+id`),'',base_table.`department+id`),IF(ISNULL(base_table.`facility+id`),'',base_table.`facility+id`),IF(ISNULL(base_table.`job+id`),'',base_table.`job+id`),IF(ISNULL(`last`.id),'',`last`.id))) AS md5 FROM `manage_4_0_dev`.`tmp_custom_report_position_list[5]` AS `base_table` LEFT JOIN `manage_4_0_dev`.`hippo_person_position` AS `last` ON ( ( `last`.`position` = `primary_form+id` ) ) WHERE (( `last`.`end_date` = (SELECT DISTINCT `end_date` AS `end_date` FROM `manage_4_0_dev`.`hippo_person_position` WHERE `manage_4_0_dev`.`hippo_person_position`.parent = `primary_form+id` ORDER BY `end_date` DESC LIMIT 0, 1)))
  580. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  581. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  582. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  583. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  584. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  585. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  586. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  587. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  588. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  589. Inserted 0 rows
  590. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  591. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  592. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  593. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  594. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  595. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  596. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  597. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  598. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  599. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[6]` 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+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title`,`base_table`.`current+id` as `current+id`,`base_table`.`current+parent` as `current+parent`,`base_table`.`current+end_date` as `current+end_date`,`base_table`.`current+start_date` as `current+start_date`,`base_table`.`department+id` as `department+id`,`base_table`.`department+parent` as `department+parent`,`base_table`.`department+name` as `department+name`,`base_table`.`facility+id` as `facility+id`,`base_table`.`facility+parent` as `facility+parent`,`base_table`.`facility+name` as `facility+name`,`base_table`.`job+id` as `job+id`,`base_table`.`job+parent` as `job+parent`,`base_table`.`job+classification` as `job+classification`,`base_table`.`job+cadre` as `job+cadre`,`base_table`.`job+title` as `job+title` , '|' AS `last+id`, NULL AS `last+parent`, NULL AS `last+end_date`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_4_0_dev`.`tmp_custom_report_position_list[5]` AS `base_table`
  600. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  601. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  602. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  603. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  604. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  605. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  606. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  607. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  608. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  609. Inserted 1001 rows
  610. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  611. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  612. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  613. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  614. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  615. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  616. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  617. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  618. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  619. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_position_list[7]`
  620. [Tue Nov 30 11:03:35 2010] [error] [client 127.0.0.1]
  621. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  622. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  623. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  624. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  625. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  626. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  627. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  628. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  629. Doing CREATE TABLE `manage_4_0_dev`.`tmp_custom_report_position_list[7]` ( `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+status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current+id` varchar(255),`current+parent` varchar(255),`current+end_date` datetime ,`current+start_date` datetime ,`department+id` varchar(255),`department+parent` varchar(255),`department+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`facility+id` varchar(255),`facility+parent` varchar(255),`facility+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+id` varchar(255),`job+parent` varchar(255),`job+classification` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last+id` varchar(255),`last+parent` varchar(255),`last+end_date` datetime ,`classification+id` varchar(255),`classification+parent` varchar(255),`classification+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+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+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`),INDEX `job+classification` (`job+classification` (255)),INDEX `job+cadre` (`job+cadre` (255)),INDEX `job+title` (`job+title` (255)),INDEX `last+end_date` (`last+end_date`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  630. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  631. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  632. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  633. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  634. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  635. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  636. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  637. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  638. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  639. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[7]` 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+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title`,`base_table`.`current+id` as `current+id`,`base_table`.`current+parent` as `current+parent`,`base_table`.`current+end_date` as `current+end_date`,`base_table`.`current+start_date` as `current+start_date`,`base_table`.`department+id` as `department+id`,`base_table`.`department+parent` as `department+parent`,`base_table`.`department+name` as `department+name`,`base_table`.`facility+id` as `facility+id`,`base_table`.`facility+parent` as `facility+parent`,`base_table`.`facility+name` as `facility+name`,`base_table`.`job+id` as `job+id`,`base_table`.`job+parent` as `job+parent`,`base_table`.`job+classification` as `job+classification`,`base_table`.`job+cadre` as `job+cadre`,`base_table`.`job+title` as `job+title`,`base_table`.`last+id` as `last+id`,`base_table`.`last+parent` as `last+parent`,`base_table`.`last+end_date` as `last+end_date` , `classification`.id as `classification+id`,`classification`.parent as `classification+parent`,`classification`.`name` AS `classification+name` , base_table.md5 AS last_md5 , MD5(CONCAT(IF(ISNULL(base_table.`primary_form+id`),'',base_table.`primary_form+id`),IF(ISNULL(base_table.`current+id`),'',base_table.`current+id`),IF(ISNULL(base_table.`department+id`),'',base_table.`department+id`),IF(ISNULL(base_table.`facility+id`),'',base_table.`facility+id`),IF(ISNULL(base_table.`job+id`),'',base_table.`job+id`),IF(ISNULL(base_table.`last+id`),'',base_table.`last+id`),IF(ISNULL(`classification`.id),'',`classification`.id))) AS md5 FROM `manage_4_0_dev`.`tmp_custom_report_position_list[6]` AS `base_table` LEFT JOIN `manage_4_0_dev`.`hippo_classification` as `classification` ON ( ( `job+classification` = `classification`.`id` ) )
  640. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  641. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  642. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  643. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  644. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  645. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  646. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  647. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  648. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  649. Inserted 1001 rows
  650. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  651. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  652. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  653. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  654. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  655. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  656. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  657. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  658. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  659. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[7]` 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+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title`,`base_table`.`current+id` as `current+id`,`base_table`.`current+parent` as `current+parent`,`base_table`.`current+end_date` as `current+end_date`,`base_table`.`current+start_date` as `current+start_date`,`base_table`.`department+id` as `department+id`,`base_table`.`department+parent` as `department+parent`,`base_table`.`department+name` as `department+name`,`base_table`.`facility+id` as `facility+id`,`base_table`.`facility+parent` as `facility+parent`,`base_table`.`facility+name` as `facility+name`,`base_table`.`job+id` as `job+id`,`base_table`.`job+parent` as `job+parent`,`base_table`.`job+classification` as `job+classification`,`base_table`.`job+cadre` as `job+cadre`,`base_table`.`job+title` as `job+title`,`base_table`.`last+id` as `last+id`,`base_table`.`last+parent` as `last+parent`,`base_table`.`last+end_date` as `last+end_date` , '|' AS `classification+id`, NULL AS `classification+parent`, NULL AS `classification+name`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_4_0_dev`.`tmp_custom_report_position_list[6]` AS `base_table`
  660. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  661. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  662. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  663. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  664. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  665. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  666. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  667. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  668. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  669. Inserted 0 rows
  670. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  671. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  672. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  673. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  674. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  675. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  676. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  677. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  678. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  679. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_position_list[8]`
  680. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  681. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  682. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  683. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  684. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  685. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  686. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  687. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  688. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  689. Doing CREATE TABLE `manage_4_0_dev`.`tmp_custom_report_position_list[8]` ( `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+status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current+id` varchar(255),`current+parent` varchar(255),`current+end_date` datetime ,`current+start_date` datetime ,`department+id` varchar(255),`department+parent` varchar(255),`department+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`facility+id` varchar(255),`facility+parent` varchar(255),`facility+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+id` varchar(255),`job+parent` varchar(255),`job+classification` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last+id` varchar(255),`last+parent` varchar(255),`last+end_date` datetime ,`classification+id` varchar(255),`classification+parent` varchar(255),`classification+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`cadre+id` varchar(255),`cadre+parent` varchar(255),`cadre+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+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+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`),INDEX `job+classification` (`job+classification` (255)),INDEX `job+cadre` (`job+cadre` (255)),INDEX `job+title` (`job+title` (255)),INDEX `last+end_date` (`last+end_date`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  690. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  691. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  692. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  693. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  694. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  695. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  696. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  697. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  698. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  699. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[8]` 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+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title`,`base_table`.`current+id` as `current+id`,`base_table`.`current+parent` as `current+parent`,`base_table`.`current+end_date` as `current+end_date`,`base_table`.`current+start_date` as `current+start_date`,`base_table`.`department+id` as `department+id`,`base_table`.`department+parent` as `department+parent`,`base_table`.`department+name` as `department+name`,`base_table`.`facility+id` as `facility+id`,`base_table`.`facility+parent` as `facility+parent`,`base_table`.`facility+name` as `facility+name`,`base_table`.`job+id` as `job+id`,`base_table`.`job+parent` as `job+parent`,`base_table`.`job+classification` as `job+classification`,`base_table`.`job+cadre` as `job+cadre`,`base_table`.`job+title` as `job+title`,`base_table`.`last+id` as `last+id`,`base_table`.`last+parent` as `last+parent`,`base_table`.`last+end_date` as `last+end_date`,`base_table`.`classification+id` as `classification+id`,`base_table`.`classification+parent` as `classification+parent`,`base_table`.`classification+name` as `classification+name` , `cadre`.id as `cadre+id`,`cadre`.parent as `cadre+parent`,`cadre`.`name` AS `cadre+name` , base_table.md5 AS last_md5 , MD5(CONCAT(IF(ISNULL(base_table.`primary_form+id`),'',base_table.`primary_form+id`),IF(ISNULL(base_table.`current+id`),'',base_table.`current+id`),IF(ISNULL(base_table.`department+id`),'',base_table.`department+id`),IF(ISNULL(base_table.`facility+id`),'',base_table.`facility+id`),IF(ISNULL(base_table.`job+id`),'',base_table.`job+id`),IF(ISNULL(base_table.`last+id`),'',base_table.`last+id`),IF(ISNULL(base_table.`classification+id`),'',base_table.`classification+id`),IF(ISNULL(`cadre`.id),'',`cadre`.id))) AS md5 FROM `manage_4_0_dev`.`tmp_custom_report_position_list[7]` AS `base_table` LEFT JOIN `manage_4_0_dev`.`hippo_cadre` as `cadre` ON ( ( `job+cadre` = `cadre`.`id` ) )
  700. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  701. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  702. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  703. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  704. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  705. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  706. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  707. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  708. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  709. Inserted 1001 rows
  710. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  711. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  712. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  713. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  714. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  715. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  716. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  717. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  718. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  719. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[8]` 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+status` as `primary_form+status`,`base_table`.`primary_form+title` as `primary_form+title`,`base_table`.`current+id` as `current+id`,`base_table`.`current+parent` as `current+parent`,`base_table`.`current+end_date` as `current+end_date`,`base_table`.`current+start_date` as `current+start_date`,`base_table`.`department+id` as `department+id`,`base_table`.`department+parent` as `department+parent`,`base_table`.`department+name` as `department+name`,`base_table`.`facility+id` as `facility+id`,`base_table`.`facility+parent` as `facility+parent`,`base_table`.`facility+name` as `facility+name`,`base_table`.`job+id` as `job+id`,`base_table`.`job+parent` as `job+parent`,`base_table`.`job+classification` as `job+classification`,`base_table`.`job+cadre` as `job+cadre`,`base_table`.`job+title` as `job+title`,`base_table`.`last+id` as `last+id`,`base_table`.`last+parent` as `last+parent`,`base_table`.`last+end_date` as `last+end_date`,`base_table`.`classification+id` as `classification+id`,`base_table`.`classification+parent` as `classification+parent`,`base_table`.`classification+name` as `classification+name` , '|' AS `cadre+id`, NULL AS `cadre+parent`, NULL AS `cadre+name`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_4_0_dev`.`tmp_custom_report_position_list[7]` AS `base_table`
  720. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  721. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  722. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  723. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  724. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  725. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  726. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  727. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  728. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  729. Inserted 0 rows
  730. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  731. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  732. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  733. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  734. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  735. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  736. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  737. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  738. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  739. Doing DROP TABLE IF EXISTS `manage_4_0_dev`.`tmp_custom_report_position_list[9]`
  740. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  741. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  742. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  743. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  744. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  745. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  746. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  747. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  748. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  749. Doing CREATE TABLE `manage_4_0_dev`.`tmp_custom_report_position_list[9]` ( `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+status` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`current+id` varchar(255),`current+parent` varchar(255),`current+end_date` datetime ,`current+start_date` datetime ,`department+id` varchar(255),`department+parent` varchar(255),`department+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`facility+id` varchar(255),`facility+parent` varchar(255),`facility+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+id` varchar(255),`job+parent` varchar(255),`job+classification` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+cadre` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`job+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last+id` varchar(255),`last+parent` varchar(255),`last+end_date` datetime ,`classification+id` varchar(255),`classification+parent` varchar(255),`classification+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`cadre+id` varchar(255),`cadre+parent` varchar(255),`cadre+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+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+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`),INDEX `job+classification` (`job+classification` (255)),INDEX `job+cadre` (`job+cadre` (255)),INDEX `job+title` (`job+title` (255)),INDEX `last+end_date` (`last+end_date`),`+days_open` int( 11 ) default NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  750. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  751. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  752. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  753. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  754. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  755. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  756. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  757. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  758. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  759. Doing INSERT IGNORE INTO `manage_4_0_dev`.`tmp_custom_report_position_list[9]` SELECT `primary_form+id`,`primary_form+parent`,`primary_form+department`,`primary_form+facility`,`primary_form+job`,`primary_form+posted_date`,`primary_form+code`,`primary_form+status`,`primary_form+title`,`current+id`,`current+parent`,`current+end_date`,`current+start_date`,`department+id`,`department+parent`,`department+name`,`facility+id`,`facility+parent`,`facility+name`,`job+id`,`job+parent`,`job+classification`,`job+cadre`,`job+title`,`last+id`,`last+parent`,`last+end_date`,`classification+id`,`classification+parent`,`classification+name`,`cadre+id`,`cadre+parent`,`cadre+name`,`last_md5`,`md5`, DATEDIFF( IFNULL( `current+start_date`, NOW() ), IFNULL( `last+end_date`, `primary_form+posted_date`)) AS `+days_open`FROM `manage_4_0_dev`.`tmp_custom_report_position_list[8]`
  760. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  761. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  762. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  763. I2CE_CustomReport->_generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  764. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  765. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  766. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  767. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  768. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  769. Inserted 1001 rows
  770. [Tue Nov 30 11:03:36 2010] [error] [client 127.0.0.1]
  771. Refered by : http://localhost/iHRIS/4.0-dev/manage/CustomReports/edit/reports
  772. I2CE: I2CE->raiseError (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:435)
  773. I2CE_CustomReport->generateCache (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  774. I2CE_Page_CustomReports->actionGenerate (/home/litlfred/rocket_cats/dev/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  775. I2CE_Page_CustomReports->action (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  776. I2CE_Page->display (/home/litlfred/rocket_cats/dev/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  777. I2CE_Wrangler->wrangle (/home/litlfred/rocket_cats/dev/ihris-manage/sites/Demo/pages/index.php:60)
  778. Report generation succeeded for position_list
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!