Here are two links that explain that you need to be careful on decimal columns when using mysql on the target platform. sqlite3 is a little more forgiving.
http://scottmotte.com/archives/86.html http://blog.coryfoy.com/2008/06/problems-in-rails-between-development-and-test-databases/ I sorted my problem out by running: rake RAILS_ENV=staging db:drop rake RAILS_ENV=staging db:create rake RAILS_ENV=staging db:migrate I am sure that I did this ......... but it could have been very late! So in a nutshell, use a scale and precision on decimal if you intend your target dbms to be mysql. O. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en.

