SQL error when migrating in production

[sylario]

I am using rails 3.0.3 with MySQL Ver 14.14 Distrib 5.1.41

At migration i have the following error :
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 '' at line 1: ALTER TABLE carts ADD status enum

How can i solve it?

[jeffp]

Hi

Instead of using t.enum in your migration, try using t.string to declare the
enumerated attribute db field.

Cheers,
J

On Fri, Sep 16, 2011 at 3:35 AM, sylario <
[email protected]>wrote:

I am using rails 3.0.3 with MySQL Ver 14.14 Distrib 5.1.41

At migration i have the following error :
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 ''
at line 1: ALTER TABLE carts ADD status enum

How can i solve it?

Reply to this email directly or view it on GitHub:
#34