[Koha] Search not working after upgrade

[Eric Bégin]

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.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>