cannot read property to String of undefined [sequelize db:migrate node.js postgres]

Question

I run

$ sequelize db:migrate,

but I get this result, with an ERROR

Loaded Configuration file "db\config\config.json".
Using environment "development".
==20190927081141-add-email-to-contacts: migrating =======

ERROR: Cannot read property 'toString' of undefined

This is my current config.json file, but I don't have any toString property in it.

//config.json

{
  "development": {
    "port":5432,
    "username": "postgres",
    "password": null,
    "database": "address-bloc-dev",
    "host": "127.0.0.1",
    "dialect": "postgres",
    "logging":false
  },
  "test": {
    "username": "postgres",
    "password": null,
    "database": "address-bloc-test",
    "host": "127.0.0.1",
    "dialect": "postgres",
    "logging": false
  }
}

Here is also the add email to contacts.js file

'use strict';
module.exports = {
  up: (queryInterface, Sequelize) => {
    return queryInterface.addColumn('Contacts', 'email',
     {
      email: {
          type: Sequelize.STRING,
      }
    });
  },
  down: (queryInterface, Sequelize) => {
    return queryInterface.removeColumn('Contacts', 'email');
  }
};

What am I doing wrong? I'm struggling in figuring it out.

Thank you

Federico

Smartniggs · Accepted Answer · 2020-07-08 18:50:59Z

3

Had a similar issue with changeColumn(), ensure that that you completely define the new data type of the column that you intend to change.

Sequelize Docs This method changes the meta data of an attribute. It is possible to change the default value, allowance of null or the data type. Please make sure, that you are completely describing the new data type.

answered Jul 8, 2020 at 18:50

Smartniggs

3003 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jayna Tanawala Over a year ago

@Smartninggs, When I am setting allowNull:false it is throwing the same error! I have only this allowNull propery needs to set! So Do I need to put other things as well like default value, datatype?

Martin Dimitrov · Accepted Answer · 2019-09-27 14:01:43Z

1

This error is not coming from the config.json file, but rather the 20190927081141-add-email-to-contacts. The error is from there.

EDIT:

What you are doing wrong is how you are setting the type of the email field.

You should do:

'use strict';
module.exports = {
  up: (queryInterface, Sequelize) => {
    return queryInterface.addColumn('Contacts', 'email',
     {
        type: Sequelize.STRING,
     });
  },
  down: (queryInterface, Sequelize) => {
    return queryInterface.removeColumn('Contacts', 'email');
  }
};

edited Sep 27, 2019 at 14:01

answered Sep 27, 2019 at 13:40

Martin Dimitrov

1,3041 gold badge11 silver badges26 bronze badges

1 Comment

user3926863 Over a year ago

thank you, I have just included it into the question

EL TEGANI MOHAMED · Accepted Answer · 2021-08-10 11:40:31Z

1

I have this error and the solution was to modify just a word.

the place of the error

  id:{
      ype: DataTypes.UUID,
      defaultValue: DataTypes.UUIDV1,
      primaryKey: true,
      allowNull: false,
    }

the solution was

 id:{
      type: DataTypes.UUID,
      defaultValue: DataTypes.UUIDV1,
      primaryKey: true,
      allowNull: false,
    }

just added the missing letter

edited Aug 10, 2021 at 11:40

answered Jun 25, 2020 at 17:09

EL TEGANI MOHAMED

1,9082 gold badges19 silver badges37 bronze badges

Comments

Ossim Julius · Accepted Answer · 2020-06-28 10:43:02Z

follow steps below:

install sequelize-cli: npm install -g sequelize-cli
install sequelize: npm install --save sequelize
install mysql2: npm install --save mysql2
initialize sequelize: sequelize init
delete the migration and seeder directory automatically generated

create a model (e.g user model):

 module.exports = (sequelize, DataTypes) => {
    const User = sequelize.define('users', {
      name: {
             type: Datatype.STRING,
             allowNull: false,
            },

      userRole: {
             type: Datatype.INTEGER,
             allowNull: false,
            },
  });
return User;

}

Add db.sequelize.sync({ force: true, logging: console.log }); to your server.js after db has been defined.
run your server

Collectives™ on Stack Overflow

cannot read property to String of undefined [sequelize db:migrate node.js postgres]

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related