On 9/18/07, cappelaere <[EMAIL PROTECTED]> wrote:
>
> I ran the migration against mysql and I am getting this:
> == WorkitemInstances: migrating
> ===============================================
> -- create_table(:workitems)
> -> 0.0225s
> -- create_table(:fields)
> -> 0.0040s
> -- add_index(:fields, [:workitem_id, :key], {:unique=>true})
> rake aborted!
> Mysql::Error: You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the r
> ight syntax to use near 'key)' at line 1: CREATE UNIQUE INDEX
> fields_workitem_id_index ON fields (workitem_id, key)
>
> There is a name problem with using "key" in Field table. Works if you
> rename it to key_field...
Hi Pat,
which version of MySQL on which Plaftorm ?
Cheers,
--
John Mettraux -///- http://jmettraux.openwfe.org
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"OpenWFEru dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/openwferu-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
