Title: Database Error
Last modified: August 21, 2016

---

# Database Error

 *  Resolved [Richard Sweeney](https://wordpress.org/support/users/theorboman/)
 * (@theorboman)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/database-error-146/)
 * 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/](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/](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

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Tung Wysija](https://wordpress.org/support/users/tung-wysija/)
 * (@tung-wysija)
 * [11 years, 11 months ago](https://wordpress.org/support/topic/database-error-146/#post-5023145)
 * 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/](http://support.mailpoet.com/feedback/)
 * We will be happy to sort it out for you.
 * Cheers,
    Tung
 *  [Wysija](https://wordpress.org/support/users/wysija/)
 * (@wysija)
 * [11 years, 10 months ago](https://wordpress.org/support/topic/database-error-146/#post-5023245)
 * Closing it.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Database Error’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/wysija-newsletters_ffddcc.svg)
 * [MailPoet Newsletters (Previous)](https://wordpress.org/plugins/wysija-newsletters/)
 * [Support Threads](https://wordpress.org/support/plugin/wysija-newsletters/)
 * [Active Topics](https://wordpress.org/support/plugin/wysija-newsletters/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wysija-newsletters/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wysija-newsletters/reviews/)

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)

 * 2 replies
 * 3 participants
 * Last reply from: [Wysija](https://wordpress.org/support/users/wysija/)
 * Last activity: [11 years, 10 months ago](https://wordpress.org/support/topic/database-error-146/#post-5023245)
 * Status: resolved