Databases
StackOverflow2013
Postsdbo
POCan't make sqlite3 work on Ruby on Rails
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCan't make sqlite3 work on Ruby on Rails
    primarykey
    data
    text
    <p>I just installed ruby on my windows 7 computer. I installed rails and sqlite3 with the gem. I then made my app work on local BUT I still seem to have problems with sqlite3. When I try this:</p> <pre><code>rake db:create </code></pre> <p>the only thing i get is an error:</p> <pre><code>Please install the sqlite3 adapter: "gem install activerecord-sqlite3-adapter" (sqlite3 is not part of the bundle. Add it to the GemFile). </code></pre> <p>I've been doing some digging here and there, and I could make this error go away adding this line to my GemFile:</p> <pre><code>gem "sqlite3", group: :sqlite3 </code></pre> <p>And i got a new error:</p> <pre><code>no driver for sqlite3 found </code></pre> <p>I tried the 'bundle' command and I have both sqlite3 and sqlite3-ruby, I reinstalled everything but the problem won't go away. This is my gemFile, I hope it helps:</p> <pre><code>source 'https://rubygems.org' gem 'rails', '3.2.12' # Bundle edge Rails instead: # gem 'rails', :git =&gt; 'git://github.com/rails/rails.git' #I tried this too, but nothig changes #gem 'sqlite3-ruby', :require =&gt; 'sqlite3' gem 'sqlite3-ruby', '1.2.5', :require =&gt; 'sqlite3' gem "sqlite3", group: :sqlite3 # Gems used only for assets and not required # in production environments by default. group :assets do gem 'sass-rails', '~&gt; 3.2.3' gem 'coffee-rails', '~&gt; 3.2.1' # See https://github.com/sstephenson/execjs#readme for more supported runtimes # gem 'therubyracer', :platforms =&gt; :ruby gem 'uglifier', '&gt;= 1.0.3' end gem 'jquery-rails' </code></pre> <p>I really don't know what to do. It's kind of frustrating, it seems like something is not (obviously) properly working with sqlite3, because fixing one error leads to a new error. How can I possibly fix this problem ?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USG4bri3l
    1. USG4bri3l
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COHave you tried just `gem 'sqlite3'`? And I assume you've run `bundle install`...?
      singulars
      1. POCan't make sqlite3 work on Ruby on Rails
      1. USChowlett
    2. COYeah, if I keep the "gem 'sqlite3' " it says that it cannot load sqlite3/sqlite3_native files, that's why I changed it, and yes I ran the bundle install ... Using rdoc (3.12.2) Using thor (0.17.0) Using railties (3.2.12) Using coffee-rails (3.2.2) Using jquery-rails (2.2.1) Using rails (3.2.12) Using sass (3.2.7) Using sass-rails (3.2.6) Using sqlite3 (1.3.7) Using sqlite3-ruby (1.3.3) Using uglifier (1.3.0) Your bundle is complete! Use `bundle show [gemname]` to see where a bundled gem is installed. Here it is!
      singulars
      1. POCan't make sqlite3 work on Ruby on Rails
      1. USG4bri3l
    3. COIs sqlite3 installed in your system?
      singulars
      1. POCan't make sqlite3 work on Ruby on Rails
      1. USPigueiras
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload