I set up Rails from scratch using the methods on: http://rubyonrails.org/download and also: gem install sqlite3-ruby download sqlite3.dll into c:\ruby\bin change config/database.yml adapter lines for dev, test, prod all to sqlite3 so sqlite3 can be used now... but what if i also installed MySQL on c:\Program Files Is there an easy way to make Rails work with MySQL? if i use gem install mysql there will be lots of errors saying No definition for next_result ... -- Posted via http://www.ruby-forum.com/. -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Yes, gem install mysql is needed. But, I''m not sure what do you mean lots of errors. Maybe you should post your errors here. On Thu, May 13, 2010 at 16:59, Jian Lin <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> I set up Rails from scratch using the methods on: > > http://rubyonrails.org/download > > and also: > > gem install sqlite3-ruby > download sqlite3.dll into c:\ruby\bin > change config/database.yml adapter lines for dev, test, prod all to > sqlite3 > > so sqlite3 can be used now... > > but what if i also installed MySQL on c:\Program Files > > Is there an easy way to make Rails work with MySQL? > > if i use > > gem install mysql > > there will be lots of errors saying > > No definition for next_result > ... > -- > Posted via http://www.ruby-forum.com/. > > -- > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Jette Chan wrote:> Yes, gem install mysql is needed. > But, I''m not sure what do you mean lots of errors. > Maybe you should post your errors here.sure, a sample run is: C:\Software Projects\ror\shov6>gem install mysql Successfully installed mysql-2.8.1-x86-mingw32 1 gem installed Installing ri documentation for mysql-2.8.1-x86-mingw32... No definition for next_result No definition for field_name No definition for field_table No definition for field_def No definition for field_type No definition for field_length No definition for field_max_length No definition for field_flags No definition for field_decimals No definition for time_inspect No definition for time_to_s No definition for time_get_year No definition for time_get_month No definition for time_get_day No definition for time_get_hour No definition for time_get_minute No definition for time_get_second ... -- Posted via http://www.ruby-forum.com/. -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
OK. Now I know... I thought t you can see "1 gem installed" So, it means you''ve already finished install mysql gem now. And the following errors come from when installation the documentation. Actually you already can use this gem now. On Thu, May 13, 2010 at 17:41, Jian Lin <lists-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> Jette Chan wrote: > > Yes, gem install mysql is needed. > > But, I''m not sure what do you mean lots of errors. > > Maybe you should post your errors here. > > sure, a sample run is: > > C:\Software Projects\ror\shov6>gem install mysql > Successfully installed mysql-2.8.1-x86-mingw32 > 1 gem installed > Installing ri documentation for mysql-2.8.1-x86-mingw32... > > No definition for next_result > > No definition for field_name > > No definition for field_table > > No definition for field_def > > No definition for field_type > > No definition for field_length > > No definition for field_max_length > > No definition for field_flags > > No definition for field_decimals > > No definition for time_inspect > > No definition for time_to_s > > No definition for time_get_year > > No definition for time_get_month > > No definition for time_get_day > > No definition for time_get_hour > > No definition for time_get_minute > > No definition for time_get_second > ... > > > -- > Posted via http://www.ruby-forum.com/. > > -- > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org<rubyonrails-talk%2Bunsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org> > . > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. > >-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Jette Chan wrote:> OK. Now I know... > I thought t you can see "1 gem installed" > So, it means you''ve already finished install mysql gem now. > And the following errors come from when installation the documentation. > > Actually you already can use this gem now.but when i use http://localhost:3000 and click on the About your application’s environment the box will say error... right now MySQL is a command line app, does it need to be run as a background process? and i guess when i create the project, it is better to use rails myapp -d mysql ? -- Posted via http://www.ruby-forum.com/. -- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On May 13, 11:53 am, Jian Lin <li...-fsXkhYbjdPsEEoCn2XhGlw@public.gmane.org> wrote:> > but when i use > > http://localhost:3000 > > and click on the > > About your application’s environment > > the box will say error...What error ?> > right now MySQL is a command line app, does it need to be run as a > background process?When you installed mysql it should have installed some graphical utilities that you can use to start up the server process (it may have already started it for you). You''ll also need to edit your database.yml to refer to the instance of mysql on your machine (it may not be a bad idea to look at a rails app created with -d mysql if you''re not familiar with how this looks) Fred> > and i guess when i create the project, it is better to use > > rails myapp -d mysql > > ? > > -- > Posted viahttp://www.ruby-forum.com/. > > -- > 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. > For more options, visit this group athttp://groups.google.com/group/rubyonrails-talk?hl=en.-- 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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.