All Questions
342
questions
1
vote
1
answer
136
views
Error: Packets out of order. Got: 0 Expected: 10 Nodejs MySQL
I occasionally encounter the following error, leading to a server crash. The crashes appear to coincide with the wait_timeout, occurring approximately every 8 hours. Apart from this issue, all other ...
0
votes
1
answer
35
views
How to make a function containing a select query return results in the overall function return - Node MySQL (npm package)
I am contacting you today because I am stuck on an error that is preventing me from moving forward. My problem is the following, I have code entirely done in OOP, the problem lies in an asynchronous ...
0
votes
2
answers
2k
views
"ECONNRESET" error in node mysql application
This error comming from my hosted node mysql application.
It's wokrs fine in my local computer
node:events:491
throw er; // Unhandled 'error' event
^
Error: read ECONNRESET
at TCP....
1
vote
0
answers
323
views
How to stream Mysql query result in node js and close if some forceclose event is received
i've a business logic to implement that entails fetching huge amount of data from mysql table approximately 1 billion.After fetching the record i've to hit an api of another system with each row.I've ...
0
votes
0
answers
23
views
MySQL in Node.js returning incorrect values [duplicate]
I'm trying to write a bot for Discord which I host with Node.js. When I try to get a user id from a database by searching for the person's name I do get a result, however the id is always a bit off. ...
-1
votes
1
answer
94
views
How to run MySQL multiple queries concurrently without waiting the result?
function dbQuery(sql)
{
dbcon.query(sql, function(err, result) {
//imagine the PING to DB server is 1 second.
//It would take 100 seconds to complete 100 Queries, if the query is ...
1
vote
1
answer
162
views
Node.js rounds my sql result. how do i prevent this?
I am requesting a bigint from my database. However, Node.js alters the value of my request, so that my program doesn't work.
Here's my code:
let query = `SELECT transcriptchannel FROM guilds WHERE ...
1
vote
0
answers
279
views
How to insert multiple queries in node js mysql after reading from excel file and insertion is dependent on excel rows?
I have a scenario where i need to read contents from an excel file. In the excel file there is column which tell if the a row is primary or not. Others will be sub rows of the primary row. I need to ...
1
vote
1
answer
2k
views
Node js mysql Running into the ECONNREFUSED error
New to js and node and I've got an app.js that will query a database and I query it using a pool so I have a file called db.js that looks like this
const mysql = require('mysql2/promise');
const ...
1
vote
1
answer
2k
views
How to escape single quotations (apostrophes) in MySQL query through Node.js?
I'm making a program where the user will enter data into inputs on a website. This information will then be relayed back to the server, using socket.io, and will be stored in a database. I am using ...
2
votes
2
answers
1k
views
ROLLBACK doesn't rollback transaction [NodeJS, MySQL]
connection.query(`START TRANSACTION;`, async function (err) {
if (err) {
req.flash("flash", "Something went wrong while deleting. Try again.");
return res.redirect("...
0
votes
0
answers
106
views
Error in your SQL syntax SET Syntax, how to solve?
While on the Lambda function, I'm trying to run the query below, but it throws an ER_PARSE_ERROR error:
{
"errorType": "Error",
"errorMessage": "ER_PARSE_ERROR:...
-1
votes
1
answer
176
views
Error in your SQL syntax: SET Syntax (Lambda function)
While on the Lambda function, I'm trying to run the following query, but it throws an ER_PARSE_ERROR error.
{
"errorType": "Error",
"errorMessage": "ER_PARSE_ERROR: ...
1
vote
1
answer
4k
views
Node.js mysql read ECONNRESET
After searching for long time regarding this error and not really be able to figure out how to handle this error in my project. I need some help from you :).
I've got the problem, that my Screen with ...
0
votes
1
answer
424
views
How to close mySql query connection in nodejs
I am using raw mySql query for my development.
I want to close the query connection after executing the query.
What can I use as per my code?
My Connection Sample:
const Sequelize = require('sequelize'...