DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist

I got following error message while upgrade to Koha version 3.16,

DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
line 7987.
DBD::mysql::db do failed: Table 'koha_library.roadtype' doesn't exist at
/usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl
line 7987.
dpkg: error processing koha-common (--configure):
 subprocess installed post-installation script returned error exit status
255
E: Sub-process /usr/bin/dpkg returned an error code (1)

Up gradation process in web interface does not proceed and it repeat it again and again.

I solved the problem using following steps,
 
Open a terminal and open following file,

sudo su
leafpad /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl

Search > Jump To > 7985

Find the line
$dbh->{RaiseError} = 1;

Change the value 1 to 0.
Save file.

Go back to koha and refresh the page.

 

Koha 3.16.5.1 Live DVD available

Koha 3.16.5.1 security fix Live DVD (32&64 bit) now available for download. Build on Ubuntu 12.04.5. You can download from here.

Customise MARC Bibliographic Framework for easy data entry

Koha cataloging using default MARC Bibliographic Frameworks is difficult due to scattered fields in various tabs. Users may feel difficult to manage with data entry fields after the installation of Koha from scratch. See the default view,

We can arrange most used fields (e.g. Author, Title etc.) in single tab. You can follow the steps to customize any available framework except Default one. Retain default framework as it is.

Click here to download the customized framework in your computer.

Go to  
Koha > Administration > MARC Bibliographic Framework > BOOK Books, Booklets > Import

Upload the customized framework file.
Check cataloging module and check the changes done.


Koha 3.14 old stable version of Live DVD (32&64-bit) released

Koha 3.14.11 old stable version of Live DVD released. Live DVD build on Ubuntu 12.04.5 LTS. 64&32 bit versions are available. Old stable version is almost bug free and suitable for production purpose. You can download DVD from Sourceforge or Google Drive

Patron import

We can import details of users from a list saved in spreadsheet (MS Excel/LibreOffice Calc). Every academic year colleges and schools prepare details of students got new admission in excel sheet. Librarian can collect list from office for the purpose of import into Koha.

Prepare patron list
Often details of students in save in spread sheet file (e.g. MS Excel). We have to arrange details in a spreadsheet. Here is an example. Filed names in header should same as in patron table. You can download sample file from here.
I have added here minimum patron fields. You can check other field names and add from here

This spread sheet represent student details from a school. cardnumber represent unique ID number of students. Student class can add in sort1 field. 

branchcode and categorycode are mandatory fields. 
Library code in Koha should be in branchcode field. 
You can check your library code from  
Koha > Administration > Libraries and Groups

Check Patron category code from 
Koha > Administration > Patron types and categories
Arrange patron details in spreadsheet. Save/Save As spread sheet to .csv format.
 
 Import Patrons
Goto Koha > Tools > Import Patrons
Upload csv file.
Press Import button. Import button located in bottom of the page.
See the result page. Your records imported successfully.

Cancel / close patron library membership

Librarian have to close membership after the expiry of membership period. Option available for cancel membership for various reasons. Librarian can enter a note about membership cancellation.

Search patron and open patron in edit mode.

Find Patron restrictions. Click on Add manual restriction.
 Enter a note in comment box. No need to enter anything in date box.
Save the patron details and see the changes.

Spine label creation

Creation of new Layout for Spine Label

Koha > Tools > Label Creator > New Layout

Fill the layout according to below screenshot,

Search and adding books for spine label creation

Koha > Tools > Label Creator > New Batch


Click on Add items button.

Select any searching parameter (e.g. Call Number).

It result all books with call number.


Select all books. Add the selected items. Click on Done button to finish.

Click on Export Batch button,

Select Layout and Template,

Download Spine Labels in PDF Format,
 See the spine labels in PDF format,