upgrading from koha 3.0/debian lenny to koha 18/ubuntu 16
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
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@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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi, It's a known bug, see bug 21931 (there is a patch to test!) https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21931 Regards, jonathan Le jeu. 13 déc. 2018 à 06:25, Tanzeem M.B <tanzeem.mb@gmail.com> a écrit :
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@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Indranil Das Gupta -
Jonathan Druart -
Tanzeem M.B