On Mon, 18 Feb 2008 16:04:20 +0100, tdabek wrote
Dariusz Kowalczyk pisze:
Po dzisiejszym upgrade mam przy wejsciu na liste sieci
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, (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
U mnie nie zaobserwowalem tego problemu.
-- Pozdrawiam Tomasz Dąbek [Thomas] [gg:14553 mail:tdabek_NO_@go2.pl]
lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms
no u mnie jest :-) a używam cvs-a od roku i co 2 tygodnie robie update z cvs-a bo dzisiejszym update sie sypneło ....mam nadzieje ze ich tylko nie wyswietla bo sieci to tam jest prawie 100 :_)
Dariusz Kowalczyk
!DSPAM:47b9a33643491804284693!