Table '367516.wp_ar_gwa_log'

  • Resolved simonr

    (@simonr)


    9 years, 7 months ago

    Bit of a snag – the confirmation email arrives and it clicking on it works fine, except that I have a string of code showing at the top of the page and the message that the table above is missing……

    Everything *works* though – it just looks like it doesn’t to the user….

    https://wordpress.org/plugins/autoresponder-gwa/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author pomspot

    (@pomspot)

    9 years, 5 months ago

    Obviously the email log table is missing. You can try disable and enable on the plugin page again, you won’t lose any data. If that doesn’t work try using this SQL in phpmyadmin. If you get an error send it in an email to admin@freeautoresponder.biz and I can help.

    CREATE TABLE wp_ar_gwa_log (
    id int(11) NOT NULL auto_increment,
    newsletterQID int(11) NOT NULL default 0,
    method set(‘mail’,’smtp’) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    From varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    FromName varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    Host varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    SMTPAuth varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    Username varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    Password varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    recepientMail varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    recepientName varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    subject varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    body text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    ContentType varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    priority int(1) NOT NULL default ‘0’,
    SendDate varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    QLID varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci default NOT NULL default ”,
    port varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci default NOT NULL default ”,
    charset varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci default NOT NULL default ”,
    encoding varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci default NOT NULL default ”,
    Response varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ”,
    PRIMARY KEY (id)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

    Thread Starter simonr

    (@simonr)

    9 years, 5 months ago

    Much appreciated – many thanks!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Table '367516.wp_ar_gwa_log'’ is closed to new replies.