Advertisement
ihris

lungo

Feb 21st, 2011
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 2.17 KB | None | 0 0
  1. Could NOT populate cach FOR application::
  2.     MDB2 Error: no such FIELD
  3.     _doQuery: [Error message: Could NOT EXECUTE statement]
  4.     [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`)]
  5.     [Native code: 1054]
  6.     [Native message: UNKNOWN COLUMN 'last_modified' IN 'where clause']
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement