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.