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!
--
Pozdrawiam!
Maciej Drobniuch
