Resolving SQLSTATE[HY000]: General Error 3098 During Magento Installation

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.