Problem
During the installation of Magento, you might encounter an error similar to the following:
[Progress: 1319 / 1319] [SUCCESS]: Magento installation complete. [SUCCESS]: Magento Admin URI: /admin Nothing to import. magento 21:21:58.25 DEBUG ==> Setting Magento configuration value 'web/secure/use_in_frontend' to '1' SQLSTATE[HY000]: General error: 3098 The table does not comply with the requirements by an external plugin., query was: INSERT INTO queue_poison_pill (version) VALUES (?)
This error indicates that the queue_poison_pill table is missing a required primary key, which causes issues when inserting data into the table.
Solution
To resolve this issue, you need to add a primary key to the queue_poison_pill table. You can do this by executing the following SQL command:
ALTER TABLE queue_poison_pill ADD `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
This command adds an id column as the primary key, which is set to auto-increment, ensuring that each row has a unique identifier.
Top comments (0)