WordPress.org

Forums

MailPoet Newsletters
[resolved] Database Error (3 posts)

  1. Richard Sweeney
    Member
    Posted 11 months ago #

    I'm getting the following errors when adding a new user to the database via php I've followed to the letter the instructions at http://support.mailpoet.com/knowledgebase/plugin-form-integrate/

    WordPress database error: [Unknown column 'domain' in 'field list']
    INSERT INTO wp_wysija_user (email,firstname,lastname,ip,created_at,keyuser,status,domain) VALUES ('testing123456@test.se','Testar hfjksdlfjasdkly','jkljklyui','83.241.140.40','1403162984','0c63506fc3714b9ae580b5efd78cbbbc','0','theshipyard.se')

    The domain column doesn't exist. Should it?! Was there a change the the database schema?

    I also get the following message error:

    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND B.is_enabled=1 AND A.list_id IN(4)' at line 1]
    SELECT A.* FROM wp_wysija_user_list as A LEFT JOIN wp_wysija_list as B on A.list_id=B.list_id WHERE A.user_id= AND B.is_enabled=1 AND A.list_id IN(4)

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

    The site is running on PHP 5.2.17 (I know, shit hosting) with MySQL 5.1.69. Latest mail poet version, latest wordpress

  2. Tung Wysija
    Member
    Posted 11 months ago #

    Hello Richard,

    Probably, your Mailpoet did not run upgrading process (to 2.6.x) correctly.
    Can you contact us privately and give us the access to your phpMyAdmin?
    Open your ticket at:
    http://support.mailpoet.com/feedback/

    We will be happy to sort it out for you.

    Cheers,
    Tung

  3. MailPoet Staff
    Member
    Plugin Author

    Posted 10 months ago #

    Closing it.

Reply

You must log in to post.

About this Plugin

  • MailPoet Newsletters
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic