Sproboj to recznie zrobic np w phpmyadmin
CREATE VIEW customersview AS SELECT c.* FROM customers c WHERE NOT EXISTS ( SELECT 1 FROM customerassignments a JOIN excludedgroups e ON (a.customergroupid = e.customergroupid) WHERE e.userid = lms_current_user() AND a.customerid = c.id);
---- Wiadomość Oryginalna ---- Od: R99 na wp r99@wp.pl Do: 'lista użytkowników LMS' lms@lists.lms.org.pl Data: 31 marca 2009 13:15 Temat: [lms] customerview
Dzień Dobry
NIe moge przejsc z wersji 1.9.4 na 1.11.x dostaje takie bledy , probowalem stworzyc te widoki, ale nie widze w lms.mysql definicji tego widoku/tabel, co z tym zrobic ?
Wersja LMS: 1.11.7 Bastet (1.962/1.23) Wersja LMSDB: 1.11.7 Bastet (1.47/1.54) Wersja MySQL: 5.0.32-Debian_7etch8-log Wersja PHP: 5.2.0-8+etch13 Wersja Smarty: 2.6.22
Wystąpiły błędy w obsłudze bazy danych! Zapytanie: SELECT c.id AS id, CONCAT(UPPER(lastname), ' ', c.name) AS customername, status, address, zip, city, countryid, countries.name AS country, email, ten, ssn, c.info AS info, message, c.divisionid, c.paytime AS paytime, (SELECT COALESCE(SUM(value),0) FROM cash WHERE customerid = c.id ) AS balance FROM customersview c LEFT JOIN countries ON c.countryid = countries.id WHERE deleted = 0 ORDER BY customername asc Błąd: Table 'lms.customersview' doesn't exist Zapytanie: SELECT id, name, inet_ntoa(address) AS address, address AS addresslong, mask, mask2prefix(inet_aton(mask)) AS prefix FROM networks ORDER BY name Błąd: FUNCTION lms.mask2prefix does not 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: Table 'lms.excludedgroups' doesn't exist Zapytanie: SELECT id, name, description FROM nodegroups ORDER BY name ASC Błąd: Table 'lms.nodegroups' doesn't exist
-- Pozdrowienia, Rafał
lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms
!DSPAM:49d1fc5d158667818312239!