Zaktualizowałem z 1.8.12 do 1.10rc2 i mam mały problem.
Napotkano błędy w bazie danych! *Zapytanie:* SELECT COUNT(id) FROM customersview WHERE deleted=0 *Błąd:* Table 'lms.customersview' doesn't exist *Zapytanie:* SELECT COUNT(id) FROM customersview WHERE status=3 AND deleted=0 *Błąd:* Table 'lms.customersview' doesn't exist *Zapytanie:* SELECT COUNT(id) FROM customersview WHERE status=2 AND deleted=0 *Błąd:* Table 'lms.customersview' doesn't exist *Zapytanie:* SELECT COUNT(id) FROM customersview WHERE status=1 AND deleted=0 *Błąd:* Table 'lms.customersview' doesn't exist *Zapytanie:* SELECT SUM(value) FROM cash LEFT JOIN customersview ON customerid = customersview.id WHERE deleted = 0 GROUP BY customerid HAVING SUM(value) < 0 *Błąd:* Table 'lms.customersview' doesn't exist
i np. takie:
Napotkano błędy w bazie danych! *Zapytanie:* SELECT c.id AS id, CONCAT(UPPER(lastname), ' ', c.name) AS customername, status, address, zip, city, email, ten, ssn, c.info AS info, message, (SELECT COALESCE(SUM(value),0) FROM cash WHERE customerid = c.id ) AS balance FROM customersview c WHERE deleted = 0 GROUP BY c.id, lastname, c.name, status, address, zip, city, email, ten, ssn, c.info, message ORDER BY customername asc *Błąd:* Table 'lms.customersview' doesn't exist *Zapytanie:* SELECT g.id, g.name, g.description FROM customergroups g WHERE NOT EXISTS ( SELECT 1 FROM excludedgroups WHERE userid = lms_current_user() AND customergroupid = g.id) ORDER BY g.name ASC *Błąd:* FUNCTION lms.lms_current_user does not exist
Jak to naprawić?
_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms
uczestnicy (1)
-
Konrad