Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Could NOT populate cach FOR application::
- MDB2 Error: no such FIELD
- _doQuery: [Error message: Could NOT EXECUTE statement]
- [LAST executed query: INSERT INTO `ihrisudsmdev`.`hippo_application`(id,parent,`last_modified`,`desired_wage`,`felony`,`felony_circumstance`,`full_time`,`hear`,`hours`,`other_info`,`position`,`start_date`) (SELECT concat('application|',id) AS id, parent , `last_modified`, `desired_wage`,`felony`,`felony_circumstance`,`full_time`,`hear`,`hours`,`other_info`,`position`,`start_date` FROM ((SELECT CONCAT( SUBSTRING(id,13),'@','ludewa') AS `id`,`desired_wage` AS `desired_wage`,`felony` AS `felony`,`felony_circumstance` AS `felony_circumstance`,`full_time` AS `full_time`,`hear` AS `hear`,`hours` AS `hours`,`other_info` AS `other_info`,formfield_mult_map_componentize(`position`,'position','ludewa') AS `position`,`start_date` AS `start_date`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person'), CONCAT( parent,'@ludewa'),parent),parent) AS `parent` FROM `ihris_ludewa`.`hippo_application` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,13),'@','njombe') AS `id`,`desired_wage` AS `desired_wage`,`felony` AS `felony`,`felony_circumstance` AS `felony_circumstance`,`full_time` AS `full_time`,`hear` AS `hear`,`hours` AS `hours`,`other_info` AS `other_info`,formfield_mult_map_componentize(`position`,'position','njombe') AS `position`,`start_date` AS `start_date`,IF ( LOCATE('|',parent) > 0 , IF ( SUBSTRING(parent,1, LOCATE('|',parent) - 1) IN ('person'), CONCAT( parent,'@njombe'),parent),parent) AS `parent` FROM `ihris_njombe`.`hippo_application` WHERE (( last_modified IS NULL OR last_modified > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `desired_wage`=VALUES(`desired_wage`),`felony`=VALUES(`felony`),`felony_circumstance`=VALUES(`felony_circumstance`),`full_time`=VALUES(`full_time`),`hear`=VALUES(`hear`),`hours`=VALUES(`hours`),`other_info`=VALUES(`other_info`),`position`=VALUES(`position`),`start_date`=VALUES(`start_date`),`id`=VALUES(`id`),`parent`=VALUES(`parent`)]
- [Native code: 1054]
- [Native message: UNKNOWN COLUMN 'last_modified' IN 'where clause']
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement