WordPress database error (table wp_zotpress does not exist)

  • Resolved keysmcplay

    (@keysmcplay)


    2 years, 8 months ago

    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

    (@keysmcplay)

    2 years, 8 months ago

    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')

    Plugin Author Katie

    (@kseaborn)

    2 years, 8 months ago

    Thanks @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.