Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Could NOT populate cach FOR person::
- MDB2 Error: no such FIELD
- _doQuery: [Error message: Could NOT EXECUTE statement]
- [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`)]
- [Native code: 1054]
- [Native message: UNKNOWN COLUMN 'last_modified' IN 'where clause']
Add Comment
Please, Sign In to add comment