python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - mysql2

not null violation: model.field cannot be null

I have sequelize models and everything is synced up with the db: supplier: class Suppliers extends Model {} Suppliers.init({ id: { type: DataTypes.UUID, defaultValue: DataTypes.UUIDV4,...
test-img

Abdulsalam Almahdi

javascript

next.js

sequelize.js

mysql2

Votes: 0

Answers: 1

Latest Answer

You shouldn't wrap all fields into values prop. Just pass them directly: nwUser = await Suppliers.create({name:user.name, password:user.hash, email:user.email, phone: user.phone, firstName: user.first...
test-img

Anatoly

The type error about the return of mysql2/promise query

I'm using the mysql2/promise library in typescript, however, I can't understand the type of the return of the query method, and I can't solve an error. My code is below. import * as mysql from "m...
test-img

Pierogi

typescript

mysql2

Votes: 0

Answers: 2

Latest Answer

I am using a Custom function. Not sure if this is the solution you are looking for or not but it does work for a single query. Still working on multiple query support. Firstly, i have created a wrapp...
test-img

Dhaval Javia

MySQL mysteriously adding VALUES

I have this code in my project app.post('/history/form/confirm', isLoggedIn, (req,res)=>{ let code = req.body.pcode, quanti = req.body.qty, price = req.body.price, ...
test-img

Carl-Valencia

mysql

node.js

mysql-workbench

ejs

mysql2

Votes: 0

Answers: 2

Latest Answer

I'm not sure where the extra values are coming from, but you can simplify this by using a prepared statement with parameters. And the query can use INSERT INTO ... SELECT ... rather than putting subqu...
test-img

Barmar

SequelizeEagerLoadingError with Sequelized

I'm getting an error when trying to run a Sequelized query. The query works when I am only asking for a User, but breaks when I add 'include' and try to join with another table (the blogs table). Here...
test-img

Anthony Barragan

javascript

node.js

express

sequelize.js

mysql2

Votes: 0

Answers: 1

Latest Answer

In case anyone comes across this problem. I imported my models like this: const User = require('../../models/User'); const Blog = require('../../models/Blog'); They should have been imported like thi...
test-img

Anthony Barragan

Posts

Questions

Blogs

Jobs