ihris

lungo

Feb 20th, 2011
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.47 KB | None | 0 0
  1. Could NOT populate cach FOR person::
  2.  
  3.     MDB2 Error: no such FIELD
  4.  
  5.     _doQuery: [Error message: Could NOT EXECUTE statement]
  6.  
  7.     [LAST executed query: INSERT INTO `ihrisudsmdev`.`hippo_person`(id,parent,`last_modified`,`firstname`,`high_edu_lev`,`nationality`,`othername`,`residence`,`surname`) (SELECT  concat('person|',id) AS id, parent , `last_modified`, `firstname`,`high_edu_lev`,`nationality`,`othername`,`residence`,`surname` FROM ((SELECT CONCAT( SUBSTRING(id,8),'@','njombe') AS `id`,`firstname` AS `firstname`, NULL  AS `high_edu_lev`,`nationality` AS `nationality`,`othername` AS `othername`,`residence` AS `residence`,`surname` AS `surname`,parent AS `parent` FROM `ihris_njombe`.`hippo_person` WHERE (( last_modified  IS NULL OR  last_modified  > FROM_UNIXTIME(0))))UNION(SELECT CONCAT( SUBSTRING(id,8),'@','ludewa') AS `id`,`firstname` AS `firstname`, NULL  AS `high_edu_lev`,`nationality` AS `nationality`,`othername` AS `othername`,`residence` AS `residence`,`surname` AS `surname`,parent AS `parent` FROM `ihris_ludewa`.`hippo_person` WHERE (( last_modified  IS NULL OR  last_modified  > FROM_UNIXTIME(0))))) AS cached_table) ON DUPLICATE KEY UPDATE `firstname`=VALUES(`firstname`),`high_edu_lev`=VALUES(`high_edu_lev`),`nationality`=VALUES(`nationality`),`othername`=VALUES(`othername`),`residence`=VALUES(`residence`),`surname`=VALUES(`surname`),`id`=VALUES(`id`),`parent`=VALUES(`parent`)]
  8.  
  9.     [Native code: 1054]
  10.  
  11.     [Native message: UNKNOWN COLUMN 'last_modified' IN 'where clause']
Add Comment
Please, Sign In to add comment