ER_NO_DEFAULT_FOR_FIELD in bulkCreate and updateOnDuplicate

[souvikinator]

So I have a model:

{
  id!: string;
  title?: string | null;
  description?: string | null;
  metaTitle?: string | null;
  metaDescription?: string | null;
  images!: string;
  price!: number;
  discount!: number;
  currency?: string | null;
  buyUrl!: string;
  sellUrl?: string | null;
  oiaBuyUrl?: string | null;
  oiaSellUrl?: string | null;
  platform!: string; // amazon, flipkart ...
  uploadId!: string;
  shopId?: string | null;
  // Timestamps
  public readonly createdAt!: Date;
  public readonly updatedAt!: Date;
}

now I am trying to do:

  const products = await Product.findAll({
    where: {
      uploadId,
    },
  });

  products.map((product) => {
    const targetProductMeta = productsMetaDetails.find(
      (productMeta) => productMeta.productId === product.id
    );
    if (targetProductMeta) {
      product.shopId = newShop.id;
      product.metaTitle = targetProductMeta.title;
      product.metaDescription = targetProductMeta.description;
    }

    return true;
  });

  await Product.bulkCreate(products, {
    updateOnDuplicate: ['shopId', 'metaTitle', 'metaDescription'],
    transaction: t,
  });
  

On running this it throws error: Error: Field 'images' doesn't have a default value
I console logged products that I am passing to bulkCreate and images do have a value for each product.

Also the raw query generated :

 INSERT INTO `IgCash_Products` (`id`,`createdAt`,`updatedAt`) VALUES ('e076b79f-42b3-429c-b1c3-c2bd3f99e94e','2023-09-18 11:59:17','2023-09-18 11:59:17'),('6e7f5fde-1429-47a8-aab0-1ce1eac03709','2023-09-18 11:59:17','2023-09-18 11:59:17'),('217fc03d-def9-4c18-95b1-ba0698c34a78','2023-09-18 11:59:17','2023-09-18 11:59:17'),('72c71a53-8031-4c8b-9526-9cf1991c3195','2023-09-18 11:59:17','2023-09-18 11:59:17'),('63a9277d-a985-4932-8cfb-d8225f3ac76a','2023-09-18 11:59:17','2023-09-18 11:59:17'),('74106358-3a0b-4686-9fd3-7aa56b26b7e7','2023-09-18 11:59:17','2023-09-18 11:59:17'),('63eb7e4f-1ad0-4a84-aa82-981116d403b2','2023-09-18 11:59:17','2023-09-18 11:59:17'),('bc820af6-9abf-497c-abc5-2e5a1953df1a','2023-09-18 11:59:17','2023-09-18 11:59:17'),('96304d02-697a-42ed-a99d-180530a45f44','2023-09-18 11:59:17','2023-09-18 11:59:17'),('c9f22bdc-b069-49a0-b9d4-f9b92d298a48','2023-09-18 11:59:17','2023-09-18 11:59:17') ON DUPLICATE KEY UPDATE `metaTitle`=VALUES(`metaTitle`),`metaDescription`=VALUES(`metaDescription`),`shopId`=VALUES(`shopId`);

why is it only passing 3 fields in the insert into? can anyone explain what's happening here?