Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trialRohit Verma
4,198 Pointsgem install sqlite3 not working
i get the following out put in cmd (Windows):
Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\ABC>gem install sqlite3 Temporarily enhancing PATH to include DevKit... Building native extensions. This could take a while... ERROR: Error installing sqlite3: ERROR: Failed to build gem native extension.
C:/Ruby21-x64/bin/ruby.exe extconf.rb
checking for sqlite3.h... no sqlite3.h is missing. Install SQLite3 from http://www.sqlite.org/ first. *** extconf.rb failed *** Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration options.
Provided configuration options: --with-opt-dir --without-opt-dir --with-opt-include --without-opt-include=${opt-dir}/include --with-opt-lib --without-opt-lib=${opt-dir}/lib --with-make-prog --without-make-prog --srcdir=. --curdir --ruby=C:/Ruby21-x64/bin/ruby --with-sqlite3-dir --without-sqlite3-dir --with-sqlite3-include --without-sqlite3-include=${sqlite3-dir}/include --with-sqlite3-lib --without-sqlite3-lib=${sqlite3-dir}/lib
extconf failed, exit code 1
Gem files will remain installed in C:/Ruby21-x64/lib/ruby/gems/2.1.0/gems/sqlite 3-1.3.10 for inspection. Results logged to C:/Ruby21-x64/lib/ruby/gems/2.1.0/extensions/x64-mingw32/2.1.0 /sqlite3-1.3.10/gem_make.out
C:\Users\ABC>
2 Answers
Jason Goebel
4,351 PointsThat is how I fixed the stipulation.
1: Go to: www.sqlite.org/download.html
2: Download <a href="http://www.sqlite.org/2014/sqlite-shell-win32-x86-3080701.zip"> sqlite-shell-win32-x86-3080701.zip </a> and the <a href="http://www.sqlite.org/2014/sqlite-shell-win32-x86-3080701.zip"> sqlite-dll-win32-x86-3080701.zip </a> files under Precompiled Binaries for Windows. (versions may differ)
3: Extract both the files into the Ruby[ver]/bin directory. Ex. c:\Ruby21-x64\bin\
4: Now try again: gem install sqlite3
That should work.
OS: Windows 8.1
Nate Meyer
3,887 Pointschecking for sqlite3.h... no sqlite3.h is missing. Install SQLite3 from http://www.sqlite.org/ first.
Did you try what the error suggested and install SQLite before attempting to build the gem?
Rohit Verma
4,198 PointsI followed instructions on this page. http://mislav.uniqpath.com/rails/install-sqlite3/#windows
Now when i enter "gem install sqlite3" i get --> Done installing documentation after 0 seconds
Jason Goebel
4,351 PointsJason Goebel
4,351 PointsUPDATE: Changing this template will fix it for all servers you make...
OPEN (versions may vary)
\Ruby21-x64\lib\ruby\gems\2.1.0\gems\railties-4.1.6\lib\rails\generators\rails\app\templates\Gemfile file.
EDIT
platforms: [:mingw, :mswin]
to read
platforms: [:mingw, :mswin, :x64_mingw]
SAVE
this should fix
Ondrej Moravcik
15,223 PointsOndrej Moravcik
15,223 Pointsdoesn't work for me :-/