search

dphuang2 / PoGoBag

Analyze and share your Pokémon through a locally run server! Official Site access has been stopped as of 12/23/2016
146 stars 49 forks source link

sqlite3: Cannot Load such file #20

Open vinsilsim opened 8 years ago

vinsilsim commented 8 years ago

Please anyone can help me?

http://prntscr.com/c3guas

How to solve?

JacobCohenIsrael commented 8 years ago

I solved this part but I have another issue

In my C:\Ruby23-x64\lib\ruby\gems\2.3.0\specifications I changed a file named sqlite3-1.3.11-x64-mingw32.gemspec It has a line where it defined as follows: s.require_paths = ["lib"] So I have changed it to s.require_paths = ["lib/sqlite3_native"]

But now I am stuck in

Could not load 'active_record/connection_adapters/sqlite3_adapter'. Make sure that the adapter in config/database.yml is valid. If you use an adapter other than 'mysql2', 'postgresql' or 'sqlite3' add the necessary adapter gem to the Gemfile.

vinsilsim commented 8 years ago

@JacobCohenIsrael same here!

K4N0 commented 8 years ago

I am also stuck at the same thing. It's an exact issue.

haitianboy420 commented 8 years ago

i am also stuck here

animekub commented 8 years ago

I am also stuck at this "rake db:setup" step

K4N0 commented 8 years ago

Can i use a WAMP Server to run this? Or is it completely different?

evilhawk00 commented 8 years ago

Problem already solved. Follow my directions in issue#1 should solve the problem https://github.com/dphuang2/PoGoBag/issues/1

JacobCohenIsrael commented 8 years ago

This solutions was brought by @evilhawk00

The way to solve sqlite_native load problem(Windows Platform):

Before this, make sure you've done the setup of Ruby DevKit. OKAY,Let's start! *you should have installed sqlite3 previously after you run gem install bundler , remove sqlite3, run gem uninstall sqlite3 first

1.Go to https://www.sqlite.org/download.html and download the following two files: source code: sqlite-amalgamation-3140000.zip Precompiled Binaries for Windows(x86 or x64): sqlite-dll-win32-x86-3140000.zip or sqlite-dll-win64-x64-3140000.zip

2.Let's extract the source code to C:\sqlite-amalgamation-3140000 , make sure this directory contains 4 files (shell.c, sqlite3.c, sqlite3.h, sqlite3ext.h) 3.Let's extract Precompiled Binaries to Ruby's Bin folder, In my case is C:\Ruby23-x64\bin, get the two files from the zip archive and place it into Ruby's Bin folder.

  1. Now install sqlite3, with the following command: With Windows CMD: gem install sqlite3 --platform=ruby -- --with-sqlite3-include="C:\sqlite-amalgamation-3140000" --with-sqlite3-lib="C:\Ruby23-x64\bin" OR With Mingw32 Terminal: gem install sqlite3 --platform=ruby -- --with-sqlite3-include=/C/sqlite-amalgamation-3140000/sqlite-amalgamation-3140000 --with-sqlite3-lib=/c/Ruby23-x64/bin

5.Now run the database setup again, you should not see any error rake db:setup

haitianboy420 commented 8 years ago

Thank you JacobCohenIsrael i can confirm that your steps worked for me

haitianboy420 commented 8 years ago

You must not have followed step by step because rake can't find sqlite

On Aug 11, 2016 3:38 PM, "TrixuEdits" notifications@github.com wrote:

So I did what JacobCohenIsrael said, but now I get this error:

c:\PoGoBag>rake db:setup rake aborted! LoadError: cannot load such file -- sqlite3/sqlite3_native c:/PoGoBag/config/application.rb:7:in <top (required)>' c:/PoGoBag/Rakefile:4:inrequire_relative' c:/PoGoBag/Rakefile:4:in <top (required)>' LoadError: cannot load such file -- sqlite3/2.3/sqlite3_native c:/PoGoBag/config/application.rb:7:in' c:/PoGoBag/Rakefile:4:in require_relative' c:/PoGoBag/Rakefile:4:in' (See full trace by running task with --trace)

Anyone know what this means? :(

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/dphuang2/PoGoBag/issues/20#issuecomment-239268249, or mute the thread https://github.com/notifications/unsubscribe-auth/ARCaGDXv-I_iWKp7EVL5CspZzN_yPnp1ks5qe3okgaJpZM4Jf8sR .

TrixuEdits commented 8 years ago

You must not have followed step by step because rake can't find sqlite

Yeah I forgot to uninstall the gem before installing it that way. But I fixed it and it is working now :)

Darkkaiba commented 8 years ago

Looks like yesterday sqlite3-amalgamation was updated to 3140100, tried using this but could get it to work...

D:\PKM>rake db:setup Could not find sqlite3-1.3.11-x86-mingw32 in any of the sources Run bundle install to install missing gems.

D:\PKM>gem install sqlite3 --platform=ruby -- --with-sqlite3-include=/d/sqlite-a malgamation-3140100 --with-sqlite3-lib=/d/Ruby23-x64/bin Temporarily enhancing PATH to include DevKit... Building native extensions with: '--with-sqlite3-include=/d/sqlite-amalgamation- 3140100 --with-sqlite3-lib=/d/Ruby23-x64/bin' This could take a while... ERROR: Error installing sqlite3: ERROR: Failed to build gem native extension.

current directory: D:/Ruby23/lib/ruby/gems/2.3.0/gems/sqlite3-1.3.11/ext/sql

ite3 D:/Ruby23/bin/ruby.exe -r ./siteconf20160812-10332-nj0brb.rb extconf.rb --with-s qlite3-include=/d/sqlite-amalgamation-3140100 --with-sqlite3-lib=/d/Ruby23-x64/b in 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=D:/Ruby23/bin/$(RUBY_BASE_NAME) --with-sqlite3-dir --without-sqlite3-dir --with-sqlite3-include=${sqlite3-dir}/include --with-sqlite3-lib=${sqlite3-dir}/lib

To see why this extension failed to compile, please check the mkmf.log which can be found here:

D:/Ruby23/lib/ruby/gems/2.3.0/extensions/x86-mingw32/2.3.0/sqlite3-1.3.11/mkmf .log

extconf failed, exit code 1

Gem files will remain installed in D:/Ruby23/lib/ruby/gems/2.3.0/gems/sqlite3-1. 3.11 for inspection. Results logged to D:/Ruby23/lib/ruby/gems/2.3.0/extensions/x86-mingw32/2.3.0/sql ite3-1.3.11/gem_make.out

D:\PKM>rake db:setup Could not find sqlite3-1.3.11-x86-mingw32 in any of the sources Run bundle install to install missing gems.

<

ghost commented 7 years ago

I'm having the same error that Darkkaiba is - except I'm on 3140200... please help!

evilhawk00 commented 7 years ago

@TheWhoDoctor I've made an auto installer can fix all your problem in one click, however I did not get the answer from the project owner if I can publish this redistribution

If you want it , go to this issue, write down your email, I'll send one copy to you https://github.com/dphuang2/PoGoBag/issues/77#issuecomment-248980921