Problems Running: RAILS_ENV=production rake db:migrate

Added by John Smith almost 8 years ago

Hello,

I am trying to run the command

RAILS_ENV=production rake db:migrate

through SSH but I get an error of

rake aborted!
syntax error on line 8, col 10: `  encoding: utf8'

I am running Ruby 1.8.7 and Rails 2.3.5, I did have Ruby 1.8.4 but upgraded to 1.8.7 so I'm not sure if I need to start the whole installation process all over again or that won't be needed.

Any help would be appreciated!

Replies (5)

RE: Problems Running: RAILS_ENV=production rake db:migrate - Added by John Smith almost 8 years ago

In case anyone has this problem in the future, after many hours I realized my password had a ; in it which was causing the problem.

RE: Problems Running: RAILS_ENV=production rake db:migrate - Added by Felix Schäfer almost 8 years ago

I think you'd need to put the password in double quotes " " in the database.yml file.

RE: Problems Running: RAILS_ENV=production rake db:migrate - Added by Amil Waduwawara over 7 years ago

+1

We're using Redmine 0.9.2 with following plugins with a MySQL back-end:
  • Redmine Issues Group v0.1.7 (by Andrew Chaika)
  • Timesheet v0.5.0 (by Eric Davis)

I tried an upgrade with our existing database, but it gave so many (MySQL) failures during database upgrade (rake db:migrate RAILS_ENV=production). After so many hours searching on the Internet and chatting on IRC, Marco123 on IRC informed about a script on http://www.redmine.org/boards/3/topics/4701#message-14933. I tried it and database upgrade was successful.

This is extracted from my comment on Redmine Wiki as Eric Davis suggested after correcting some mistakes.

RE: Problems Running: RAILS_ENV=production rake db:migrate - Added by Andrew Perry about 6 years ago

Complex passwords with symbols tend to cause problems, so definitely suggest quoting " " the password.

RE: Problems Running: RAILS_ENV=production rake db:migrate - Added by Volkan Evrin almost 6 years ago

The solution is easy :-), you should leave a space between the password tag and your password in config/database.yml file.

(1-5/5)