View | Details | Raw Unified | Return to bug 26995
Collapse All | Expand All

(-)a/about.pl (-7 / +2 lines)
Lines 496-512 $template->param( 'bad_yaml_prefs' => \@bad_yaml_prefs ) if @bad_yaml_prefs; Link Here
496
{
496
{
497
    my $dbh   = C4::Context->dbh;
497
    my $dbh   = C4::Context->dbh;
498
    my ($bad_relationships_count) = $dbh->selectall_arrayref(q{
498
    my ($bad_relationships_count) = $dbh->selectall_arrayref(q{
499
        SELECT COUNT(*)
499
        SELECT COUNT(*) FROM borrower_relationships WHERE relationship='_bad_data'
500
        FROM (
501
            SELECT relationship FROM borrower_relationships WHERE relationship='_bad_data'
502
    });
500
    });
503
501
504
    $bad_relationships_count = $bad_relationships_count->[0]->[0];
502
    $bad_relationships_count = $bad_relationships_count->[0]->[0];
505
503
506
    my $existing_relationships = $dbh->selectall_arrayref(q{
504
    my $existing_relationships = $dbh->selectall_arrayref(q{
507
          SELECT DISTINCT(relationship)
505
          SELECT DISTINCT(relationship) FROM borrower_relationships WHERE relationship IS NOT NULL
508
          FROM (
509
              SELECT relationship FROM borrower_relationships WHERE relationship IS NOT NULL
510
    });
506
    });
511
507
512
    my %valid_relationships = map { $_ => 1 } split( /,|\|/, C4::Context->preference('borrowerRelationship') );
508
    my %valid_relationships = map { $_ => 1 } split( /,|\|/, C4::Context->preference('borrowerRelationship') );
513
- 

Return to bug 26995