count AS with group by causing error locally
Hi Ray. First and foremost I hope the treatment is going well. No urgency with this but i have an issue with a query that is working on our remote server but fails the page with a 500 error on the local server. I have tried to set PHP version the same on both.
The query is as follows:
$rsPayments = new WA_MySQLi_RS("rsPayments",$RTMFi,10);
$rsPayments->setQuery("SELECT registered_apps.acc_id, registered_apps.rtm_status, registered_apps.members, application_pcd.date_of_app, application_bi.premises_name, Count(consented_leaseholders.entry_id) AS Countentry_id FROM registered_apps INNER JOIN application_pcd ON registered_apps.app_id = application_pcd.application_id INNER JOIN application_bi ON application_pcd.application_id = application_bi.applicant_id LEFT OUTER JOIN consented_leaseholders ON application_bi.applicant_id = consented_leaseholders.app_id WHERE consented_leaseholders.fee = 'Unpaid' AND registered_apps.product_type != 'CCO' GROUP BY application_bi.premises_name ORDER BY application_pcd.date_of_app DESC");
The databases are the same remotely and locally...
I’ve attached screenshots of phpMyAdmin settings for both remote and local servers.
Any idea what’s causing it to fail locally only?
Thanks in advance!