API tools faq
paste
Advertisement
ihris

Mathayo

ihris
Feb 8th, 2011
118
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 32.90 KB | None | 0 0
raw download clone embed print report
  1. `hippo_training_funder_contact` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,25),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`address` AS `address`,`alt_telephone` AS `alt_telephone`,`email` AS `email`,`fax` AS `fax`,`notes` AS `notes`,`telephone` AS `telephone`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('training_funder'), CONCAT( parent,'@western'),parent),parent) AS `parent` FROM `manage_cssc_western`.`hippo_training_funder_contact` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`address`=values(`address`),`alt_telephone`=values(`alt_telephone`),`email`=values(`email`),`fax`=values(`fax`),`notes`=values(`notes`),`telephone`=values(`telephone`),`id`=values(`id`),`parent`=values(`parent`)]
  2. [Native code: 1054]
  3. [Native message: Unknown column 'i2ce_hidden' in 'field list']
  4. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  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/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
  7. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  8. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  9. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  10. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  11. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  12. The form training_institution is dirty
  13. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  14. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  15. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
  16. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  17. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  18. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  19. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  20. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  21. Poulating fields for training_institution
  22. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  23. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  24. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
  25. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  26. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  27. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  28. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  29. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  30. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  31. Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_training_institution`(id,parent,`last_modified`,`i2ce_hidden`,`location`,`name`) (SELECT concat('training_institution|',id) as id, parent , `last_modified`, `i2ce_hidden`,`location`,`name` FROM ((SELECT CONCAT( SUBSTRING(id,22),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_eastern`.`hippo_training_institution` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,22),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_lake`.`hippo_training_institution` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,22),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_northern`.`hippo_training_institution` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,22),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_southern`.`hippo_training_institution` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,22),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_western`.`hippo_training_institution` 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`),`id`=values(`id`),`parent`=values(`parent`)
  32. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  33. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  34. I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
  35. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  36. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  37. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  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. Could not populate cach for training_institution::
  42. MDB2 Error: no such field
  43. _doQuery: [Error message: Could not execute statement]
  44. [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_training_institution`(id,parent,`last_modified`,`i2ce_hidden`,`location`,`name`) (SELECT concat('training_institution|',id) as id, parent , `last_modified`, `i2ce_hidden`,`location`,`name` FROM ((SELECT CONCAT( SUBSTRING(id,22),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_eastern`.`hippo_training_institution` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,22),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_lake`.`hippo_training_institution` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,22),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_northern`.`hippo_training_institution` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,22),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_southern`.`hippo_training_institution` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,22),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`location` AS `location`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_western`.`hippo_training_institution` 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`),`id`=values(`id`),`parent`=values(`parent`)]
  45. [Native code: 1054]
  46. [Native message: Unknown column 'i2ce_hidden' in 'field list']
  47. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  48. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  49. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
  50. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  51. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  52. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  53. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  54. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  55. The form training_institution_contact is dirty
  56. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  57. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  58. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
  59. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  60. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  61. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  62. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  63. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  64. Poulating fields for training_institution_contact
  65. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  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_CachedForm.php:417)
  68. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  69. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  70. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  71. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  72. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  73. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  74. Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_training_institution_contact`(id,parent,`last_modified`,`i2ce_hidden`,`address`,`alt_telephone`,`email`,`fax`,`notes`,`telephone`) (SELECT concat('training_institution_contact|',id) as id, parent , `last_modified`, `i2ce_hidden`,`address`,`alt_telephone`,`email`,`fax`,`notes`,`telephone` FROM ((SELECT CONCAT( SUBSTRING(id,30),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`address` AS `address`,`alt_telephone` AS `alt_telephone`,`email` AS `email`,`fax` AS `fax`,`notes` AS `notes`,`telephone` AS `telephone`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('training_institution'), CONCAT( parent,'@eastern'),parent),parent) AS `parent` FROM `manage_cssc_eastern`.`hippo_training_institution_contact` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,30),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`address` AS `address`,`alt_telephone` AS `alt_telephone`,`email` AS `email`,`fax` AS `fax`,`notes` AS `notes`,`telephone` AS `telephone`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('training_institution'), CONCAT( parent,'@lake'),parent),parent) AS `parent` FROM `manage_cssc_lake`.`hippo_training_institution_contact` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,30),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`address` AS `address`,`alt_telephone` AS `alt_telephone`,`email` AS `email`,`fax` AS `fax`,`notes` AS `notes`,`telephone` AS `telephone`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('training_institution'), CONCAT( parent,'@northern'),parent),parent) AS `parent` FROM `manage_cssc_northern`.`hippo_training_institution_contact` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,30),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`address` AS `address`,`alt_telephone` AS `alt_telephone`,`email` AS `email`,`fax` AS `fax`,`notes` AS `notes`,`telephone` AS `telephone`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('training_institution'), CONCAT( parent,'@southern'),parent),parent) AS `parent` FROM `manage_cssc_southern`.`hippo_training_institution_contact` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,30),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`address` AS `address`,`alt_telephone` AS `alt_telephone`,`email` AS `email`,`fax` AS `fax`,`notes` AS `notes`,`telephone` AS `telephone`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('training_institution'), CONCAT( parent,'@western'),parent),parent) AS `parent` FROM `manage_cssc_western`.`hippo_training_institution_contact` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`address`=values(`address`),`alt_telephone`=values(`alt_telephone`),`email`=values(`email`),`fax`=values(`fax`),`notes`=values(`notes`),`telephone`=values(`telephone`),`id`=values(`id`),`parent`=values(`parent`)
  75. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  76. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  77. I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
  78. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  79. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  80. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  81. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  82. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  83. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  84. Could not populate cach for training_institution_contact::
  85. MDB2 Error: no such field
  86. _doQuery: [Error message: Could not execute statement]
  87. [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_training_institution_contact`(id,parent,`last_modified`,`i2ce_hidden`,`address`,`alt_telephone`,`email`,`fax`,`notes`,`telephone`) (SELECT concat('training_institution_contact|',id) as id, parent , `last_modified`, `i2ce_hidden`,`address`,`alt_telephone`,`email`,`fax`,`notes`,`telephone` FROM ((SELECT CONCAT( SUBSTRING(id,30),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`address` AS `address`,`alt_telephone` AS `alt_telephone`,`email` AS `email`,`fax` AS `fax`,`notes` AS `notes`,`telephone` AS `telephone`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('training_institution'), CONCAT( parent,'@eastern'),parent),parent) AS `parent` FROM `manage_cssc_eastern`.`hippo_training_institution_contact` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,30),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`address` AS `address`,`alt_telephone` AS `alt_telephone`,`email` AS `email`,`fax` AS `fax`,`notes` AS `notes`,`telephone` AS `telephone`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('training_institution'), CONCAT( parent,'@lake'),parent),parent) AS `parent` FROM `manage_cssc_lake`.`hippo_training_institution_contact` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,30),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`address` AS `address`,`alt_telephone` AS `alt_telephone`,`email` AS `email`,`fax` AS `fax`,`notes` AS `notes`,`telephone` AS `telephone`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('training_institution'), CONCAT( parent,'@northern'),parent),parent) AS `parent` FROM `manage_cssc_northern`.`hippo_training_institution_contact` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,30),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`address` AS `address`,`alt_telephone` AS `alt_telephone`,`email` AS `email`,`fax` AS `fax`,`notes` AS `notes`,`telephone` AS `telephone`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('training_institution'), CONCAT( parent,'@southern'),parent),parent) AS `parent` FROM `manage_cssc_southern`.`hippo_training_institution_contact` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,30),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`address` AS `address`,`alt_telephone` AS `alt_telephone`,`email` AS `email`,`fax` AS `fax`,`notes` AS `notes`,`telephone` AS `telephone`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('training_institution'), CONCAT( parent,'@western'),parent),parent) AS `parent` FROM `manage_cssc_western`.`hippo_training_institution_contact` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`address`=values(`address`),`alt_telephone`=values(`alt_telephone`),`email`=values(`email`),`fax`=values(`fax`),`notes`=values(`notes`),`telephone`=values(`telephone`),`id`=values(`id`),`parent`=values(`parent`)]
  88. [Native code: 1054]
  89. [Native message: Unknown column 'i2ce_hidden' in 'field list']
  90. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  91. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  92. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
  93. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  94. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  95. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  96. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  97. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  98. The form tribe is dirty
  99. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  100. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  101. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
  102. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  103. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  104. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  105. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  106. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  107. Poulating fields for tribe
  108. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  109. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  110. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
  111. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  112. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  113. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  114. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  115. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  116. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  117. Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_tribe`(id,parent,`last_modified`,`i2ce_hidden`,`name`) (SELECT concat('tribe|',id) as id, parent , `last_modified`, `i2ce_hidden`,`name` FROM ((SELECT CONCAT( SUBSTRING(id,7),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_eastern`.`hippo_tribe` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,7),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_lake`.`hippo_tribe` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,7),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_northern`.`hippo_tribe` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,7),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_southern`.`hippo_tribe` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,7),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_western`.`hippo_tribe` 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`)
  118. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  119. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  120. I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
  121. I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
  122. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  123. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  124. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  125. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  126. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  127. Could not populate cach for tribe::
  128. MDB2 Error: no such field
  129. _doQuery: [Error message: Could not execute statement]
  130. [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_tribe`(id,parent,`last_modified`,`i2ce_hidden`,`name`) (SELECT concat('tribe|',id) as id, parent , `last_modified`, `i2ce_hidden`,`name` FROM ((SELECT CONCAT( SUBSTRING(id,7),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_eastern`.`hippo_tribe` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,7),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_lake`.`hippo_tribe` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,7),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_northern`.`hippo_tribe` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,7),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_southern`.`hippo_tribe` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,7),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_western`.`hippo_tribe` 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`)]
  131. [Native code: 1054]
  132. [Native message: Unknown column 'i2ce_hidden' in 'field list']
  133. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  134. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  135. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
  136. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  137. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  138. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  139. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  140. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  141. The form user is dirty
  142. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  143. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  144. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
  145. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  146. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  147. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  148. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  149. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  150. Poulating fields for user
  151. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  152. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  153. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:455)
  154. I2CE_CachedForm->slowPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:368)
  155. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  156. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  157. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  158. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  159. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  160. Slow populate:
  161. INSERT INTO `manage_cssc_central`.`hippo_user` (`i2ce_hidden`,`creator`,`email`,`firstname`,`lastname`,`password`,`role`,`username`,`last_modified`,`id`,`parent` ) VALUES (?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`creator`=values(`creator`),`email`=values(`email`),`firstname`=values(`firstname`),`lastname`=values(`lastname`),`password`=values(`password`),`role`=values(`role`),`username`=values(`username`),`last_modified`=values(`last_modified`),`id`=values(`id`),`parent`=values(`parent`)
  162. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  163. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  164. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:489)
  165. I2CE_CachedForm->slowPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:368)
  166. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  167. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  168. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  169. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  170. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  171. Populate 3 entries for user
  172. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  173. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  174. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:372)
  175. I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
  176. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  177. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  178. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  179. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  180. Populated user at 1297181296:Tue, 08 Feb 2011 19:08:16 +0300
  181. [Tue Feb 08 19:08:16 2011] [error] [client 41.217.202.11]
  182. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  183. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:490)
  184. I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
  185. I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
  186. I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
  187. I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
  188. CacheAll: Could not cache accident,application,benefit,benefit_recurrence,benefit_type,competency,competency_evaluation,competency_type,contact,continuing_education,continuing_education_course,council,cssc_spouse,demographic,department,diocese,disciplinary_action,education,employer,employment,facility,facility_contact,notes,person,person_competency,person_contact_emergency,person_contact_other,person_contact_personal,person_contact_work,person_id,person_language,person_position,person_scheduled_training_course,position,position_decision,position_interview,position_type,registration,relg_affil,salary,salary_grade,scheduled_training_course,title,training_course,training_course_category,training_course_competency_evaluation,training_course_evaluation,training_course_requestor,training_course_status,training_funder,training_funder_contact,training_institution,training_institution_contact,tribe
  189. [Tue Feb 08 19:08:18 2011] [error] [client 41.217.202.11]
  190. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  191. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:304)
  192. I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:592)
  193. I2CE->initializeDSN (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49)
  194. No memcached
  195. [Tue Feb 08 19:08:26 2011] [error] [client 41.217.202.11]
  196. Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
  197. I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:304)
  198. I2CE->setupMagicData (/var/lib/iHRIS/lib/4.0.10/I2CE/lib/I2CE.php:592)
  199. I2CE->initializeDSN (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:49)
  200. No memcached
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!