Koha Live Catalogues from Pune

British Council - http://www.library.britishcouncil.org.in/

Pune Nagar Vachan Mandir - http://www.punenagarvachan.org

LibliveDVD small correction

Realized that new liblivedvd-ver 1.5 does not search non-latin characters properly. Had forgotten to made following changes while compiling liblivedvd. The following commands added by Vimal Kumar may be of help to correct the issue if non-latin searches if are not working properly.

http://lists.katipo.co.nz/public/koha/2013-October/037509.html

Koha upgrade from 3.10 to 3.18

I helped one of the library to upgrade their koha from 3.10 to 3.18. Initially I tried direct upgrade from 3.10 to 3.18 but when data was imported all bibliographic records were visible but items were blank. At the same time they had also added their OPAC pages which was added in live.iso this was a major issue. If any xyz library downloads this iso the OPAC pages of X library are also installed when Y library installs this iso. For the library community who does not know anything abot technology it is such as difficult task to remove all OPAC related pages which are visible from X library when they install their distributed iso.

While converting their data from 3.10 to 3.18 i tried to import that data from 3.10 to 3.12, 3.12 to 3.14 then 3.14 to 3.16 then from 3.16 to 3.18 and then everything was alright.

While going from 3.14 to 3.16 it threw error of table roadtype not available. When the following command was run in mysql it upgraded successfully.

mysql>use koha_library;

mysql>CREATE TABLE `roadtype` ( `roadtypeid` int(11) NOT NULL auto_increment, `road_type` varchar(100) NOT NULL default '', PRIMARY KEY (`roadtypeid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

mysql>\q

The above command in mysql helped to upgrade from 3.14 to 3.16. Then after 3.16 to 3.18 upgrade was smooth.