{"id":7313,"date":"2014-06-07T02:24:22","date_gmt":"2014-06-07T02:24:22","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/06\/07\/how-do-i-install-rubys-sqlite3-extension-on-windows-collection-of-common-programming-errors\/"},"modified":"2014-06-07T02:24:22","modified_gmt":"2014-06-07T02:24:22","slug":"how-do-i-install-rubys-sqlite3-extension-on-windows-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/06\/07\/how-do-i-install-rubys-sqlite3-extension-on-windows-collection-of-common-programming-errors\/","title":{"rendered":"How do I install Ruby&#39;s SQLite3 extension on Windows?-Collection of common programming errors"},"content":{"rendered":"<p>This is the first time I am running Ruby on Rails.<\/p>\n<p>When running the &#8220;<em>blog<\/em>&#8221; application I got the message &#8220;We&#8217;re sorry, but something went wrong. We&#8217;ve been notified about this issue and we&#8217;ll take a look at it shortly.&#8221;<\/p>\n<p>Then I checked the CODE\\blog\\log\\development.log and got this:<\/p>\n<pre><code>\/!\\ FAILSAFE \/!\\  Tue Jun 30 15:22:55 +0100 2009\n Status: 500 Internal Server Error\n no such file to load -- sqlite3\n   c:\/ruby\/lib\/ruby\/site_ruby\/1.8\/rubygems\/custom_require.rb:31:in\n`gem_original_require'\n   c:\/ruby\/lib\/ruby\/site_ruby\/1.8\/rubygems\/custom_require.rb:31:in\n`require'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activesupport-2.3.2\/lib\/\nactive_support\/dependencies.rb:156:in `require'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activesupport-2.3.2\/lib\/\nactive_support\/dependencies.rb:521:in `new_constants_in'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activesupport-2.3.2\/lib\/\nactive_support\/dependencies.rb:156:in `require'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activesupport-2.3.2\/lib\/\nactive_support\/core_ext\/kernel\/requires.rb:7:in\n`require_library_or_gem'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activesupport-2.3.2\/lib\/\nactive_support\/core_ext\/kernel\/reporting.rb:11:in `silence_warnings'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activesupport-2.3.2\/lib\/\nactive_support\/core_ext\/kernel\/requires.rb:5:in\n`require_library_or_gem'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/sqlite3_adapter.rb:10:in\n`sqlite3_connection'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/abstract\/connection_pool.rb:223:in\n`send'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/abstract\/connection_pool.rb:223:in\n`new_connection'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/abstract\/connection_pool.rb:245:in\n`checkout_new_connection'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/abstract\/connection_pool.rb:188:in\n`checkout'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/abstract\/connection_pool.rb:184:in\n`loop'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/abstract\/connection_pool.rb:184:in\n`checkout'\n   c:\/ruby\/lib\/ruby\/1.8\/monitor.rb:242:in `synchronize'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/abstract\/connection_pool.rb:183:in\n`checkout'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/abstract\/connection_pool.rb:98:in\n`connection'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/abstract\/connection_pool.rb:326:in\n`retrieve_connection'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/abstract\/connection_specification.rb:\n123:in `retrieve_connection'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/abstract\/connection_specification.rb:\n115:in `connection'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/query_cache.rb:9:in `cache'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/query_cache.rb:28:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/activerecord-2.3.2\/lib\/\nactive_record\/connection_adapters\/abstract\/connection_pool.rb:361:in\n`call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/vendor\/rack-1.0\/rack\/head.rb:9:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/vendor\/rack-1.0\/rack\/methodoverride.rb:24:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/params_parser.rb:15:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/rewindable_input.rb:25:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/session\/cookie_store.rb:93:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/reloader.rb:9:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/failsafe.rb:11:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/vendor\/rack-1.0\/rack\/lock.rb:11:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/vendor\/rack-1.0\/rack\/lock.rb:11:in `synchronize'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/vendor\/rack-1.0\/rack\/lock.rb:11:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/dispatcher.rb:106:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/rails-2.3.2\/lib\/rails\/rack\/\nstatic.rb:31:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/vendor\/rack-1.0\/rack\/urlmap.rb:46:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/vendor\/rack-1.0\/rack\/urlmap.rb:40:in `each'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/vendor\/rack-1.0\/rack\/urlmap.rb:40:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/rails-2.3.2\/lib\/rails\/rack\/\nlog_tailer.rb:17:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/vendor\/rack-1.0\/rack\/content_length.rb:13:in `call'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/vendor\/rack-1.0\/rack\/handler\/webrick.rb:46:in\n`service'\n   c:\/ruby\/lib\/ruby\/1.8\/webrick\/httpserver.rb:104:in `service'\n   c:\/ruby\/lib\/ruby\/1.8\/webrick\/httpserver.rb:65:in `run'\n   c:\/ruby\/lib\/ruby\/1.8\/webrick\/server.rb:173:in `start_thread'\n   c:\/ruby\/lib\/ruby\/1.8\/webrick\/server.rb:162:in `start'\n   c:\/ruby\/lib\/ruby\/1.8\/webrick\/server.rb:162:in `start_thread'\n   c:\/ruby\/lib\/ruby\/1.8\/webrick\/server.rb:95:in `start'\n   c:\/ruby\/lib\/ruby\/1.8\/webrick\/server.rb:92:in `each'\n   c:\/ruby\/lib\/ruby\/1.8\/webrick\/server.rb:92:in `start'\n   c:\/ruby\/lib\/ruby\/1.8\/webrick\/server.rb:23:in `start'\n   c:\/ruby\/lib\/ruby\/1.8\/webrick\/server.rb:82:in `start'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/actionpack-2.3.2\/lib\/\naction_controller\/vendor\/rack-1.0\/rack\/handler\/webrick.rb:13:in `run'\n   c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/rails-2.3.2\/lib\/commands\/server.rb:\n111\n   c:\/ruby\/lib\/ruby\/site_ruby\/1.8\/rubygems\/custom_require.rb:31:in\n`gem_original_require'\n   c:\/ruby\/lib\/ruby\/site_ruby\/1.8\/rubygems\/custom_require.rb:31:in\n`require'\n   script\/server:3\n<\/code><\/pre>\n<p>I have already tried:<\/p>\n<pre><code>gem install sqlite3\n<\/code><\/pre>\n<p>And got this response.<\/p>\n<pre><code>ERROR:  could not find gem sqlite3 locally or in a repository\n<\/code><\/pre>\n<p>I also tried:<\/p>\n<pre><code>gem install sqlite3-ruby\n<\/code><\/pre>\n<p>And got this response.<\/p>\n<pre><code>Building native extensions.  This could take a while...\nERROR:  Error installing sqlite3-ruby:\n       ERROR: Failed to build gem native extension.\n\nc:\/ruby\/bin\/ruby.exe extconf.rb\nchecking for fdatasync() in rt.lib... no\nchecking for sqlite3.h... no\n\nnmake\n'nmake' is not recognized as an internal or external command,\noperable program or batch file.\n\nGem files will remain installed in c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/\nsqlite3-ruby-1\n.2.4 for inspection.\nResults logged to c:\/ruby\/lib\/ruby\/gems\/1.8\/gems\/sqlite3-ruby-1.2.4\/\next\/sqlite3_\napi\/gem_make.out\n<\/code><\/pre>\n<p>I am running Windows XP with XAMPP (Apache + MySQL + PHP).<\/p>\n<p>How can I solve this?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the first time I am running Ruby on Rails. When running the &#8220;blog&#8221; application I got the message &#8220;We&#8217;re sorry, but something went wrong. We&#8217;ve been notified about this issue and we&#8217;ll take a look at it shortly.&#8221; Then I checked the CODE\\blog\\log\\development.log and got this: \/!\\ FAILSAFE \/!\\ Tue Jun 30 15:22:55 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7313","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/7313","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=7313"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/7313\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=7313"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=7313"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=7313"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}