[Koha] upgrading from koha 3.0/debian lenny to koha 18/ubuntu 16

[Indranil Das Gupta]

Hi Tanzeem,

With that ancient version of Koha (3.0), your best bet is to separately
export your existing data - bibliographic, patron and circulation
information and re-import them into a clean latest stable / oldstable
install.

Technically an in-situ upgrade from such an ancient version to the latest
while not impossible, is a technically non-trivial task and will require
you to study both db schema and code to override the many errors it will
throw up.

Just my 2p.

Cheers
Indranil Das Gupta


On Thu 13 Dec, 2018, 2:56 PM Tanzeem M.B, <tanzeem.mb at gmail.com> wrote:

> Hi
>
> I am upgrading from koha 3.0.2 to a latest supported version.
> My present koha installation is koha version 3.0 installed in Debian Lenny
> In the new installation on another machine I have loaded ubuntu 16
> and installed the latest version of koha 18.
> I took the backup of koha from debian.
> Restored the database in the new installation of koha 18 in ubuntu16.
> Then upgraded the database schema
> and run zebra-rebuld indexing.
> which run successfully. I rebooted the system and loaded the installed koha
> in the browser with url
> http://<koha-instance>.<domain-name>:8080
> and the web-installer got run again and after the update database step I
> got the following error
> ```Updating database structure
>
> Update report :
>
>    - Status: 500
>    - Content-type: text/html
>    -
>    - <h1>Software error:</h1>
>    - <pre>DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column
>    'me.weight' in 'field list' at /usr/share/koha/lib/Koha/Objects.pm line
> 110
>    - </pre>
>    - <p>
>    - For help, please send mail to the webmaster (<a href="mailto:[no
>    address given]">[no address given]</a>), giving this error message
>    - and the time and date of the error.
>    -
>    - </p>
>
> Update errors :
>
>    - [Thu Dec 13 14:28:24 2018] updatedatabase.pl: DBD::mysql::st execute
>    failed: Unknown column 'me.weight' in 'field list' [for Statement
> "SELECT
>    `me`.`id`, `me`.`name`, `me`.`label`, `me`.`type`, `me`.`weight` FROM
>    `search_field` `me` WHERE ( `me`.`name` = ? )" with ParamValues:
> 0='ta'] at
>    /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1834.
>    - [Thu Dec 13 14:28:24 2018] updatedatabase.pl:
>    DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.weight' in
>    'field list' at /usr/share/koha/lib/Koha/Objects.pm line 110
>
> ```
> Please help to move further.
>
> With Thanks & Regards
>
> Mr. Tanzeem M B
> +91 9446705956
>
> Thiruvananthapuram
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>