- Issue created by @CirrusLab
- 🇮🇳India shrishail hiremath
@CirrusLab
This has been fixed in the latest version.
- Assigned to shrishail hiremath
- Status changed to Fixed
over 1 year ago 7:24am 28 March 2023
In a Galera MariaDB cluster with innoDB it is strongly recommended to have primary keys on the tables.
Steps to reproduce :
Importing a SQL dump :
mysql -u root database_name < database_name.sql
On the table "UserAuthenticationType" :
ERROR 1173 (42000) at line 25: This table type requires a primary key
View the database configuration :
show global variables like 'innodb_force_primary_key';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| innodb_force_primary_key | ON |
+--------------------------+-------+
Add the primary key to the table :
PRIMARY KEY (`uid`)
@CirrusLab
This has been fixed in the latest version.