I am using the MailPoet plugin to create newsletters which has been working ok. However, after creating my 3rd newsletter, an exception is experienced and the newsletter list isn’t displayed. I have deleted the newly created newsletter directly from the mailpoet database using phpmyadmin, the error disappears and the previous 2 newsletters are once again displayed in the list. If I create a new basic one, the error returns and no newsletters are displayed.
From my investigations, I trust that this is to do with SQL_BIG_SELECTS not being enabled on your servers and there wouldn’t be a workaround?
I have logged a call with the Mailpoet support team also, incase it’s something they need to address.
This relates to the wordpress dashboard.
An exception occurred while executing ‘SELECT d0_.newsletter_id AS sclr_0, COUNT(DISTINCT d0_.subscriber_id) AS sclr_1 FROM wp_mailpoet_statistics_opens d0_ WHERE d0_.newsletter_id IN (?, ?, ?) AND ((d0_.user_agent_type = ?) OR (d0_.user_agent_type IS NULL)) GROUP BY d0_.newsletter_id’ with params [7, 4, 3, 0]: SQLSTATE: Syntax error or access violation: 1104 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