Wystąpiły błędy w obsłudze bazy danych!
Zapytanie: SELECT customers.id AS id, CONCAT(UPPER(lastname), ' ', customers.name) AS customername, status, address, zip, city, email, phone1, ten, ssn, customers.info AS info, message, COALESCE(SUM(value), 0.00) AS balance FROM customers LEFT JOIN cash ON (customers.id=cash.customerid) WHERE deleted = 0 GROUP BY customers.id, lastname, customers.name, status, address, zip, city, email, phone1, ten, ssn, customers.info, message ORDER BY customername asc
Błąd: Unknown column 'phone1' in 'field list'