Postgres and Sequelize - Cannot read property 'name' of undefined

Question

I am trying to change database in a project running fine on MySQL to Postgres.
I receive the following error when running a migration (both with sync and sequelize db:migrate).

/myProject/node_modules/pg/lib/connection.js:109
      self.emit(msg.name, msg);
                   ^

TypeError: Cannot read property 'name' of undefined
    at Socket.<anonymous> (/myProject/node_modules/pg/lib/connection.js:109:20)
    at emitOne (events.js:96:13)
    at Socket.emit (events.js:188:7)
    at readableAddChunk (_stream_readable.js:172:18)
    at Socket.Readable.push (_stream_readable.js:130:10)
    at TCP.onread (net.js:542:20)

I have isolated only this simple model, but I still get the error

module.exports = (sequelize, DataTypes) => {
  var User = sequelize.define('User', {
    email: {
      type: DataTypes.STRING,
      validate: {
        isEmail: true
      }
    },
    googleId: {
      type: DataTypes.STRING,
      allowNull: false
    }
  }, {
    underscored: true
  })

  return User
}

What could be the problem?

I doubt that is in your models. Can you paste your sequelize initialization code? — Ivan Drinchev
– Ivan Drinchev, Commented May 10, 2016 at 21:47

Mino · Accepted Answer · 2016-05-11 09:09:18Z

1

I had to change the connection string to this and now it works. Thanks.

var sequelize = new Sequelize(match[5], match[1], match[2], {
  dialect: 'postgres',
  protocol: 'postgres',
  port: match[4],
  host: match[3],
  logging: false,
  dialectOptions: {
    ssl: true
  }
})

answered May 11, 2016 at 9:09

Mino

63513 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

Postgres and Sequelize - Cannot read property 'name' of undefined

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related