wp_wpml_mails doesn’t exist

  • Resolved shybutterfly

    (@shybutterfly)


    7 months ago

    Hello,

    None of my mails are getting logged into the plugin. I tried to disable it, uninstall, clean the database table created by the plugin to do a fresh start but when reinstalling it, it shows this error each time i try to access the mail log : 

    WordPress database error Table '***.wp_wpml_mails' doesn't exist for query SELECT COUNT(*) FROM wp_wpml_mails WHERE error IS NULL OR error = '' made by do_action('toplevel_page_wpml_plugin_log'), WP_Hook->do_action, WP_Hook->apply_filters, No3x\WPML\WPML_OptionsManager->LogMenu, do_action('wp_mail_logging_admin_tab_content'), WP_Hook->do_action, WP_Hook->apply_filters, No3x\WPML\Admin\EmailLogsTab->display_tab_content, No3x\WPML\WPML_Email_Log_List->prepare_items, No3x\WPML\Model\Email_Log_Collection->get_statuses_count, No3x\WPML\Model\Email_Log_Collection->find_list
    NOTICE: PHP message: WordPress database error Table '***.wp_wpml_mails' doesn't exist for query SELECT COUNT(*) FROM wp_wpml_mails WHERE error IS NOT NULL AND error != '' made by do_action('toplevel_page_wpml_plugin_log'), WP_Hook->do_action, WP_Hook->apply_filters, No3x\WPML\WPML_OptionsManager->LogMenu, do_action('wp_mail_logging_admin_tab_content'), WP_Hook->do_action, WP_Hook->apply_filters, No3x\WPML\Admin\EmailLogsTab->display_tab_content, No3x\WPML\WPML_Email_Log_List->prepare_items, No3x\WPML\Model\Email_Log_Collection->get_statuses_count, No3x\WPML\Model\Email_Log_Collection->find_list
    NOTICE: PHP message: WordPress database error Table '***.wp_wpml_mails' doesn't exist for query SELECT * FROM wp_wpml_mails ORDER BY mail_id desc LIMIT 25 made by do_action('toplevel_page_wpml_plugin_log'), WP_Hook->do_action, WP_Hook->apply_filters, No3x\WPML\WPML_OptionsManager->LogMenu, do_action('wp_mail_logging_admin_tab_content'), WP_Hook->do_action, WP_Hook->apply_filters, No3x\WPML\Admin\EmailLogsTab->display_tab_content, No3x\WPML\WPML_Email_Log_List->prepare_items, No3x\WPML\Model\Email_Log_Collection->find_list
    NOTICE: PHP message: WordPress database error Table '***.wp_wpml_mails' doesn't exist for query SELECT COUNT(*) FROM wp_wpml_mails made by do_action('toplevel_page_wpml_plugin_log'), WP_Hook->do_action, WP_Hook->apply_filters, No3x\WPML\WPML_OptionsManager->LogMenu, do_action('wp_mail_logging_admin_tab_content'), WP_Hook->do_action, WP_Hook->apply_filters, No3x\WPML\Admin\EmailLogsTab->display_tab_content, No3x\WPML\WPML_Email_Log_List->prepare_items, No3x\WPML\Model\Email_Log_Collection->find_list

    I censored the database name. The table is not recreated by default.

    For aditionnal context i migrated from apache wordpress docker official image to fpm wordpress docker official image. Yet this is the only plugin that refuse to work.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Darshana

    (@darshanaw)

    7 months ago

    Hi @shybutterfly,

    Thank you for sharing the additional details and error logs!

    From the errors, it looks like the WP Mail Logging plugin’s database table hasn’t been recreated properly after re-installation. This would explain why emails aren’t being logged.

    Here are a few steps you can try:

    • Deactivate and uninstall the WP Mail Logging plugin directly from your WordPress admin dashboard.
    • Double-check your database and remove any leftover tables related to the plugin, if they weren’t already removed.
    • Reinstall the plugin from the ww.wp.xz.cn repository. On first activation, the plugin should automatically recreate the required table

    Since you migrated from Apache to the FPM Docker image, it’s worth verifying that your database user has full CREATE / ALTER / INSERT permissions. Without this, the plugin cannot create the needed table.

    If after following these steps the issue persists, it may be related to the migration environment. In that case, I’d recommend temporarily switching to your default WordPress theme and disabling any caching/optimization or security plugins, then activating WP Mail Logging again to see if the table is created correctly.

    Please give this a try and let us know how it goes.

    Thank you!

    Plugin Support Darshana

    (@darshanaw)

    6 months, 2 weeks ago

    Hi @shybutterfly,

    We haven’t heard from you in a while, so I’m going to go ahead and close out this thread for now. If you’re still having trouble, feel free to respond here at your convenience and we’ll be happy to help.

    Have a great day!

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

The topic ‘wp_wpml_mails doesn’t exist’ is closed to new replies.