Yes, the old server is 3.18 and the new one is 3.20. I ran through the web installer page and the upgrade was done with the following errors. However, the server is now running and I don't know whether these errors will cause any issues.
Updating database structure Upgrade to 3.19.00.006 done (Bug 11944: Convert DB tables to utf8_unicode_ci) Upgrade to 3.19.00.007 done (Bug 12905: Check budget integrity: OK) Upgrade to 3.19.00.008 done (Bug 12601: Add new foreign key aqorders.budget_id) Upgrade to 3.19.00.009 done (Bug 13007: Add new foreign key suggestions.budgetid) Upgrade to 3.19.00.010 done (Bug 5511: SessionRestrictionByIP) Upgrade to 3.19.00.011 done (Bug 13417: Add permission to delete public lists) Upgrade to 3.19.00.012 done (Bug 13523 Remove NOT NULL restriction on field marcxml due to mysql STRICT_TRANS_TABLES) Upgrade to 3.19.00.013 done (Bug 11395: Add permission tools_records_batchmod) Upgrade to 3.19.00.014 done (Bug 12648: Add letter ACQ_NOTIF_ON_RECEIV ) Upgrade to 3.19.00.015 done (Bug 11430: Add primary key for search_history) Upgrade to 3.19.00.016 done (Bug 13380: ORDER_CANCELLATION_REASON authorised value already existed from earlier update!) Upgrade to 3.19.00.017 done (Bug 5786: Move AllowOnShelfHolds to circulation matrix; Move OPACItemHolds system preference to circulation matrix) Upgrade to 3.19.00.018 done (Bug 10328: Rename opaccolorstylesheet to OpacAdditionalStylesheet Upgrade to 3.19.00.019 done (Bug 9580: Cover image from Coce, a remote image URL cache) Upgrade to 3.19.00.020 done (Bug 11008: DROP column aqorders.supplierreference) Upgrade to 3.19.00.021 done (Bug 2806: Remove issuingbranch columns) Upgrade to 3.19.00.022 done (Bug 13006: Drop column suggestion.mailoverseeing) Upgrade to 3.19.00.023 done (Bug 13497: Remove the AddPatronLists system preferences) Upgrade to 3.19.00.024 done (Bug 13539: Remove table patroncards from database as it's no longer in use) Upgrade to 3.19.00.025 done (Bug 13528: Add the SearchWithISBNVariations syspref) Upgrade to 3.19.00.026 done (Bug 13322: Update MARC21 frameworks to Update No. 19 - October 2014) Upgrade to 3.19.00.027 done (Bug 4222: Nonpublic note not appearing in the staff client) <b>Please check each of your frameworks to ensure your non-public item notes are mapped to items.itemnotes_nonpublic. After doing so please have your administrator run misc/batchRebuildItemsTables.pl </b>) Upgrade to 3.19.00.028 done (Bug 13790: Add unique id issue_id to issues and oldissues tables) Upgrade to 3.19.00.030 done (Bug 14030: Add Georgian language and fix Kannada language code) Upgrade to 3.19.00.031 done (Bug 8992: Add system preference IdRef)) Upgrade to 3.19.00.032 done (Bug 4041: Address Format as a I18N/L10N system preference Upgrade to 3.19.00.033 done (Bug 11165: Update auth_header.datemodified when updated) Upgrade to 3.19.00.037 done (Bug 13810: Change collate for tagsubfield (utf8_bin)) Upgrade to 3.19.00.038 done (Bug 13421: Add DB field virtualshelves.created_on) Upgrade to 3.19.00.039 done (Koha 3.20 beta) Upgrade to 3.19.00.040 done (Bug 11006: Drop column aqorders.totalamount) Upgrade to 3.19.00.041 done (Bug 14132: suggestions table is missing indexes) Upgrade to 3.19.00.042 done (Bug 8480: Add foreign key on auth_subfield_structure.authtypecode) Upgrade to 3.19.00.043 done (Bug 5338: Add Serial to the report groups if does not exist) Upgrade to 3.20.00.000 done (Koha 3.20) Upgrade to 3.20.00.001 done (Bug 14285: Add new region India) Upgrade to 3.20.00.002 done (Bug 5010: Fix OPACBaseURL to include protocol) Upgrade to 3.20.01.000 done (Koha 3.20.1) Update errors : [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::st execute failed: Table 'koha_librarytest.patroncards' doesn't exist at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 9713. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 9714. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: Use of uninitialized value $table[1] in pattern match (m//) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 9715. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Table 'koha_librarytest.patroncards' doesn't exist at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 9733. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Can't create table 'koha_librarytest.#sql-462b_6fe' (errno: 121) at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 9797. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Can't create table 'koha_librarytest.#sql-462b_6fe' (errno: 121) at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 9817. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '20' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 9838. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '20- delete_public_lists' for key 'PRIMARY' at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 9842. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry '13- records_batchmod' for key 'PRIMARY' at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 9866. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Table 'aqorder_users' already exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 9876. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'acquisition-ACQ_NOTIF_ON_RECEIV--email' for key 'PRIMARY' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 9886. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'id' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 9896. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'onshelfholds' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 9948. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'opacitemholds' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 9961. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'supplierreference'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10009. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'issuingbranch'; check that column/key exists at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10019. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'issuingbranch'; check that column/key exists at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 10022. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Can't DROP 'mailoverseeing'; check that column/key exists at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 10031. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Unknown table 'patroncards' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10049. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate entry 'SearchWithISBNVariations' for key 'PRIMARY' at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 10056. [Thu Jul 23 16:44:46 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'itemnotes_nonpublic' at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 10173. [Thu Jul 23 16:44:47 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'itemnotes_nonpublic' at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 10174. [Thu Jul 23 16:44:47 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'issue_id' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10188. [Thu Jul 23 16:44:47 2015] updatedatabase.pl: DBD::mysql::db do failed: Deadlock found when trying to get lock; try restarting transaction at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 10278. [Thu Jul 23 16:44:47 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate column name 'created_on' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10383. [Thu Jul 23 16:44:47 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate key name 'status' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10415. [Thu Jul 23 16:44:47 2015] updatedatabase.pl: DBD::mysql::db do failed: Duplicate key name 'branchcode' at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 10421. Best Regards, Kitty On Fri, Jul 24, 2015 at 5:36 AM, Indranil Das Gupta <[email protected]> wrote: > Hi, > > On Thu, Jul 23, 2015 at 7:49 AM, Kitty Chan <[email protected]> wrote: > > > I see that on the new server, I have the new instance folders in the > > /etc/koha/sites and also the new databases. However, when I access > > http://library-admin.usj.edu.mo:8080, I was asked to lead to the " > Welcome > > to the Koha web installer" web page. I thought I should be displayed > with > > the admin login page to access my old Koha server contents. > > If your old server's Koha version is lower than your new server's Koha > version, then you will see this most definitely. Is that the case? > > Usually you need to let the web installer to do its job. > > cheers > -indranil > > > -- > 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 > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
