mysql --version
mysql Ver 14.12 Distrib 5.0.20a, for apple-darwin8.5.1 (i686) using
readline 5.0
on a Mac of course.
Pat.
On Sep 18, 2007, at 9:30 AM, John Mettraux wrote:
>
> 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
-~----------~----~----~----~------~----~------~--~---
