[Koha] koha upgrade 3.14 to 3.16

[Indranil Das Gupta]

Hi Sunita,

On Sat, Jul 5, 2014 at 6:42 PM, Sunita Barve <sunitabarve at gmail.com> wrote:
> While we tried to upgrade koha from 3.14 to 3.16 the web installation
> after running upgrade command threw following error

Question : Which specific 3.14 version were on you? 3.14.8 or earlier?
Please confirm. If you were on 3.14.8 at the time of upgrade then
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7372 might
explain what happened.

In the meanwhile:

1. open the db - koha_library using phpmyadmin or which ever mysql
client you are using.

2. check if you have the table 'roadtype'

3. if not, then run the following create table command using
phpmyadmin (or mysql client of your choice)

CREATE TABLE `roadtype` ( -- road types defined in administration and
used in patron management
  `roadtypeid` int(11) NOT NULL auto_increment, -- unique identifier
assigned by Koha for each road type
  `road_type` varchar(100) NOT NULL default '', -- text for road type
  PRIMARY KEY  (`roadtypeid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

4. re-run the web-installer and check.

> How to resolve this error and login to kohaadmin. If this does not
> work how to get system back in working with either 3.14 on
> ubuntu12.04.

If you have reliable backups in place use them for restoration.

Otherwise, assuming you are using Koha's .deb packages, revert to
using 3.14 tree by following the tips at
http://wiki.koha-community.org/wiki/Koha_3.x_on_Debian_Squeeze#Old_Stable_Version

Install Koha 3.14.8 using apt-get

If you have reliable koha_library db backup restore them into your new
Koha instance's database.

You should be good to go.

cheers
-indra

-- 
Indranil Das Gupta

Phone : +91-98300-20971
Blog    : http://indradg.randomink.org/blog
IRC      : indradg on irc://irc.freenode.net
Twitter : indradg

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-
Please exchange editable Office documents only in ODF Format. No other
format is acceptable. Support Open Standards.

For a free editor supporting ODF, please visit LibreOffice -
http://www.documentfoundation.org