Encountering a Sequelize error message that reads "Invalid value" while executing a basic query

Question

Encountering a Sequelize error message that reads "Invalid value" while executing a basic query

After successfully creating a user with sequelize, I encountered an issue where querying any user resulted in an "Invalid value" error.

The Sequelize User model is defined as follows:

import DataTypes from "sequelize";
import bcrypt from "bcrypt";
import config from "../../config.js";

export default (sequelize) => {
  sequelize.define("user", {
    id: {
      primaryKey: true,
      type: DataTypes.INTEGER,
      allowNull: false,
      autoIncrement: true,
    },
    username: {
      type: DataTypes.STRING(25),
      allowNull: false,
      unique: true,
    },
    password: {
      type: DataTypes.STRING(60),
      allowNull: false,
      set(value) {
        this.setDataValue(
          "password",
          bcrypt.hashSync(value, config.saltRounds)
        );
      },
    },
    isAdmin: {
      type: DataTypes.BOOLEAN,
      allowNull: false,
      defaultValue: false,
    },
  });
};

Query used:

import { sequelize as db } from "./database/index.js";
import Op from "sequelize";
import bcrypt from "bcrypt";
import config from "./config.js";

const hashedPwd = bcrypt.hashSync("pass", config.saltRounds);

db.models.user
  .findOne({
    where: {
      [Op.and]: [{ username: "user" }, { password: hashedPwd }],
    },
  })
  .then((user) => {
    console.log(user);
    console.log(user.id)
  })
  .catch((err) => {
    console.log(err);
  });

Database entry can be viewed here.

Upon running the query, the result was:

> node .\test.js
Error: Invalid value { username: 'user' }
    at Object.escape (node_modules\sequelize\lib\sql-string.js:65:11)
    at MariaDBQueryGenerator.escape (node_modules\sequelize\lib\dialects\abstract\query-generator.js:995:22)
    at node_modules\sequelize\lib\dialects\abstract\query-generator.js:2572:69
    at Array.map (<anonymous>)
    at MariaDBQueryGenerator._whereParseSingleValueObject (node_modules\sequelize\lib\dialects\abstract\query-generator.js:2572:52)
    at MariaDBQueryGenerator.whereItemQuery (node_modules\sequelize\lib\dialects\abstract\query-generator.js:2354:19)
    at node_modules\sequelize\lib\dialects\abstract\query-generator.js:2259:25
    at Array.forEach (<anonymous>)
    at MariaDBQueryGenerator.whereItemsQuery (node_modules\sequelize\lib\dialects\abstract\query-generator.js:2257:35)
    at MariaDBQueryGenerator.getWhereConditions (node_modules\sequelize\lib\dialects\abstract\query-generator.js:2675:19)

Seeking insights on why every username queried triggers an "Invalid value" error.

node.js sequelize.js

Answer 1

Answer №1

To start off, make sure to import Op using the following syntax. It's not exported as a default.

import { Op } from 'sequelize';

Next, you can substitute top-level Op.and with the following:

db.models.user
  .findOne({
    where: {
      username: 'user',
      password: hashedPwd,
    },
  })

Lastly (unrelated to this issue), it's important to note that each call to bcrypt for hashing will yield a different result. This means that the where condition will never match. I suggest searching for a user by username/email and then verifying the password like so:

db.models.user.findOne({ where: { username: 'myUsername' } })
  .then((user) => {
    return bcrypt.compareSync('myPassword', user.password)
  })
  .then((isMatch) => {
    if (!isMatch) {
      throw new Error('UNAUTHORIZED') // or any other appropriate action
    }
  })

Answer 2

To start off, make sure to import Op using the following syntax. It's not exported as a default.

import { Op } from 'sequelize';

Next, you can substitute top-level Op.and with the following:

db.models.user
  .findOne({
    where: {
      username: 'user',
      password: hashedPwd,
    },
  })

Lastly (unrelated to this issue), it's important to note that each call to bcrypt for hashing will yield a different result. This means that the where condition will never match. I suggest searching for a user by username/email and then verifying the password like so:

db.models.user.findOne({ where: { username: 'myUsername' } })
  .then((user) => {
    return bcrypt.compareSync('myPassword', user.password)
  })
  .then((isMatch) => {
    if (!isMatch) {
      throw new Error('UNAUTHORIZED') // or any other appropriate action
    }
  })

Answer 3

Answer №2

To start, make sure to import Op from sequelize by adding the following line of code:

import { Op } from 'sequelize';

Next, you can query the user using their unique field (such as email or phone number) like so:

db.models.user.findOne({
 where: {username: "username"}
})

This will return the user if they exist. Remember to verify their password with bcrypt as bcrypt generates different strings each time.

Answer 4

To start, make sure to import Op from sequelize by adding the following line of code:

import { Op } from 'sequelize';

Next, you can query the user using their unique field (such as email or phone number) like so:

db.models.user.findOne({
 where: {username: "username"}
})

This will return the user if they exist. Remember to verify their password with bcrypt as bcrypt generates different strings each time.

Answer 5

Answer №3

If you're facing a similar problem, double check that you are correctly placing elements in your code. Remember, an Include should not be within the Where statement but should instead be placed as a sibling to it.

Answer 6

If you're facing a similar problem, double check that you are correctly placing elements in your code. Remember, an Include should not be within the Where statement but should instead be placed as a sibling to it.

Encountering a Sequelize error message that reads "Invalid value" while executing a basic query

Answer №1

Answer №2

Answer №3

Similar questions

Node.js/Express - unable to retrieve client body data on server

Utilizing Mongoose to fetch data from Atlas MongoDB for integration into an Angular application

In production, all Next.js API routes consistently return an "Interval Server Error," whereas in development, all routes operate smoothly without any issues

Using JavaScript, import the variable module object from a specific module

Node and Express Issue: Index file failing to correctly call files

What steps should be followed to execute this moment.js code in an Angular.js controller using Node.js?

What is the best way to utilize functions in Express to dynamically display content on my Jade template?

Guide to setting the connection string for connect-pg-simple

How can I add a subdocument to a MongoDB array based on a specific condition being met?

Error: Unable to verify the user's identity. Mongoose

I am looking to serve static HTML files in Express.js while also retaining app.get() methods for handling server-side logic

I'm encountering an operation timeout error in my sequelize connection. Any suggestions on how to resolve this issue?

Tips for transferring data from Express to .ejs file during redirection in Node.js

Issues arise when attempting to delete messages that have already been retrieved

Encountering an issue when starting a Node.js/Swagger application using pm2 within a Docker environment: Unable to

How to integrate an AngularJS page into a Node application

I'm having trouble using Discord.js to set up a custom role with specialized permissions for muting users

Building a CRUD application with Node.js and Sequelize ORM

Utilizing NLP stemming on web pages using JavaScript and PHP for enhanced browsing experience

"Exploring the dynamic capabilities of Node.JS and Java Publisher/Subscriber