Search problem after massive upgrade

Many occassions I found following error message after upgrade from very old version of Koha to the latest version. 
Software error:
Can't call method "branchname" on an undefined value at /usr/share/koha/lib/C4/Biblio.pm line 1570.

The solution is that execute a full index of Zebra. Apply following command;

sudo su
koha-rebuild-zebra -f -a -b -v library

How to make available Koha in a network

Koha has web interface and can easily make available Staff Client and OPAC in the institutional / library network. Then library users can access OPAC from their seats. Library staff can use Staff Client from other client PCs. Make sure that the Koha installed computer inside a LAN (Local Area Network). Following things should try from Koha installed PC.

1. Identify IP and Netmask of the PC
Open a Terminal and apply following command.

sudo su
ifconfig


Note down the IP address and Netmask.
e.g. IP address- 192.168.1.25
       Netmask  -  255.255.0.0

Enable barcode/accession number search in OPAC

Add following query in
Koha> Administration › System preferences › OPACUserJS

$("select[name='idx']").append("<option value='bc'>Accession No.</option>");

Save.
Refresh OPAC page and see the change.

Information courtesy:
L2C2 Technologies
http://blog.l2c2.co.in/index.php/2016/09/10/quick-tip-add-barcode-lookup-to-your-opacs-search-index-selection-downdown/

Import Quotes into Koha

1. Enable and beautify Quotes of the Day in Koha. 
Check following link;
http://kohageek.blogspot.in/2017/12/beautify-quote-of-day-in-opac.html

2. Prepare quotes
Open a spread sheet (Applications > Office > Libre Office Writer). Put quotes in spreadsheet. Arrange author or source name in first column and the quote in second column.  Save as .csv format.
Quotes arranged in a .csv file.

Beautify Quote of the day in OPAC


1. Add CSS

Koha > Administration > Global System Preferences > OPAC > OPACUserCSS

Add following  CSS query.

#daily-quote {
background-color:#FFFFFF;
border:1px solid #000000;
border-radius:15px 15px 15px 15px;
margin:0 0px 0px;
text-align:center;
width:740px;
}

#daily-quote-text{
color: black;
}

#daily-quote-source {
color: black;
}



Save it.

2. Enable Quote of the Day feature

Koha > Administration > Global System Preferences > OPAC > QuoteOfTheDay > Enable

3. Add some quotes

Koha > Tools > Edit quotes for QOTD feature

4. Open Koha OPAC interface and check the quote.

Information courtesy
1. Subeesh Gopinathan
2. http://bywatersolutions.com/2013/02/28/qotd-in-koha-310/

Delete records in Koha

In certain occasions need to empty bibliographic, patron and transaction details from Koha database and clean the installation to start the process again. The user has to go to Koha database and empty the concerned tables.

Log into MySQL
Apply following commands to login to the MySQL database;

sudo su
mysql -uroot -p
use koha_library;


Delete circulation entries from databse tables

Certain records reluctant to Checkin due to DBMS auto increment problem. In such cases the transaction remain in the tables. Developers still working for the solution. Here is a temporary solution.
Record reluctant to checkin.