Without overriding JSON.stringify, the query works fine. When JSON.stringify is overridden, I get SyntaxError: Unexpected token ':' This is the entire code. I run it with "node filename.js" Why? const mysql = require('mysql2'); const originalStringify = JSON.stringify; /* without this…
I have a handler to handle a specific route in nodejs with express. async function handleGetAllBookingByUserId(req, res, next) { try { let bookings = await pool.execute(queries.getAllBookingByUserId, [ req.params.userId, ]); let map_ = await groupByBookings(bookings); console.log(map_.values()); res.send(map_.values()); } catch (err) {…
I'm using mysql2 in my nodejs project, in mysql library i used Multiple Statements for update my database and that works great, but for some reason in mysql2 it doesn't work, i googled it a lot and didn't found any…
I'm trying to connect my NodeJS application to my remote MySQL Database, but it keeps giving me a 1045 error ('ER_ACCESS_DENIED_ERROR'). From the same workstation, I can connect to the same database through MySQL Workbench perfectly fine. This leads me…