[OSM-dev] Error when running rake db:migrate

[Tom Hughes]

In message <37d514850708021518t2c89dd71k70878b76ff3a48a at mail.gmail.com>
          "Dan Karran" <dan at karran.net> wrote:

> I'm trying to update my dev sandbox to the latest db schema but I'm
> getting errors in the 002 update to do with duplicate primary ids
> being defined... am I doing something wrong, or missed a step
> somewhere?
> 
> -- add_primary_key("current_nodes", ["id"])
> rake aborted!
> Mysql::Error: Multiple primary key defined: ALTER TABLE current_nodes
> ADD PRIMARY KEY (`id`)

Do you somehow already have a primary key on current_nodes? You shouldn't
have as the previous schema version did not include one.

What does "show indexes for current_nodes" report?

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/