GX-Bug #70067
Von Moritz Bunjes vor mehr als 1 Jahr aktualisiert
Even though we no longer support outdated database versions, the solution to display the Gambio Admin > Statistics > Overview > Customers page without errors is a simple adjustment of an SQL command. To keep support issues low, the SQL command should be `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)` MariaDB 10.3 MySQL 5.5 for example does not support the second SQL query.