Entire mail list of 1000’s disappeared

Thankfully I seem to have 487 rows of 25 users in bft_users table in phpmyadmin

Where have they gone in the WordPress admin?

One of your updates must have caused this???

An update cannot cause the emails to disappear. There is only one place where you can mass-delete contacts and it requires manual confirmation.

If another plugin or custom code have really deleted records from the DB you can revert your site to a backup from your hosting control panel.

If you have records in phpmyadmin but don’t see them in the mailing lists page, enable debugging:

Debugging in WordPress

And let us know what errors you see.

Hi,

From debugging mode debug.log:

[24-Aug-2021 15:31:44 UTC] WordPress database error The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay for query SELECT SQL_CALC_FOUND_ROWS tU.*, COUNT(tS.id) as cnt_mails FROM www0_bft_users tU
				LEFT JOIN www0_bft_sentmails tS ON tS.user_id=tU.id 
				WHERE 1 
				GROUP BY tU.id ORDER BY email ASC LIMIT 0, 20 made by do_action('arigato-light_page_bft_list'), WP_Hook->do_action, WP_Hook->apply_filters, bft_list

Thanks, you’ll need to contact your hosting support to raise these limits. This cannot be done from the plugin code.