node.js – Weebtech

May 20, 2016May 29, 2016 Chris Grimmettjavascript, mocha, node.js, swaggerLeave a Comment

swagger project test shows [SyntaxError: Unexpected identifier]

I’ve been working with Swagger to make an API server. With it, I created https://myopenbazaar.top. Pretty cool software, but I found testing with it pretty confusing. Swagger abstracts away mochajs, and for whatever reason, Swagger was hiding a stack trace […]

Continue reading ➞

August 31, 2013August 21, 2014 Chris Grimmettbinet, bitcoin, botnet, brainstorming, development, ideas, javascript, json, LOIC, node.js, programming, progress, project, server side, toolsLeave a Comment

Bitnet Project

I’m working on what I’m calling a bitnet. In a nutshell, it is a project to monitor and manage crypto currency mining on several remote computers I have at my disposal. There are other projects out there that do this […]

Continue reading ➞

August 27, 2013September 24, 2019 Chris Grimmettdatabase, error, fix, javascript, node, node-sqlite3, node.js, sqliteLeave a Comment

node.js node-sqlite3 error

I got this wonderful error when setting up CRUD functions on a little node project I’m working on: { [Error: SQLITE_RANGE: bind or column index out of range] errno: 25, code: 'SQLITE_RANGE' } Here is the code that caused the error:

var row_update = function(index, name, password, comment, callback) {

var update = db.prepare("UPDATE workers SET name = '?', password = '?', comment = '?' WHERE id = '?'");

update.run(name, password, comment, index, function(err) {
if (err) {
console.log(err);
callback(err);

} else {
callback(0);
}
});
}

var row_update = function(index, name, password, comment, callback) {

var update = db.prepare("UPDATE workers SET name = '?', password = '?', comment = '?' WHERE id = '?'");

update.run(name, password, comment, index, function(err) {

if (err) {

console.log(err);

callback(err);

} else {

callback(0);

}

});

}

The problem here is that I enclosed the question mark placeholders in […]

Continue reading ➞