[Koha] Backup and migrate Koha from one server to another

Fri Jul 24 13:18:57 NZST 2015

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 at gmail.com>
wrote:

> Hi,
>
> On Thu, Jul 23, 2015 at 7:49 AM, Kitty Chan <kitty.chan at 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
>