[Koha-cvs] koha/C4 Search.pm [dev_week]

[Mason James]

CVSROOT:	/sources/koha
Module name:	koha
Branch:		dev_week
Changes by:	Mason James <sushi>	07/05/16 00:04:14

Modified files:
	C4             : Search.pm 

Log message:
	fixing sql for mysql5 in bibidata()

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Search.pm?cvsroot=koha&only_with_tag=dev_week&r1=1.99.2.11.2.40&r2=1.99.2.11.2.41

Patches:
Index: Search.pm
===================================================================
RCS file: /sources/koha/koha/C4/Search.pm,v
retrieving revision 1.99.2.11.2.40
retrieving revision 1.99.2.11.2.41
diff -u -b -r1.99.2.11.2.40 -r1.99.2.11.2.41
--- Search.pm	9 May 2007 19:41:06 -0000	1.99.2.11.2.40
+++ Search.pm	16 May 2007 00:04:14 -0000	1.99.2.11.2.41
@@ -40,7 +40,7 @@
 use vars qw($VERSION @ISA @EXPORT @EXPORT_OK %EXPORT_TAGS);
 
 # set the version for version checking
-$VERSION = do { my @v = '$Revision: 1.99.2.11.2.40 $' =~ /\d+/g;
+$VERSION = do { my @v = '$Revision: 1.99.2.11.2.41 $' =~ /\d+/g;
           shift(@v) . "." . join("_", map {sprintf "%03d", $_ } @v); };
 
 =head1 NAME
@@ -1456,7 +1456,7 @@
 	my ($bibnum, $type) = @_;
 	my $dbh   = C4::Context->dbh;
 	my $sth   = $dbh->prepare("Select *, biblioitems.notes AS bnotes, biblio.notes
-								from biblio, biblioitems
+								from (biblio, biblioitems)
 								left join bibliosubtitle on
 								biblio.biblionumber = bibliosubtitle.biblionumber
 								left join itemtypes on biblioitems.itemtype=itemtypes.itemtype