Problem with "rake db:migrate"

OpenStreetMap Questions and Answers
#1

Hi,

i will setup a rails_port. but it failds.

I have opensuse 11.0 with “Mysql Ver 5.0.51a for suse-linux-gnu on x86_64 (SUSE MySQL RPM)”.

rake db:migrate faild with:
== ChangeUserLocale: migrating ===============================================
– remove_foreign_key(:users, [:locale], :languages, [:code])
rake aborted!
An error has occurred, all later migrations canceled:

Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘CONSTRAINT users_locale_fkey’ at line 1: ALTER TABLE users DROP CONSTRAINT users_locale_fkey

(See full trace by running task with --trace)

regards kita

#2

Hi,
I also have this problem with MySQL (using Ubuntu). I think the problem is that it tries to remove a foreign key that does not exist (and MySQLs error message is not very informative).
I guess this is a bug in the rails port, which show up in MySQL but not in Postgre?

regards David