My koha search no longer works after upgrading from 3.00.01.005 to 3.08.01.002. First I'll explain the details of my upgrade from July 6, 2012: *PART1: details of my upgrade* 1) On a new server I created a new Debian 6 Squeeze installation on VMware. 2) I installed Koha using apt-get 3) I uploaded the database export from my 3.0 prod system to the new Debian installation 4) I edited '/etc/koha/koha-sites.conf' to attach my new db before the install: DEFAULTSQL="/home/kohabox/koha_db_dump.201206271900.sql.gz" 5) ran koha-create --create-db kohapei. This created my db and ran the update db scripts over many hours 6) ran /usr/sbin/koha-upgrade-to-3.4. Again this took many hours. 7) At this point I can access the site and login. *PART2: Now onto the search problems* =========== /SEARCH 1/ Choose Advanced search Keyword = Math Individual libraries: All Libraries RESULTS: 3446 result(s) found for 'kw,wrdl: math' in PEI School Library System Catalog. NOTE: on the results screen I can see many items are available in many different schools. Eg. One school that has many math books is Bluefield High School. ============ /SEARCH 2/ Choose Advanced search Keyword = Math Individual libraries: Bluefield High School RESULTS: No results match your search for 'kw,wrdl: math' with limit(s): 'branch:Bluefield High School' in PEI School Library System Catalog NOTE: as I explained after 'search 1' there are may available math books at Bluefield High School. However koha cant find any. ============ /SEARCH 3/ Choose Advanced search Keyword = {any word} Individual libraries: {any choice other than "All Libraries"} RESULTS: No results match your search ============ As you can see from the results I cannot search a specific branch. Any attempt gives no results. NOTE: just to clarify the search worked fine for my 3.00.01.005 installation *PART3: observations* -zebraqueue table: before upgrade this table was empty. at some point during the running of script koha-upgrade-to-3.4 it populated this table with +385000 records. I'm not exactly sure how this works but since koha doesn't search based on the database why would it need to populate so much into this table. should this table be truncated at some point? (the koha wiki site recommends not backing this table up so I assume the contents are not critical)...is it just used to flag changes to biblios to make reindexing zebra faster? -no errors noticed in: intranet-error.log intranet-error.log.1 opac-error.log zebra-error.log zebra-output.log Final Note: One week before all this work I also completed the same steps as above for another installation on a server running Debian 6 directly...no VMware. I got ran into the same problem with the search. I'm pretty much out of ideas of what to do at this point. It seems like a did a standard upgrade for koha, but I'm not sure why I see all these search problems. If you have any Ideas of what I could try please let me know. I can provide any info you may need to see. Thanks, Ryan -- View this message in context: http://koha.1045719.n5.nabble.com/Search-not-working-after-upgrade-tp5719182... Sent from the Koha-general mailing list archive at Nabble.com.
Bonjour Monsieur Blanchard, The problem seems to be related to the branch limit. From what I saw, the branch id for Bluefield High School is 314, so the search should indicate something like : kw,wrdl: math' with limit(s):'branch:314' I would check why the branch in the request is Bluefield High School and not 314. This is problably related to the combobox from which the user pick its branch. Hope that helps, Eric Bégin Solutions inLibro inc. http://www.inLibro.com On 2012-07-10 09:00, rfblanchard wrote:
My koha search no longer works after upgrading from 3.00.01.005 to 3.08.01.002. First I'll explain the details of my upgrade from July 6, 2012:
*PART1: details of my upgrade*
1) On a new server I created a new Debian 6 Squeeze installation on VMware. 2) I installed Koha using apt-get 3) I uploaded the database export from my 3.0 prod system to the new Debian installation 4) I edited '/etc/koha/koha-sites.conf' to attach my new db before the install: DEFAULTSQL="/home/kohabox/koha_db_dump.201206271900.sql.gz" 5) ran koha-create --create-db kohapei. This created my db and ran the update db scripts over many hours 6) ran /usr/sbin/koha-upgrade-to-3.4. Again this took many hours. 7) At this point I can access the site and login.
*PART2: Now onto the search problems*
=========== /SEARCH 1/ Choose Advanced search Keyword = Math Individual libraries: All Libraries
RESULTS: 3446 result(s) found for 'kw,wrdl: math' in PEI School Library System Catalog.
NOTE: on the results screen I can see many items are available in many different schools. Eg. One school that has many math books is Bluefield High School. ============ /SEARCH 2/ Choose Advanced search Keyword = Math Individual libraries: Bluefield High School
RESULTS: No results match your search for 'kw,wrdl: math' with limit(s): 'branch:Bluefield High School' in PEI School Library System Catalog
NOTE: as I explained after 'search 1' there are may available math books at Bluefield High School. However koha cant find any. ============ /SEARCH 3/ Choose Advanced search Keyword = {any word} Individual libraries: {any choice other than "All Libraries"}
RESULTS: No results match your search ============
As you can see from the results I cannot search a specific branch. Any attempt gives no results. NOTE: just to clarify the search worked fine for my 3.00.01.005 installation
*PART3: observations* -zebraqueue table: before upgrade this table was empty. at some point during the running of script koha-upgrade-to-3.4 it populated this table with +385000 records. I'm not exactly sure how this works but since koha doesn't search based on the database why would it need to populate so much into this table. should this table be truncated at some point? (the koha wiki site recommends not backing this table up so I assume the contents are not critical)...is it just used to flag changes to biblios to make reindexing zebra faster?
-no errors noticed in: intranet-error.log intranet-error.log.1 opac-error.log zebra-error.log zebra-output.log
Final Note: One week before all this work I also completed the same steps as above for another installation on a server running Debian 6 directly...no VMware. I got ran into the same problem with the search.
I'm pretty much out of ideas of what to do at this point. It seems like a did a standard upgrade for koha, but I'm not sure why I see all these search problems. If you have any Ideas of what I could try please let me know. I can provide any info you may need to see. Thanks, Ryan
-- View this message in context: http://koha.1045719.n5.nabble.com/Search-not-working-after-upgrade-tp5719182... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi, the url is like this after a search with a branch selected: http://kohapeiadmin/cgi-bin/koha/catalogue/search.pl?idx=kw&q=math&idx=kw&idx=kw&limit=branch%3A314&sort_by=relevance notice it sets the branch based on number. however koha translates that to the name of the school and spits out this: No results match your search for 'kw,wrdl: math' with limit(s): 'branch:Bluefield High School' in PEI School Library System Catalog. I should also note that this is a clean install of 3.8 with my db migrated into it. Should I need to make changes to the koha code files just to make the search work? Is it possible this is just a db setting that needs to be updated, or perhaps something in the systempreferences that carried over from my 3.0 db that is not needed for koha 3.8. I figured this stuff would have been taken care of with the update scripts that ran against my db during the install. Ryan -- View this message in context: http://koha.1045719.n5.nabble.com/Search-not-working-after-upgrade-tp5719182... Sent from the Koha-general mailing list archive at Nabble.com.
Hi Ryan, The URL looks fine to me. I forgot that the school code was translated when displayed. Can you take a look in your database to check what are the homebranch and holdingbranch of a bibliographic record located at Bluefield High School ? Eric On 2012-07-11 08:39, rfblanchard wrote:
Hi, the url is like this after a search with a branch selected: http://kohapeiadmin/cgi-bin/koha/catalogue/search.pl?idx=kw&q=math&idx=kw&idx=kw&limit=branch%3A314&sort_by=relevance
notice it sets the branch based on number.
however koha translates that to the name of the school and spits out this: No results match your search for 'kw,wrdl: math' with limit(s): 'branch:Bluefield High School' in PEI School Library System Catalog.
I should also note that this is a clean install of 3.8 with my db migrated into it. Should I need to make changes to the koha code files just to make the search work?
Is it possible this is just a db setting that needs to be updated, or perhaps something in the systempreferences that carried over from my 3.0 db that is not needed for koha 3.8. I figured this stuff would have been taken care of with the update scripts that ran against my db during the install.
Ryan
-- View this message in context: http://koha.1045719.n5.nabble.com/Search-not-working-after-upgrade-tp5719182... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Hi Eric, I checked and the holdingbranch and homebranch in the items table for records at bluefield high are 314. Other records will use the code for the corresponding school where the book is located. Eg. books at Birchwood Intermediate School have 320 as the code, and so on for each of the 64 branches. Ryan -- View this message in context: http://koha.1045719.n5.nabble.com/Search-not-working-after-upgrade-tp5719182... Sent from the Koha-general mailing list archive at Nabble.com.
Our system uses 090 tags instead of the default 952 tags for items...could this be related to why my search is screwed up? If I choose administration->koha to MARC mapping these are the options that are set under items: Koha field Tag Subfield Lib itemnumber 090 g Koha biblioitemnumber (auto-generated) Edit barcode 090 e Piece designation (barcode) Edit homebranch 090 b School Code Edit itemcallnumber 090 a Koha full call number Edit ccode 090 f Collection Edit volumenumber 090 d Volume Number Edit -- View this message in context: http://koha.1045719.n5.nabble.com/Search-not-working-after-upgrade-tp5719182... Sent from the Koha-general mailing list archive at Nabble.com.
Ryan, Our system uses 090 tags instead of the default 952 tags for items...could
this be related to why my search is screwed up? If I choose administration->koha to MARC mapping these are the options that are set under items:
Koha field Tag Subfield Lib itemnumber 090 g Koha biblioitemnumber (auto-generated) Edit barcode 090 e Piece designation (barcode) Edit homebranch 090 b School Code Edit itemcallnumber 090 a Koha full call number Edit ccode 090 f Collection Edit volumenumber 090 d Volume Number Edit
This would be the problem, yes. Right now changing Koha to MARC mappings has no effect on searching. With search rewritten it would be fairly straightforward to respect the mappings for searches. Until that's done, though, you will need to change your mappings to use the standard 952 fields (and hope for the best). Regards, Jared -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins@cpbibliography.com (web) http://www.cpbibliography.com/
participants (3)
-
Eric Bégin -
Jared Camins-Esakov -
rfblanchard