[Koha] Search not working after upgrade

[rfblanchard]

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.