Hi,
Today I discovered that i can't edit or create contacts in Opsview any
more. Every time I try I get the following exception:
Errors encountered: Caught exception in
Opsview::Web::Controller::Admin::Contact->save
"DBIx::Class::ResultSet::delete(): DBI Exception: DBD::mysql::st execute
failed: Unknown column 'contactid' in 'where clause' [for Statement
"DELETE FROM notificationprofile_hostgroups WHERE ( ( hostgroupid NOT IN (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ? ) AND contactid = ? ) )" with ParamValues: 0='149', 1='96',
2='147', 3='127', 4='141', 5='122', 6='121', 7='156', 8='58', 9='157',
10='68', 11='90', 12='94', 13='19', 14='148', 15='98', 16='130', 17='159',
18='139', 19='67', 20='89', 21='124', 22='125', 23='108', 24='111',
25='91', 26='31', 27='71', 28='65', 29='95', 30='129', 31='20', 32='123',
33='103', 34='76', 35='126', 36='77', 37='33', 38='138', 39='99',
40='118', 41='112', 42='114', 43='155', 44='5', 45='116', 46='153',
47='158', 48='151', 49='78', 50='113', 51='154', 52='115', 53='22',
54='117', 55='56', 56='133', 57='100', 58='41', 59='120', 60='142',
61='64', 62='93', 63='8', 64='69', 65='29', 66='81', 67='131', 68='74',
69='79', 70='101', 71='36', 72='62', 73='24', 74='135', 75='92', 76='160',
77='140', 78='72', 79='995'] at
/usr/local/nagios/lib/Opsview/ResultSet/Contacts.pm line 103"
I already figured out, that the Table "notificationprofile_hostgroups" is
empty. Is this perhaps the problem?
I'm using Opsview 3.7.0 on Debian Lenny.
Any Ideas?
Thanks
Michael
_______________________________________________
Opsview-users mailing list
Opsview-users@lists.opsview.org
http://lists.opsview.org/lists/listinfo/opsview-users
