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!
RE: Problems Running: RAILS_ENV=production rake db:migrate - Added by John Smith almost 12 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 12 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 almost 12 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.
RE: Problems Running: RAILS_ENV=production rake db:migrate - Added by Andrew Perry about 10 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 10 years ago
The solution is easy :-), you should leave a space between the password tag and your password in config/database.yml file.