Here''s the message I get when I try to start a development environment?: Loading development environment. D:/INSTAN~1/ruby/lib/ruby/1.8/yaml.rb:133:in ''load'':ArgumentError: syntax error on line 18, col 2: '' host: localhost''>>Recently had some MySQL problems and now I get a 500 error on http://localhost:3000/ No idea what blew up. Had been very stable until yesterday. Any ideas would be appreciated. --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Sat, 13 Oct 2007 13:40:22 -0700, MrLipid wrote:> Loading development environment. > D:/INSTAN~1/ruby/lib/ruby/1.8/yaml.rb:133:in ''load'':ArgumentError: > syntax error on line 18, col 2: '' host: localhost'' >>>What''s on the line before it? If that doesn''t help, post the whole database.yml file (mask out any passwords of course). -- Jay Levitt | Boston, MA | My character doesn''t like it when they Faster: jay at jay dot fm | cry or shout or hit. http://www.jay.fm | - Kristoffer --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Oct 13, 3:48 pm, Jay Levitt <jay+n...-WxwZQdyI2t0@public.gmane.org> wrote:> On Sat, 13 Oct 2007 13:40:22 -0700, MrLipid wrote: > > Loading development environment. > > D:/INSTAN~1/ruby/lib/ruby/1.8/yaml.rb:133:in ''load'':ArgumentError: > > syntax error on line 18, col 2: '' host: localhost'' > > What''s on the line before it? If that doesn''t help, post the whole > database.yml file (mask out any passwords of course). > > -- > Jay Levitt | > Boston, MA | My character doesn''t like it when they > Faster: jay at jay dot fm | cry or shout or hit.http://www.jay.fm | - Kristoffer# MySQL (default setup). Versions 4.1 and 5.0 are recommended. # # Install the MySQL driver: # gem install mysql # On MacOS X: # gem install mysql -- --include=/usr/local/lib # On Windows: # gem install mysql # Choose the win32 build. # Install MySQL and put its /bin directory on your path. # # And be sure to use new-style password hashing: # http://dev.mysql.com/doc/refman/5.0/en/old-client.html development: adapter: mysql database: VCBeta2_development username: root password: host: localhost # Warning: The database defined as ''test'' will be erased and # re-generated from your development database when you run ''rake''. # Do not set this db to the same as development or production. test: adapter: mysql database: VCBeta2_test username: root password: host: localhost production: adapter: mysql database: VCBeta2_production username: root password: host: localhost --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Sat, 13 Oct 2007 13:52:59 -0700, MrLipid wrote:> On Oct 13, 3:48 pm, Jay Levitt <jay+n...-WxwZQdyI2t0@public.gmane.org> wrote: >> On Sat, 13 Oct 2007 13:40:22 -0700, MrLipid wrote: >>> Loading development environment. >>> D:/INSTAN~1/ruby/lib/ruby/1.8/yaml.rb:133:in ''load'':ArgumentError: >>> syntax error on line 18, col 2: '' host: localhost'' >> >> What''s on the line before it? If that doesn''t help, post the whole >> database.yml file (mask out any passwords of course).Is the "password:" line really blank, or did you just remove the password? It looks like that''s actually the line that''s giving it trouble. Make sure there are no tabs where there should be spaces, and that there''s no whitespace at the end of the line; I don''t know if either is *supposed* to matter to YAML, but Ruby and tabs can do weird things on Windows. Try switching the order of the password: and username: lines, and see if the error now lists username instead of host. And (assuming the passwords are the same or really blank) try swapping two of the password: lines, or retyping the line from scratch. Look at the file in a hex editor and see if there''s anything weird with line endings (CRLF vs LF). -- Jay Levitt | Boston, MA | My character doesn''t like it when they Faster: jay at jay dot fm | cry or shout or hit. http://www.jay.fm | - Kristoffer --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
You solved it! Genius! It was a missing white space. Things seem fine again. Thanks! --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---