Title: WordPress DB Error – Unknown COlumn
Last modified: November 8, 2018

---

# WordPress DB Error – Unknown COlumn

 *  [shackbill](https://wordpress.org/support/users/shackbill/)
 * (@shackbill)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/wordpress-db-error-unknown-column/)
 * I an using AWS/SES to send email and i just tested it and got this error and 
   wondered if it is associated with WP Mail Log. i DID get the email but WP Mail
   Log did not log it. thanks.
 *     ```
       WordPress database error: [Unknown column 'error' in 'field list']
       INSERT INTO <code>wp_wpml_mails</code> (<code>mail_id</code>, <code>timestamp</code>, <code>host</code>, <code>receiver</code>, <code>subject</code>, <code>message</code>, <code>headers</code>, <code>attachments</code>, <code>error</code>, <code>plugin_version</code>) VALUES (NULL, '2018-11-08 15:27:29', 'ip.address.here', 'myemailaddresshere', 'email from SES', 'This is a test email sent through AWS SES.', '', '', NULL, '1.8.5')
       ```
   
 * wordpress 4.9.8
    using wp mail logging v1.8.5 using WP SES v 0.8.1 (delicious
   brains)
 * bill

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

 *  [No3x](https://wordpress.org/support/users/no3x/)
 * (@no3x)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/wordpress-db-error-unknown-column/#post-10876814)
 * Seems like the upgrade from a previous version was not successful.
 * The easiest way is to drop the wp_mails table if it’s acceptable to loose the
   logs. If not please tell me.
 *  Thread Starter [shackbill](https://wordpress.org/support/users/shackbill/)
 * (@shackbill)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/wordpress-db-error-unknown-column/#post-10877505)
 * ok there is NO wp_mails (or wp_wpml_mails) table. I guess thats the problem. 
   so i deleted the Plugin and re-installed and still no wp_mails table. Ideas? 
   I thought maybe it would create the table upon first email but no table created
   and i got the error again.
 * Ideas?
 *  [No3x](https://wordpress.org/support/users/no3x/)
 * (@no3x)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/wordpress-db-error-unknown-column/#post-10911181)
 * It should be created on activation. Please delete the WPML_installed falg in 
   the wp_options table then. It checks if the table is present in the database –
   do you use a recent version of the plugin?
    -  This reply was modified 7 years, 6 months ago by [No3x](https://wordpress.org/support/users/no3x/).
 *  Thread Starter [shackbill](https://wordpress.org/support/users/shackbill/)
 * (@shackbill)
 * [7 years, 6 months ago](https://wordpress.org/support/topic/wordpress-db-error-unknown-column/#post-10915754)
 * As ive indicated above the version i have is 1.8.5 which should be the latest?
 * If you want me to delete the entry above, can you lease give me a hint how to
   find it 😛
 * ie ??
    SELECT * FROM `wp_options` WHERE `option_name`== WPML_installed ??
 * bill

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

The topic ‘WordPress DB Error – Unknown COlumn’ is closed to new replies.

 * ![](https://ps.w.org/wp-mail-logging/assets/icon-256x256.jpg?rev=2562296)
 * [WP Mail Logging](https://wordpress.org/plugins/wp-mail-logging/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-mail-logging/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-mail-logging/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-mail-logging/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-mail-logging/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-mail-logging/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [shackbill](https://wordpress.org/support/users/shackbill/)
 * Last activity: [7 years, 6 months ago](https://wordpress.org/support/topic/wordpress-db-error-unknown-column/#post-10915754)
 * Status: not resolved