GX-Bug #70067
Von Moritz Bunjes vor mehr als 1 Jahr aktualisiert
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)`