Hallo - and sorry for the delay in this.

I'm still trying to have Koha 2.2.7 working with MySQL 5 (on Debian Etch).

I still can not find books that I've catalogued – neither through the Web-OPAC nor through the staff Intranet Catalogue search.

I do see the book in MySQL - in the "biblio" table.

[code]

      mysql> SELECT biblionumber, author, title, unititle, timestamp

       -> FROM biblio

       -> WHERE author = 'OrenM';

      +--------------+--------+--------------+----------+---------------------+

      | biblionumber | author | title | unititle | timestamp |

     +--------------+--------+--------------+----------+---------------------+

      | 1 | OrenM | Hallo World | NULL | 2006-12-13 18:21:21 |

      +--------------+--------+--------------+----------+---------------------+

      1 row in set (0.00 sec)

      mysql>

[/code]

Here are the change that I have made:

-----------------------------------------

A.1

Additions in: ~/koha/koha-2.2.7/modules/C4/Search.pm

lines 915 - 923 - added brackets after the "left join additionalauthors on"

[code]

$query="select *,biblio.author,biblio.biblionumber from

biblio

left join additionalauthors

on (additionalauthors.biblionumber =biblio.biblionumber)

where

((biblio.author like ? or biblio.author like ? or

additionalauthors.author like ? or additionalauthors.author

like ?

)";

[/code]

-----------------------------------------

A.2

Additions in: ~/koha/koha-2.2.7/modules/C4/Search.pm

lines 1304-1305- added brackets after the "left join itemtypes on"

[code]

my $query = "SELECT *,items.notforloan as itemnotforloan FROM items, biblio, biblioitems

left join itemtypes on (biblioitems.itemtype = itemtypes.itemtype)

[/code]

-----------------------------------------

B.1

Additions in: ~/koha/koha-2.2.7/modules/C4/SearchMarc.pm

lines 383-387

brackets after the "LEFT JOIN biblioitems on"

and

brackets after the "LEFT JOIN itemtypes on"

[code]

$sth = $dbh->prepare("SELECT biblio.biblionumber as bn,biblioitems.*,biblio.*, marc_biblio.bibid,itemtypes.notforloan,itemtypes.description

FROM marc_biblio, biblio

LEFT JOIN biblioitems on (biblio.biblionumber = biblioitems.biblionumber)

LEFT JOIN itemtypes on (itemtypes.itemtype=biblioitems.itemtype)

WHERE biblio.biblionumber = marc_biblio.biblionumber AND bibid = ?");

[/code]

-----------------------------------------

-----------------------------------------