Problems Running: RAILS_ENV=production rake db:migrate
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!
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 over 10 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 10 years ago
+1We'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.
Complex passwords with symbols tend to cause problems, so definitely suggest quoting " " the password.
The solution is easy :-), you should leave a space between the password tag and your password in config/database.yml file.