Support » Plugin: ecampaign » Table ‘xx_wpxxx.wpxj_ecampaign_log’ doesn’t exist

  • papyrusdoc

    (@papyrusdoc)


    I had this plugin working on my old server for a long time. The client moved servers, and when I reinstalled the plugin, I got the following error:Table ‘xx_wpxxx.wpxj_ecampaign_log’ doesn’t exist

    I tried specifying that I just want to send an email (not sign a petition) but I still get the error upon submitting the form.

    I uninstalled and reinstalled the plugin and got another generic error.
    any advice? can I manually create the table? If so what fields should it have?

    thanks,
    Kim

    The page I need help with: [log in to see the link]

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

    (@john-ackers)

    You can manually create the table and the SQL is in the EcampaignLog.class.php. It looks something like:
    CREATE TABLEwp_ecampaign_log` (
    id bigint(20) NOT NULL AUTO_INCREMENT,
    date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    state char(20) NOT NULL,
    visitorName varchar(50) NOT NULL,
    visitorEmail varchar(50) NOT NULL,
    address varchar(100) NOT NULL,
    checkbox1 tinyint(1) NOT NULL,
    checkbox2 tinyint(1) NOT NULL,
    target varchar(50) NOT NULL,
    info varchar(1024) NOT NULL,
    postID bigint(20) NOT NULL,
    PRIMARY KEY (id),
    KEY postID_visitorEmail (postID,visitorEmail)
    ) ;`

    Not sure why your new site didn’t recognise that you had a virgin install. Anyway hope this helps.

    Thread Starter papyrusdoc

    (@papyrusdoc)

    Thanks so much!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Table ‘xx_wpxxx.wpxj_ecampaign_log’ doesn’t exist’ is closed to new replies.