Issue: DE6866 Can't call method "title" on an undefined value at /usr/local/airwave/lib/perl/Mercury/DB/View
If you see page crash on Report > Generated page like this:
[Mon Oct 11 13:54:55 2010] [error] [client 127.0.0.1] Can't call method "title" on an undefined value at /usr/local/airwave/lib/perl/Mercury/DB/View/ReportList.pm line 30.
You can fix it with this command:
# select id from report where id not in (select report_id from report_definition where report_id is not null);
# dbc "delete from report where id not in (select report_id from report_definition where report_id is not null);"
this is fixed in 7.2
[Mon Oct 11 13:54:55 2010] [error] [client 127.0.0.1] Can't call method "title" on an undefined value at /usr/local/airwave/lib/perl/Mercury/DB/View/ReportList.pm line 30.
at /usr/local/airwave/lib/perl/Mercury/DB/View/ReportList.pm line 30
Mercury::DB::View::ReportList::title('Mercury::DB::View::ReportList=HASH(0x2586d0c4)') called at /usr/local/airwave/lib/perl/Mercury/Handler/Table/ColumnDB.pm line 183
Mercury::Handler::Table::ColumnDB::value_for_row('Mercury::Handler::Table::ColumnDB=HASH(0x258676bc)', 'Mercury::DB::View::ReportList=HASH(0x2586d0c4)') called at /usr/local/airwave/lib/perl/Mercury/Handler/Table/ColumnDB.pm line 165
Mercury::Handler::Table::ColumnDB::_get('Mercury::Handler::Table::ColumnDB=HASH(0x258676bc)', 'display_html', 'Mercury::DB::View::ReportList=HASH(0x2586d0c4)') called at /usr/local/airwave/lib/perl/Mercury/Handler/Table/ColumnDB.pm line 156
Mercury::Handler::Table::ColumnDB::get_html('Mercury::Handler::Table::ColumnDB=HASH(0x258676bc)', 'Mercury::DB::View::ReportList=HASH(0x2586d0c4)') called at /usr/local/airwave/lib/perl/Mercury/Handler/ListEdit/List.pm line 1164
Mercury::Handler::ListEdit::List::get_row('Mercury::Handler::Reports::Generated::List=HASH(0x25677d64)', 'Mercury::DB::View::ReportList=HASH(0x2586d0c4)', 'Mercury::Apache::Request=HASH(0x25732b2c)', 'ARRAY(0x1209f26c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/ListEdit/List.pm line 1051
Mercury::Handler::ListEdit::List::inject_row('Mercury::Handler::Reports::Generated::List=HASH(0x25677d64)', 'Mercury::Apache::Request=HASH(0x25732b2c)', 'Mercury::DB::View::ReportList=HASH(0x2586d0c4)', 'ARRAY(0x1209f26c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/ListEdit/List.pm line 1044
Mercury::Handler::ListEdit::List::inject_rows('Mercury::Handler::Reports::Generated::List=HASH(0x25677d64)', 'Mercury::Apache::Request=HASH(0x25732b2c)', 'Mercury::DB::View::ReportList=HASH(0x2586d0c4)') called at /usr/local/airwave/lib/perl/Mercury/Handler/ListEdit/List.pm line 590
Mercury::Handler::ListEdit::List::_paint('Mercury::Handler::Reports::Generated::List=HASH(0x25677d64)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 600
Mercury::Handler::View::paint('Mercury::Handler::Reports::Generated::List=HASH(0x25677d64)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 568
Mercury::Handler::View::embed('Mercury::Handler::Reports::Generated::List=HASH(0x25677d64)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 463
eval {...} called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 462
Mercury::Handler::View::embed_children('Mercury::Handler::Reports::Generated::Container=HASH(0x257279fc)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 418
Mercury::Handler::View::paint_children('Mercury::Handler::Reports::Generated::Container=HASH(0x257279fc)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 602
Mercury::Handler::View::paint('Mercury::Handler::Reports::Generated::Container=HASH(0x257279fc)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 568
Mercury::Handler::View::embed('Mercury::Handler::Reports::Generated::Container=HASH(0x257279fc)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View/Ordered.pm line 61
Mercury::Handler::View::Ordered::embed_children('Mercury::Handler::View::Ordered=HASH(0x2573a59c)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 418
Mercury::Handler::View::paint_children('Mercury::Handler::View::Ordered=HASH(0x2573a59c)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 602
Mercury::Handler::View::paint('Mercury::Handler::View::Ordered=HASH(0x2573a59c)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 568
Mercury::Handler::View::embed('Mercury::Handler::View::Ordered=HASH(0x2573a59c)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 463
eval {...} called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 462
Mercury::Handler::View::embed_children('Mercury::Handler::Reports=HASH(0x256c6374)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 418
Mercury::Handler::View::paint_children('Mercury::Handler::Reports=HASH(0x256c6374)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 602
Mercury::Handler::View::paint('Mercury::Handler::Reports=HASH(0x256c6374)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 81
Mercury::Handler::View::build_output('Mercury::Handler::Reports=HASH(0x256c6374)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/Dispatcher.pm line 143
Mercury::Handler::Dispatcher::__ANON__() called at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 414
eval {...} called at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 401
Mercury::DB::Q::_run_then_do('Mercury::DB::Q', 'CODE(0x256a6944)', 'CODE(0x256b9184)') called at /usr/local/airwave/lib/perl/Mercury/DB/Q.pm line 372
Mercury::DB::Q::run_in_transaction('Mercury::DB::Q', 'CODE(0x256a6944)') called at /usr/local/airwave/lib/perl/Mercury/Handler/Dispatcher.pm line 144
Mercury::Handler::Dispatcher::call_handler('Mercury::Handler::Dispatcher', 'Mercury::Handler::Reports=HASH(0x256c6374)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/Dispatcher.pm line 54
Mercury::Handler::Dispatcher::handler('Mercury::Handler::Dispatcher', 'Apache2::RequestRec=SCALAR(0x2569a8ec)') called at -e line 0
eval {...} called at -e line 0
at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 468
Mercury::Handler::View::embed_children('Mercury::Handler::Reports::Generated::Container=HASH(0x257279fc)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 418
Mercury::Handler::View::paint_children('Mercury::Handler::Reports::Generated::Container=HASH(0x257279fc)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 602
Mercury::Handler::View::paint('Mercury::Handler::Reports::Generated::Container=HASH(0x257279fc)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 568
Mercury::Handler::View::embed('Mercury::Handler::Reports::Generated::Container=HASH(0x257279fc)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View/Ordered.pm line 61
Mercury::Handler::View::Ordered::embed_children('Mercury::Handler::View::Ordered=HASH(0x2573a59c)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 418
Mercury::Handler::View::paint_children('Mercury::Handler::View::Ordered=HASH(0x2573a59c)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 602
Mercury::Handler::View::paint('Mercury::Handler::View::Ordered=HASH(0x2573a59c)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 568
Mercury::Handler::View::embed('Mercury::Handler::View::Ordered=HASH(0x2573a59c)', 'Mercury::Apache::Request=HASH(0x25732b2c)') called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 463
eval {...} called at /usr/local/airwave/lib/perl/Mercury/Handler/View.pm line 462
Mercury::Handler::View::embed_