Witam! Problem polega na tym ze mam baze lms i musze wrzucic do lms z wersji 1.11.8 Belus (1.981/1.23) I tak tez zrobiłem Jednakże przeglądając klientów pojawia mi się: Database errors occurred! *Query:* 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 *Error:* Table 'lms.customersview' doesn't exist *Query:* SELECT id, name, inet_ntoa(address) AS address, address AS addresslong, mask, mask2prefix(inet_aton(mask)) AS prefix, disabled FROM networks ORDER BY name *Error:* FUNCTION lms.mask2prefix does not exist *Query:* 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 *Error:* FUNCTION lms.lms_current_user does not exist
Gdzieś na grupie znalazłem ze trzeba dodać customersview
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)
jednak wywala: #1305 - FUNCTION lms.lms_current_user does not exist
Dodałem: SET GLOBAL log_bin_trust_function_creators =1;
I dalej niestety to samo :( Co robię źle ? Dzieki i pozdrawiam!