Error: Missing query string MariaDB NodeJS

Question

I have this error every time I try to run a query to DB:

Error: Missing query string

I don't understand what could be wrong with my code, the query is correct I have tested it:

function getChannelCTSize(octopusMac, channelID, adcTicks, callback){
    var queryString = "SELECT Channels.CT_size FROM Channels INNER JOIN Octopus ON Octopus.Id=Channels.Octopus_Id WHERE Octopus.Mac = ? AND Channels.Channel_Id = ?";
    var filter = [octopusMac, channelID];

    var query = mariaDB.query({
        sql: queryString
    }, filter );

    query.on('error', function(err) {
        if (err) {
            console.log(err.code);
            return
        }
    })
        .on('result', function(row) {
            callback(result[0].CT_size, channelID, octopusMac, adcTicks);
        })
        .on('end', function() {
            mariaDB.release();
        });
}

what should the filter do? Just return entries with octopusMac like the value you gave to the method? — Tobias Lins
– Tobias Lins, Commented Mar 13, 2017 at 14:36

Tobias Lins · Accepted Answer · 2017-03-13 14:49:39Z

1

The query function of mariasql should be invoked with a string as first argument (the query) instead of an object)

It should look like:

var queryString = "SELECT Channels.CT_size FROM Channels INNER JOIN Octopus ON Octopus.Id=Channels.Octopus_Id WHERE Octopus.Mac = :octopusMac AND Channels.Channel_Id = :channelID";

var query = mariaDB.query(queryString, { octopusMac, channelID }, function(err, rows) {
  if (err)
    console.log(err.code);

  callback(rows[0].CT_size, channelID, octopusMac, adcTicks);
})

edited Mar 13, 2017 at 14:49

answered Mar 13, 2017 at 14:36

Tobias Lins

2,65121 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

0xtuytuy Over a year ago

I have tried this but the code never returns any err

Jeremy Pridemore Over a year ago

The second argument in your example has a typo on syntax. It should be an array. An object works too if you prepare the statement with :octopusMac or whatever name in there.

Collectives™ on Stack Overflow

Error: Missing query string MariaDB NodeJS

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related