hmm i might have forgotten to add the "*" when doing: cat docs/upgrade/mysql/jffnms-0.7.9-to-0.8.0.mysql.diff* | mysql -u jffnms -pjffnms jffnms
It is working now. *goes hiding in a corner shaming himself Alex Quoting [EMAIL PROTECTED]: > > > 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 > ---------------------------------------------------------------- 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
