API tools faq
paste
Advertisement
ihris

Mathayo

ihris
Feb 3rd, 2011
141
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 56.55 KB | None | 0 0
raw download clone embed print report
  1. |',id) as id, parent , `last_modified`, `i2ce_hidden`,`name` FROM ((SELECT CONCAT( SUBSTRING(id,12),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_eastern`.`hippo_department` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,12),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_lake`.`hippo_department` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,12),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_northern`.`hippo_department` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,12),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_southern`.`hippo_department` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,12),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_western`.`hippo_department` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`name`=values(`name`),`id`=values(`id`),`parent`=values(`parent`)]
  2. [Native code: 1064]
  3. [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'parent`` FROM `manage_cssc_eastern`.`hippo_department` WHERE (( last_modified I' at line 1]
  4. [Thu Feb 03 09:46:47 2011] [error] [client 196.46.109.86]
  5. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  6. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:304)
  7. I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:592)
  8. I2CE->initializeDSN (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49)
  9. No memcached
  10. [Thu Feb 03 09:46:48 2011] [error] [client 196.46.109.86]
  11. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  12. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:153)
  13. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  14. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  15. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  16. forceCreateCache
  17. [Thu Feb 03 09:46:48 2011] [error] [client 196.46.109.86]
  18. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  19. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
  20. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  21. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  22. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  23. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  24. The form edu_type is dirty
  25. [Thu Feb 03 09:46:48 2011] [error] [client 196.46.109.86]
  26. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  27. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
  28. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  29. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  30. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  31. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  32. Poulating fields for edu_type
  33. [Thu Feb 03 09:46:48 2011] [error] [client 196.46.109.86]
  34. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  35. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
  36. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  37. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  38. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  39. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  40. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  41. Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_edu_type`(id,parent,`last_modified`,`i2ce_hidden`,`name`) (SELECT concat('edu_type|',id) as id, parent , `last_modified`, `i2ce_hidden`,`name` FROM (SELECT c.name as `id`,`joined_i2ce_hidden`.value as `i2ce_hidden`,`joined_name`.value as `name`,`joined_parent`.value as `parent`,modified.value AS `last_modified` FROM config_alt c LEFT JOIN config_alt `joined_i2ce_hidden` ON `joined_i2ce_hidden`.parent= CONCAT(c.parent, '/' , c.name , '/fields') AND `joined_i2ce_hidden`.name = 'i2ce_hidden' LEFT JOIN config_alt `joined_name` ON `joined_name`.parent= CONCAT(c.parent, '/' , c.name , '/fields') AND `joined_name`.name = 'name' LEFT JOIN config_alt `joined_parent` ON `joined_parent`.parent = CONCAT(c.parent,'/',c.name) and `joined_parent`.name = 'parent' LEFT JOIN config_alt modified ON modified.parent = CONCAT(c.parent ,'/',c.name) AND modified.name = 'last_modified' WHERE (c.parent = '/I2CE/formsData/forms/edu_type' AND (modified.value IS NULL OR modified.value > STR_TO_DATE('1970-01-01 03:00:00','%Y-%m-%d %H:%i:%s')))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`name`=values(`name`),`id`=values(`id`),`parent`=values(`parent`)
  42. [Thu Feb 03 09:46:48 2011] [error] [client 196.46.109.86]
  43. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  44. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:422)
  45. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  46. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  47. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  48. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  49. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  50. Updated 0 records for edu_type
  51. [Thu Feb 03 09:46:48 2011] [error] [client 196.46.109.86]
  52. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  53. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:372)
  54. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  55. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  56. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  57. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  58. Populated edu_type at 1296715608:Thu, 03 Feb 2011 09:46:48 +0300
  59. [Thu Feb 03 09:46:49 2011] [error] [client 196.46.109.86]
  60. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  61. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:304)
  62. I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:592)
  63. I2CE->initializeDSN (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49)
  64. No memcached
  65. [Thu Feb 03 09:46:49 2011] [error] [client 196.46.109.86]
  66. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  67. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:153)
  68. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  69. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  70. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  71. forceCreateCache
  72. [Thu Feb 03 09:46:49 2011] [error] [client 196.46.109.86]
  73. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  74. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
  75. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  76. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  77. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  78. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  79. The form education is dirty
  80. [Thu Feb 03 09:46:49 2011] [error] [client 196.46.109.86]
  81. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  82. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
  83. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  84. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  85. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  86. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  87. Poulating fields for education
  88. [Thu Feb 03 09:46:50 2011] [error] [client 196.46.109.86]
  89. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  90. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
  91. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  92. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  93. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  94. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  95. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  96. Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_education`(id,parent,`last_modified`,`degree`,`institution`,`location`,`major`,`year`) (SELECT concat('education|',id) as id, parent , `last_modified`, `degree`,`institution`,`location`,`major`,`year` FROM ((SELECT CONCAT( SUBSTRING(id,11),'@','eastern') AS `id`,`degree` AS `degree`,`institution` AS `institution`,`location` AS `location`,`major` AS `major`,`year` AS `year`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person'), CONCAT( parent,'@eastern'),parent),parent) AS ``parent`` FROM `manage_cssc_eastern`.`hippo_education` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,11),'@','lake') AS `id`,`degree` AS `degree`,`institution` AS `institution`,`location` AS `location`,`major` AS `major`,`year` AS `year`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person'), CONCAT( parent,'@lake'),parent),parent) AS ``parent`` FROM `manage_cssc_lake`.`hippo_education` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,11),'@','northern') AS `id`,`degree` AS `degree`,`institution` AS `institution`,`location` AS `location`,`major` AS `major`,`year` AS `year`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person'), CONCAT( parent,'@northern'),parent),parent) AS ``parent`` FROM `manage_cssc_northern`.`hippo_education` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,11),'@','southern') AS `id`,`degree` AS `degree`,`institution` AS `institution`,`location` AS `location`,`major` AS `major`,`year` AS `year`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person'), CONCAT( parent,'@southern'),parent),parent) AS ``parent`` FROM `manage_cssc_southern`.`hippo_education` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,11),'@','western') AS `id`,`degree` AS `degree`,`institution` AS `institution`,`location` AS `location`,`major` AS `major`,`year` AS `year`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person'), CONCAT( parent,'@western'),parent),parent) AS ``parent`` FROM `manage_cssc_western`.`hippo_education` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `degree`=values(`degree`),`institution`=values(`institution`),`location`=values(`location`),`major`=values(`major`),`year`=values(`year`),`id`=values(`id`),`parent`=values(`parent`)
  97. [Thu Feb 03 09:46:50 2011] [error] [client 196.46.109.86]
  98. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  99. I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
  100. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  101. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  102. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  103. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  104. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  105. Could not populate cach for education::
  106. MDB2 Error: syntax error
  107. _doQuery: [Error message: Could not execute statement]
  108. [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_education`(id,parent,`last_modified`,`degree`,`institution`,`location`,`major`,`year`) (SELECT concat('education|',id) as id, parent , `last_modified`, `degree`,`institution`,`location`,`major`,`year` FROM ((SELECT CONCAT( SUBSTRING(id,11),'@','eastern') AS `id`,`degree` AS `degree`,`institution` AS `institution`,`location` AS `location`,`major` AS `major`,`year` AS `year`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person'), CONCAT( parent,'@eastern'),parent),parent) AS ``parent`` FROM `manage_cssc_eastern`.`hippo_education` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,11),'@','lake') AS `id`,`degree` AS `degree`,`institution` AS `institution`,`location` AS `location`,`major` AS `major`,`year` AS `year`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person'), CONCAT( parent,'@lake'),parent),parent) AS ``parent`` FROM `manage_cssc_lake`.`hippo_education` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,11),'@','northern') AS `id`,`degree` AS `degree`,`institution` AS `institution`,`location` AS `location`,`major` AS `major`,`year` AS `year`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person'), CONCAT( parent,'@northern'),parent),parent) AS ``parent`` FROM `manage_cssc_northern`.`hippo_education` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,11),'@','southern') AS `id`,`degree` AS `degree`,`institution` AS `institution`,`location` AS `location`,`major` AS `major`,`year` AS `year`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person'), CONCAT( parent,'@southern'),parent),parent) AS ``parent`` FROM `manage_cssc_southern`.`hippo_education` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,11),'@','western') AS `id`,`degree` AS `degree`,`institution` AS `institution`,`location` AS `location`,`major` AS `major`,`year` AS `year`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person'), CONCAT( parent,'@western'),parent),parent) AS ``parent`` FROM `manage_cssc_western`.`hippo_education` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `degree`=values(`degree`),`institution`=values(`institution`),`location`=values(`location`),`major`=values(`major`),`year`=values(`year`),`id`=values(`id`),`parent`=values(`parent`)]
  109. [Native code: 1064]
  110. [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'parent`` FROM `manage_cssc_eastern`.`hippo_education` WHERE (( last_modified IS' at line 1]
  111. [Thu Feb 03 09:46:54 2011] [error] [client 196.46.109.86]
  112. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  113. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:304)
  114. I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:592)
  115. I2CE->initializeDSN (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49)
  116. No memcached
  117. [Thu Feb 03 09:46:54 2011] [error] [client 196.46.109.86]
  118. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  119. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:153)
  120. I2CE_Page_CachedForm->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/cssc_zonal_deploy/sites/central/pages/index.php:60)
  123. forceCreateCache
  124. [Thu Feb 03 09:46:54 2011] [error] [client 196.46.109.86]
  125. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  126. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
  127. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  128. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  129. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  130. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  131. The form employer is dirty
  132. [Thu Feb 03 09:46:54 2011] [error] [client 196.46.109.86]
  133. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  134. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
  135. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  136. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  137. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  138. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  139. Poulating fields for employer
  140. [Thu Feb 03 09:46:54 2011] [error] [client 196.46.109.86]
  141. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  142. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
  143. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  144. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  145. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  146. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  147. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  148. Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_employer`(id,parent,`last_modified`,`i2ce_hidden`,`name`) (SELECT concat('employer|',id) as id, parent , `last_modified`, `i2ce_hidden`,`name` FROM ((SELECT CONCAT( SUBSTRING(id,10),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_eastern`.`hippo_employer` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_lake`.`hippo_employer` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_northern`.`hippo_employer` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_southern`.`hippo_employer` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_western`.`hippo_employer` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`name`=values(`name`),`id`=values(`id`),`parent`=values(`parent`)
  149. [Thu Feb 03 09:46:54 2011] [error] [client 196.46.109.86]
  150. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  151. I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
  152. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  153. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  154. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  155. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  156. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  157. Could not populate cach for employer::
  158. MDB2 Error: syntax error
  159. _doQuery: [Error message: Could not execute statement]
  160. [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_employer`(id,parent,`last_modified`,`i2ce_hidden`,`name`) (SELECT concat('employer|',id) as id, parent , `last_modified`, `i2ce_hidden`,`name` FROM ((SELECT CONCAT( SUBSTRING(id,10),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_eastern`.`hippo_employer` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_lake`.`hippo_employer` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_northern`.`hippo_employer` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_southern`.`hippo_employer` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS ``parent`` FROM `manage_cssc_western`.`hippo_employer` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`name`=values(`name`),`id`=values(`id`),`parent`=values(`parent`)]
  161. [Native code: 1064]
  162. [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'parent`` FROM `manage_cssc_eastern`.`hippo_employer` WHERE (( last_modified IS ' at line 1]
  163. [Thu Feb 03 09:47:01 2011] [error] [client 196.46.109.86]
  164. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  165. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:304)
  166. I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:592)
  167. I2CE->initializeDSN (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49)
  168. No memcached
  169. [Thu Feb 03 09:47:02 2011] [error] [client 196.46.109.86]
  170. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  171. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:153)
  172. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  173. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  174. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  175. forceCreateCache
  176. [Thu Feb 03 09:47:02 2011] [error] [client 196.46.109.86]
  177. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  178. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
  179. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  180. I2CE_Page_CachedForm->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/cssc_zonal_deploy/sites/central/pages/index.php:60)
  183. The form facility is dirty
  184. [Thu Feb 03 09:47:02 2011] [error] [client 196.46.109.86]
  185. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  186. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
  187. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  188. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  189. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  190. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  191. Poulating fields for facility
  192. [Thu Feb 03 09:47:02 2011] [error] [client 196.46.109.86]
  193. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  194. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
  195. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  196. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  197. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  198. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  199. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  200. Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_facility`(id,parent,`last_modified`,`i2ce_hidden`,`location`,`name`,`facility_type`,`cssc_code`,`diocese`) (SELECT concat('facility|',id) as id, parent , `last_modified`, `i2ce_hidden`,`location`,`name`,`facility_type`,`cssc_code`,`diocese` FROM ((SELECT CONCAT( SUBSTRING(id,10),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,`facility_type` AS `facility_type`,`cssc_code` AS `cssc_code`,IF ( LOCATE('|',`diocese`) > 0 , IF ( SUBSTRING(`diocese`,1, LOCATE('|',`diocese`) - 1) IN ('diocese'), CONCAT( `diocese`,'@eastern'),`diocese`),`diocese`) AS `diocese`,parent AS ``parent`` FROM `manage_cssc_eastern`.`hippo_facility` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,`facility_type` AS `facility_type`,`cssc_code` AS `cssc_code`,IF ( LOCATE('|',`diocese`) > 0 , IF ( SUBSTRING(`diocese`,1, LOCATE('|',`diocese`) - 1) IN ('diocese'), CONCAT( `diocese`,'@lake'),`diocese`),`diocese`) AS `diocese`,parent AS ``parent`` FROM `manage_cssc_lake`.`hippo_facility` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,`facility_type` AS `facility_type`,`cssc_code` AS `cssc_code`,IF ( LOCATE('|',`diocese`) > 0 , IF ( SUBSTRING(`diocese`,1, LOCATE('|',`diocese`) - 1) IN ('diocese'), CONCAT( `diocese`,'@northern'),`diocese`),`diocese`) AS `diocese`,parent AS ``parent`` FROM `manage_cssc_northern`.`hippo_facility` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,`facility_type` AS `facility_type`,`cssc_code` AS `cssc_code`,IF ( LOCATE('|',`diocese`) > 0 , IF ( SUBSTRING(`diocese`,1, LOCATE('|',`diocese`) - 1) IN ('diocese'), CONCAT( `diocese`,'@southern'),`diocese`),`diocese`) AS `diocese`,parent AS ``parent`` FROM `manage_cssc_southern`.`hippo_facility` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,`facility_type` AS `facility_type`,`cssc_code` AS `cssc_code`,IF ( LOCATE('|',`diocese`) > 0 , IF ( SUBSTRING(`diocese`,1, LOCATE('|',`diocese`) - 1) IN ('diocese'), CONCAT( `diocese`,'@western'),`diocese`),`diocese`) AS `diocese`,parent AS ``parent`` FROM `manage_cssc_western`.`hippo_facility` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`location`=values(`location`),`name`=values(`name`),`facility_type`=values(`facility_type`),`cssc_code`=values(`cssc_code`),`diocese`=values(`diocese`),`id`=values(`id`),`parent`=values(`parent`)
  201. [Thu Feb 03 09:47:02 2011] [error] [client 196.46.109.86]
  202. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  203. I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
  204. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  205. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  206. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  207. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  208. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  209. Could not populate cach for facility::
  210. MDB2 Error: syntax error
  211. _doQuery: [Error message: Could not execute statement]
  212. [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_facility`(id,parent,`last_modified`,`i2ce_hidden`,`location`,`name`,`facility_type`,`cssc_code`,`diocese`) (SELECT concat('facility|',id) as id, parent , `last_modified`, `i2ce_hidden`,`location`,`name`,`facility_type`,`cssc_code`,`diocese` FROM ((SELECT CONCAT( SUBSTRING(id,10),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,`facility_type` AS `facility_type`,`cssc_code` AS `cssc_code`,IF ( LOCATE('|',`diocese`) > 0 , IF ( SUBSTRING(`diocese`,1, LOCATE('|',`diocese`) - 1) IN ('diocese'), CONCAT( `diocese`,'@eastern'),`diocese`),`diocese`) AS `diocese`,parent AS ``parent`` FROM `manage_cssc_eastern`.`hippo_facility` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,`facility_type` AS `facility_type`,`cssc_code` AS `cssc_code`,IF ( LOCATE('|',`diocese`) > 0 , IF ( SUBSTRING(`diocese`,1, LOCATE('|',`diocese`) - 1) IN ('diocese'), CONCAT( `diocese`,'@lake'),`diocese`),`diocese`) AS `diocese`,parent AS ``parent`` FROM `manage_cssc_lake`.`hippo_facility` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,`facility_type` AS `facility_type`,`cssc_code` AS `cssc_code`,IF ( LOCATE('|',`diocese`) > 0 , IF ( SUBSTRING(`diocese`,1, LOCATE('|',`diocese`) - 1) IN ('diocese'), CONCAT( `diocese`,'@northern'),`diocese`),`diocese`) AS `diocese`,parent AS ``parent`` FROM `manage_cssc_northern`.`hippo_facility` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,`facility_type` AS `facility_type`,`cssc_code` AS `cssc_code`,IF ( LOCATE('|',`diocese`) > 0 , IF ( SUBSTRING(`diocese`,1, LOCATE('|',`diocese`) - 1) IN ('diocese'), CONCAT( `diocese`,'@southern'),`diocese`),`diocese`) AS `diocese`,parent AS ``parent`` FROM `manage_cssc_southern`.`hippo_facility` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,10),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,`facility_type` AS `facility_type`,`cssc_code` AS `cssc_code`,IF ( LOCATE('|',`diocese`) > 0 , IF ( SUBSTRING(`diocese`,1, LOCATE('|',`diocese`) - 1) IN ('diocese'), CONCAT( `diocese`,'@western'),`diocese`),`diocese`) AS `diocese`,parent AS ``parent`` FROM `manage_cssc_western`.`hippo_facility` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`location`=values(`location`),`name`=values(`name`),`facility_type`=values(`facility_type`),`cssc_code`=values(`cssc_code`),`diocese`=values(`diocese`),`id`=values(`id`),`parent`=values(`parent`)]
  213. [Native code: 1064]
  214. [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'parent`` FROM `manage_cssc_eastern`.`hippo_facility` WHERE (( last_modified IS ' at line 1]
  215. [Thu Feb 03 09:47:05 2011] [error] [client 196.46.109.86]
  216. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  217. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:304)
  218. I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:592)
  219. I2CE->initializeDSN (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49)
  220. No memcached
  221. [Thu Feb 03 09:47:06 2011] [error] [client 196.46.109.86]
  222. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  223. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:153)
  224. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  225. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  226. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  227. forceCreateCache
  228. [Thu Feb 03 09:47:06 2011] [error] [client 196.46.109.86]
  229. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  230. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
  231. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  232. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  233. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  234. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  235. The form job is dirty
  236. [Thu Feb 03 09:47:06 2011] [error] [client 196.46.109.86]
  237. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  238. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
  239. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  240. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  241. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  242. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  243. Poulating fields for job
  244. [Thu Feb 03 09:47:06 2011] [error] [client 196.46.109.86]
  245. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  246. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
  247. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  248. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  249. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  250. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  251. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  252. Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_job`(id,parent,`last_modified`,`i2ce_hidden`,`cadre`,`classification`,`code`,`description`,`isco_88_unit`,`salary_grade`,`title`) (SELECT concat('job|',id) as id, parent , `last_modified`, `i2ce_hidden`,`cadre`,`classification`,`code`,`description`,`isco_88_unit`,`salary_grade`,`title` FROM (SELECT c.name as `id`,`joined_i2ce_hidden`.value as `i2ce_hidden`,`joined_cadre`.value as `cadre`,`joined_classification`.value as `classification`,`joined_code`.value as `code`,`joined_description`.value as `description`,`joined_isco_88_unit`.value as `isco_88_unit`,`joined_salary_grade`.value as `salary_grade`,`joined_title`.value as `title`,`joined_parent`.value as `parent`,modified.value AS `last_modified` FROM config_alt c LEFT JOIN config_alt `joined_i2ce_hidden` ON `joined_i2ce_hidden`.parent= CONCAT(c.parent, '/' , c.name , '/fields') AND `joined_i2ce_hidden`.name = 'i2ce_hidden' LEFT JOIN config_alt `joined_cadre` ON `joined_cadre`.parent= CONCAT(c.parent, '/' , c.name , '/fields') AND `joined_cadre`.name = 'cadre' LEFT JOIN config_alt `joined_classification` ON `joined_classification`.parent= CONCAT(c.parent, '/' , c.name , '/fields') AND `joined_classification`.name = 'classification' LEFT JOIN config_alt `joined_code` ON `joined_code`.parent= CONCAT(c.parent, '/' , c.name , '/fields') AND `joined_code`.name = 'code' LEFT JOIN config_alt `joined_description` ON `joined_description`.parent= CONCAT(c.parent, '/' , c.name , '/fields') AND `joined_description`.name = 'description' LEFT JOIN config_alt `joined_isco_88_unit` ON `joined_isco_88_unit`.parent= CONCAT(c.parent, '/' , c.name , '/fields') AND `joined_isco_88_unit`.name = 'isco_88_unit' LEFT JOIN config_alt `joined_salary_grade` ON `joined_salary_grade`.parent= CONCAT(c.parent, '/' , c.name , '/fields') AND `joined_salary_grade`.name = 'salary_grade' LEFT JOIN config_alt `joined_title` ON `joined_title`.parent= CONCAT(c.parent, '/' , c.name , '/fields') AND `joined_title`.name = 'title' LEFT JOIN config_alt `joined_parent` ON `joined_parent`.parent = CONCAT(c.parent,'/',c.name) and `joined_parent`.name = 'parent' LEFT JOIN config_alt modified ON modified.parent = CONCAT(c.parent ,'/',c.name) AND modified.name = 'last_modified' WHERE (c.parent = '/I2CE/formsData/forms/job' AND (modified.value IS NULL OR modified.value > STR_TO_DATE('1970-01-01 03:00:00','%Y-%m-%d %H:%i:%s')))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`cadre`=values(`cadre`),`classification`=values(`classification`),`code`=values(`code`),`description`=values(`description`),`isco_88_unit`=values(`isco_88_unit`),`salary_grade`=values(`salary_grade`),`title`=values(`title`),`id`=values(`id`),`parent`=values(`parent`)
  253. [Thu Feb 03 09:47:06 2011] [error] [client 196.46.109.86]
  254. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  255. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:422)
  256. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  257. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  258. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  259. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  260. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  261. Updated 0 records for job
  262. [Thu Feb 03 09:47:06 2011] [error] [client 196.46.109.86]
  263. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  264. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:372)
  265. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  266. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  267. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  268. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  269. Populated job at 1296715626:Thu, 03 Feb 2011 09:47:06 +0300
  270. [Thu Feb 03 09:47:11 2011] [error] [client 196.46.109.86]
  271. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  272. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:304)
  273. I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:592)
  274. I2CE->initializeDSN (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49)
  275. No memcached
  276. [Thu Feb 03 09:47:12 2011] [error] [client 196.46.109.86]
  277. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  278. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:153)
  279. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  280. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  281. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  282. forceCreateCache
  283. [Thu Feb 03 09:47:12 2011] [error] [client 196.46.109.86]
  284. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  285. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
  286. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  287. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  288. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  289. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  290. The form person is dirty
  291. [Thu Feb 03 09:47:12 2011] [error] [client 196.46.109.86]
  292. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  293. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
  294. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  295. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  296. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  297. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  298. Poulating fields for person
  299. [Thu Feb 03 09:47:12 2011] [error] [client 196.46.109.86]
  300. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  301. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
  302. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  303. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  304. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  305. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  306. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  307. Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_person`(id,parent,`last_modified`,`firstname`,`nationality`,`othername`,`residence`,`surname`,`relg_affil`,`title`,`tribe`) (SELECT concat('person|',id) as id, parent , `last_modified`, `firstname`,`nationality`,`othername`,`residence`,`surname`,`relg_affil`,`title`,`tribe` FROM ((SELECT CONCAT( SUBSTRING(id,8),'@','eastern') AS `id`,`firstname` AS `firstname`,`nationality` AS `nationality`,`othername` AS `othername`,`residence` AS `residence`,`surname` AS `surname`,IF ( LOCATE('|',`relg_affil`) > 0 , IF ( SUBSTRING(`relg_affil`,1, LOCATE('|',`relg_affil`) - 1) IN ('relg_affil'), CONCAT( `relg_affil`,'@eastern'),`relg_affil`),`relg_affil`) AS `relg_affil`,IF ( LOCATE('|',`title`) > 0 , IF ( SUBSTRING(`title`,1, LOCATE('|',`title`) - 1) IN ('title'), CONCAT( `title`,'@eastern'),`title`),`title`) AS `title`,IF ( LOCATE('|',`tribe`) > 0 , IF ( SUBSTRING(`tribe`,1, LOCATE('|',`tribe`) - 1) IN ('tribe'), CONCAT( `tribe`,'@eastern'),`tribe`),`tribe`) AS `tribe`,parent AS ``parent`` FROM `manage_cssc_eastern`.`hippo_person` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,8),'@','lake') AS `id`,`firstname` AS `firstname`,`nationality` AS `nationality`,`othername` AS `othername`,`residence` AS `residence`,`surname` AS `surname`,IF ( LOCATE('|',`relg_affil`) > 0 , IF ( SUBSTRING(`relg_affil`,1, LOCATE('|',`relg_affil`) - 1) IN ('relg_affil'), CONCAT( `relg_affil`,'@lake'),`relg_affil`),`relg_affil`) AS `relg_affil`,IF ( LOCATE('|',`title`) > 0 , IF ( SUBSTRING(`title`,1, LOCATE('|',`title`) - 1) IN ('title'), CONCAT( `title`,'@lake'),`title`),`title`) AS `title`,IF ( LOCATE('|',`tribe`) > 0 , IF ( SUBSTRING(`tribe`,1, LOCATE('|',`tribe`) - 1) IN ('tribe'), CONCAT( `tribe`,'@lake'),`tribe`),`tribe`) AS `tribe`,parent AS ``parent`` FROM `manage_cssc_lake`.`hippo_person` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,8),'@','northern') AS `id`,`firstname` AS `firstname`,`nationality` AS `nationality`,`othername` AS `othername`,`residence` AS `residence`,`surname` AS `surname`,IF ( LOCATE('|',`relg_affil`) > 0 , IF ( SUBSTRING(`relg_affil`,1, LOCATE('|',`relg_affil`) - 1) IN ('relg_affil'), CONCAT( `relg_affil`,'@northern'),`relg_affil`),`relg_affil`) AS `relg_affil`,IF ( LOCATE('|',`title`) > 0 , IF ( SUBSTRING(`title`,1, LOCATE('|',`title`) - 1) IN ('title'), CONCAT( `title`,'@northern'),`title`),`title`) AS `title`,IF ( LOCATE('|',`tribe`) > 0 , IF ( SUBSTRING(`tribe`,1, LOCATE('|',`tribe`) - 1) IN ('tribe'), CONCAT( `tribe`,'@northern'),`tribe`),`tribe`) AS `tribe`,parent AS ``parent`` FROM `manage_cssc_northern`.`hippo_person` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,8),'@','southern') AS `id`,`firstname` AS `firstname`,`nationality` AS `nationality`,`othername` AS `othername`,`residence` AS `residence`,`surname` AS `surname`,IF ( LOCATE('|',`relg_affil`) > 0 , IF ( SUBSTRING(`relg_affil`,1, LOCATE('|',`relg_affil`) - 1) IN ('relg_affil'), CONCAT( `relg_affil`,'@southern'),`relg_affil`),`relg_affil`) AS `relg_affil`,IF ( LOCATE('|',`title`) > 0 , IF ( SUBSTRING(`title`,1, LOCATE('|',`title`) - 1) IN ('title'), CONCAT( `title`,'@southern'),`title`),`title`) AS `title`,IF ( LOCATE('|',`tribe`) > 0 , IF ( SUBSTRING(`tribe`,1, LOCATE('|',`tribe`) - 1) IN ('tribe'), CONCAT( `tribe`,'@southern'),`tribe`),`tribe`) AS `tribe`,parent AS ``parent`` FROM `manage_cssc_southern`.`hippo_person` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,8),'@','western') AS `id`,`firstname` AS `firstname`,`nationality` AS `nationality`,`othername` AS `othername`,`residence` AS `residence`,`surname` AS `surname`,IF ( LOCATE('|',`relg_affil`) > 0 , IF ( SUBSTRING(`relg_affil`,1, LOCATE('|',`relg_affil`) - 1) IN ('relg_affil'), CONCAT( `relg_affil`,'@western'),`relg_affil`),`relg_affil`) AS `relg_affil`,IF ( LOCATE('|',`title`) > 0 , IF ( SUBSTRING(`title`,1, LOCATE('|',`title`) - 1) IN ('title'), CONCAT( `title`,'@western'),`title`),`title`) AS `title`,IF ( LOCATE('|',`tribe`) > 0 , IF ( SUBSTRING(`tribe`,1, LOCATE('|',`tribe`) - 1) IN ('tribe'), CONCAT( `tribe`,'@western'),`tribe`),`tribe`) AS `tribe`,parent AS ``parent`` FROM `manage_cssc_western`.`hippo_person` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `firstname`=values(`firstname`),`nationality`=values(`nationality`),`othername`=values(`othername`),`residence`=values(`residence`),`surname`=values(`surname`),`relg_affil`=values(`relg_affil`),`title`=values(`title`),`tribe`=values(`tribe`),`id`=values(`id`),`parent`=values(`parent`)
  308. [Thu Feb 03 09:47:12 2011] [error] [client 196.46.109.86]
  309. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  310. I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
  311. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  312. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:163)
  313. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  314. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  315. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  316. Could not populate cach for person::
  317. MDB2 Error: syntax error
  318. _doQuery: [Error message: Could not execute statement]
  319. [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_person`(id,parent,`last_modified`,`firstname`,`nationality`,`othername`,`residence`,`surname`,`relg_affil`,`title`,`tribe`) (SELECT concat('person|',id) as id, parent , `last_modified`, `firstname`,`nationality`,`othername`,`residence`,`surname`,`relg_affil`,`title`,`tribe` FROM ((SELECT CONCAT( SUBSTRING(id,8),'@','eastern') AS `id`,`firstname` AS `firstname`,`nationality` AS `nationality`,`othername` AS `othername`,`residence` AS `residence`,`surname` AS `surname`,IF ( LOCATE('|',`relg_affil`) > 0 , IF ( SUBSTRING(`relg_affil`,1, LOCATE('|',`relg_affil`) - 1) IN ('relg_affil'), CONCAT( `relg_affil`,'@eastern'),`relg_affil`),`relg_affil`) AS `relg_affil`,IF ( LOCATE('|',`title`) > 0 , IF ( SUBSTRING(`title`,1, LOCATE('|',`title`) - 1) IN ('title'), CONCAT( `title`,'@eastern'),`title`),`title`) AS `title`,IF ( LOCATE('|',`tribe`) > 0 , IF ( SUBSTRING(`tribe`,1, LOCATE('|',`tribe`) - 1) IN ('tribe'), CONCAT( `tribe`,'@eastern'),`tribe`),`tribe`) AS `tribe`,parent AS ``parent`` FROM `manage_cssc_eastern`.`hippo_person` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,8),'@','lake') AS `id`,`firstname` AS `firstname`,`nationality` AS `nationality`,`othername` AS `othername`,`residence` AS `residence`,`surname` AS `surname`,IF ( LOCATE('|',`relg_affil`) > 0 , IF ( SUBSTRING(`relg_affil`,1, LOCATE('|',`relg_affil`) - 1) IN ('relg_affil'), CONCAT( `relg_affil`,'@lake'),`relg_affil`),`relg_affil`) AS `relg_affil`,IF ( LOCATE('|',`title`) > 0 , IF ( SUBSTRING(`title`,1, LOCATE('|',`title`) - 1) IN ('title'), CONCAT( `title`,'@lake'),`title`),`title`) AS `title`,IF ( LOCATE('|',`tribe`) > 0 , IF ( SUBSTRING(`tribe`,1, LOCATE('|',`tribe`) - 1) IN ('tribe'), CONCAT( `tribe`,'@lake'),`tribe`),`tribe`) AS `tribe`,parent AS ``parent`` FROM `manage_cssc_lake`.`hippo_person` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,8),'@','northern') AS `id`,`firstname` AS `firstname`,`nationality` AS `nationality`,`othername` AS `othername`,`residence` AS `residence`,`surname` AS `surname`,IF ( LOCATE('|',`relg_affil`) > 0 , IF ( SUBSTRING(`relg_affil`,1, LOCATE('|',`relg_affil`) - 1) IN ('relg_affil'), CONCAT( `relg_affil`,'@northern'),`relg_affil`),`relg_affil`) AS `relg_affil`,IF ( LOCATE('|',`title`) > 0 , IF ( SUBSTRING(`title`,1, LOCATE('|',`title`) - 1) IN ('title'), CONCAT( `title`,'@northern'),`title`),`title`) AS `title`,IF ( LOCATE('|',`tribe`) > 0 , IF ( SUBSTRING(`tribe`,1, LOCATE('|',`tribe`) - 1) IN ('tribe'), CONCAT( `tribe`,'@northern'),`tribe`),`tribe`) AS `tribe`,parent AS ``parent`` FROM `manage_cssc_northern`.`hippo_person` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,8),'@','southern') AS `id`,`firstname` AS `firstname`,`nationality` AS `nationality`,`othername` AS `othername`,`residence` AS `residence`,`surname` AS `surname`,IF ( LOCATE('|',`relg_affil`) > 0 , IF ( SUBSTRING(`relg_affil`,1, LOCATE('|',`relg_affil`) - 1) IN ('relg_affil'), CONCAT( `relg_affil`,'@southern'),`relg_affil`),`relg_affil`) AS `relg_affil`,IF ( LOCATE('|',`title`) > 0 , IF ( SUBSTRING(`title`,1, LOCATE('|',`title`) - 1) IN ('title'), CONCAT( `title`,'@southern'),`title`),`title`) AS `title`,IF ( LOCATE('|',`tribe`) > 0 , IF ( SUBSTRING(`tribe`,1, LOCATE('|',`tribe`) - 1) IN ('tribe'), CONCAT( `tribe`,'@southern'),`tribe`),`tribe`) AS `tribe`,parent AS ``parent`` FROM `manage_cssc_southern`.`hippo_person` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,8),'@','western') AS `id`,`firstname` AS `firstname`,`nationality` AS `nationality`,`othername` AS `othername`,`residence` AS `residence`,`surname` AS `surname`,IF ( LOCATE('|',`relg_affil`) > 0 , IF ( SUBSTRING(`relg_affil`,1, LOCATE('|',`relg_affil`) - 1) IN ('relg_affil'), CONCAT( `relg_affil`,'@western'),`relg_affil`),`relg_affil`) AS `relg_affil`,IF ( LOCATE('|',`title`) > 0 , IF ( SUBSTRING(`title`,1, LOCATE('|',`title`) - 1) IN ('title'), CONCAT( `title`,'@western'),`title`),`title`) AS `title`,IF ( LOCATE('|',`tribe`) > 0 , IF ( SUBSTRING(`tribe`,1, LOCATE('|',`tribe`) - 1) IN ('tribe'), CONCAT( `tribe`,'@western'),`tribe`),`tribe`) AS `tribe`,parent AS ``parent`` FROM `manage_cssc_western`.`hippo_person` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `firstname`=values(`firstname`),`nationality`=values(`nationality`),`othername`=values(`othername`),`residence`=values(`residence`),`surname`=values(`surname`),`relg_affil`=values(`relg_affil`),`title`=values(`title`),`tribe`=values(`tribe`),`id`=values(`id`),`parent`=values(`parent`)]
  320. [Native code: 1064]
  321. [Native message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'parent`` FROM `manage_cssc_eastern`.`hippo_person` WHERE (( last_modified IS NU' at line 1]
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!