# sqlite 3 error **URL:** \ **Category:** rubyonrails-talk\ **Created:** [June 27, 2011, 7:17am UTC](https://discuss.rubyonrails.org/t/sqlite-3-error/59615 "2011-06-27T07:17:28Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Amrit\_Pal\_Pathak](https://avatars.discourse-cdn.com/v4/letter/a/6f9a4e/32.png) [@Amrit\_Pal\_Pathak](https://discuss.rubyonrails.org/u/Amrit_Pal_Pathak)\ **Post date:** [June 27, 2011, 7:17am UTC](https://discuss.rubyonrails.org/t/sqlite-3-error/59615/1 "2011-06-27T07:17:28Z")
I have installed Ruby on Rails . rails -v=\>3.0.7 gem -v=\>1.3.6 ruby -v=\>ruby 1.8.7 (2010-01-10 patchlevel 249) [i486-linux] when i tried to start the server by “rails s” or tried to do anything it gives the error Could not find gem ‘sqlite3 (\>= 0, runtime)’ in any of the gem sources listed in your Gemfile. Run `bundle install` to install missing gems. Please somebody help me to get rid of it…😛 Thanks in advance [amritpalpathakgne.wordpress.com](http://amritpalpathakgne.wordpress.com) ---
**Author:** ![Kevin2](https://avatars.discourse-cdn.com/v4/letter/k/bcef8e/32.png) [@Kevin2](https://discuss.rubyonrails.org/u/Kevin2)\ **Post date:** [June 27, 2011, 8:16am UTC](https://discuss.rubyonrails.org/t/sqlite-3-error/59615/2 "2011-06-27T08:16:06Z")
Hi, first you need to install sqlite3. In Ubuntu: sudo apt-get install libsqlite3-dev Second install the sqlite gem gem install sqlite3-ruby see here for example [installation - Rails 3 can not find sqlite3-ruby - Stack Overflow](http://stackoverflow.com/questions/2305920/rails-3-can-not-find-sqlite3-ruby) I am not sure if rails 3 works with ruby 1.8.7 but I would recommend you to switch to version 1.9.2 anyway ---
**Author:** ![Chirag](https://avatars.discourse-cdn.com/v4/letter/c/ecccb3/32.png) [@Chirag](https://discuss.rubyonrails.org/u/Chirag)\ **Post date:** [June 27, 2011, 8:33am UTC](https://discuss.rubyonrails.org/t/sqlite-3-error/59615/3 "2011-06-27T08:33:40Z")
Do, what it says… run ‘bundle install’ on your app. Or manually install sqlite3 gem ---
**Author:** ![Amrit\_Pal\_Pathak](https://avatars.discourse-cdn.com/v4/letter/a/6f9a4e/32.png) [@Amrit\_Pal\_Pathak](https://discuss.rubyonrails.org/u/Amrit_Pal_Pathak)\ **Post date:** [June 27, 2011, 4:26pm UTC](https://discuss.rubyonrails.org/t/sqlite-3-error/59615/4 "2011-06-27T16:26:59Z")
I tried “bundle install” from app.I couldn’t work too.error persists. thanks ---
**Author:** ![Saikiran\_Mothe](https://avatars.discourse-cdn.com/v4/letter/s/bcef8e/32.png) [@Saikiran\_Mothe](https://discuss.rubyonrails.org/u/Saikiran_Mothe)\ **Post date:** [June 27, 2011, 4:37pm UTC](https://discuss.rubyonrails.org/t/sqlite-3-error/59615/5 "2011-06-27T16:37:51Z")
Hi, try gem install sqlite3, or try this mysql db rails my\_new\_app --database=mysql Cheers, Sai ---
**Author:** ![tekniklr](https://sea2.discourse-cdn.com/rubyonrails/user_avatar/discuss.rubyonrails.org/tekniklr/32/11533_2.png) [@tekniklr](https://discuss.rubyonrails.org/u/tekniklr)\ **Post date:** [June 27, 2011, 5:24pm UTC](https://discuss.rubyonrails.org/t/sqlite-3-error/59615/6 "2011-06-27T17:24:16Z")
Rails 3 and even 3.1.0rc4 work fine with ruby 1.8.7. Make sure the place you will eventually deploy to supports Ruby 1.9.2 before switching. I just had to downgrade to deploy to Dreamhost because their passenger won't work with anything but 1.8.7. ---
**Author:** ![Amrit\_Pal\_Pathak](https://avatars.discourse-cdn.com/v4/letter/a/6f9a4e/32.png) [@Amrit\_Pal\_Pathak](https://discuss.rubyonrails.org/u/Amrit_Pal_Pathak)\ **Post date:** [June 27, 2011, 5:26pm UTC](https://discuss.rubyonrails.org/t/sqlite-3-error/59615/7 "2011-06-27T17:26:12Z")
Thank you very much. one thing left .now i can start old rail app but it gives the error of rake when i did “rake db:create” rake aborted! You have already activated rake 0.9.2, but your Gemfile requires rake 0.8.7. Consider using bundle exec. (See full trace by running task with --trace) thanks ---
**Author:** ![Kevin2](https://avatars.discourse-cdn.com/v4/letter/k/bcef8e/32.png) [@Kevin2](https://discuss.rubyonrails.org/u/Kevin2)\ **Post date:** [June 27, 2011, 9:49pm UTC](https://discuss.rubyonrails.org/t/sqlite-3-error/59615/8 "2011-06-27T21:49:43Z")
Teri you are right, ruby 1.8.7 works fine. You can check with "gem list" which gems are installed. Probably you have a newer version installed (0.9.2) as required in your Gemfile (0.8.7). So try running "bundle exec rake" instead of just rake. See here for example: [Confused with rake error in Rails 3 - Stack Overflow](http://stackoverflow.com/questions/6205377/confused-with-rake-error-in-rails-3) I encourage you to use the ruby version manager. It enables you to switch between different gem sets really easy and you can install different gem versions for different projects.