Migration Error, when istalling plugin

[alex-brukhty]

Description

Happens on fresh install

Migration Error – craft\errors\MigrationException

An error occurred while executing the "craft\shopify\migrations\Install migration: SQLSTATE[42703]: Undefined column: 7 ERROR: column "shopifyid" named in key does not exist at character 544

The SQL being executed was: CREATE TABLE "shopify_productdata" (
   "shopifyId" varchar(255),
   "title" text,
   "bodyHtml" text,
   "createdAt" timestamp(0),
   "handle" varchar(255),
   "images" text,
   "options" text,
   "productType" varchar(255),
   "publishedAt" timestamp(0),
   "publishedScope" varchar(255),
   "shopifyStatus" varchar(255),
   "tags" varchar(255),
   "templateSuffix" varchar(255),
   "updatedAt" varchar(255),
   "variants" text,
   "vendor" varchar(255),
   "metaFields" text,
   "dateCreated" timestamp(0) NOT NULL,
   "dateUpdated" timestamp(0) NOT NULL,
   "uid" varchar(255),
   PRIMARY KEY(shopifyId)
)

Steps to reproduce

1. Go to plugin store
2. Install plugin

Additional info

• Craft version: 4.3.10
• PHP version: 8.2.1
• Database driver & version: PostgreSQL 12.13
• Plugins & versions: 3.1.0

[lukeholder]

Looks like a bug with PostgreSQL - I will look to fix it shortly. Sorry for the delay.

[lukeholder]

Thanks for reporting. This is fixed for the next release.

To get the fix early, change your craftcms/shopify requirement in composer.json to:

"require": {
  "craftcms/shopify": "dev-develop#e554c89dc58837e63da85865dfe60351ef0cfb8e as 3.1.1",
  "...": "..."
}

Then run composer update.

Thanks!

[lukeholder]

This is now out in 3.2.0!

See the notes in the upgrading section of the README