Query Factory / Query Builder Fails

[bumba000]

Hi All,
Running ZC 1.5.5e on php 7.0. In preparing to send a newsletter using the "dormant customers" query

select c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c, TABLE_ORDERS o where c.customers_newsletter = '1' AND c.customers_id = o.customers_id and o.date_purchased > subdate(now(),INTERVAL 3 MONTH) GROUP BY c.customers_email_address, c.customers_lastname, c.customers_firstname order by c.customers_lastname, c.customers_firstname ASC

I get the following debug log

[04-Dec-2018 14:14:19 America/New_York] Request URI: /admin/newsletters.php?page=1&nID=40&action=confirm, IP address: 24.154.59.125
#1  mysqli_query() called at [/home/acctss/public_html/includes/classes/db/mysql/query_factory.php:45]
#2  queryFactory->query() called at [/home/acctss/public_html/includes/classes/db/mysql/query_factory.php:257]
#3  queryFactory->Execute() called at [/home/acctss/public_html/admin/includes/modules/newsletters/newsletter.php:52]
#4  newsletter->confirm() called at [/home/acctss/public_html/admin/newsletters.php:324]

[04-Dec-2018 14:14:19 America/New_York] PHP Warning:  mysqli_query(): Empty query in /home/acctss/public_html/includes/classes/db/mysql/query_factory.php on line 45
[04-Dec-2018 14:14:19 America/New_York] Request URI: /admin/newsletters.php?page=1&nID=40&action=confirm, IP address: 24.154.59.125
#1  trigger_error() called at [/home/acctss/public_html/includes/classes/db/mysql/query_factory.php:167]
#2  queryFactory->show_error() called at [/home/acctss/public_html/includes/classes/db/mysql/query_factory.php:139]
#3  queryFactory->set_error() called at [/home/acctss/public_html/includes/classes/db/mysql/query_factory.php:266]
#4  queryFactory->Execute() called at [/home/acctss/public_html/admin/includes/modules/newsletters/newsletter.php:52]
#5  newsletter->confirm() called at [/home/acctss/public_html/admin/newsletters.php:324]

[04-Dec-2018 14:14:19 America/New_York] PHP Fatal error:  0: ::  ==> (as called by) /home/acctss/public_html/admin/includes/modules/newsletters/newsletter.php on line 52 <== in /home/acctss/public_html/includes/classes/db/mysql/query_factory.php on line 167

All other groups seem to be working without issue. Limiting to 10 records, changing to order DESC doesn't help. I get a white page with warning an error occurred etc...

Thank You,
John

[bumba000]

The problem was in the query_name. Dormant Customers (>3months) (Subscribers)
Removed the brackets and greater than and it works just fine. strange...

Thank you John