Re: [lms] mysql error

Karol wrote:

W bazie danych wystapily mi błedy jak to naprawić?

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'

jakie wersje lmsa, bazy? jaki moduł?