[OSM-dev] rake db:migrate error

[Tom Hughes]

On 07/10/09 12:49, Pallinger Péter wrote:

> I am new to (running) OSM, but would very like to use it in a project.
> However, I have the following error when running rake db:migrate (after some success
> messages for former tasks):
>
>
> ==  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

Use PostgreSQL not MySQL - the MySQL support is not really maintained 
anymore so it likely to be extremely fragile as you've just discovered.

Tom

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