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

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

Return to bug 28490