Using dm-is-state_machine causes invalid SQL syntax error
Reported by Bryan Ray | July 18th, 2008 @ 06:08 PM
Simply including the dm-is-state_machine plugin and then declaring an is :state_machine reference in a model will render this error when you run "rake dm:db:automigrate":
~ 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 'new, `post_id` INT(11), PRIMARY KEY(`id`)) ENGINE = InnoDB CHARACTER SET utf8 CO' at line 1
rake aborted!
Comments and changes to this ticket
-
Bernerd Schaefer July 22nd, 2008 @ 12:36 PM
- State changed from “new” to “resolved”
Thanks for finding this, Bryan. It had to do with the :initial value being a symbol, and getting passed to mysql without quotes.
As of 22ddfae, dm-is-state_machine calls to_s on the initial value passed in. If you are on the gem, then you should just need to change :initial => :new to :initial => "new".
-
Please Sign in or create a free account to add a new ticket.
With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
Rick