Error: Wrong number of values to escape

[bbigras]

I got "Error: Wrong number of values to escape" while trying to run the following code. Am I missing something?

var mysql = require('db-mysql');
new mysql.Database({
  hostname: 'localhost',
  user: 'user',
  password: 'password',
  database: 'database'
}).connect(function(error) {
  if (error) {
    return console.log("CONNECTION ERROR: " + error);
  } else {

    this.query().execute("INSERT INTO test (`test`) VALUES ('?');", ['test value'], function(error, rows) {
      if (error) {
        console.log(error);
      } else {
        console.log("ok");
      }
    });
  }
});

[mariano]

Yup, you have the placemark between quotes, which means is considered part of the string for node-db. You need to remove the quotes. Like so:

this.query().execute("INSERT INTO test (`test`) VALUES (?);", ['test value'], function() { ... });

[bbigras]

Thanks. Sorry for the noise.

[mariano]

No issues

[bbigras]

It's weird, I still have the problem when removing the quotes around the placemark.

/home/bbigras/project/app3.js:12
  this.query().execute("INSERT INTO test (test) VALUES (?);", ['test value'],
               ^
Error: Wrong number of values to escape
    at [object Object].<anonymous> (/home/bbigras/project/app3.js:12:16)

.

var mysql = require('db-mysql');
new mysql.Database({
  hostname: 'localhost',
  user: 'user',
  password: 'password',
  database: 'database'
}).connect(function(error) {
  if (error) {
    return console.log("CONNECTION ERROR: " + error);
  }

  this.query().execute("INSERT INTO test (`test`) VALUES (?);", ['test value'], function(error, rows) {
    if (error) {
      console.log("err", error);
    } else {
      console.log("ok");
    }
  });
});

[mariano]

Yup, now I get it, and that is a bug. Working on a fix.

[bbigras]

Thanks!