----- Original Message ----- From: "Matys Łukasz" <lukasz@e-matys.com> To: "lista użytkowników LMS" <lms@lists.lms.org.pl> Sent: Thursday, October 22, 2009 10:09 PM Subject: Re: [lms] Upgrade do 1.11.8 Przed updatem, dodaj do my.cnf [mysqld] set-variable=log_bin_trust_function_creators=1 I dopiero upgrade. Pozdrawiam. -- Matys Łukasz mobile: (+ 48) 504257944 gg: 6808288 Red Hat Certified Engineer CN: 805008539731256 _______________________________________________ Zrobilem jak radziles i na ekranie logowania owszem nie mam już błędów, ale za to po zalogowaniu, nie mam np. żadnej sieci IP, a przy próbie przeglądania ich list mam błąd: Wystąpiły błędy w obsłudze bazy danych! Zapytanie: SELECT id, name, inet_ntoa(address) AS address, address AS addresslong, mask, interface, gateway, dns, dns2, domain, wins, dhcpstart, dhcpend, mask2prefix(inet_aton(mask)) AS prefix, broadcast(address, inet_aton(mask)) AS broadcastlong, inet_ntoa(broadcast(address, inet_aton(mask))) AS broadcast, pow(2,(32 - mask2prefix(inet_aton(mask)))) AS size, disabled, (SELECT COUNT(*) FROM nodes WHERE (ipaddr >= address AND ipaddr <= broadcast(address, inet_aton(mask))) OR (ipaddr_pub >= address AND ipaddr_pub <= broadcast(address, inet_aton(mask))) ) AS assigned, (SELECT COUNT(*) FROM nodes WHERE ((ipaddr >= address AND ipaddr <= broadcast(address, inet_aton(mask))) OR (ipaddr_pub >= address AND ipaddr_pub <= broadcast(address, inet_aton(mask)))) AND (UNIX_TIMESTAMP() - lastonline < 600) ) AS online FROM networks ORDER BY name Błąd: FUNCTION lms.mask2prefix does not exist Domyślam się że błąd ten jest spowodowany brakiem funkcji lms.mask2prefix ale nie wiem co to i jak to uruchomic. Pomóżcie proszę. pozdr. McX