156c
php 7.3.20
maria 10.3.23

email address exporter gives white page in admin when query built in 154 is selected in 156c
another query for email address exporter functions as in the past

ADM debug log
Code:
[23-Jul-2020 10:45:19 America/Los_Angeles] Request URI: /adminfolderemail_export.php?action=save, IP address: xxx.yyy.zzz107
#1  mysqli_query() called at [/home/cpanel/public_html/includes/classes/db/mysql/query_factory.php:45]
#2  queryFactory->query() called at [/home/cpanel/public_html/includes/classes/db/mysql/query_factory.php:261]
#3  queryFactory->Execute() called at [/home/cpanel/public_html/adminfolderemail_export.php:89]
--> PHP Warning: mysqli_query(): Empty query in /home/cpanel/public_html/includes/classes/db/mysql/query_factory.php on line 45.

[23-Jul-2020 10:45:19 America/Los_Angeles] Request URI: /adminfolderemail_export.php?action=save, IP address: xxx.yyy.zzz107
#1  queryFactory->show_error() called at [/home/cpanel/public_html/includes/classes/db/mysql/query_factory.php:143]
#2  queryFactory->set_error() called at [/home/cpanel/public_html/includes/classes/db/mysql/query_factory.php:270]
#3  queryFactory->Execute() called at [/home/cpanel/public_html/adminfolderemail_export.php:89]
--> PHP Warning: Use of undefined constant DB_ERROR_NOT_CONNECTED - assumed 'DB_ERROR_NOT_CONNECTED' (this will throw an Error in a future version of PHP) in /home/cpanel/public_html/includes/classes/db/mysql/query_factory.php on line 152.

[23-Jul-2020 10:45:19 America/Los_Angeles] Request URI: /adminfolderemail_export.php?action=save, IP address: xxx.yyy.zzz107
#1  trigger_error() called at [/home/cpanel/public_html/includes/classes/db/mysql/query_factory.php:171]
#2  queryFactory->show_error() called at [/home/cpanel/public_html/includes/classes/db/mysql/query_factory.php:143]
#3  queryFactory->set_error() called at [/home/cpanel/public_html/includes/classes/db/mysql/query_factory.php:270]
#4  queryFactory->Execute() called at [/home/cpanel/public_html/adminfolderemail_export.php:89]
--> PHP Fatal error: 0: ::  ==> (as called by) /home/cpanel/public_html/adminfolderemail_export.php on line 89 <== in /home/cpanel/public_html/includes/classes/db/mysql/query_factory.php on line 171.
from query_factory in db
query name:
Code:
Dormant Customers (>3months)(Order > $10 (Subscribers)
query description:
Code:
Subscribers who HAVE made a purchase over $10, but have NOT purchased for at least three months.
query string:
Code:
select o.date_purchased, c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c, TABLE_ORDERS o WHERE c.customers_id = o.customers_id AND
o.order_total > 10 AND
c.customers_newsletter = 1 GROUP BY c.customers_email_address HAVING max(o.date_purchased) <= subdate(now(),INTERVAL 3 MONTH) ORDER BY c.customers_lastname, c.customers_firstname ASC