I had the same problem. MySQL can't handle a default on a text column. I
replaced
change_column "comments", "comment", :text, :default => ""
with
remove_column "comments", "comment"
add_column "comments", "comment", :text
and everything worked fine (including the self.down -- the default for the
string column causes no problem).
Regards,
Stan
On Thu, Sep 4, 2008 at 1:25 PM, simon <[EMAIL PROTECTED]> wrote:
>
>
> On 4 Sep., 20:34, "Bruno Bornsztein" <[EMAIL PROTECTED]>
> wrote:
> > What version of MySQL are you using? I don't get this error on 5.0.
> > Thanks,
> > Bruno
>
> MySQL 5.0.67-community-nt
>
> and the tables use the InnoDB backend if that makes any difference.
> (and latin1 charset so i have to recreate the whole DB with utf8 but
> thats another story)
>
> cheers
>
> Simon
> >
>
--
Warm Regards,
Stan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CommunityEngine" 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/communityengine?hl=en
-~----------~----~----~----~------~----~------~--~---
