Title: WordPress database error (table wp_zotpress does not exist)
Last modified: September 11, 2023

---

# WordPress database error (table wp_zotpress does not exist)

 *  Resolved [keysmcplay](https://wordpress.org/support/users/keysmcplay/)
 * (@keysmcplay)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_zotpress-does-not-exist/)
 * Hi Zotpress friends!
 * I’m running into an error that must be preventing the plugin from working for
   me. When I activate, I see this, which doesn’t give a warm fuzzy feeling…
 * `The plugin generated 1485 characters of **unexpected output** during activation.
   If you notice “headers already sent” messages, problems with syndication feeds
   or other issues, try deactivating or removing this plugin.`
 * Then, even though entering my user id and api key validates successfully, I can’t
   see my synced user in the list, and I have this message at the top of the plugin
   window pane…
 * **WordPress database error:** [Table ‘one8_485fe72463c54fdb989df69619e42431_database.
   wp_zotpress’ doesn’t exist]
   `SELECT * FROM wp_zotpress`
 * Has anyone here ever encountered this issue?
 * WordPress Version 6.3.1
   PHP Version 8.2.9

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [keysmcplay](https://wordpress.org/support/users/keysmcplay/)
 * (@keysmcplay)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_zotpress-does-not-exist/#post-17042933)
 * 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](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…[](https://learn.microsoft.com/en-us/azure/dms/known-issues-azure-mysql-fs-online#incompatible-sql-mode)
 * 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')`
 *  Plugin Author [Katie](https://wordpress.org/support/users/kseaborn/)
 * (@kseaborn)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_zotpress-does-not-exist/#post-17042937)
 * Thanks [@keysmcplay](https://wordpress.org/support/users/keysmcplay/) !

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WordPress database error (table wp_zotpress does not exist)’ is closed
to new replies.

 * ![](https://ps.w.org/zotpress/assets/icon-256x256.png?rev=1995512)
 * [Zotpress](https://wordpress.org/plugins/zotpress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/zotpress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/zotpress/)
 * [Active Topics](https://wordpress.org/support/plugin/zotpress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/zotpress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/zotpress/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [Katie](https://wordpress.org/support/users/kseaborn/)
 * Last activity: [2 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-error-table-wp_zotpress-does-not-exist/#post-17042937)
 * Status: resolved