API tools faq
paste
Advertisement
ihris

Kayode Odusote

ihris
Jan 20th, 2011
114
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 32.40 KB | None | 0 0
raw download clone embed print report
  1. Was able to upgrade to version 10.10 successfully but the problem with generating reports still persists. Below is the apache-tail output for forced generation of search people report:
  2.  
  3.  
  4. [Thu Jan 20 16:12:48 2011] [error] [client 127.0.0.1]
  5. Refered by : http://localhost/manage/CustomReports/edit/reports
  6. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  7. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  8. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  9. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  10. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  11. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  12. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  13. Doing DROP TABLE IF EXISTS `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[4]`
  14. [Thu Jan 20 16:12:48 2011] [error] [client 127.0.0.1]
  15. Refered by : http://localhost/manage/CustomReports/edit/reports
  16. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  17. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  18. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  19. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  20. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  21. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  22. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  23. Doing CREATE TABLE `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[4]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+surname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`application+id` varchar(255),`application+parent` varchar(255),`application+position` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_person_position+id` varchar(255),`last_person_position+parent` varchar(255),`last_person_position+start_date` datetime ,`last_person_position+position` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_person_position+end_date` datetime ,`last_position+id` varchar(255),`last_position+parent` varchar(255),`last_position+facility` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_position+job` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_position+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,last_md5 VARCHAR(32) UNIQUE,md5 VARCHAR(32) UNIQUE,KEY (`primary_form+id`),INDEX `last_person_position+start_date` (`last_person_position+start_date`),INDEX `last_person_position+position` (`last_person_position+position` (255)),INDEX `last_person_position+end_date` (`last_person_position+end_date`),INDEX `last_position+facility` (`last_position+facility` (255)),INDEX `last_position+job` (`last_position+job` (255)),INDEX `last_position+title` (`last_position+title` (255))) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  24. [Thu Jan 20 16:12:48 2011] [error] [client 127.0.0.1]
  25. Refered by : http://localhost/manage/CustomReports/edit/reports
  26. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  27. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  28. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  29. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  30. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  31. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  32. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  33. Doing INSERT IGNORE INTO `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[4]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+firstname` as `primary_form+firstname`,`base_table`.`primary_form+surname` as `primary_form+surname`,`base_table`.`application+id` as `application+id`,`base_table`.`application+parent` as `application+parent`,`base_table`.`application+position` as `application+position`,`base_table`.`last_person_position+id` as `last_person_position+id`,`base_table`.`last_person_position+parent` as `last_person_position+parent`,`base_table`.`last_person_position+start_date` as `last_person_position+start_date`,`base_table`.`last_person_position+position` as `last_person_position+position`,`base_table`.`last_person_position+end_date` as `last_person_position+end_date` , `last_position`.id as `last_position+id`,`last_position`.parent as `last_position+parent`,`last_position`.`facility` AS `last_position+facility` ,`last_position`.`job` AS `last_position+job` ,`last_position`.`title` AS `last_position+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.`application+id`),'',base_table.`application+id`),IF(ISNULL(base_table.`last_person_position+id`),'',base_table.`last_person_position+id`),IF(ISNULL(`last_position`.id),'',`last_position`.id))) AS md5 FROM `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[3]` AS `base_table` LEFT JOIN `manage_northern_ghana_4_0`.`hippo_position` as `last_position` ON ( ( `last_person_position+position` = `last_position`.`id` ) )
  34. [Thu Jan 20 16:12:50 2011] [error] [client 127.0.0.1]
  35. Refered by : http://localhost/manage/CustomReports/edit/reports
  36. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  37. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  38. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  39. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  40. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  41. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  42. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  43. Inserted 2489 rows
  44. [Thu Jan 20 16:12:50 2011] [error] [client 127.0.0.1]
  45. Refered by : http://localhost/manage/CustomReports/edit/reports
  46. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  47. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  48. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  49. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  50. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  51. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  52. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  53. Doing INSERT IGNORE INTO `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[4]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+firstname` as `primary_form+firstname`,`base_table`.`primary_form+surname` as `primary_form+surname`,`base_table`.`application+id` as `application+id`,`base_table`.`application+parent` as `application+parent`,`base_table`.`application+position` as `application+position`,`base_table`.`last_person_position+id` as `last_person_position+id`,`base_table`.`last_person_position+parent` as `last_person_position+parent`,`base_table`.`last_person_position+start_date` as `last_person_position+start_date`,`base_table`.`last_person_position+position` as `last_person_position+position`,`base_table`.`last_person_position+end_date` as `last_person_position+end_date` , '|' AS `last_position+id`, NULL AS `last_position+parent`, NULL AS `last_position+facility`, NULL AS `last_position+job`, NULL AS `last_position+title`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[3]` AS `base_table`
  54. [Thu Jan 20 16:12:51 2011] [error] [client 127.0.0.1]
  55. Refered by : http://localhost/manage/CustomReports/edit/reports
  56. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  57. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  58. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  59. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  60. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  61. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  62. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  63. Inserted 0 rows
  64. [Thu Jan 20 16:12:51 2011] [error] [client 127.0.0.1]
  65. Refered by : http://localhost/manage/CustomReports/edit/reports
  66. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  67. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  68. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  69. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  70. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  71. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  72. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  73. Doing DROP TABLE IF EXISTS `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[3]`
  74. [Thu Jan 20 16:12:51 2011] [error] [client 127.0.0.1]
  75. Refered by : http://localhost/manage/CustomReports/edit/reports
  76. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  77. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  78. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  79. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  80. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  81. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  82. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  83. Doing DROP TABLE IF EXISTS `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[5]`
  84. [Thu Jan 20 16:12:51 2011] [error] [client 127.0.0.1]
  85. Refered by : http://localhost/manage/CustomReports/edit/reports
  86. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  87. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  88. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  89. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  90. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  91. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  92. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  93. Doing CREATE TABLE `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[5]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+surname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`application+id` varchar(255),`application+parent` varchar(255),`application+position` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_person_position+id` varchar(255),`last_person_position+parent` varchar(255),`last_person_position+start_date` datetime ,`last_person_position+position` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_person_position+end_date` datetime ,`last_position+id` varchar(255),`last_position+parent` varchar(255),`last_position+facility` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_position+job` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_position+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_facility+id` varchar(255),`last_facility+parent` varchar(255),`last_facility+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,last_md5 VARCHAR(32) UNIQUE,md5 VARCHAR(32) UNIQUE,KEY (`primary_form+id`),INDEX `last_person_position+start_date` (`last_person_position+start_date`),INDEX `last_person_position+position` (`last_person_position+position` (255)),INDEX `last_person_position+end_date` (`last_person_position+end_date`),INDEX `last_position+facility` (`last_position+facility` (255)),INDEX `last_position+job` (`last_position+job` (255)),INDEX `last_position+title` (`last_position+title` (255))) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  94. [Thu Jan 20 16:12:51 2011] [error] [client 127.0.0.1]
  95. Refered by : http://localhost/manage/CustomReports/edit/reports
  96. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  97. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  98. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  99. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  100. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  101. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  102. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  103. Doing INSERT IGNORE INTO `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[5]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+firstname` as `primary_form+firstname`,`base_table`.`primary_form+surname` as `primary_form+surname`,`base_table`.`application+id` as `application+id`,`base_table`.`application+parent` as `application+parent`,`base_table`.`application+position` as `application+position`,`base_table`.`last_person_position+id` as `last_person_position+id`,`base_table`.`last_person_position+parent` as `last_person_position+parent`,`base_table`.`last_person_position+start_date` as `last_person_position+start_date`,`base_table`.`last_person_position+position` as `last_person_position+position`,`base_table`.`last_person_position+end_date` as `last_person_position+end_date`,`base_table`.`last_position+id` as `last_position+id`,`base_table`.`last_position+parent` as `last_position+parent`,`base_table`.`last_position+facility` as `last_position+facility`,`base_table`.`last_position+job` as `last_position+job`,`base_table`.`last_position+title` as `last_position+title` , `last_facility`.id as `last_facility+id`,`last_facility`.parent as `last_facility+parent`,`last_facility`.`name` AS `last_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.`application+id`),'',base_table.`application+id`),IF(ISNULL(base_table.`last_person_position+id`),'',base_table.`last_person_position+id`),IF(ISNULL(base_table.`last_position+id`),'',base_table.`last_position+id`),IF(ISNULL(`last_facility`.id),'',`last_facility`.id))) AS md5 FROM `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[4]` AS `base_table` LEFT JOIN `manage_northern_ghana_4_0`.`hippo_facility` as `last_facility` ON ( ( `last_position+facility` = `last_facility`.`id` ) )
  104. [Thu Jan 20 16:12:53 2011] [error] [client 127.0.0.1]
  105. Refered by : http://localhost/manage/CustomReports/edit/reports
  106. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  107. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  108. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  109. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  110. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  111. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  112. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  113. Inserted 2489 rows
  114. [Thu Jan 20 16:12:53 2011] [error] [client 127.0.0.1]
  115. Refered by : http://localhost/manage/CustomReports/edit/reports
  116. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  117. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  118. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  119. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  120. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  121. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  122. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  123. Doing INSERT IGNORE INTO `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[5]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+firstname` as `primary_form+firstname`,`base_table`.`primary_form+surname` as `primary_form+surname`,`base_table`.`application+id` as `application+id`,`base_table`.`application+parent` as `application+parent`,`base_table`.`application+position` as `application+position`,`base_table`.`last_person_position+id` as `last_person_position+id`,`base_table`.`last_person_position+parent` as `last_person_position+parent`,`base_table`.`last_person_position+start_date` as `last_person_position+start_date`,`base_table`.`last_person_position+position` as `last_person_position+position`,`base_table`.`last_person_position+end_date` as `last_person_position+end_date`,`base_table`.`last_position+id` as `last_position+id`,`base_table`.`last_position+parent` as `last_position+parent`,`base_table`.`last_position+facility` as `last_position+facility`,`base_table`.`last_position+job` as `last_position+job`,`base_table`.`last_position+title` as `last_position+title` , '|' AS `last_facility+id`, NULL AS `last_facility+parent`, NULL AS `last_facility+name`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[4]` AS `base_table`
  124. [Thu Jan 20 16:12:54 2011] [error] [client 127.0.0.1]
  125. Refered by : http://localhost/manage/CustomReports/edit/reports
  126. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  127. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  128. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  129. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  130. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  131. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  132. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  133. Inserted 0 rows
  134. [Thu Jan 20 16:12:54 2011] [error] [client 127.0.0.1]
  135. Refered by : http://localhost/manage/CustomReports/edit/reports
  136. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  137. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  138. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  139. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  140. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  141. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  142. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  143. Doing DROP TABLE IF EXISTS `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[4]`
  144. [Thu Jan 20 16:12:54 2011] [error] [client 127.0.0.1]
  145. Refered by : http://localhost/manage/CustomReports/edit/reports
  146. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  147. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  148. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  149. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  150. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  151. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  152. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  153. Doing DROP TABLE IF EXISTS `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[6]`
  154. [Thu Jan 20 16:12:54 2011] [error] [client 127.0.0.1]
  155. Refered by : http://localhost/manage/CustomReports/edit/reports
  156. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  157. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  158. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  159. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  160. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  161. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  162. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  163. Doing CREATE TABLE `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[6]` ( `primary_form+id` varchar(255),`primary_form+parent` varchar(255),`primary_form+firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`primary_form+surname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`application+id` varchar(255),`application+parent` varchar(255),`application+position` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_person_position+id` varchar(255),`last_person_position+parent` varchar(255),`last_person_position+start_date` datetime ,`last_person_position+position` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_person_position+end_date` datetime ,`last_position+id` varchar(255),`last_position+parent` varchar(255),`last_position+facility` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_position+job` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_position+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_facility+id` varchar(255),`last_facility+parent` varchar(255),`last_facility+name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,`last_job+id` varchar(255),`last_job+parent` varchar(255),`last_job+title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin,last_md5 VARCHAR(32) UNIQUE,md5 VARCHAR(32) UNIQUE,KEY (`primary_form+id`),INDEX `last_person_position+start_date` (`last_person_position+start_date`),INDEX `last_person_position+position` (`last_person_position+position` (255)),INDEX `last_person_position+end_date` (`last_person_position+end_date`),INDEX `last_position+facility` (`last_position+facility` (255)),INDEX `last_position+job` (`last_position+job` (255)),INDEX `last_position+title` (`last_position+title` (255))) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
  164. [Thu Jan 20 16:12:54 2011] [error] [client 127.0.0.1]
  165. Refered by : http://localhost/manage/CustomReports/edit/reports
  166. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  167. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  168. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  169. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  170. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  171. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  172. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  173. Doing INSERT IGNORE INTO `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[6]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+firstname` as `primary_form+firstname`,`base_table`.`primary_form+surname` as `primary_form+surname`,`base_table`.`application+id` as `application+id`,`base_table`.`application+parent` as `application+parent`,`base_table`.`application+position` as `application+position`,`base_table`.`last_person_position+id` as `last_person_position+id`,`base_table`.`last_person_position+parent` as `last_person_position+parent`,`base_table`.`last_person_position+start_date` as `last_person_position+start_date`,`base_table`.`last_person_position+position` as `last_person_position+position`,`base_table`.`last_person_position+end_date` as `last_person_position+end_date`,`base_table`.`last_position+id` as `last_position+id`,`base_table`.`last_position+parent` as `last_position+parent`,`base_table`.`last_position+facility` as `last_position+facility`,`base_table`.`last_position+job` as `last_position+job`,`base_table`.`last_position+title` as `last_position+title`,`base_table`.`last_facility+id` as `last_facility+id`,`base_table`.`last_facility+parent` as `last_facility+parent`,`base_table`.`last_facility+name` as `last_facility+name` , `last_job`.id as `last_job+id`,`last_job`.parent as `last_job+parent`,`last_job`.`title` AS `last_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.`application+id`),'',base_table.`application+id`),IF(ISNULL(base_table.`last_person_position+id`),'',base_table.`last_person_position+id`),IF(ISNULL(base_table.`last_position+id`),'',base_table.`last_position+id`),IF(ISNULL(base_table.`last_facility+id`),'',base_table.`last_facility+id`),IF(ISNULL(`last_job`.id),'',`last_job`.id))) AS md5 FROM `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[5]` AS `base_table` LEFT JOIN `manage_northern_ghana_4_0`.`hippo_job` as `last_job` ON ( ( `last_position+job` = `last_job`.`id` ) )
  174. [Thu Jan 20 16:12:56 2011] [error] [client 127.0.0.1]
  175. Refered by : http://localhost/manage/CustomReports/edit/reports
  176. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:458)
  177. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  178. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  179. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  180. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  181. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  182. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  183. Inserted 2489 rows
  184. [Thu Jan 20 16:12:56 2011] [error] [client 127.0.0.1]
  185. Refered by : http://localhost/manage/CustomReports/edit/reports
  186. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:452)
  187. I2CE_CustomReport->_generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_CustomReport.php:430)
  188. I2CE_CustomReport->generateCache (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:329)
  189. I2CE_Page_CustomReports->actionGenerate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/CustomReports/lib/I2CE_Page_CustomReports.php:143)
  190. I2CE_Page_CustomReports->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  191. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  192. I2CE_Wrangler->wrangle (/var/lib/iHRIS/sites/manage/pages/index.php:66)
  193. Doing INSERT IGNORE INTO `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[6]` SELECT `base_table`.`primary_form+id` as `primary_form+id`,`base_table`.`primary_form+parent` as `primary_form+parent`,`base_table`.`primary_form+firstname` as `primary_form+firstname`,`base_table`.`primary_form+surname` as `primary_form+surname`,`base_table`.`application+id` as `application+id`,`base_table`.`application+parent` as `application+parent`,`base_table`.`application+position` as `application+position`,`base_table`.`last_person_position+id` as `last_person_position+id`,`base_table`.`last_person_position+parent` as `last_person_position+parent`,`base_table`.`last_person_position+start_date` as `last_person_position+start_date`,`base_table`.`last_person_position+position` as `last_person_position+position`,`base_table`.`last_person_position+end_date` as `last_person_position+end_date`,`base_table`.`last_position+id` as `last_position+id`,`base_table`.`last_position+parent` as `last_position+parent`,`base_table`.`last_position+facility` as `last_position+facility`,`base_table`.`last_position+job` as `last_position+job`,`base_table`.`last_position+title` as `last_position+title`,`base_table`.`last_facility+id` as `last_facility+id`,`base_table`.`last_facility+parent` as `last_facility+parent`,`base_table`.`last_facility+name` as `last_facility+name` , '|' AS `last_job+id`, NULL AS `last_job+parent`, NULL AS `last_job+title`,base_table.md5 AS md5, base_table.md5 AS last_md5 FROM `manage_northern_ghana_4_0`.`tmp_custom_report_search_people[5]` AS `base_table`
  194. ^C
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!