keysmcplay

Turns out this is a known issue with Azure MySQL Flexible Server.

I got more error messages after resetting Zotpress.

TLDR:
https://learn.microsoft.com/en-us/azure/dms/known-issues-azure-mysql-fs-online

• Workaround: Set the server parameter sql_generate_invisible_primary_key for target MySQL Flexible Server to OFF. The server parameter can be found in the Server parameters Blade under the All tab for the target MySQL Flexible Server. Additionally, drop the target database and start over the DMS migration to not have any mismatched schemas.

Here are the errors that helped me find the workaround…

WordPress database error: [Failed to generate invisible primary key. Auto-increment column already exists.]
CREATE TABLE wp_zotpress ( id INT(9) NOT NULL AUTO_INCREMENT, account_type VARCHAR(10) NOT NULL, api_user_id VARCHAR(10) NOT NULL, public_key VARCHAR(28) default NULL, nickname VARCHAR(200) default NULL, version VARCHAR(10) default '5.1', UNIQUE KEY id (id) )
WordPress database error: [Failed to generate invisible primary key. Auto-increment column already exists.]
CREATE TABLE wp_zotpress_oauth ( id INT(9) NOT NULL AUTO_INCREMENT, cache LONGTEXT NOT NULL, UNIQUE KEY id (id) )
WordPress database error: [Table ‘one8_485fe72463c54fdb989df69619e42431_database.wp_zotpress_oauth’ doesn’t exist]
SELECT COUNT(*) FROM wp_zotpress_oauth;
WordPress database error: [Table ‘one8_485fe72463c54fdb989df69619e42431_database.wp_zotpress_oauth’ doesn’t exist]
INSERT INTO wp_zotpress_oauth (cache) VALUES ('empty')