<style type="text/css">!--
@page { size: 8.5in 11in; margin: 0.79in }
P { margin-bottom: 0.08in }
-->
</style>
<p style="margin-bottom: 0in; font-style: normal;">
<font face="Times New Roman, serif">Hallo - and sorry for the delay
in this. </font>
</p>
<p style="margin-bottom: 0in; font-style: normal;">
<br>
</p>
<p style="margin-bottom: 0in; font-style: normal;">
<font face="Times New Roman, serif">I'm still trying to have Koha
2.2.7 working with MySQL 5 (on Debian Etch). </font>
</p>
<p style="margin-bottom: 0in;"><br>
</p>
<p style="margin-bottom: 0in;">I still can not find books that I've
catalogued – neither through the Web-OPAC nor through the staff
Intranet Catalogue search.
</p>
<p style="margin-bottom: 0in;"><br>
</p>
<p style="margin-bottom: 0in;">I do see the book in MySQL - in the
"biblio" table.</p><p style="margin-bottom: 0in;">[code]
</p>
<p style="margin-bottom: 0in;"> mysql> SELECT biblionumber, author,
title, unititle, timestamp</p>
<p style="margin-bottom: 0in;"> -> FROM biblio</p>
<p style="margin-bottom: 0in;"> -> WHERE author = 'OrenM';</p>
<p style="margin-bottom: 0in;"> +--------------+--------+--------------+----------+---------------------+</p>
<p style="margin-bottom: 0in;"> | biblionumber | author | title
| unititle | timestamp |</p>
<p style="margin-bottom: 0in;"> +--------------+--------+--------------+----------+---------------------+</p>
<p style="margin-bottom: 0in;"> | 1 | OrenM | Hallo World
| NULL | 2006-12-13 18:21:21 |</p>
<p style="margin-bottom: 0in;"> +--------------+--------+--------------+----------+---------------------+</p>
<p style="margin-bottom: 0in;"> 1 row in set (0.00 sec)</p>
<p style="margin-bottom: 0in;"> mysql></p>
<p style="margin-bottom: 0in;">[/code]</p><p style="margin-bottom: 0in;"><br>
</p>
<p style="margin-bottom: 0in;">Here are the change that I have made:
</p>
<p style="margin-bottom: 0in;">-----------------------------------------</p>
<p style="margin-bottom: 0in;">A.1
</p>
<p style="margin-bottom: 0in;">Additions in:
~/koha/koha-2.2.7/modules/C4/Search.pm</p>
<p style="margin-bottom: 0in;">lines 915 - 923 - added brackets after
the "left join additionalauthors on"</p>
<p style="margin-bottom: 0in;"><br></p><p style="margin-bottom: 0in;">[code]</p>
<p style="margin-bottom: 0in;"><br>$query="select
*,biblio.author,biblio.biblionumber from</p>
<p style="margin-bottom: 0in;"> biblio</p>
<p style="margin-bottom: 0in;"> left join additionalauthors</p>
<p style="margin-bottom: 0in;"> on
(additionalauthors.biblionumber =biblio.biblionumber)</p>
<p style="margin-bottom: 0in;"> where</p>
<p style="margin-bottom: 0in;"> ((biblio.author like ? or
biblio.author like ? or</p>
<p style="margin-bottom: 0in;"> additionalauthors.author like ?
or additionalauthors.author</p>
<p style="margin-bottom: 0in;"> like ?</p>
<p style="margin-bottom: 0in;"> )";</p>
<p style="margin-bottom: 0in;"> </p>
<p style="margin-bottom: 0in;">[/code]</p>
<p style="margin-bottom: 0in;"><br>-----------------------------------------
</p>
<p style="margin-bottom: 0in; line-height: 100%;">A.2</p>
<p style="margin-bottom: 0in; line-height: 100%;">Additions in:
~/koha/koha-2.2.7/modules/C4/Search.pm</p>
<p style="margin-bottom: 0in; line-height: 100%;">lines 1304-1305-
added brackets after the "left join itemtypes on"</p>
<p style="margin-bottom: 0in; line-height: 100%;"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%;">[code]</p>
<p style="margin-bottom: 0in;"> my $query = "SELECT
*,items.notforloan as itemnotforloan FROM items, biblio, biblioitems
</p>
<p style="margin-bottom: 0in;"> left join itemtypes on
(biblioitems.itemtype = itemtypes.itemtype)
</p>
<p style="margin-bottom: 0in;">[/code]</p>
<p style="margin-bottom: 0in;"></p><p style="margin-bottom: 0in;">-----------------------------------------
</p>
<p style="margin-bottom: 0in; line-height: 100%;">B.1</p>
<p style="margin-bottom: 0in;"><br>Additions in:
~/koha/koha-2.2.7/modules/C4/SearchMarc.pm</p>
<p style="margin-bottom: 0in;">lines 383-387</p>
<p style="margin-bottom: 0in;">brackets after the "LEFT JOIN
biblioitems on"</p>
<p style="margin-bottom: 0in;">and
</p>
<p style="margin-bottom: 0in;">brackets after the "LEFT JOIN
itemtypes on"
</p>
<p style="margin-bottom: 0in;">[code]</p>
<p style="margin-bottom: 0in;"> $sth = $dbh->prepare("SELECT
biblio.biblionumber as bn,biblioitems.*,biblio.*,
marc_biblio.bibid,itemtypes.notforloan,itemtypes.description</p>
<p style="margin-bottom: 0in;"> FROM marc_biblio, biblio
</p>
<p style="margin-bottom: 0in;"> LEFT JOIN biblioitems on
(biblio.biblionumber = biblioitems.biblionumber)
</p>
<p style="margin-bottom: 0in;"> LEFT JOIN itemtypes on
(itemtypes.itemtype=biblioitems.itemtype)
</p>
<p style="margin-bottom: 0in;"> WHERE biblio.biblionumber =
marc_biblio.biblionumber AND bibid = ?");</p>
<p style="margin-bottom: 0in;">[/code]</p>
<p style="margin-bottom: 0in;">-----------------------------------------</p><br><p style="margin-bottom: 0in;"><br></p>WHat else should be done?? <br><br>Best regards <br>(& a Happy New Year!)<br><br>Oren Maurer<br>
<p style="margin-bottom: 0in;">-----------------------------------------
</p>
<br><br><div><span class="gmail_quote">On 12/7/06, <b class="gmail_sendername">Alex King</b> <<a href="mailto:alex@king.net.nz">alex@king.net.nz</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
So did you modify (or verify, I haven't looked at what's in 2.2.7) the<br>two modules <a href="http://Search.pm">Search.pm</a> and SearchMarc.pm as listed in Dana's email? That<br>was all that was necessary to get
2.2.5 search function working.<br><br>Perhaps you could execute the same searches yourself in the mysql client<br>and see what the results are?<br><br>Cheers,<br><br>Alex<br><br><br>oren maurer wrote:<br>><br>> Hi all
<br>><br>> 1.<br>> In spite of the known incompatibility of current version (2.2.7) with<br>> MySQL 5.0, I do want to try having it working (I have Debian Etch I<br>> had troubles downgrading to MySQL 4.1).
<br>><br>> I succeeded with installation of 2.2.7.<br>><br>> 2.<br>> The first problem I see:<br>> I can use catalogue to add book, and than see it in the database using<br>> MySQL-ADMIN<br>><br>
> But I can not see it by using search.<br>><br>> Could it be connected to the MySQL version?<br>><br>> 3.<br>> I read and tried the suggestion of Dana Huff (even though it was for<br>> 2.2.5) in <a href="http://lists.katipo.co.nz/pipermail/koha/2006/010477.html">
http://lists.katipo.co.nz/pipermail/koha/2006/010477.html</a><br>> Where it's written: "... there are a couple of modules that must be<br>> modified"<br>><br>><br>><br>> This didn't help here.
<br>><br>><br>><br>> Any ideas??<br>><br>><br>><br>> Thanks<br>><br>><br>><br>> --<br>> ________________________________<br>> Oren Maurer<br>> _______________________________
<br>><br>> ------------------------------------------------------------------------<br>><br>> _______________________________________________<br>> Koha mailing list<br>> <a href="mailto:Koha@lists.katipo.co.nz">
Koha@lists.katipo.co.nz</a><br>> <a href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>><br></blockquote></div><br><br clear="all"><br>-- <br>________________________________
<br> Oren Maurer <br> <a href="http://www.meorero.org.il">http://www.meorero.org.il</a> <br> _______________________________<br> # =======================|<br> # Please avoid sending me Word |<br> # or PowerPoint attachments |
<br> # =======================|<br> # See: <a href="http://www.gnu.org/philosophy/no-word-attachments.html">http://www.gnu.org/philosophy/no-word-attachments.html</a>