talkingtab
commented
9 years ago Hi, I don't have a windows machine so I can't help specifically. The error appears to be because the sqlite3 module is not found. You can verify this by trying to run a file with only the line var sqlite3 = require('sqlite3');
If you run that and get the same error then the easiest way to attack it is to start in a new clean directory. There are compatibility issues between various versions of node and sqlite3. Node changes. Currently my stable configuration is to run the current v0.11.x version of node. So I would install that and make sure that is the version you have running by doing node --version
Next just do npm install sqlite3
Now create your test file with just the require line and see if it works.
Terry
On 11/13/14, 10:28 AM, sveinnM wrote:
Hi, I get an error trying to use sqlite3. I'm new to nodejs (my first project), so I started out installing the latest nodejs, which made me unable to install ( "npm install sqlite3" ) sqlite3 (got lots of errors), then after hours of googling I saw that the newest version of nodejs has bugs, so i downloaded older version (0.10.29). After that installing sqlite3 worked. So I made a test to see if it worked. Made a file sqlitee.js:
|var sqlite3 = require('sqlite3').verbose(); var db = new sqlite3.Database(':memory:');
db.serialize(function() {
db.run("CREATE TABLE lorem (info TEXT)"); var stmt = db.prepare("INSERT INTO lorem VALUES (?)"); for (var i = 0; i < 10; i++) { stmt.run("Ipsum " + i); } stmt.finalize(); db.each("SELECT rowid AS id, info FROM lorem", function(err, row) { console.log(row.id + ": " + row.info); });}); db.close(); |
When I then run "node sqlitee.js" i get:
module.js:340 throw err; ^ Error: Cannot find module 'C:\Users\Sveinn\Documents\HÍ\Haust 2014\Vefforritun\ Skilaverkefni 11\node_modules\sqlite3\lib\binding\node-v11-win32-ia32\node_sqlit e3.node' at Function.Module._resolveFilename (module.js:338:15) at Function.Module._load (module.js:280:25) at Module.require (module.js:364:17) at require (module.js:380:17) at Object. (C:\Users\Sveinn\Documents\HÍ\Haust 2014\Vefforritun\ Skilaverkefni 11\node_modules\sqlite3\lib\sqlite3.js:4:15) at Module._compile (module.js:456:26) at Object.Module._extensions..js (module.js:474:10) at Module.load (module.js:356:32) at Function.Module._load (module.js:312:12) at Module.require (module.js:364:17) I have v3.0.2 of sqlite3 installed. I really have been googling for 6 hours total now, and found nothing that works for me.
HELP ME PLEASE!
— Reply to this email directly or view it on GitHub https://github.com/mapbox/node-sqlite3/issues/364.
springmeyer
sveinnM
daiyam
silkentrance
robertd
Mithgol
wenlisu
mucahidyazar
ghost
lanceliamll
anadsonpassos
Hi, I get an error trying to use sqlite3. I'm new to nodejs (my first project), so I started out installing the latest nodejs, which made me unable to install ( "npm install sqlite3" ) sqlite3 (got lots of errors), then after hours of googling I saw that the newest version of nodejs has bugs, so i downloaded older version (0.10.29). After that installing sqlite3 worked. So I made a test to see if it worked. Made a file sqlitee.js:
When I then run "node sqlitee.js" i get:
I have v3.0.2 of sqlite3 installed. I really have been googling for 6 hours total now, and found nothing that works for me.
I am using Windows 8.
HELP ME PLEASE!