Ich habe versucht das Plugin zu installieren, jedoch kommt der Fehler 221 – SQL Fehler, das wäre der Passende Eventlog. Die Tabelle scheint schon zu bestehen. Kann die einfach gelöscht werden oder was wäre ein Lösungsweg?
Grüße
Maik
Error executing query CREATE TABLE `xplugin_jtl_paypal_checkout_vaulting` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`customer_id` INT NOT NULL DEFAULT 0,
`payment_id` INT NOT NULL DEFAULT 0,
`funding_source` VARCHAR(32) NOT NULL,
`vault_id` VARCHAR(64) NOT NULL,
`vault_status` VARCHAR(32) NOT NULL,
`vault_customer` VARCHAR(64) NOT NULL,
`shipping_hash` VARCHAR(64) NOT NULL,
CONSTRAINT UNIQUE KEY `idx_customer_payment_uq` (`customer_id`, `payment_id`, `funding_source`),
CONSTRAINT UNIQUE KEY `idx_vault_id` (`vault_id`),
CONSTRAINT UNIQUE KEY `idx_vault_customer` (`vault_customer`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
SQLSTATE[42S01]: Base table or view already exists: 1050 Table xplugin_jtl_paypal_checkout_vaulting already exists
Grüße
Maik
Error executing query CREATE TABLE `xplugin_jtl_paypal_checkout_vaulting` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`customer_id` INT NOT NULL DEFAULT 0,
`payment_id` INT NOT NULL DEFAULT 0,
`funding_source` VARCHAR(32) NOT NULL,
`vault_id` VARCHAR(64) NOT NULL,
`vault_status` VARCHAR(32) NOT NULL,
`vault_customer` VARCHAR(64) NOT NULL,
`shipping_hash` VARCHAR(64) NOT NULL,
CONSTRAINT UNIQUE KEY `idx_customer_payment_uq` (`customer_id`, `payment_id`, `funding_source`),
CONSTRAINT UNIQUE KEY `idx_vault_id` (`vault_id`),
CONSTRAINT UNIQUE KEY `idx_vault_customer` (`vault_customer`)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
SQLSTATE[42S01]: Base table or view already exists: 1050 Table xplugin_jtl_paypal_checkout_vaulting already exists