The database is an old version of MariaDB, the equivalent of MySQL 5.5. The table contains those columns
id
auth
old_auth
device_id_fk
This error is showing
Table contains 4 indexes inside InnoDB, which is different from the number of indexes 3 defined in MySQL
The results of SHOW CREATE TABLE
CREATE TABLE `wtb_device_auths` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`device_id_fk` int(11) NOT NULL,
`auth` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`old_auth` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `auth_index` (`auth`),
KEY `auth1_index` (`device_id_fk`),
KEY `auth2_index` (`old_auth`)
) ENGINE=InnoDB AUTO_INCREMENT=627642 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
How to fix it?
SHOW CREATE TABLE tablename;
on both servers, copy returned table scripts and paste them into your question. And - where is your question?Table contains 4 indexes inside InnoDB, which is different from the number of indexes 3 defined in MySQL