GX-Entwicklung

Using MariaDB 10.3 or MySQL 5.7 for example causes an error on the Gambio Admin > Statistics > Overview > Customers page. A simple adjustment of a SQL query solves the problem.

SELECT COUNT(customers_id) AS totalCustomers, SUM(customers_newsletter) AS subscribers FROM customers WHERE (account_type = 0) AND (customers_status != 0);

instead of

SELECT COUNT(customers_id) AS totalCustomers, COUNT((SELECT customers_newsletter WHERE customers_newsletter = 1)) AS subscribers FROM customers WHERE (account_type = 0) AND (customers_status != 0)