I had 0.8.0pre2 running, but put back a copy of 0.7.9 I used to upgrade to that 0.8.0. I also put back a copy of the database I made before upgrading to 0.8.0pre2. (This all while the cronjobs might still have been running).
Then I ran the patch following the steps in UPGRADE, to 0.8.0pre3. Now I can see the list of alarms (bottom frame), a list of hosts. But as soon as I want to 'View Host Interfaces', or use the 'Interface Selector', I get the error at the end. I will try to install and upgrade from a basic 0.7.9 now if I get the time. But there is a chance I have to try another monitoring system, since i'm just an intern here. Personally I like JFFNMS though, except for the (overlapping alarms) errors I have.. Regards, Alex --------- path: http://127.0.0.1/jffnms/admin/menu_interface_list.php?type=&frame=frame2&field=client&field_id=2&field_name=Alex%20Haan --------- 11:30:13 db_ping(mysql) Connection to DB Restored... 11:30:14 db_ping(mysql) Connection to DB Restored... 11:30:16 db_ping(mysql) Connection to DB Restored... 11:30:17 db_ping(mysql) Connection to DB Restored... 11:30:18 db_ping(mysql) Connection to DB Restored... Query Failed - get_db_list() - SELECT /*! HIGH_PRIORITY */ /* get_db_list() */ interfaces.id, interfaces.host, interfaces.type, interfaces.sla, interfaces.client, interfaces.show_rootmap, interfaces.interface, interfaces.poll, interfaces.check_status, interfaces.make_sound, interfaces.creation_date, interfaces.modification_date, interfaces.last_poll_date, interfaces.rrd_mode, interfaces.poll_interval, hosts.name as host_name, hosts.ip as host_ip, hosts.show_host as host_show, hosts.poll_interval as host_poll_interval, clients.name as client_name, clients.shortname as client_shortname, slas.description as sla_description, slas.threshold as sla_threshold, pollers_groups.description as poller_group_description, interface_types.description as type_description, hosts.zone as zone, zones.zone as zone_name, zones.image as zone_image, zones.show_zone as zone_show, zones.shortname as zone_shortname, interfaces.id as aux_table_index FROM interfaces, hosts, zones, slas, clients, pollers_groups, interface_types WHERE (1=1) and zones.id = hosts.zone and slas.id = interfaces.sla and hosts.id = interfaces.host and clients.id = interfaces.client and pollers_groups.id = interfaces.poll and interface_types.id = interfaces.type and interfaces.client = 2 and interfaces.id > 1 order by interfaces.type asc, interfaces.interface desc, clients.name asc - Unknown column 'hosts.poll_interval' in 'field list' ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ jffnms-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jffnms-users
