WordPress DB Error – Unknown COlumn

  • shackbill

    (@shackbill)


    7 years, 4 months ago

    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

    (@no3x)

    7 years, 4 months ago

    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

    (@shackbill)

    7 years, 4 months ago

    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

    (@no3x)

    7 years, 4 months ago

    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, 4 months ago by No3x.
    Thread Starter shackbill

    (@shackbill)

    7 years, 4 months ago

    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.