Yes I’m talking about the plugin files in wp-content/plugins/wp-mail-logging/.
For debugging we must change the wp-config.php:
define('WP_DEBUG', true);
define('WP_DEBUG_DISPLAY', true);
define('WP_DEBUG_LOG', true);
define('SAVEQUERIES', true);
Now we are able to debug several points:
First try to reproduce the behaviour and see if there are any errors displayed. If there are no errors try to debug the sql.
SQL
There are few sql queries in the plugin. The relevant delete query is in WPML_Email_Log_List.php#L329. We loop over all submitted mail_id’s and delete them. Since SAVEQUERIES is defined all queries are saved to $wpdb->queries, so we can add a debug print to the debug.log (you can find it at wp_content/debug.log (because WP_DEBUG_LOG is defined))
$wpdb->query( $wpdb->prepare("DELETE FROM $tableName WHERE mail_id = %d", esc_sql($item_id) ), ARRAY_A );
error_log( print_r( $wpdb->queries, true ) );
See if the sql is fine.
The output should be similar to:
[48] => Array
(
[0] => DELETE FROM 'wp_wpml_mails' WHERE 'mail_id' = 74
[1] => 0.0086419582366943
[2] => do_action('toplevel_page_wpml_plugin_log'), call_user_func_array, WPML_OptionsManager->LogMenu, Email_Logging_ListTable->prepare_items, Email_Logging_ListTable->process_bulk_action
)
Depending on the result of your investigation we can try other things.
