Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- NCAT( SUBSTRING(id,27),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`end_date` AS `end_date`,`instructors` AS `instructors`,`location` AS `location`,`name` AS `name`,`notes` AS `notes`,`num_students` AS `num_students`,`start_date` AS `start_date`,IF ( LOCATE('|',`training_course`) > 0 , IF ( SUBSTRING(`training_course`,1, LOCATE('|',`training_course`) - 1) IN ('training_course'), CONCAT( `training_course`,'@lake'),`training_course`),`training_course`) AS `training_course`,parent AS `parent` FROM `manage_cssc_lake`.`hippo_scheduled_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,27),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`end_date` AS `end_date`,`instructors` AS `instructors`,`location` AS `location`,`name` AS `name`,`notes` AS `notes`,`num_students` AS `num_students`,`start_date` AS `start_date`,IF ( LOCATE('|',`training_course`) > 0 , IF ( SUBSTRING(`training_course`,1, LOCATE('|',`training_course`) - 1) IN ('training_course'), CONCAT( `training_course`,'@northern'),`training_course`),`training_course`) AS `training_course`,parent AS `parent` FROM `manage_cssc_northern`.`hippo_scheduled_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,27),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`end_date` AS `end_date`,`instructors` AS `instructors`,`location` AS `location`,`name` AS `name`,`notes` AS `notes`,`num_students` AS `num_students`,`start_date` AS `start_date`,IF ( LOCATE('|',`training_course`) > 0 , IF ( SUBSTRING(`training_course`,1, LOCATE('|',`training_course`) - 1) IN ('training_course'), CONCAT( `training_course`,'@southern'),`training_course`),`training_course`) AS `training_course`,parent AS `parent` FROM `manage_cssc_southern`.`hippo_scheduled_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,27),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`end_date` AS `end_date`,`instructors` AS `instructors`,`location` AS `location`,`name` AS `name`,`notes` AS `notes`,`num_students` AS `num_students`,`start_date` AS `start_date`,IF ( LOCATE('|',`training_course`) > 0 , IF ( SUBSTRING(`training_course`,1, LOCATE('|',`training_course`) - 1) IN ('training_course'), CONCAT( `training_course`,'@western'),`training_course`),`training_course`) AS `training_course`,parent AS `parent` FROM `manage_cssc_western`.`hippo_scheduled_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`end_date`=values(`end_date`),`instructors`=values(`instructors`),`location`=values(`location`),`name`=values(`name`),`notes`=values(`notes`),`num_students`=values(`num_students`),`start_date`=values(`start_date`),`training_course`=values(`training_course`),`id`=values(`id`),`parent`=values(`parent`)
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
- I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Could not populate cach for scheduled_training_course::
- MDB2 Error: no such field
- _doQuery: [Error message: Could not execute statement]
- [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_scheduled_training_course`(id,parent,`last_modified`,`i2ce_hidden`,`end_date`,`instructors`,`location`,`name`,`notes`,`num_students`,`start_date`,`training_course`) (SELECT concat('scheduled_training_course|',id) as id, parent , `last_modified`, `i2ce_hidden`,`end_date`,`instructors`,`location`,`name`,`notes`,`num_students`,`start_date`,`training_course` FROM ((SELECT CONCAT( SUBSTRING(id,27),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`end_date` AS `end_date`,`instructors` AS `instructors`,`location` AS `location`,`name` AS `name`,`notes` AS `notes`,`num_students` AS `num_students`,`start_date` AS `start_date`,IF ( LOCATE('|',`training_course`) > 0 , IF ( SUBSTRING(`training_course`,1, LOCATE('|',`training_course`) - 1) IN ('training_course'), CONCAT( `training_course`,'@eastern'),`training_course`),`training_course`) AS `training_course`,parent AS `parent` FROM `manage_cssc_eastern`.`hippo_scheduled_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,27),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`end_date` AS `end_date`,`instructors` AS `instructors`,`location` AS `location`,`name` AS `name`,`notes` AS `notes`,`num_students` AS `num_students`,`start_date` AS `start_date`,IF ( LOCATE('|',`training_course`) > 0 , IF ( SUBSTRING(`training_course`,1, LOCATE('|',`training_course`) - 1) IN ('training_course'), CONCAT( `training_course`,'@lake'),`training_course`),`training_course`) AS `training_course`,parent AS `parent` FROM `manage_cssc_lake`.`hippo_scheduled_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,27),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`end_date` AS `end_date`,`instructors` AS `instructors`,`location` AS `location`,`name` AS `name`,`notes` AS `notes`,`num_students` AS `num_students`,`start_date` AS `start_date`,IF ( LOCATE('|',`training_course`) > 0 , IF ( SUBSTRING(`training_course`,1, LOCATE('|',`training_course`) - 1) IN ('training_course'), CONCAT( `training_course`,'@northern'),`training_course`),`training_course`) AS `training_course`,parent AS `parent` FROM `manage_cssc_northern`.`hippo_scheduled_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,27),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`end_date` AS `end_date`,`instructors` AS `instructors`,`location` AS `location`,`name` AS `name`,`notes` AS `notes`,`num_students` AS `num_students`,`start_date` AS `start_date`,IF ( LOCATE('|',`training_course`) > 0 , IF ( SUBSTRING(`training_course`,1, LOCATE('|',`training_course`) - 1) IN ('training_course'), CONCAT( `training_course`,'@southern'),`training_course`),`training_course`) AS `training_course`,parent AS `parent` FROM `manage_cssc_southern`.`hippo_scheduled_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,27),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`end_date` AS `end_date`,`instructors` AS `instructors`,`location` AS `location`,`name` AS `name`,`notes` AS `notes`,`num_students` AS `num_students`,`start_date` AS `start_date`,IF ( LOCATE('|',`training_course`) > 0 , IF ( SUBSTRING(`training_course`,1, LOCATE('|',`training_course`) - 1) IN ('training_course'), CONCAT( `training_course`,'@western'),`training_course`),`training_course`) AS `training_course`,parent AS `parent` FROM `manage_cssc_western`.`hippo_scheduled_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`end_date`=values(`end_date`),`instructors`=values(`instructors`),`location`=values(`location`),`name`=values(`name`),`notes`=values(`notes`),`num_students`=values(`num_students`),`start_date`=values(`start_date`),`training_course`=values(`training_course`),`id`=values(`id`),`parent`=values(`parent`)]
- [Native code: 1054]
- [Native message: Unknown column 'i2ce_hidden' in 'field list']
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- The form title is dirty
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Poulating fields for title
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
- I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_title`(id,parent,`last_modified`,`i2ce_hidden`,`name`) (SELECT concat('title|',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_title` 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_title` 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_title` 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_title` 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_title` 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`)
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
- I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Could not populate cach for title::
- MDB2 Error: no such field
- _doQuery: [Error message: Could not execute statement]
- [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_title`(id,parent,`last_modified`,`i2ce_hidden`,`name`) (SELECT concat('title|',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_title` 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_title` 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_title` 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_title` 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_title` 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`)]
- [Native code: 1054]
- [Native message: Unknown column 'i2ce_hidden' in 'field list']
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- The form training_course is dirty
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Poulating fields for training_course
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
- I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_training_course`(id,parent,`last_modified`,`i2ce_hidden`,`competency`,`continuing_education_course`,`name`,`notes`,`topic`,`training_course_category`,`training_course_status`,`training_funder`,`training_institution`) (SELECT concat('training_course|',id) as id, parent , `last_modified`, `i2ce_hidden`,`competency`,`continuing_education_course`,`name`,`notes`,`topic`,`training_course_category`,`training_course_status`,`training_funder`,`training_institution` FROM ((SELECT CONCAT( SUBSTRING(id,17),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,formfield_mult_map_componentize(`competency`,'competency','eastern') AS `competency`,formfield_mult_map_componentize(`continuing_education_course`,'continuing_education_course','eastern') AS `continuing_education_course`,`name` AS `name`,`notes` AS `notes`,`topic` AS `topic`,IF ( LOCATE('|',`training_course_category`) > 0 , IF ( SUBSTRING(`training_course_category`,1, LOCATE('|',`training_course_category`) - 1) IN ('training_course_category'), CONCAT( `training_course_category`,'@eastern'),`training_course_category`),`training_course_category`) AS `training_course_category`,IF ( LOCATE('|',`training_course_status`) > 0 , IF ( SUBSTRING(`training_course_status`,1, LOCATE('|',`training_course_status`) - 1) IN ('training_course_status'), CONCAT( `training_course_status`,'@eastern'),`training_course_status`),`training_course_status`) AS `training_course_status`,formfield_mult_map_componentize(`training_funder`,'training_funder','eastern') AS `training_funder`,IF ( LOCATE('|',`training_institution`) > 0 , IF ( SUBSTRING(`training_institution`,1, LOCATE('|',`training_institution`) - 1) IN ('training_institution'), CONCAT( `training_institution`,'@eastern'),`training_institution`),`training_institution`) AS `training_institution`,parent AS `parent` FROM `manage_cssc_eastern`.`hippo_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,17),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,formfield_mult_map_componentize(`competency`,'competency','lake') AS `competency`,formfield_mult_map_componentize(`continuing_education_course`,'continuing_education_course','lake') AS `continuing_education_course`,`name` AS `name`,`notes` AS `notes`,`topic` AS `topic`,IF ( LOCATE('|',`training_course_category`) > 0 , IF ( SUBSTRING(`training_course_category`,1, LOCATE('|',`training_course_category`) - 1) IN ('training_course_category'), CONCAT( `training_course_category`,'@lake'),`training_course_category`),`training_course_category`) AS `training_course_category`,IF ( LOCATE('|',`training_course_status`) > 0 , IF ( SUBSTRING(`training_course_status`,1, LOCATE('|',`training_course_status`) - 1) IN ('training_course_status'), CONCAT( `training_course_status`,'@lake'),`training_course_status`),`training_course_status`) AS `training_course_status`,formfield_mult_map_componentize(`training_funder`,'training_funder','lake') AS `training_funder`,IF ( LOCATE('|',`training_institution`) > 0 , IF ( SUBSTRING(`training_institution`,1, LOCATE('|',`training_institution`) - 1) IN ('training_institution'), CONCAT( `training_institution`,'@lake'),`training_institution`),`training_institution`) AS `training_institution`,parent AS `parent` FROM `manage_cssc_lake`.`hippo_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,17),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,formfield_mult_map_componentize(`competency`,'competency','northern') AS `competency`,formfield_mult_map_componentize(`continuing_education_course`,'continuing_education_course','northern') AS `continuing_education_course`,`name` AS `name`,`notes` AS `notes`,`topic` AS `topic`,IF ( LOCATE('|',`training_course_category`) > 0 , IF ( SUBSTRING(`training_course_category`,1, LOCATE('|',`training_course_category`) - 1) IN ('training_course_category'), CONCAT( `training_course_category`,'@northern'),`training_course_category`),`training_course_category`) AS `training_course_category`,IF ( LOCATE('|',`training_course_status`) > 0 , IF ( SUBSTRING(`training_course_status`,1, LOCATE('|',`training_course_status`) - 1) IN ('training_course_status'), CONCAT( `training_course_status`,'@northern'),`training_course_status`),`training_course_status`) AS `training_course_status`,formfield_mult_map_componentize(`training_funder`,'training_funder','northern') AS `training_funder`,IF ( LOCATE('|',`training_institution`) > 0 , IF ( SUBSTRING(`training_institution`,1, LOCATE('|',`training_institution`) - 1) IN ('training_institution'), CONCAT( `training_institution`,'@northern'),`training_institution`),`training_institution`) AS `training_institution`,parent AS `parent` FROM `manage_cssc_northern`.`hippo_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,17),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,formfield_mult_map_componentize(`competency`,'competency','southern') AS `competency`,formfield_mult_map_componentize(`continuing_education_course`,'continuing_education_course','southern') AS `continuing_education_course`,`name` AS `name`,`notes` AS `notes`,`topic` AS `topic`,IF ( LOCATE('|',`training_course_category`) > 0 , IF ( SUBSTRING(`training_course_category`,1, LOCATE('|',`training_course_category`) - 1) IN ('training_course_category'), CONCAT( `training_course_category`,'@southern'),`training_course_category`),`training_course_category`) AS `training_course_category`,IF ( LOCATE('|',`training_course_status`) > 0 , IF ( SUBSTRING(`training_course_status`,1, LOCATE('|',`training_course_status`) - 1) IN ('training_course_status'), CONCAT( `training_course_status`,'@southern'),`training_course_status`),`training_course_status`) AS `training_course_status`,formfield_mult_map_componentize(`training_funder`,'training_funder','southern') AS `training_funder`,IF ( LOCATE('|',`training_institution`) > 0 , IF ( SUBSTRING(`training_institution`,1, LOCATE('|',`training_institution`) - 1) IN ('training_institution'), CONCAT( `training_institution`,'@southern'),`training_institution`),`training_institution`) AS `training_institution`,parent AS `parent` FROM `manage_cssc_southern`.`hippo_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,17),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,formfield_mult_map_componentize(`competency`,'competency','western') AS `competency`,formfield_mult_map_componentize(`continuing_education_course`,'continuing_education_course','western') AS `continuing_education_course`,`name` AS `name`,`notes` AS `notes`,`topic` AS `topic`,IF ( LOCATE('|',`training_course_category`) > 0 , IF ( SUBSTRING(`training_course_category`,1, LOCATE('|',`training_course_category`) - 1) IN ('training_course_category'), CONCAT( `training_course_category`,'@western'),`training_course_category`),`training_course_category`) AS `training_course_category`,IF ( LOCATE('|',`training_course_status`) > 0 , IF ( SUBSTRING(`training_course_status`,1, LOCATE('|',`training_course_status`) - 1) IN ('training_course_status'), CONCAT( `training_course_status`,'@western'),`training_course_status`),`tr
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
- I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Could not populate cach for training_course::
- MDB2 Error: no such field
- _doQuery: [Error message: Could not execute statement]
- [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_training_course`(id,parent,`last_modified`,`i2ce_hidden`,`competency`,`continuing_education_course`,`name`,`notes`,`topic`,`training_course_category`,`training_course_status`,`training_funder`,`training_institution`) (SELECT concat('training_course|',id) as id, parent , `last_modified`, `i2ce_hidden`,`competency`,`continuing_education_course`,`name`,`notes`,`topic`,`training_course_category`,`training_course_status`,`training_funder`,`training_institution` FROM ((SELECT CONCAT( SUBSTRING(id,17),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,formfield_mult_map_componentize(`competency`,'competency','eastern') AS `competency`,formfield_mult_map_componentize(`continuing_education_course`,'continuing_education_course','eastern') AS `continuing_education_course`,`name` AS `name`,`notes` AS `notes`,`topic` AS `topic`,IF ( LOCATE('|',`training_course_category`) > 0 , IF ( SUBSTRING(`training_course_category`,1, LOCATE('|',`training_course_category`) - 1) IN ('training_course_category'), CONCAT( `training_course_category`,'@eastern'),`training_course_category`),`training_course_category`) AS `training_course_category`,IF ( LOCATE('|',`training_course_status`) > 0 , IF ( SUBSTRING(`training_course_status`,1, LOCATE('|',`training_course_status`) - 1) IN ('training_course_status'), CONCAT( `training_course_status`,'@eastern'),`training_course_status`),`training_course_status`) AS `training_course_status`,formfield_mult_map_componentize(`training_funder`,'training_funder','eastern') AS `training_funder`,IF ( LOCATE('|',`training_institution`) > 0 , IF ( SUBSTRING(`training_institution`,1, LOCATE('|',`training_institution`) - 1) IN ('training_institution'), CONCAT( `training_institution`,'@eastern'),`training_institution`),`training_institution`) AS `training_institution`,parent AS `parent` FROM `manage_cssc_eastern`.`hippo_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,17),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,formfield_mult_map_componentize(`competency`,'competency','lake') AS `competency`,formfield_mult_map_componentize(`continuing_education_course`,'continuing_education_course','lake') AS `continuing_education_course`,`name` AS `name`,`notes` AS `notes`,`topic` AS `topic`,IF ( LOCATE('|',`training_course_category`) > 0 , IF ( SUBSTRING(`training_course_category`,1, LOCATE('|',`training_course_category`) - 1) IN ('training_course_category'), CONCAT( `training_course_category`,'@lake'),`training_course_category`),`training_course_category`) AS `training_course_category`,IF ( LOCATE('|',`training_course_status`) > 0 , IF ( SUBSTRING(`training_course_status`,1, LOCATE('|',`training_course_status`) - 1) IN ('training_course_status'), CONCAT( `training_course_status`,'@lake'),`training_course_status`),`training_course_status`) AS `training_course_status`,formfield_mult_map_componentize(`training_funder`,'training_funder','lake') AS `training_funder`,IF ( LOCATE('|',`training_institution`) > 0 , IF ( SUBSTRING(`training_institution`,1, LOCATE('|',`training_institution`) - 1) IN ('training_institution'), CONCAT( `training_institution`,'@lake'),`training_institution`),`training_institution`) AS `training_institution`,parent AS `parent` FROM `manage_cssc_lake`.`hippo_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,17),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,formfield_mult_map_componentize(`competency`,'competency','northern') AS `competency`,formfield_mult_map_componentize(`continuing_education_course`,'continuing_education_course','northern') AS `continuing_education_course`,`name` AS `name`,`notes` AS `notes`,`topic` AS `topic`,IF ( LOCATE('|',`training_course_category`) > 0 , IF ( SUBSTRING(`training_course_category`,1, LOCATE('|',`training_course_category`) - 1) IN ('training_course_category'), CONCAT( `training_course_category`,'@northern'),`training_course_category`),`training_course_category`) AS `training_course_category`,IF ( LOCATE('|',`training_course_status`) > 0 , IF ( SUBSTRING(`training_course_status`,1, LOCATE('|',`training_course_status`) - 1) IN ('training_course_status'), CONCAT( `training_course_status`,'@northern'),`training_course_status`),`training_course_status`) AS `training_course_status`,formfield_mult_map_componentize(`training_funder`,'training_funder','northern') AS `training_funder`,IF ( LOCATE('|',`training_institution`) > 0 , IF ( SUBSTRING(`training_institution`,1, LOCATE('|',`training_institution`) - 1) IN ('training_institution'), CONCAT( `training_institution`,'@northern'),`training_institution`),`training_institution`) AS `training_institution`,parent AS `parent` FROM `manage_cssc_northern`.`hippo_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,17),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,formfield_mult_map_componentize(`competency`,'competency','southern') AS `competency`,formfield_mult_map_componentize(`continuing_education_course`,'continuing_education_course','southern') AS `continuing_education_course`,`name` AS `name`,`notes` AS `notes`,`topic` AS `topic`,IF ( LOCATE('|',`training_course_category`) > 0 , IF ( SUBSTRING(`training_course_category`,1, LOCATE('|',`training_course_category`) - 1) IN ('training_course_category'), CONCAT( `training_course_category`,'@southern'),`training_course_category`),`training_course_category`) AS `training_course_category`,IF ( LOCATE('|',`training_course_status`) > 0 , IF ( SUBSTRING(`training_course_status`,1, LOCATE('|',`training_course_status`) - 1) IN ('training_course_status'), CONCAT( `training_course_status`,'@southern'),`training_course_status`),`training_course_status`) AS `training_course_status`,formfield_mult_map_componentize(`training_funder`,'training_funder','southern') AS `training_funder`,IF ( LOCATE('|',`training_institution`) > 0 , IF ( SUBSTRING(`training_institution`,1, LOCATE('|',`training_institution`) - 1) IN ('training_institution'), CONCAT( `training_institution`,'@southern'),`training_institution`),`training_institution`) AS `training_institution`,parent AS `parent` FROM `manage_cssc_southern`.`hippo_training_course` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,17),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,formfield_mult_map_componentize(`competency`,'competency','western') AS `competency`,formfield_mult_map_componentize(`continuing_education_course`,'continuing_education_course','western') AS `continuing_education_course`,`name` AS `name`,`notes` AS `notes`,`topic` AS `topic`,IF ( LOCATE('|',`training_course_category`) > 0 , IF ( SUBSTRING(`training_course_category`,1, LOCATE('|',`training_course_category`) - 1) IN ('training_course_category'), CONCAT( `training_course_category`,'@western'),`training_course_category`),`training_course_category`) AS `training_course_category`,IF ( LOCATE('|',`training_course_status`) > 0 , IF ( SUBSTRING(`training_course_status`,1, LOCATE('|',`trai
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- The form training_course_category is dirty
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Poulating fields for training_course_category
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
- I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_training_course_category`(id,parent,`last_modified`,`i2ce_hidden`,`name`) (SELECT concat('training_course_category|',id) as id, parent , `last_modified`, `i2ce_hidden`,`name` FROM ((SELECT CONCAT( SUBSTRING(id,26),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_eastern`.`hippo_training_course_category` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,26),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_lake`.`hippo_training_course_category` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,26),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_northern`.`hippo_training_course_category` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,26),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_southern`.`hippo_training_course_category` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,26),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_western`.`hippo_training_course_category` 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`)
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
- I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Could not populate cach for training_course_category::
- MDB2 Error: no such field
- _doQuery: [Error message: Could not execute statement]
- [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_training_course_category`(id,parent,`last_modified`,`i2ce_hidden`,`name`) (SELECT concat('training_course_category|',id) as id, parent , `last_modified`, `i2ce_hidden`,`name` FROM ((SELECT CONCAT( SUBSTRING(id,26),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_eastern`.`hippo_training_course_category` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,26),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_lake`.`hippo_training_course_category` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,26),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_northern`.`hippo_training_course_category` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,26),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_southern`.`hippo_training_course_category` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,26),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_western`.`hippo_training_course_category` 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`)]
- [Native code: 1054]
- [Native message: Unknown column 'i2ce_hidden' in 'field list']
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- The form training_course_competency_evaluation is dirty
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Poulating fields for training_course_competency_evaluation
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
- I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_training_course_competency_evaluation`(id,parent,`last_modified`,`competency`,`competency_evaluation`,`evaluation_date`,`notes`) (SELECT concat('training_course_competency_evaluation|',id) as id, parent , `last_modified`, `competency`,`competency_evaluation`,`evaluation_date`,`notes` FROM ((SELECT CONCAT( SUBSTRING(id,39),'@','eastern') AS `id`,IF ( LOCATE('|',`competency`) > 0 , IF ( SUBSTRING(`competency`,1, LOCATE('|',`competency`) - 1) IN ('competency'), CONCAT( `competency`,'@eastern'),`competency`),`competency`) AS `competency`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@eastern'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`evaluation_date` AS `evaluation_date`,`notes` AS `notes`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person_scheduled_training_course'), CONCAT( parent,'@eastern'),parent),parent) AS `parent` FROM `manage_cssc_eastern`.`hippo_training_course_competency_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,39),'@','lake') AS `id`,IF ( LOCATE('|',`competency`) > 0 , IF ( SUBSTRING(`competency`,1, LOCATE('|',`competency`) - 1) IN ('competency'), CONCAT( `competency`,'@lake'),`competency`),`competency`) AS `competency`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@lake'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`evaluation_date` AS `evaluation_date`,`notes` AS `notes`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person_scheduled_training_course'), CONCAT( parent,'@lake'),parent),parent) AS `parent` FROM `manage_cssc_lake`.`hippo_training_course_competency_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,39),'@','northern') AS `id`,IF ( LOCATE('|',`competency`) > 0 , IF ( SUBSTRING(`competency`,1, LOCATE('|',`competency`) - 1) IN ('competency'), CONCAT( `competency`,'@northern'),`competency`),`competency`) AS `competency`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@northern'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`evaluation_date` AS `evaluation_date`,`notes` AS `notes`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person_scheduled_training_course'), CONCAT( parent,'@northern'),parent),parent) AS `parent` FROM `manage_cssc_northern`.`hippo_training_course_competency_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,39),'@','southern') AS `id`,IF ( LOCATE('|',`competency`) > 0 , IF ( SUBSTRING(`competency`,1, LOCATE('|',`competency`) - 1) IN ('competency'), CONCAT( `competency`,'@southern'),`competency`),`competency`) AS `competency`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@southern'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`evaluation_date` AS `evaluation_date`,`notes` AS `notes`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person_scheduled_training_course'), CONCAT( parent,'@southern'),parent),parent) AS `parent` FROM `manage_cssc_southern`.`hippo_training_course_competency_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,39),'@','western') AS `id`,IF ( LOCATE('|',`competency`) > 0 , IF ( SUBSTRING(`competency`,1, LOCATE('|',`competency`) - 1) IN ('competency'), CONCAT( `competency`,'@western'),`competency`),`competency`) AS `competency`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@western'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`evaluation_date` AS `evaluation_date`,`notes` AS `notes`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person_scheduled_training_course'), CONCAT( parent,'@western'),parent),parent) AS `parent` FROM `manage_cssc_western`.`hippo_training_course_competency_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `competency`=values(`competency`),`competency_evaluation`=values(`competency_evaluation`),`evaluation_date`=values(`evaluation_date`),`notes`=values(`notes`),`id`=values(`id`),`parent`=values(`parent`)
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
- I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Could not populate cach for training_course_competency_evaluation::
- MDB2 Error: no such field
- _doQuery: [Error message: Could not execute statement]
- [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_training_course_competency_evaluation`(id,parent,`last_modified`,`competency`,`competency_evaluation`,`evaluation_date`,`notes`) (SELECT concat('training_course_competency_evaluation|',id) as id, parent , `last_modified`, `competency`,`competency_evaluation`,`evaluation_date`,`notes` FROM ((SELECT CONCAT( SUBSTRING(id,39),'@','eastern') AS `id`,IF ( LOCATE('|',`competency`) > 0 , IF ( SUBSTRING(`competency`,1, LOCATE('|',`competency`) - 1) IN ('competency'), CONCAT( `competency`,'@eastern'),`competency`),`competency`) AS `competency`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@eastern'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`evaluation_date` AS `evaluation_date`,`notes` AS `notes`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person_scheduled_training_course'), CONCAT( parent,'@eastern'),parent),parent) AS `parent` FROM `manage_cssc_eastern`.`hippo_training_course_competency_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,39),'@','lake') AS `id`,IF ( LOCATE('|',`competency`) > 0 , IF ( SUBSTRING(`competency`,1, LOCATE('|',`competency`) - 1) IN ('competency'), CONCAT( `competency`,'@lake'),`competency`),`competency`) AS `competency`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@lake'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`evaluation_date` AS `evaluation_date`,`notes` AS `notes`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person_scheduled_training_course'), CONCAT( parent,'@lake'),parent),parent) AS `parent` FROM `manage_cssc_lake`.`hippo_training_course_competency_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,39),'@','northern') AS `id`,IF ( LOCATE('|',`competency`) > 0 , IF ( SUBSTRING(`competency`,1, LOCATE('|',`competency`) - 1) IN ('competency'), CONCAT( `competency`,'@northern'),`competency`),`competency`) AS `competency`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@northern'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`evaluation_date` AS `evaluation_date`,`notes` AS `notes`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person_scheduled_training_course'), CONCAT( parent,'@northern'),parent),parent) AS `parent` FROM `manage_cssc_northern`.`hippo_training_course_competency_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,39),'@','southern') AS `id`,IF ( LOCATE('|',`competency`) > 0 , IF ( SUBSTRING(`competency`,1, LOCATE('|',`competency`) - 1) IN ('competency'), CONCAT( `competency`,'@southern'),`competency`),`competency`) AS `competency`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@southern'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`evaluation_date` AS `evaluation_date`,`notes` AS `notes`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person_scheduled_training_course'), CONCAT( parent,'@southern'),parent),parent) AS `parent` FROM `manage_cssc_southern`.`hippo_training_course_competency_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,39),'@','western') AS `id`,IF ( LOCATE('|',`competency`) > 0 , IF ( SUBSTRING(`competency`,1, LOCATE('|',`competency`) - 1) IN ('competency'), CONCAT( `competency`,'@western'),`competency`),`competency`) AS `competency`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@western'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`evaluation_date` AS `evaluation_date`,`notes` AS `notes`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person_scheduled_training_course'), CONCAT( parent,'@western'),parent),parent) AS `parent` FROM `manage_cssc_western`.`hippo_training_course_competency_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `competency`=values(`competency`),`competency_evaluation`=values(`competency_evaluation`),`evaluation_date`=values(`evaluation_date`),`notes`=values(`notes`),`id`=values(`id`),`parent`=values(`parent`)]
- [Native code: 1054]
- [Native message: Unknown column 'last_modified' in 'where clause']
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:356)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- The form training_course_evaluation is dirty
- [Mon Feb 07 15:55:46 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:362)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Poulating fields for training_course_evaluation
- [Mon Feb 07 15:55:47 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->raiseError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:417)
- I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Fast Populate Query:INSERT INTO `manage_cssc_central`.`hippo_training_course_evaluation`(id,parent,`last_modified`,`i2ce_hidden`,`competency_evaluation`,`name`) (SELECT concat('training_course_evaluation|',id) as id, parent , `last_modified`, `i2ce_hidden`,`competency_evaluation`,`name` FROM ((SELECT CONCAT( SUBSTRING(id,28),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@eastern'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_eastern`.`hippo_training_course_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,28),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@lake'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_lake`.`hippo_training_course_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,28),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@northern'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_northern`.`hippo_training_course_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,28),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@southern'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_southern`.`hippo_training_course_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,28),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@western'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_western`.`hippo_training_course_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`competency_evaluation`=values(`competency_evaluation`),`name`=values(`name`),`id`=values(`id`),`parent`=values(`parent`)
- [Mon Feb 07 15:55:47 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
- I2CE: I2CE->pearError (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:419)
- I2CE_CachedForm->fastPopulate (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_CachedForm.php:364)
- I2CE_CachedForm->generateCachedTable (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:477)
- I2CE_Page_CachedForm->cacheAll (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Forms/modules/CachedForms/lib/I2CE_Page_CachedForm.php:128)
- I2CE_Page_CachedForm->action (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Page.php:463)
- I2CE_Page->display (/var/lib/iHRIS/lib/4.0.10/I2CE/modules/Pages/lib/I2CE_Wrangler.php:89)
- I2CE_Wrangler->wrangle (/var/lib/iHRIS/cssc_zonal_deploy/sites/central/pages/index.php:60)
- Could not populate cach for training_course_evaluation::
- MDB2 Error: no such field
- _doQuery: [Error message: Could not execute statement]
- [Last executed query: INSERT INTO `manage_cssc_central`.`hippo_training_course_evaluation`(id,parent,`last_modified`,`i2ce_hidden`,`competency_evaluation`,`name`) (SELECT concat('training_course_evaluation|',id) as id, parent , `last_modified`, `i2ce_hidden`,`competency_evaluation`,`name` FROM ((SELECT CONCAT( SUBSTRING(id,28),'@','eastern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@eastern'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_eastern`.`hippo_training_course_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,28),'@','lake') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@lake'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_lake`.`hippo_training_course_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,28),'@','northern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@northern'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_northern`.`hippo_training_course_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,28),'@','southern') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@southern'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_southern`.`hippo_training_course_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,28),'@','western') AS `id`,`i2ce_hidden` AS `i2ce_hidden`,IF ( LOCATE('|',`competency_evaluation`) > 0 , IF ( SUBSTRING(`competency_evaluation`,1, LOCATE('|',`competency_evaluation`) - 1) IN ('competency_evaluation'), CONCAT( `competency_evaluation`,'@western'),`competency_evaluation`),`competency_evaluation`) AS `competency_evaluation`,`name` AS `name`,parent AS `parent` FROM `manage_cssc_western`.`hippo_training_course_evaluation` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `i2ce_hidden`=values(`i2ce_hidden`),`competency_evaluation`=values(`competency_evaluation`),`name`=values(`name`),`id`=values(`id`),`parent`=values(`parent`)]
- [Native code: 1054]
- [Native message: Unknown column 'i2ce_hidden' in 'field list']
- [Mon Feb 07 15:55:47 2011] [error] [client 196.43.81.249]
- Refered by : http://196.43.81.171/manage-central/index.php/CachedForms
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement