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
h1Software error:/h1
preDB 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
