@@ -, +, @@ --- C4/Category.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) --- a/C4/Category.pm +++ a/C4/Category.pm @@ -79,7 +79,7 @@ sub all { my $dbh = C4::Context->dbh; # The categories table is small enough for # `SELECT *` to be harmless. - my $query = "SELECT * FROM categories"; + my $query = "SELECT *, categories.categorycode as categorycode FROM categories"; $query .= qq{ LEFT JOIN categories_branches ON categories_branches.categorycode = categories.categorycode WHERE categories_branches.branchcode = ? OR categories_branches.branchcode IS NULL --