[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