All Questions
462
questions
0
votes
1
answer
23
views
Getting error in fetching data with Sequelize for Mysql Database (Backend Node.js)
I am using Sequelize ORM with mysql database for nodejs application. Somewhere I am stuck with one api whose job is just to show list based on the queryparam values. Issue is when I am not applying ...
0
votes
0
answers
13
views
import 'exported' sql file into mysql database using node.js
I had one sql file which i want to import in my new database using node.js.
I have tried multiple ways but no progress
This error i receive when i try readFile approach
Error executing SQL file: ...
0
votes
0
answers
37
views
Why is my SQL table only showing one one row with null columns after I run this code?
const db = require('./db');
const { createHash } = require('crypto');
async function registerUser(user, pass, email) {
if (pass.includes('?') || pass.includes('\'') || pass.includes('\"')) {
...
0
votes
0
answers
135
views
Authentication error when connecting to mysql database using node.js
what's up
I have a problem when I connect to a Mysql database.
The version of mysql I use is 5.0.95.
And the version of mysql2 is 3.6.5
The error in question is: Error: Server requests authentication ...
0
votes
0
answers
64
views
Facing ECONNREFUSED error while connecting to MySQL database (127.0.0.1:3306)
I'm encountering an ECONNREFUSED error when attempting to connect to my MySQL database using Node.js. I've configured my connection to use the address '127.0.0.1' and port '3306', but the connection ...
0
votes
0
answers
24
views
How to get the column values in list for same other column value in Sequelize
I wanted get to get nested output from Sequelize findAll api.
I am retrieving rows from table and I am getting below output,
[
{
"productId": 468,
"...
0
votes
0
answers
10
views
MySQL Error: ER_NOT_SUPPORTED_AUTH_MODE - Client does not support authentication protocol requested by server [duplicate]
I'm encountering an issue when trying to initialize my local database. I have already created a local database and added the necessary scripts, but I'm getting the following error:
{
code: '...
0
votes
0
answers
26
views
SQL database, Login failed for user ''
I am currently trying to create a database for a website I am creating and have been following a tutorial on youtube (https://www.youtube.com/watch?v=Uh2JCSUjA_E&ab_channel=CodingwithKevin).
I ...
0
votes
0
answers
119
views
Sequence.js:8 Uncaught TypeError: Cannot read properties of undefined (reading 'listenerCount') using node javascript in browser
I tryed implementing databases in my project , to make it clear is a simple login page. and i tryed implementig it in typescript in the main ,the code for the usage of the database and main is this:
...
0
votes
0
answers
200
views
How to fix "Error: connect ETIMEDOUT"using MySQL in node.js?
I just started learning how to use MySql by watching some tutorial video and I was trying to execute a query to MySQL database by using node but I'm still keep having this error: "Error: connect ...
1
vote
0
answers
40
views
I am trying to drop procedure after 30 seconds but I got this error?
module.exports.mainStoredProcedure = async(allQuerys,message) => {
const mainCallForSP = `
create procedure SP_${nanoId}()
begin
DECLARE errno varchar(300);
DECLARE text ...
0
votes
1
answer
221
views
I am getting an empty array as result from database
I am creating a sign up page and getting all the information from user using form but everything is working fine except the part where I am checking if the user exists or not
router.post("/test&...
1
vote
0
answers
468
views
How to fix this prisma query problem in nestjs
I have the following query which is running fine on express with knex. But when I try to convert it into prisma in NestJs it throwing me error.
`
async fetchCompanyActivities(
body: ...
0
votes
0
answers
101
views
How can I resolve ECONNREFUSED error when connecting my Node.js app to MySQL database on cPanel?
I want to connect the database to my app before uploading my website to the host
but there is an error: connect ECONNREFUSED when i try to connect nodejs app to mysql database
I tried to connect it ...
0
votes
0
answers
84
views
sequelize keep saying it can't read property 'hasOne' of undefined
I'm working on an application to allow users to create teams for online games, but right now I am having a problem with my database. At the moment I have three models user, team and teamMembers.
The ...