Hi Sunita, On Sat, Jul 5, 2014 at 6:42 PM, Sunita Barve <sunitabarve@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_Ve... 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