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