Port database to EE - [Err] 1062 - Duplicate entry '0' for key 'PRIMARY'

Hi all,

I need to port a database from a old site with a schema different of EE has. I have a table homes and I want to insert each entry as a channel entry. I am trying to do run a query like this:

INSERT INTO exp_channel_data (site_id,channel_id,field_id_1) SELECT 1,1,summary FROM homes

But I get the following error:

[Err] 1062 - Duplicate entry ‘0’ for key ‘PRIMARY’

It has to be the exp_channel_data.entry_id that is not auto_increment but is it safe to edit it?

Thanks in advance