mailster_actions table does not have explicit primary key

  • Resolved deamonmv

    (@deamonmv)


    5 years, 2 months ago

    Hello

    I have faced problem with Mailter in context of moving database into Percona XtraDB Cluster – https://www.percona.com/doc/kubernetes-operator-for-pxc/kubernetes.html

    The thing is PXC have “validator” https://www.percona.com/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html

    And table mailster_actions have problem:

    Percona-XtraDB-Cluster prohibits use of DML command on a table (userdb.wp_mailster_actions) without an explicit primary key with pxc_strict_mode = ENFORCING or MASTER

    CREATE TABLE wp_mailster_actions (
    subscriber_id bigint(20) unsigned DEFAULT NULL,
    campaign_id bigint(20) unsigned DEFAULT NULL,
    timestamp int(11) unsigned NOT NULL DEFAULT ‘0’,
    count int(11) unsigned NOT NULL DEFAULT ‘0’,
    type tinyint(1) NOT NULL DEFAULT ‘0’,
    link_id bigint(20) unsigned NOT NULL DEFAULT ‘0’,
    UNIQUE KEY id (subscriber_id,campaign_id,type,link_id),
    KEY subscriber_id (subscriber_id),
    KEY campaign_id (campaign_id),
    KEY type (type)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

    It is possible to solve this problem?

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter deamonmv

    (@deamonmv)

    5 years, 2 months ago

    The same this happens with this tables
    – mailster_subscriber_meta

    CREATE TABLEwp_mailster_subscriber_meta` (
    subscriber_id bigint(20) unsigned DEFAULT NULL,
    campaign_id bigint(20) unsigned NOT NULL,
    meta_key varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    meta_value longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    UNIQUE KEY id (subscriber_id,campaign_id,meta_key),
    KEY subscriber_id (subscriber_id),
    KEY campaign_id (campaign_id),
    KEY meta_key (meta_key)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;`

    It’s will be very-very good to have solution to avoid using PXC PERMISSIVE mode.

    Thank you in advance

    Thread Starter deamonmv

    (@deamonmv)

    5 years, 2 months ago

    It’s possible that I missed with Plugin.

    So if it’s your plugin do not have such tables, please close the ticket

    Thank you

    Thread Starter deamonmv

    (@deamonmv)

    5 years, 2 months ago

    Hello

    Seems that we already use different plugin – WP SMTP Mail, but tables from Mailster plugin still present.

    I reach guys from WP SMTP Mail plugin, they said that they do not have such tables https://wordpress.org/support/topic/mailster_actions-table-does-not-have-explicit-primary-key-2/#new-topic-0

    Can you please tell me how to make clean up of the old tables?

    Thank you

    Plugin Author brandtoss

    (@brandtoss)

    5 years, 2 months ago

    Hey deamonmv,

    we don’t have such tables in WP Mailster – you are looking at a different plugin.

    Thanks

    Thread Starter deamonmv

    (@deamonmv)

    5 years, 2 months ago

    Hi @brandtoss

    Thank you for the information.

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

The topic ‘mailster_actions table does not have explicit primary key’ is closed to new replies.