Archive insert fails with 'unknown column'

[Nic Laschinger]

Hi guys,

after much googling, I still am unclear why this is occurring:

I am trying to archive off old data to an exact copy of the database, the INSERT INTO statement works on one table but fails on another with a "1054: uniqueid column unknown" error.

I am running 5.5, and as i said the tables are exact copies of each other.

Query:

INSERT INTO `archive`.`call` (SELECT * FROM `bill`.`call` WHERE `starttime` < DATE_SUB(DATE(NOW()), INTERVAL 270 DAY));

Hope someone can shed some light.