Error while adding data to datanase using sequelize

Bickey1436 · March 22, 2020, 7:42pm

Unhandled rejection SequelizeDatabaseError: Unknown column ‘productID’ in ‘field list’
at Query.formatError (F:\Website\node_modules\sequelize\lib\dialects\mysql\query.js:244:16)
at Prepare.onResult (F:\Website\node_modules\mysql2\lib\connection.js:604:11)
at Prepare.execute (F:\Website\node_modules\mysql2\lib\commands\command.js:30:14)
at Connection.handlePacket (F:\Website\node_modules\mysql2\lib\connection.js:417:32)
at PacketParser.onPacket (F:\Website\node_modules\mysql2\lib\connection.js:75:12)
at PacketParser.executeStart (F:\Website\node_modules\mysql2\lib\packet_parser.js:75:16)
at Socket. (F:\Website\node_modules\mysql2\lib\connection.js:82:25)
at Socket.emit (events.js:210:5)
at addChunk (_stream_readable.js:309:12)

M17LP0065 · March 23, 2020, 8:21am

Upload the entire code on github and send the link.

Bickey1436 · March 23, 2020, 12:16pm

https://github.com/ashu-dixit/ecommerce.git here

M17LP0065 · March 26, 2020, 10:08pm

github.com

ashu-dixit/ecommerce/blob/master/db.js

const Sequelize = require('sequelize')
const db = new Sequelize('shopdb', 'shopper', 'shoppass', {

    host: 'localhost',
    dialect: 'mysql',

    pool: {
        max: 6,
        min: 0,
        acquire: 30000,
        idle: 10000
    }
})

const customer = db.define('Customer', {
    customerID: {
        type: Sequelize.INTEGER,
        primaryKey: true,

        allowNull: false

This file has been truncated. show original

Here you have id as column name instead of productID, thus the column productID is unknown.

M17LP0065 · March 28, 2020, 5:18pm

I hope I’ve cleared your doubt. I ask you to please rate your experience here
Your feedback is very important. It helps us improve our platform and hence provide you
the learning experience you deserve.

On the off chance, you still have some questions or not find the answers satisfactory, you may reopen
the doubt.