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

(-)a/C4/Category.pm (-1 / +1 lines)
Lines 79-85 sub all { Link Here
79
    my $dbh = C4::Context->dbh;
79
    my $dbh = C4::Context->dbh;
80
    # The categories table is small enough for
80
    # The categories table is small enough for
81
    # `SELECT *` to be harmless.
81
    # `SELECT *` to be harmless.
82
    my $query = "SELECT * FROM categories";
82
    my $query = "SELECT categories.* FROM categories";
83
    $query .= qq{
83
    $query .= qq{
84
        LEFT JOIN categories_branches ON categories_branches.categorycode = categories.categorycode
84
        LEFT JOIN categories_branches ON categories_branches.categorycode = categories.categorycode
85
        WHERE categories_branches.branchcode = ? OR categories_branches.branchcode IS NULL
85
        WHERE categories_branches.branchcode = ? OR categories_branches.branchcode IS NULL
(-)a/C4/Members.pm (-2 / +1 lines)
Lines 1491-1497 sub GetBorrowercategoryList { Link Here
1491
        ? 0
1491
        ? 0
1492
        : C4::Context->userenv ? C4::Context->userenv->{"branch"} : "";
1492
        : C4::Context->userenv ? C4::Context->userenv->{"branch"} : "";
1493
    my $dbh       = C4::Context->dbh;
1493
    my $dbh       = C4::Context->dbh;
1494
    my $query = "SELECT * FROM categories";
1494
    my $query = "SELECT categories.* FROM categories";
1495
    $query .= qq{
1495
    $query .= qq{
1496
        LEFT JOIN categories_branches ON categories.categorycode = categories_branches.categorycode
1496
        LEFT JOIN categories_branches ON categories.categorycode = categories_branches.categorycode
1497
        WHERE branchcode = ? OR branchcode IS NULL GROUP BY description
1497
        WHERE branchcode = ? OR branchcode IS NULL GROUP BY description
1498
- 

Return to bug 7919