Witam
Po dodaniu kilku urzadzen do sieci w lmsie zaczal wystepowac przy wyswietlaniu listy klientow nastepujacy blad:
Napotkano błędy w bazie 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: Got error 28 from table handler
Jak wejde juz do karty ktoregos z klientow po nazwie badz numerze ID pokazuje sie blad nastepujacy:
Zapytanie: SELECT customergroups.id AS id, name, customerid FROM customergroups LEFT JOIN customerassignments ON (customergroups.id=customergroupid AND customerid = '5') GROUP BY customergroups.id, name, customerid HAVING customerid IS NULL ORDER BY name Błąd: Got error 28 from table handler
Teraz pytanie z jakiego powodu wystepuje ten blad ? Dodam jeszcze ze zostala dodana jeszcze jedna siec w bazie. Wykasowalem to co dodalem i w dalszym ciagu blad wystepuje...