Upgrading from 3.00 to 3.6, we're still not getting our search results. We can see the records in the Reservoir and can find records using the check in function with a known barcode, but searching in the OPAC & Staff interface gives us nothing. here's the report from the upgrade...is there something here that is blocking the search functions? Update report : Upgrade to 3.01.00.000 done (start of 3.1) Upgrade to 3.01.00.001 done (add hold_fill_targets table and a column to tmp_holdsqueue) Upgrade to 3.01.00.002 done (bug 2582: set null issues.issuedate to lastreneweddate) Upgrade to 3.01.00.003 done (add new syspref) Upgrade to 3.01.00.004 done (added OPACDisplayRequestPriority system preference) Upgrade to 3.01.00.005 done (Add letter for holds notifications) Upgrade to 3.01.00.006 done (add index on biblioitems.issn) Upgrade to 3.01.00.007 done (fix display of many sysprefs) Upgrade to 3.01.00.008 done (added branch_transfer_limits table and UseBranchTransferLimits system preference) Upgrade to 3.01.00.009 done (added subpermissions for circulate permission) Upgrade to 3.01.00.010 done (bug 2687: increase length of borrower attribute fields) Upgrade to 3.01.00.011 done (removed bogus intranetuserjs syspref) Upgrade to 3.01.00.012 done (Add tables and system preferences for holds policies) Upgrade to 3.01.00.013 done (data for Email Checkout Slips project) Upgrade to 3.01.00.014 done ( Updated table for Branch Transfer Limits) Upgrade to 3.01.00.015 done (added Syndetics Enhanced Content system preferences) Upgrade to 3.01.00.016 done (Added Babeltheque syspref) Upgrade to 3.01.00.017 done ( Updated table for Serials Display) Upgrade to 3.01.00.018 done (added deletedborrowers.smsalertnumber, missed in 3.00.00.091) Upgrade to 3.01.00.019 done (adding OPACShowCheckoutName systempref) Upgrade to 3.01.00.020 done (adding LibraryThing for Libraries sysprefs) Upgrade to 3.01.00.021 done (adding OPACAmazonReviews syspref) Upgrade to 3.01.00.022 done (bug 2945: increase size of labels_conf.formatstring) Upgrade to 3.01.00.023 done (bug 2765: increase width of isbn column in several tables) Upgrade to 3.01.00.024 done (change labels.batch_id from varchar to int) Upgrade to 3.01.00.025 done (added ceilingDueDate system preference) Upgrade to 3.01.00.026 done (added numReturnedItemsToShow system preference) Upgrade to 3.01.00.027 done (Increased size of zebraqueue biblio_auth_number to address bug 3148.) Upgrade to 3.01.00.028 done (added AmazonReviews) Upgrade to 3.01.00.029 done (fixed bug 2599: using Spanish search limit retrieves Russian results) Upgrade to 3.01.00.030 done (added AllowNotForLoanOverride system preference) Upgrade to 3.01.00.031 done (fix column widths in branch_transfer_limits) Upgrade to 3.01.00.032 done (Change the field) Upgrade to 3.01.00.033 done (DB changes to allow patron category defaults for messaging preferences) Upgrade to 3.01.00.034 done (Adding graceperiod column to subscription table) Upgrade to 3.01.00.035 done (Adding location to subscription table) Upgrade to 3.01.00.036 done (new viewISBD, viewLabeledMARC, viewMARC sysprefs and tweak IntranetBiblioDefaultView) Upgrade to 3.01.00.037 done (added FilterBeforeOverdueReport syspref and new index on authorised_values) Upgrade to 3.01.00.038 done (add ZIP, city, country, URL, and notes column to branches) Upgrade to 3.01.00.039 done (added SpineLabelFormat and SpineLabelAutoPrint sysprefs) Upgrade to 3.01.00.040 done (AllowHoldDateInFuture and OPACAllowHoldDateInFuture sysprefs) Upgrade to 3.01.00.041 done (added AWSPrivateKey syspref - note that if you use enhanced content from Amazon, this should be set right away.) Upgrade to 3.01.00.042 done (added OPACFineNoRenewals syspref) Upgrade to 3.01.00.043 done (amended Item added NewItemsDefaultLocation, InProcessingToShelvingCart, ReturnToShelvingCart sysprefs) Upgrade to 3.01.00.044 done (added DisplayClearS creenButton system preference) Upgrade to 3.01.00.045 done (added a preference to hide the patrons name in the staff catalog) Upgrade to 3.01.00.046 done (add country and B_country to borrowers) Upgrade to 3.01.00.047 done (bug 2761: change max length of itemcallnumber to 255 from 30) Upgrade to 3.01.00.048 done (bug 2611: fix spelling/capitalization in permission flag descriptions) Upgrade to 3.01.00.049 done (bug 2611: changed catalogue to catalog per the standard) Upgrade to 3.01.00.050 done (bug 1934: Add OPACSearchForTitleIn syspref) Upgrade to 3.01.00.051 done (fixed typos in new sysprefs) Upgrade to 3.01.00.052 done (bug 3481: add permanent_location column to deleteditems) Status: 500 Content-type: text/html <h1>Software error:</h1> <pre>DB ERROR: Unknown column 'batch_id' in 'field list' </pre> <p> For help, please send mail to the webmaster (<a href="mailto:[no address given]">[no address given]</a>), giving this error message and the time and date of the error. </p> Upgrade to 3.01.00.053 done (Migrated labels tables and data to new schema.) NOTE: All existing label batches have been assigned to the first branch in the list of branches. This is ONLY true of migrated label batches. Upgrade to 3.01.00.054 done (bug 1600, bug 3454: add altcontactcountry and B_address2 to borrowers and deletedborrowers) Upgrade to 3.01.00.055 done (changed OPACSearchForTitleIn per requests in bug 1934) Upgrade to 3.01.00.056 done (Bug 1172 : Add OPACPatronDetails syspref) Upgrade to 3.01.00.057 done (Bug 2576 : Add OPACFinesTab syspref) Upgrade to 3.01.00.058 done (Added primary keys to language tables) Upgrade to 3.01.00.059 done (added DisplayOPACiconsXSLT sysprefs) Upgrade to 3.01.00.060 done ( Added AllowAllMessageDeletion syspref and messages table ) Upgrade to 3.01.00.061 done ( Added ShowPatronImageInWebBasedSelfCheck system preference ) Upgrade to 3.01.00.062 done (added csv export profiles) Upgrade to 3.01.00.063 done (Created table fieldmapping) Upgrade to 3.01.00.064 done (Version number skipped: nothing done) Upgrade to 3.01.00.065 done (Moving allowed renewals from itemtypes to issuingrule) Upgrade to 3.01.00.066 done (Moving max allowed reserves from system preference to issuingrule) Upgrade to 3.01.00.067 done (added permissions for batch modification and deletion) Upgrade to 3.01.00.068 done (Adding finedays in issuingrules table) Upgrade to 3.01.00.069 done (added OPAC search history preference and table) Upgrade to 3.01.00.070 done (Added a lib_opac field in authorised_values table) Upgrade to 3.01.00.071 done ( Adding enddate to subscription) Upgrade to 3.01.00.072 done (add new syspref and column in borrowers) Upgrade to 3.01.00.073 done (adding aqcontract table) Upgrade to 3.01.00.074 done (edit aqbasket table done) Upgrade to 3.01.00.075 done (adding uncertainprices) Upgrade to 3.01.00.076 done (adding basketgroups) Upgrade to 3.01.00.077 done (Adding new aqbudgetperiods, aqbudgets and aqbudget_planning tables ) Upgrade to 3.01.00.078 done (adds 'budget_period_total' column to aqbudgetperiods table) Upgrade to 3.01.00.079 done (adds 'active' column to currencies table) Upgrade to 3.01.00.080 done (adds permissions for the acquisitions module) Upgrade to 3.01.00.081 done (added per-supplier gstrate setting) Upgrade to 3.01.00.082 done (adding ReservesNeedReturns systempref, in circulation) Upgrade to 3.01.00.083 done (New aqorders_items table for acqui) Upgrade to 3.01.00.084 done (CurrencyFormat syspref added) Upgrade to 3.01.00.085 done update budget_id size that should not be a tinyint Upgrade to 3.01.00.086 done (Suggestions) Upgrade to 3.01.00.087 done (Drop column budget_amount_sublevel from aqbudgets) Upgrade to 3.01.00.088 done (intranetbookbag syspref added) Upgrade to 3.01.00.090 done (granular permissions for guided reports added) Upgrade to 3.01.00.091 done (opac-detail default tag updated) Upgrade to 3.01.00.092 done (Added RoutingListAddReserves syspref) Upgr ade to 3.01.00.093 done (added index to ISSN) Upgrade to 3.01.00.094 done (adding deliveryplace deliverycomment to basketgroups) Upgrade to 3.01.00.095 done (stocknumber field added) Upgrade to 3.01.00.096 done (PDF orders system preferences added and updated) Upgrade to 3.01.00.097 done (Adding billingplace to aqbasketgroups) Upgrade to 3.01.00.098 done (changing frameworkcode length in auth_subfield_structure) Upgrade to 3.01.00.099 done (granular permissions for cataloging added) Upgrade to 3.01.00.100 done (added CAS authentication system preferences) Upgrade to 3.01.00.101 done (added OverdueNoticeBcc system preferences) Upgrade to 3.01.00.102 done (fixed spelling error in edit_catalogue permission) Upgrade to 3.01.00.103 done (adding patron permissions for tags tool) Upgrade to 3.01.00.104 done ( add defaults to authorized values for MANUAL_INV and BOR_NOTES and add new default LOC authorized values for shelf to cart processing ) Upgrade to 3.01.00.105 done (added collection and collection_tracking tables for rotating collections functionality) Upgrade to 3.01.00.106 done (added OpacAddMastheadLibraryPulldown system preferences) Status: 500 Content-type: text/html <h1>Software error:</h1> <pre>DB ERROR: Key column 'printer_name' doesn't exist in table </pre> <p> For help, please send mail to the webmaster (<a href="mailto:[no address given]">[no address given]</a>), giving this error message and the time and date of the error. </p> Upgrade to 3.01.00.107 done (Migrated labels and patroncards tables and data to new schema.) Upgrade to 3.01.00.108 done (added separators for csv export) Upgrade to 3.01.00.109 done (added encoding for csv export) Upgrade to 3.01.00.110 done (Add enrolment period date support) Upgrade to 3.01.00.111 done (mark DBrev for 3.2-alpha release) Upgrade to 3.01.00.112 done ( added Show Spine Label Printer on Bib Items Details preferences ) Upgrade to 3.01.00.113 done (added two new syspref: OPACXSLTResultsDisplay and OPACXSLTDetailDisplay). You may have to go in Admin > System preference to tweak XSLT related syspref both in OPAC and Search tabs. Upgrade to 3.01.00.114 done ( Added AutoSelfCheckAllowed, AutoSelfCheckID, and AutoShelfCheckPass system preference ) Upgrade to 3.01.00.115 done ( Default aqorders.quantityreceived to 0 ) Upgrade to 3.01.00.116 done (corrected default OrderPdfFormat value if still set wrong ) Upgrade to 3.01.00.117 done (corrected ISO 639-2 language code for Portuguese) Upgrade to 3.01.00.118 done (bug 4203: add display column to aqbudgets_planning if missing) Upgrade to 3.01.00.119 done (Locale::Currency::Format installed.) Upgrade to 3.01.00.120 done (bug 1080: add soundon system preference for circulation sounds) Upgrade to 3.01.00.121 done ( Added Additional Fields to Reserves tables ) Upgrade to 3.01.00.122 done. — Add a new system preference OAI-PMF:ConfFile Upgrade to 3.01.00.123 done (Add granular permission for holds modification and update description of reserveforothers permission) Upgrade to 3.01.00.124 done (bug 3242: add HOLDPLACED letter template, which is used when emailLibrarianWhenHoldIsPlaced is enabled) Upgrade to 3.01.00.125 done (bug 3482: Printable hold and overdue notices) Upgrade to 3.01.00.126 done (Adding ILS-DI updates and ILS-DI:AuthorizedIPs) Upgrade to 3.01.00.127 done (bug 4190: messages in patron account did not work with branchcodes > 4) Upgrade to 3.01.00.128 done (bug 4331: index orders by budget_id) Upgrade to 3.01.00.129 done (Change permissions names for item batch modification / deletion) Upgrade to 3.01.00.130 done (change reserves.expirationdate values of 0000-00-00 to NULL (bug 1532) Upgrade to 3.01.00.131 done (adding print and feed message transport types) Upgrade to 3.01.00.132 done (Adding index to language_descriptions table) Upgrade to 3.01.00.133 done (bug 4405: added OverduesBlockCirc syspref to control whether circulation is blocked if a borrower has overdues) Upgrade to 3.01.00.134 d one (adding syspref DisplayMultiPlaceHold to control whether multiple holds can be placed from the search results page) Upgrade to 3.01.00.135 done (bug 4377: added HOLD_PRINT message template) Upgrade to 3.01.00.136 done (Adding a new permission to edit items) Upgrade to 3.01.00.137 done (adding granular permissions for serials) Upgrade to 3.01.00.138 done (bug 4896: removing GranularPermissions syspref; use of granular permissions is now the default) Upgrade to 3.01.00.139 done (bug 3682: change message_name from varchar(20) to varchar(40)) Upgrade to 3.01.00.140 done (bug 4312 TagsModeration changed from NULL to 0) Upgrade to 3.01.00.141 done Remove upcoming events messaging option (bug 2434) Upgrade to 3.01.00.142 done (Remove upcoming events messaging option part 2 (bug 2434)) Upgrade to 3.01.00.143 done (Create index on authorised_values and borrower_attribute_types (bug 4139)) Upgrade to 3.01.00.144 done (Update the 'default' to 'normal' for the IntranetBiblioDefaultView syspref (bug 5007)) Upgrade to 3.01.00.145 done (Add index on guarantorid) Upgrade to 3.01.00.999 done (3.2.0 release candidate) Upgrade to 3.02.00.000 done (Add HomeOrHoldingBranchReturn system preference) Upgrade to 3.02.00.001 done (bug 3756: remove disused system preferences) Upgrade to 3.02.00.002 done (bug 3881: remove unused OpacPrivacy system preference) Upgrade to 3.02.00.003 done (correct ILS-DI:AuthorizedIPs) Upgrade to 3.02.00.004 done (3.2.0 general release) Upgrade to 3.03.00.001 done (Make subscriptionroutinglist more strict) Upgrade to 3.03.00.002 done (Correct language mappings) Upgrade to 3.03.00.003 done (Add UseTablesortForCirc syspref) Upgrade to 3.03.00.004 done (bug 5127: add default templates for suggestion status change notifications) Upgrade to 3.03.00.005 done (Add itemBarcodeInputFilter choice libsuite8) Upgrade to 3.03.00.006 done (Fix differences between borrowers and deletedborrowers) Upgrade to 3.03.00.007 done (Added acq related columns to suggestions) Upgrade to 3.03.00.008 done (adding syspref OPACNoResultsFound to control what displays when no results are found for a search in the OPAC.) Upgrade to 3.03.00.009 done (Add IntranetUserCSS syspref) Upgrade to 3.03.00.010 done (Fix misspelled 034r subfield in MARC21 Frameworks) Upgrade to 3.03.00.011 done (Bug 5186: allow GST rate to be set to 0) Upgrade to 3.03.00.012 done (Bug 2142: maxItemsInSearchResults syspref resurrected) Upgrade to 3.03.00.013 done (added 'OpacPublic' syspref) Upgrade to 3.03.00.014 done (Add flexible shelf browser constraints) Upgrade to 3.03.00.015 done (Bug 5619: Add subfield 9 to marc21 648,654,655,656,657,658,662) Upgrade to 3.03.00.016 done (OpacPrivacy reimplementation) Upgrade to 3.03.00.017 done (Enable currency rates >= 100) Upgrade to 3.03.00.018 done (Correct language descriptions) Upgrade to 3.03.00.019 done (Correct language descriptions for Norwegian) Upgrade to 3.03.00.020 done (Bug 5811: Add sysprefs controlling overriding fines) Upgrade to 3.03.00.021 done (bug 5642: longer serial enumeration) Upgrade to 3.03.00.022 done (Add AuthoritiesLog syspref) Upgrade to 3.03.00.023 done (Reconcile aqbasketgroups) Upgrade to 3.03.00.024 done (Add syspref to force whole-subfield matching on subject tracings) Upgrade to 3.03.00.025 done (Add syspref to control if user can choose pickup branch for holds) Upgrade to 3.03.00.026 done ( fix capitalization in message type ) Upgrade to 3.03.00.027 done (Preferences for facet count) Upgrade to 3.03.00.028 done (Add FacetLabelTruncationLength syspref to control facets displayed length) Upgrade to 3.03.00.029 done (Add syspref to control if user can choose branch when making purchase suggestion) Upgrade to 3.03.00.030 done (Add sysprefs to control custom favicons) Upgrade to 3.03.00.031 done (Add syspref FineNotifyAtCheckin) Upgrade to 3.03.00.032 done ( include subdivisions when generating subject tracing searches ) Upgrade to 3.03.00.033 done (System pref StaffAuthorise dValueImages) Upgrade to 3.03.00.034 done (Add hidelostitems preference to borrower categories) Upgrade to 3.03.00.035 done (Move global and ceiling due dates to Circ Rules level) Upgrade to 3.03.00.036 done ( Make COinS optional in OPAC search results ) Upgrade to 3.03.00.037 done (Add 'Display856uAsImage' and 'OPACDisplay856uAsImage' syspref) Upgrade to 3.03.00.038 done ( Add Self-checkout by Login system preferences ) Upgrade to 3.03.00.039 done (Add syspref ShowReviewer) Upgrade to 3.03.00.040 done (Add syspref UseControlNumber) Upgrade to 3.03.00.041 done (Add sysprefs to control alternate holdings information display) Upgrade to 3.03.00.042 done (5860 Index itemstocknumber) Upgrade to 3.03.00.043 done ( add generic boolean YES_NO authorised_values pair ) Upgrade to 3.03.00.044 done (adding freedeliveryplace to basketgroups) Upgrade to 3.03.00.045 done (Remove obsolete columns from aqbooksellers and aqbudgets if needed) Upgrade to 3.03.00.046 done (Setting NULL default value for delayn columns in table overduerules) Upgrade to 3.03.00.047 done (Add state field to patron's addresses) Upgrade to 3.03.00.048 done (Add state to branch address) Upgrade to 3.03.00.049 done (adding note and manager_id fields in accountlines table) Upgrade to 3.03.00.050 done (Adding OpacHiddenItems syspref) Upgrade to 3.03.00.051 done (Remove spaces and dashes from message_attribute names) Upgrade to 3.03.00.052 done (Add syspref WaitingNotifyAtCheckin) Upgrade to 3.04.00.000 done Koha 3.4.0 release Upgrade to 3.05.00.001 done (Adds New System preference numSearchRSSResults) Upgrade to 3.05.00.002 done (Fix for stocknumber index) Upgrade to 3.05.00.003 done (Adds New System preference OpacRenewalBranch) Upgrade to 3.05.00.004 done (Add syspref ShowReviewerPhoto) Upgrade to 3.05.00.005 done (Adds pref BasketConfirmations) Upgrade to 3.05.00.006 done (Add syspref MARCAuthorityControlField008) Upgrade to 3.05.00.007 done (Add syspref OpenLibraryCovers) Add state and country to cities table corresponding to new columns in borrowers Upgrade to 3.05.00.009 done (issues referential integrity) Create an index on reserves to speed up holds awaiting pickup report bug 5866 Upgrade to 3.05.00.011 done (add OPACResultsSidebar syspref (enh 6165)) Upgrade to 3.05.00.012 done (add RecordLocalUseOnReturn syspref (enh 6403)) Upgrade to 3.05.00.013 done (Add syspref 'OpacKohaUrl') Modified userid column length into 75 in borrowers Upgrade to 3.05.00.015 done (Add support for EBSCO's NoveList Select (enh 6902)) Upgrade to 3.05.00.016 done (Add EasyAnalyticalRecords syspref) Upgrade to 3.05.00.017 done (Add 773 subfield 9 and 0 to default framework) Upgrade to 3.05.00.018 done (add OpacNavBottom syspref (enh 6825): if appropriate, you can split OpacNav into OpacNav and OpacNavBottom) Upgrade to 3.05.00.019 done (remove duplicate VOKAL Book icons, bug 6862) Upgrade to 3.05.00.020 done (Add syspref AcqViewBaskets) Upgrade to 3.05.00.021 done (Added a display_checkout field in borrower_attribute_types table) Upgrade to 3.05.00.022 done (6094: Fixing ModAuthority problems, add a need_merge_authorities table) Upgrade to 3.05.00.023 done (Add syspref OpacShowRecentComments. When the preference is turned on a link to recent comments will appear in the OPAC masthead. ) Upgrade to 3.06.00.000 done Koha 3.6.0 release Upgrade to 3.06.01.000 done (Incrementing version for 3.6.1 release. See release notes for details.) Upgrade to 3.06.02.000 done (Incrementing version for 3.6.2 release. See release notes for details.) Upgrade to 3.06.02.001 done (Add column to suggestions table to store patrons' reasons for submitting a suggestion. ) Upgrade to 3.06.02.002 done alter items.material from varchar(10) to text Upgrade to 3.06.02.003 done (add MARC21 field 545 to framework) Upgrade to 3.06.03.000 done (Incrementing version for 3.6.3 release. See release notes for details.) Upgrade to 3.06.03.001 add 'AllowItemsOnHoldCheckout' syspref Upgrade to 3. 06.04.000 done (Incrementing version for 3.6.4 release. See release notes for details.) Update errors : After the upgrade to 3.01.00.002, there are still 13 loan(s) with a NULL (blank) loan date. Please check the issues table in your database.[Tue Apr 17 11:00:54 2012] updatedatabase.pl: DBD::mysql::db do failed: Unknown column 'batch_id' in 'labels' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 2360. [Tue Apr 17 11:01:09 2012] labels_upgrade.pl: DBD::mysql::db do failed: Unknown column 'batch_id' in 'field list' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/labels_upgrade.pl line 120. [Tue Apr 17 11:01:09 2012] labels_upgrade.pl: DB ERROR: Unknown column 'batch_id' in 'field list' [Tue Apr 17 11:01:40 2012] patroncards_upgrade.pl: DBD::mysql::db do failed: Key column 'printer_name' doesn't exist in table at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/patroncards_upgrade.pl line 129. [Tue Apr 17 11:01:40 2012] patroncards_upgrade.pl: DB ERROR: Key column 'printer_name' doesn't exist in table [Tue Apr 17 11:01:41 2012] updatedatabase.pl: Use of uninitialized value $value in concatenation (.) or string at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3764. [Tue Apr 17 11:01:41 2012] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'maxItemsInSearchResults' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3955. [Tue Apr 17 11:01:41 2012] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3997. [Tue Apr 17 11:01:41 2012] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'privacy' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 3998. [Tue Apr 17 11:01:58 2012] updatedatabase.pl: DBD::mysql::db do failed: Error on rename of './poplar_library/#sql-1065_31e' to './poplar_library/issues' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4424. [Tue Apr 17 11:01:58 2012] updatedatabase.pl: DBD::mysql::db do failed: Error on rename of './poplar_library/#sql-1065_31e' to './poplar_library/issues' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4425. [Tue Apr 17 11:01:58 2012] updatedatabase.pl: DBD::mysql::db do failed: Error on rename of './poplar_library/#sql-1065_31e' to './poplar_library/issues' (errno: 150) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 4426. Lenora StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission