697 questions
0
votes
0
answers
51
views
ER_ACCESS_DENIED_NO_PASSWORD_ERROR: Access denied for user ''@'localhost'
I use the @flowfuse dashboard, I wanted to modify the ui-gauge node, so that every time there is an update in my table, it updates my gauge accordingly
I use mysql and @rodrigos/mysql-events for that
...
- 3
1
vote
0
answers
49
views
mariadb npm package database keeps timing out even if it's under no load
I have a query function that takes an sql and executes it, like this:
import mariadb, { QueryOptions } from "mariadb";
const pool = mariadb.createPool({
host: process.env.DB_HOST,
...
- 11
0
votes
0
answers
102
views
Error when connecting a database from node.js
So I have this error, I made my database in phpMyAdmin and I am trying to connect the database, but I can't. I am new to website development so I am unsure what I am doing. Any help is more than ...
- 45
0
votes
0
answers
42
views
Nodejs mysql: Cannot enqueue Query after invoking quit
I have this code:
const conn = mysql.createConnection(connData);
conn.connect(function (err) {
if (err) throw err;
function query(sql) {
return new Promise(function (resolve, reject) ...
1
vote
1
answer
263
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 ...
- 575
0
votes
1
answer
45
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 ...
-1
votes
1
answer
126
views
uri format connection gets access-denied in mysql
I'm using Node and MySQL2
import mysql2 from 'mysql2'
Following successfully creates connection:
const connection = mysql2.createConnection({
host: 'localhost',
user: 'root',
...
- 2,341
-2
votes
1
answer
48
views
Why is routing to 'name' not working when it works for 'id'?
I have local backend on mysql and I am using connect Node.js to connect both of them. Everything is working fine. The connection is succesfull all the queries are happening but why is this not working....
1
vote
1
answer
680
views
Best way to handle MySQL PROTOCOL_CONNECTION_LOST in Fastify - GCP hosted
I'm getting a couple of PROTOCOL_CONNECTION_LOST error codes in production for one of my projects when running SQL queries. What is the best way to handle this in Fastify?
I've searched Stackoverflow ...
- 1,487
1
vote
1
answer
957
views
Node + MySQL - How to get the raw query with bindings
is it possible to get the raw SQL query with its bindings either prior or after execution to see what's about to, or has just executed?
Example:
const id = 4
const connection = await fastify.mysql....
- 1,487
1
vote
1
answer
74
views
How to use mysql Joins with paramerized query in Nodejs
I am working with Nodejs and expressjs,I am using "mysql2 library" and Right now i want to concat and use join (with paramerized) query , How can i do this ? I have following query and i ...
- 21
4
votes
1
answer
152
views
My SQL statement is not comparing unicode emojis properly?
fullEmoji is a property stored in discord.js ParsedEmoji object
which should just be a literal emoji '😄'.
The ParsedEmoji is just an interface but I get that from calling
parseEmoji() which is a ...
- 43
1
vote
1
answer
60
views
How do I send a longblob as image/jpeg?
I'm stuck trying to get an express server to answer an image file loaded from a mysql database. All of this is running on a robust AWS EC2 image running Rocky Linux (CentOS8).
I have a jpeg/jpg image ...
- 1,049
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
459
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 ...
- 527