Error when deleting from mySQL in node.js

Question

I'm getting an error I don't understand when sending the parameters to my method, I thought my query was wrong but I did it manually and mySQL did what it had to do. So the problem is in my code but I don't seem to find where, thanks in advance.

exports.defav = function(id_user, id_restaurant, callback){

console.log(id_user + " " + id_restaurant); //Just making sure i'm reciving correclt
pool.getConnection(function(err, connection){
  if(err){
    console.log(err);
    callback(true);
    return;
  }

  connection.query("DELETE FROM favorites WHERE id_user = ? AND id_restaurant = ?", id_user, id_restaurant, function(err, results) {
    console.log("SUCCESS: Removed from fav ");
    connection.release();
      if(err){
        console.log(err);
        callback(true);
        return;
      }

      callback(results);
    });
  });
};

The error I'm getting is:

throw err; // Rethrow non-MySQL errors ^

TypeError: this._callback.apply is not a function

robertklep · Accepted Answer · 2016-06-15 18:16:55Z

1

Query parameters should be passed in an array:

connection.query("DELETE FROM favorites WHERE id_user = ? AND id_restaurant = ?", [ id_user, id_restaurant ], function(err, results) {
  ...
});

answered Jun 15, 2016 at 18:16

robertklep

205k38 gold badges421 silver badges413 bronze badges

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

1 Comment

Alan Over a year ago

Omg, I don't know how i missed that, I have a hundred more queries with them and I miss them Ha! Thanks for the help will mark as correct in 4 mins as I have to wait.

Collectives™ on Stack Overflow

Error when deleting from mySQL in node.js

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related