My settings page in Mailpoet is rather odd

  • Resolved kengray20

    (@kengray20)


    8 years, 6 months ago

    Folks:

    When I try to go to settings in mailpoet on bulldogottawa.com I get this. Mailpoet works perfectly on my other wordpress site bulldogcanadian.com.

    Here’s what I see when I go to settings page:

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT user_id FROM wp_wysija_user WHERE keyuser=”8135b5bf6954e938b0846710796afe69″

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wysija_user

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_list’ doesn’t exist]
    SELECT name, list_id FROM wp_wysija_list WHERE is_enabled=1 ORDER BY list_id DESC

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE email=”mailer@bulldogottawa.com” ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    UPDATE wp_wysija_user SET wpuser_id = 1 WHERE email=”mailer@bulldogottawa.com”

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT user_id FROM wp_wysija_user WHERE keyuser=”8135b5bf6954e938b0846710796afe69″

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wysija_user

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE email=”mailer@bulldogottawa.com” ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    UPDATE wp_wysija_user SET wpuser_id = 1 WHERE email=”mailer@bulldogottawa.com”

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT user_id FROM wp_wysija_user WHERE keyuser=”8135b5bf6954e938b0846710796afe69″

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wysija_user

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE email=”mailer@bulldogottawa.com” ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    UPDATE wp_wysija_user SET wpuser_id = 1 WHERE email=”mailer@bulldogottawa.com”

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT user_id FROM wp_wysija_user WHERE keyuser=”8135b5bf6954e938b0846710796afe69″

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wysija_user

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE email=”mailer@bulldogottawa.com” ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    UPDATE wp_wysija_user SET wpuser_id = 1 WHERE email=”mailer@bulldogottawa.com”

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT user_id FROM wp_wysija_user WHERE keyuser=”8135b5bf6954e938b0846710796afe69″

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wysija_user

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE email=”mailer@bulldogottawa.com” ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    UPDATE wp_wysija_user SET wpuser_id = 1 WHERE email=”mailer@bulldogottawa.com”

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT user_id FROM wp_wysija_user WHERE keyuser=”8135b5bf6954e938b0846710796afe69″

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wysija_user

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE email=”mailer@bulldogottawa.com” ORDER BY user_id DESC LIMIT 0 , 1

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    UPDATE wp_wysija_user SET wpuser_id = 1 WHERE email=”mailer@bulldogottawa.com”

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT user_id FROM wp_wysija_user WHERE keyuser=”8135b5bf6954e938b0846710796afe69″

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SHOW FULL COLUMNS FROM wp_wysija_user

    WordPress database error: [Table ‘bulldo16_restore.wp_wysija_user’ doesn’t exist]
    SELECT * FROM wp_wysija_user WHERE wpuser_id=1 ORDER BY user_id DESC LIMIT 0 , 1

    Anybody know what the problem is and how to solve it? I’m but a simple man and not a coder though I can fool around with code a bit when pressed.

    Any help you can provide would be outstanding.

    I really like the plugin and it works like a charm on bulldogcanadian.com. That why I want to use it on bulldogottawa.com

    Thx in advance.

    cheers

    Ken Gray

    https://wordpress.org/plugins/wysija-newsletters/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Wysija

    (@wysija)

    8 years, 6 months ago

    Looks like your plugin wasn’t properly installed. If this MailPoet install is new, the “fix” is rather easy. Go to Settings page > Advanced tab > Geeky Options link. Look for the last option that says “Reinstall MailPoet. Click on that button. This should fix your issue. In case it doesn’t, repeat the same steps again.

    If this is not a new install, meaning that you already have some sent newsletters and subscribers, the steps above will completely erase that. Then, you’ll need to recreate the wysija_user table manually on your database.

    Thread Starter kengray20

    (@kengray20)

    8 years, 6 months ago

    Thank you, MailPoet Staff:

    The plugin now works like a charm.

    I’m really glad the fix was so easy.

    Good luck with your venture.

    cheers

    Ken Gray

    Wysija

    (@wysija)

    8 years, 4 months ago

    Not a problem!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘My settings page in Mailpoet is rather odd’ is closed to new replies.

Tags