Support » Plugin: Newsletter » mysql error/warning messages

  • Resolved unsubscribed

    (@unsubscribed)


    Hello,

    I have some mysql error/warning messages after update this plugin

    2016-10-06 10:20:45 140362825378560 [ERROR] Slave SQL: Error ‘Duplicate column name ‘token” on query. Default database: ‘wpdb’. Query: ‘alter table wp_newsletter_emails add column token varchar(10) not null default ”’, Internal MariaDB error code: 1060

    2016-10-06 10:20:45 140362825378560 [Warning] WSREP: RBR event 1 Query apply warning: 1, 105767
    2016-10-06 10:20:45 140362825378560 [Warning] WSREP: Ignoring error for TO isolated action: source: 84923ca8-8bc7-11e6-b394-5615483976b8 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 12 trx_id: -1 seqnos (l: 52, g: 105767, s: 105766, d: 105766, ts: 1035856380737985)

    2016-10-06 10:20:45 140362826730240 [ERROR] Slave SQL: Error ‘Can’t DROP ‘visibility’; check that column/key exists’ on query. Default database: ‘wpdb’. Query: ‘alter table wp_newsletter_emails drop column visibility’, Internal MariaDB error code: 1091

    2016-10-06 10:20:45 140362826730240 [Warning] WSREP: RBR event 1 Query apply warning: 1, 105768
    2016-10-06 10:20:45 140362826730240 [Warning] WSREP: Ignoring error for TO isolated action: source: 84923ca8-8bc7-11e6-b394-5615483976b8 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 12 trx_id: -1 seqnos (l: 53, g: 105768, s: 105767, d: 105767, ts: 1035856385769503)

    2016-10-06 10:20:45 140362825378560 [ERROR] Slave SQL: Error ‘Duplicate column name ‘private” on query. Default database: ‘wpdb’. Query: ‘alter table wp_newsletter_emails add column private tinyint(1) not null default 0’, Internal MariaDB error code: 1060

    2016-10-06 10:20:45 140362825378560 [Warning] WSREP: RBR event 1 Query apply warning: 1, 105769
    2016-10-06 10:20:45 140362825378560 [Warning] WSREP: Ignoring error for TO isolated action: source: 84923ca8-8bc7-11e6-b394-5615483976b8 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 12 trx_id: -1 seqnos (l: 54, g: 105769, s: 105768, d: 105768, ts: 1035856390290199)

    there are much more error/warning message when deactivate & activate.

    after uninstall & re-installing

    2016-10-06 10:46:38 140362826730240 [ERROR] Slave SQL: Error ‘Can’t DROP ‘name’; check that column/key exists’ on query. Default database: ‘wpdb’. Query: ‘alter table wp_newsletter_emails drop column name’, Internal MariaDB error code: 1091

    2016-10-06 10:46:38 140362826730240 [Warning] WSREP: RBR event 1 Query apply warning: 1, 106127
    2016-10-06 10:46:38 140362826730240 [Warning] WSREP: Ignoring error for TO isolated action: source: 84923ca8-8bc7-11e6-b394-5615483976b8 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 79 trx_id: -1 seqnos (l: 415, g: 106127, s: 106126, d: 106126, ts: 1037409823466257)

    2016-10-06 10:46:39 140362825378560 [ERROR] Slave SQL: Error ‘Can’t DROP ‘visibility’; check that column/key exists’ on query. Default database: ‘wpdb’. Query: ‘alter table wp_newsletter_emails drop column visibility’, Internal MariaDB error code: 1091

    2016-10-06 10:46:39 140362825378560 [Warning] WSREP: RBR event 1 Query apply warning: 1, 106194
    2016-10-06 10:46:39 140362825378560 [Warning] WSREP: Ignoring error for TO isolated action: source: 84923ca8-8bc7-11e6-b394-5615483976b8 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 79 trx_id: -1 seqnos (l: 482, g: 106194, s: 106193, d: 106193, ts: 1037410978907248)

    2016-10-06 10:46:39 140362825378560 [ERROR] Slave SQL: Error ‘Table ‘wpdb.wp_newsletter_stats’ doesn’t exist’ on query. Default database: ‘wpdb’. Query: ‘alter table wp_newsletter_stats change column newsletter_id user_id int not null default 0’, Internal MariaDB error code: 1146

    2016-10-06 10:46:39 140362825378560 [Warning] WSREP: RBR event 1 Query apply warning: 1, 106196
    2016-10-06 10:46:39 140362825378560 [Warning] WSREP: Ignoring error for TO isolated action: source: 84923ca8-8bc7-11e6-b394-5615483976b8 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 79 trx_id: -1 seqnos (l: 484, g: 106196, s: 106195, d: 106195, ts: 1037411002263956)

    2016-10-06 10:46:39 140362826730240 [ERROR] Slave SQL: Error ‘Table ‘wpdb.wp_newsletter_stats’ doesn’t exist’ on query. Default database: ‘wpdb’. Query: ‘alter table wp_newsletter_stats change column newsletter_id user_id int not null default 0’, Internal MariaDB error code: 1146

    2016-10-06 10:46:39 140362826730240 [Warning] WSREP: RBR event 1 Query apply warning: 1, 106197
    2016-10-06 10:46:39 140362826730240 [Warning] WSREP: Ignoring error for TO isolated action: source: 84923ca8-8bc7-11e6-b394-5615483976b8 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 79 trx_id: -1 seqnos (l: 485, g: 106197, s: 106196, d: 106196, ts: 1037411005644997)

    2016-10-06 10:46:39 140362825378560 [ERROR] Slave SQL: Error ‘Table ‘wpdb.wp_newsletter_stats’ doesn’t exist’ on query. Default database: ‘wpdb’. Query: ‘alter table wp_newsletter_stats change column date created timestamp not null default current_timestamp’, Internal MariaDB error code: 1146

    2016-10-06 10:46:39 140362825378560 [Warning] WSREP: RBR event 1 Query apply warning: 1, 106198
    2016-10-06 10:46:39 140362825378560 [Warning] WSREP: Ignoring error for TO isolated action: source: 84923ca8-8bc7-11e6-b394-5615483976b8 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 79 trx_id: -1 seqnos (l: 486, g: 106198, s: 106197, d: 106197, ts: 1037411010934426)

    2016-10-06 10:46:39 140362825378560 [ERROR] Slave SQL: Error ‘Unknown column ‘read_count’ in ‘wp_newsletter_emails” on query. Default database: ‘wpdb’. Query: ‘alter table wp_newsletter_emails change column read_count open_count int not null default 0’, Internal MariaDB error code: 1054

    2016-10-06 10:46:39 140362825378560 [Warning] WSREP: RBR event 1 Query apply warning: 1, 106212
    2016-10-06 10:46:39 140362825378560 [Warning] WSREP: Ignoring error for TO isolated action: source: 84923ca8-8bc7-11e6-b394-5615483976b8 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 79 trx_id: -1 seqnos (l: 500, g: 106212, s: 106211, d: 106211, ts: 1037411208833976)

Viewing 1 replies (of 1 total)
  • Thread Starter unsubscribed

    (@unsubscribed)

    after update new version no error/warning messages

    Thanks.

Viewing 1 replies (of 1 total)
  • The topic ‘mysql error/warning messages’ is closed to new replies.