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 <indradg@gmail.com> wrote:
Hi,
On Thu, Jul 23, 2015 at 7:49 AM, Kitty Chan <kitty.chan@usj.edu.mo> 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