Newsletter send SQL error

[peterduffy]

Hi all im having problems when trying to send newsletters

zen version 1.3.8a
sql version 5.0.89

I receive the error.....

1104 The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
in:
[SELECT DISTINCT c.customers_email_address as customers_email_address, c.customers_lastname as customers_lastname, c.customers_firstname as customers_firstname FROM customers c LEFT JOIN orders o ON c.customers_id=o.customers_id WHERE o.date_purchased IS NULL ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

can anybody help? thanks

[DrByte]

Two solutions available:

1. Upgrade to the latest v1.3.9 (recommended method)
or
2. Bandage with this: http://www.zen-cart.com/forum/showpo...7&postcount=12 and put a plan in place to do a proper upgrade ASAP.

[peterduffy]

thanks!