db.run(`begin transaction;
  replace into players (user_id, role) values ($id, $role);
  update signed_up_users set finalised = 1 where user_id = $id;
  commit;`, { $id: id, $role: role}, err=>{
    if (err) {throw err;}
  });

Error: SQLITE_RANGE: bind or column index out of range
--> in Database#run('begin transaction;n      replace into players (user_id, role) values (?, ?);n      update signed_up_users set finalised = 1 where user_id = ?;n      commit;', [ '123', 'INNOCENT', '123' ], [Function])
    at Object.exports.finalise_user (C:whateverfile.js)
    at user.resolve_to_id.then.id (C:whateverfile.js:52:14)
    at <anonymous>
    at process._tickCallback (internal/process/next_tick.js:188:7)