<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div style="padding-bottom: 10px; padding-top: 5px;">
<div style="padding:12px; border:1px solid #8D3970; background-color:#F7F9FA; color:#8D3970; font-size:14px; line-height:22px; font-family: Calibri, Arial, Helvetica, sans-serif;">
<strong>CAUTION:</strong> This e-mail originated outside the University of Southampton.
</div>
</div>
<div>
<div dir="ltr">Hello again!
<div><br>
</div>
<div>I continue to test migration path to the latest ePrints version. Yes, I am doing that on new server with following software versions:</div>
<div><br>
</div>
<div>CentOS Linux release 7.9.2009</div>
<div>mariadb.x86_64 1:5.5.68-1.el7<br>
</div>
<div>httpd.x86_64 2.4.6-97.el7.centos<br>
</div>
<div><br>
</div>
<div>Switching mysql debug on did not help much. I assume error was not related to db.</div>
<div><br>
</div>
<div>Then I tried to migrate versions one by one 3.1-&gt;3.2-&gt;3.3-&gt;3.4. This worked better. At least, upgrade script run till end. There was some errors, but that does not matter.</div>
<div><br>
</div>
<div>At last, when I tried to run webserver on upgraded to v3.4 repository I got error:<br>
<br>
Can't use an undefined value as an ARRAY reference at /usr/share/eprints/perl_lib/EPrints/Repository.pm line 1358.<br>
</div>
<div><br>
</div>
<div>I could not solve it and decided to try another advice - set up new clean test repository. First everything run smooth, but webserver gave error:</div>
<div><br>
</div>
<div>Can't use an undefined value as an ARRAY reference at /usr/share/eprints/lib/cfg.d/<a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Feprint_search_staff.pl%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818534037%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=Aehohqchis2AJ3a%2FsSCplLaOJOjEGFYvITmjxakFaNI%3D&amp;reserved=0" originalSrc="http://eprint_search_staff.pl/" shash="H7zElwFTaZZSOyiAzXvJkDyyzbJI/+JtunB6jcB8/c0sBTtu5igFdoRScTH12cY1Dt8UfHVraOEpZzpkSjRDfm1WJkyUJ4TL1ojkvDWjjXOwajAxUL8Ju0vpLAI3HCImy73jjC5lUyny2gxMAuu2bXv9/4ekBBQIj2ioY7zBpo0=">eprint_search_staff.pl</a> line 15.</div>
<div><br>
</div>
<div>I found that reason for this is missing&nbsp;<a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Feprint_search_advanced.pl%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818534037%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=qnl4L3u9n7WI7BsuR1x3%2FCwHIuNhLly4Q6CG%2BrEY0Bw%3D&amp;reserved=0" originalSrc="http://eprint_search_advanced.pl/" shash="KBAHUV/MfHtvgAucF3BFsErmI1EiBGj4WFqda5xbwmwYcPX0Kxy71N4Eb1jR/Ol/ua/FmxZK9mlpYSjpieA6nrYLmPoaMobKP49yVq9vcJM7RtM6PK0zLvkfpdKZjiIz/KPTLvLaRuwwJoq4N7WdpNId72wapNqjc71ob1aJvnA=">eprint_search_advanced.pl</a> file, created it and now I am getting same error as with upgraded repository:</div>
<div><br>
</div>
<div>Can't use an undefined value as an ARRAY reference at /usr/share/eprints/perl_lib/EPrints/Repository.pm line 1358.<br>
</div>
<div><br>
</div>
<div>Probably some missing configuration file? Error refers to this line:</div>
<div><br>
</div>
<div>my @lib_order = &nbsp;reverse(@{ &nbsp;$self-&gt;config('flavours')-&gt;{$flavour} &nbsp; }); ##use this name to retrive the lib list<br>
</div>
<div><br>
</div>
<div>Regards,</div>
<div>Guntis</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Sun, Jan 17, 2021 at 6:14 PM David R Newman via Eprints-tech &lt;<a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a>&gt; wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Hi Guntis,</p>
<p>So to confirm, are you trying to run &quot;epadmin upgrade&quot; against a database running on MySQL 4.1.22 or is the database now running on a more up to date version of MySQL or MariaDB?&nbsp; If not I would export and reimport to a more recent version of MySQL before
 trying the upgrade, as I suspect that version of MySQL may not support the upgrade operations that EPrints 3.3.16 needs to perform.</p>
<p>The &quot;Upgrading rindex and grep tables for subject&quot; is still down to a foreign key constraint which I am surprised to see once you have set the flag as I suggested.&nbsp; One thing you could do to get a better idea of what is going wrong in to temporarily turn
 on MySQL debug that will log all the queries being run.&nbsp; This can be done by editing line 112 of perl_lib/EPrints/Database.pm to:</p>
<p>my $DEBUG_SQL = 1;<br>
</p>
<p>Where previous the value would have been set to 0.&nbsp; This will create a lot of noise when you run &quot;epadmin upgrade&quot; but it should allow you to spot the specific query that has an issue (i.e. the last one before the script fails).&nbsp; It may be worth trying to
 run the failed last SQL query again from the MySQL command to get out a specific error message, as it looks like this gets masked by the epadmin script.</p>
<p>If you are planning on upgrading to EPrints 3.4.2.&nbsp; I would recommend getting a completely default install of this working first, then add your old archive into the archives directory and follow the instructions for upgrading to 3.4.x at:</p>
<p><a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FUpgrading_3.3.12%252B_to_3.4&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818544029%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=RvCi6h4I6AP6BwikTBQ3igL%2Fd4m48HoCSeUIludSZeg%3D&amp;reserved=0" originalSrc="https://wiki.eprints.org/w/Upgrading_3.3.12%2B_to_3.4" shash="HKaS00IVzOqv0BZvAuY6kuDDr7BzKxnGnjNWR7nRLPcsSKGFILatE6+HZm0q0U4qr7bJqxWYOBk0iV5NVeDl9r2UCHa2I077aTJNYb49OiVFpTl6Ft/z/ydVnQH81LHcoUodIoqv3ijG3ZIBLuHTIy0xaQVP5+yiJT7Fh8Yq7fc=" target="_blank">https://wiki.eprints.org/w/Upgrading_3.3.12%2B_to_3.4</a></p>
<p>and possible also upgrade instructions for 3.1 to 3.2 and 3.2 to 3.3 at:</p>
<a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FUpgrading_from_3.1&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818554024%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=zGWDSK78g3cxtAnGmyKLJ7B9yGurN6MOnXRHXTp%2F%2Bv4%3D&amp;reserved=0" originalSrc="https://wiki.eprints.org/w/Upgrading_from_3.1" shash="dF0cmJdRTk0JmLKZPulZiMdcm3BZveb+TPXtG3ssUyzCUR+Lggp6btAts6LfK9/YJzNO4TD2WdN9P+Rli2oWjnG3FurEG/4o2q669LsVDhkkCpl2MyjIymUojG55BXDbbMgmQIqPLV7NUtrPIgHKENdiy4KNa5wgy964FSJG2sc=" target="_blank">https://wiki.eprints.org/w/Upgrading_from_3.1</a><br>
<a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FUpgrading_from_3.2&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818554024%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=ghLN2AfYWAHZQ%2FSHrgxoQ4I%2BHrrejYra%2FDtRWjOa5IM%3D&amp;reserved=0" originalSrc="https://wiki.eprints.org/w/Upgrading_from_3.2" shash="Vm31t84yJ6yv5BzXxD0Jp0FltafqhqyN4xcJJh09QuMbFs4mvB6QPrlH+sEXeN4t6mCdIfaW7mnXH7Glul73JjgzLVTjHi5Ee5+VwXrOshnpxg3xEeJZHibyqPHUASAGbnEalxBCTCoHuhm/6JUv7gJgPJWiQz65mnlP5NxAKJ0=" target="_blank">https://wiki.eprints.org/w/Upgrading_from_3.2</a><br>
<p>I would advise getting your archive's configuration working so you can create a new empty EPrints database rather than immediately trying to get it working with your old database and upgrading it.&nbsp; By creating a new database and checking the your repository
 works OK in a web browsers you can be failry confident this part is correct.&nbsp; Then you can import your old database update the
<a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fdatabase.pl%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818564016%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=c%2BxjI4s3q4y4Qw5p6N08o%2B2kaWmakwS9b4BMB%2BT5sOo%3D&amp;reserved=0" originalSrc="http://database.pl/" shash="Dp5toR+189TLMAMgWJ5RPvcPkSBw3kM5LKxMhXbMsuXH2INcn59viz+eyJZzuDJg5Lw8M21vZH3WUIj5d+boNlXIclPT40Zl8GS2BzUJNJnjnC4PyDm7BFib+48Spx4E3g2oaz+nwzsJXnXWIGdF03yUIP8cUx1keJ66+QAd4JM=" target="_blank">database.pl</a> configuration to point at it an drun &quot;epadmin upgrade&quot; knowing that if there are issues it is due to the database rather than your EPrints configuration.</p>
<p>Regards</p>
<p>David Newman<br>
</p>
<p><br>
</p>
<div>On 17/01/2021 15:38, Guntis Zelvis via Eprints-tech wrote:<br>
</div>
<blockquote type="cite">
<div style="padding-bottom:10px;padding-top:5px">
<div style="padding:12px;border:1px solid rgb(141,57,112);background-color:rgb(247,249,250);color:rgb(141,57,112);font-size:14px;line-height:22px;font-family:Calibri,Arial,Helvetica,sans-serif">
<strong>CAUTION:</strong> This e-mail originated outside the University of Southampton.
</div>
</div>
<div>
<div dir="ltr">David, thanks for advice. This removed most errors related to foreign key constraints. Just one remained:
<div><br>
</div>
<div>Upgrading rindex and grep tables for subject<br>
DBD::mysql::db do failed: Error on rename of './scireldiaprints/#sql-10710_48' to './scireldiaprints/subject__rindex' (errno: 150) at /usr/share/eprints/bin/../perl_lib/EPrints/Database.pm line 3052, &lt;STDIN&gt; line 1.<br>
SQL ERROR (do): ALTER IGNORE TABLE subject__rindex MODIFY field VARCHAR(64) CHARACTER SET UTF8, MODIFY word VARCHAR(128) CHARACTER SET UTF8, DEFAULT CHARACTER SET UTF8, DROP PRIMARY KEY, ADD PRIMARY KEY(field,word,`subjectid`), DROP KEY `subject__rindex_subjectid_2`<br>
SQL ERROR (do): Error on rename of './scireldiaprints/#sql-10710_48' to './scireldiaprints/subject__rindex' (errno: 150) (#1025)<br>
</div>
<div><br>
</div>
<div>However, the main problem that stops upgrade script remains:</div>
<div><br>
</div>
<div>Upgrading dataset metafield<br>
<br>
------------------------------------------------------------------<br>
---------------- EPrints System Error ----------------------------<br>
------------------------------------------------------------------<br>
An unexpected error occurred while attempting to convert tables to UTF-8.<br>
<br>
------------------------------------------------------------------<br>
EPrints System Error inducing stack dump<br>
&nbsp;at /usr/share/eprints/bin/../perl_lib/EPrints.pm line 147, &lt;STDIN&gt; line 1.<br>
&nbsp; &nbsp; &nbsp; &nbsp; EPrints::abort() called at /usr/share/eprints/bin/epadmin line 2753<br>
&nbsp; &nbsp; &nbsp; &nbsp; main::upgrade_mysql_charset('EPrints::Repository=HASH(0x13dec90)', 'EPrints::Database::mysql=HASH(0x408a3b8)') called at /usr/share/eprints/bin/epadmin line 3008<br>
&nbsp; &nbsp; &nbsp; &nbsp; main::upgrade_3_1_2_to_3_2_0('EPrints::Repository=HASH(0x13dec90)', 'EPrints::Database::mysql=HASH(0x408a3b8)') called at /usr/share/eprints/bin/epadmin line 2887<br>
&nbsp; &nbsp; &nbsp; &nbsp; main::upgrade('scireldiaprints') called at /usr/share/eprints/bin/epadmin line 320<br>
</div>
<div><br>
</div>
<div>And, yes. This is very old version of ePrints (3.1.3) as well as underlaying MySQL version (4.1.22). Now I am researching upgrade path to ePrints 3.4.2 on MariaDB 5.5.68.</div>
<div><br>
</div>
<div>Guntis</div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Sat, Jan 16, 2021 at 8:37 PM David R Newman &lt;<a href="mailto:drn@ecs.soton.ac.uk" target="_blank">drn@ecs.soton.ac.uk</a>&gt; wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div>
<p>Hi Guntis,</p>
<p>This looks to be down to foreign key constraints.&nbsp; As you are trying to upgrade from a version of EPrints that is over 12 years ago, I cannot know whether this was a known issue at the time or just some quirk of running an very old EPrints database schema
 in what may be a rather more recent version of MySQL.&nbsp; <br>
</p>
<p>Assuming that you have suitables backups of the database so you can roll back if things go wrong, I would recommend temporarily adding the following line to perl_lib/EPrints/Database/<a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmysql.pm%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818564016%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=1mU4FsFAgwG4jH05g%2FxTMrA4hvlyY%2FOKuUUOS1AdXy8%3D&amp;reserved=0" originalSrc="http://mysql.pm/" shash="a3ss5H4qLI8Nd0z9ydzvR5jAhIEAYC0NoSkPJDijxyIpE1txvVeRpyBZZDLV7OLPoIP5OE+2fWRaLeUOXZjYAxjoIXv4Ns+MAf0+GyxmPb1hEIg0zX9gfs+5T53dCymAWphWID/CzNNviIib7ekxSUWivVKKwsjtVnwrY5xAOyY=" target="_blank">mysql.pm</a>
 (for EPrints 3.3.16) after line 243:</p>
<pre><code><span>                $self-&gt;do('SET</span> foreign_key_checks = <span>0</span>;');
</code></pre>
<div>This should allow you to run the upgrade script without getting any errors like you previously reported.&nbsp; However, once you have hopefully run epadmin upgrade successfully you should immediately remove this line from
<a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmysql.pm%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818574013%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=lP9cZ25GfjtV%2FZ0A9n9b4cB65Rbrg6bKLpm4ipES9mk%3D&amp;reserved=0" originalSrc="http://mysql.pm/" shash="ozNS879MSz3rqw2/Rf0mVxoQredbSIXpN6yTmXLkUmN+GhpunZR/xq1e3DJsPYwy+7dL5Hx4rvWb6g5jtMyIafDKN4AZWBismLyKw9Kb7irG11gfDL2B8tJDHFUiqUfeX+N/hNzurZ6RFnAEhY/ILjRS0mpWquTPtRk1Xf9Uxyc=" target="_blank">
mysql.pm</a>.&nbsp; This temporary change should allow the upgrade script to tinker with the database schema without having to worry about foreign keys constraints being temporarily broken.&nbsp; Hopefully, by the time it finishes the database schema will be fully upgraded
 but there will not be any foreign key constraint issues still present.<br>
</div>
<div><br>
</div>
<div>I am not sure whether the issues you had from you first run of &quot;epadmin upgrade&quot; will have left the database in an inconsistent state, so it may be worth restoring the database from a backup be re-running &quot;epadmin upgrade&quot; with the change I have suggested
 to <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmysql.pm%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818574013%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=lP9cZ25GfjtV%2FZ0A9n9b4cB65Rbrg6bKLpm4ipES9mk%3D&amp;reserved=0" originalSrc="http://mysql.pm/" shash="ozNS879MSz3rqw2/Rf0mVxoQredbSIXpN6yTmXLkUmN+GhpunZR/xq1e3DJsPYwy+7dL5Hx4rvWb6g5jtMyIafDKN4AZWBismLyKw9Kb7irG11gfDL2B8tJDHFUiqUfeX+N/hNzurZ6RFnAEhY/ILjRS0mpWquTPtRk1Xf9Uxyc=" target="_blank">
mysql.pm</a>.</div>
<div><br>
</div>
<div>Let me know how it goes.&nbsp; I may be able to help if you still have problems but I have really much worked with EPrints prior to 3.2.&nbsp; There may be some veterans on the list that may know more about known issues upgrading from 3.1.x to 3.3.</div>
<div><br>
</div>
<div>Regards</div>
<div><br>
</div>
<div>David Newman<br>
</div>
<div><br>
</div>
<div>On 16/01/2021 18:01, Guntis Zelvis via Eprints-tech wrote:<br>
</div>
<blockquote type="cite">
<pre>CAUTION: This e-mail originated outside the University of Southampton.

Hello! I am trying to migrate EPrints v3.1.2 to the latest version. As
I understand it is impossible to migrate straight to v3.4.2, so first
I try to install v3.3.16 and upgrade repository to this version, but
there is few errors in output of 'epadmin upgrade REPOID'

Added dataset upload_progress
DBD::mysql::db do failed: Can't create table 'REPOID.#sql-10710_38'
(errno: 150) at /usr/share/eprints/bin/../perl_lib/EPrints/Database.pm
line 3052, &lt;STDIN&gt; line 1.
SQL ERROR (do): ALTER TABLE `subject_name_sortvalue` ADD CONSTRAINT
`subject_name_sortvalue_fk` FOREIGN KEY(`subjectid`) REFERENCES
`subject`(`subjectid`) ON DELETE CASCADE
SQL ERROR (do): Can't create table 'REPOID.#sql-10710_38' (errno: 150) (#1005)

Later there is:

Upgrading dataset file
Upgrading `file` by insertion
DBD::mysql::db do failed: Cannot delete or update a parent row: a
foreign key constraint fails at
/usr/share/eprints/bin/../perl_lib/EPrints/Database.pm line 3052,
&lt;STDIN&gt; line 1.
SQL ERROR (do): DROP TABLE IF EXISTS `old_file`
SQL ERROR (do): Cannot delete or update a parent row: a foreign key
constraint fails (#1217)

Upgrading dataset upload_progress
Upgrading `upload_progress` by insertion
DBD::mysql::db do failed: Cannot delete or update a parent row: a
foreign key constraint fails at
/usr/share/eprints/bin/../perl_lib/EPrints/Database.pm line 3052,
&lt;STDIN&gt; line 1.
SQL ERROR (do): DROP TABLE IF EXISTS `old_upload_progress`
SQL ERROR (do): Cannot delete or update a parent row: a foreign key
constraint fails (#1217)

Upgrading rindex and grep tables for subject
DBD::mysql::st execute failed: Table 'REPOID.subject__rindex' doesn't
exist at /usr/share/eprints/perl_lib/EPrints/Database/<a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmysql.pm%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818584008%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=%2Fk3KppqvW%2B1o4rzSnJYcDsgP26XsBfgM1exivIV4aug%3D&amp;reserved=0" originalSrc="http://mysql.pm/" shash="hWGYcOi0YYPy8DeU3pLgowBeu1R3qHVyGcYX3vzI4tCuyTKsor4p2OlOE9OxZ2U5NMi2AFr9TyZfTQVEDrwBs+9eqvg/cxuptz89DntC8n4kXb/58wP0ymdt6EY92PbrhvNMu5UjryaqE4EuktK9wiclL3cMXFMlTnyibVEWjrc=" target="_blank">mysql.pm</a> line
423, &lt;STDIN&gt; line 1.
DBD::mysql::st fetch failed: fetch() without execute() at
/usr/share/eprints/perl_lib/EPrints/Database/<a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmysql.pm%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818584008%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=%2Fk3KppqvW%2B1o4rzSnJYcDsgP26XsBfgM1exivIV4aug%3D&amp;reserved=0" originalSrc="http://mysql.pm/" shash="hWGYcOi0YYPy8DeU3pLgowBeu1R3qHVyGcYX3vzI4tCuyTKsor4p2OlOE9OxZ2U5NMi2AFr9TyZfTQVEDrwBs+9eqvg/cxuptz89DntC8n4kXb/58wP0ymdt6EY92PbrhvNMu5UjryaqE4EuktK9wiclL3cMXFMlTnyibVEWjrc=" target="_blank">mysql.pm</a> line 426,
&lt;STDIN&gt; line 1.
DBD::mysql::st execute failed: Table 'REPOID.subject__rindex' doesn't
exist at /usr/share/eprints/bin/epadmin line 2769, &lt;STDIN&gt; line 1.
DBD::mysql::st fetch failed: fetch() without execute() at
/usr/share/eprints/bin/epadmin line 2770, &lt;STDIN&gt; line 1.
DBD::mysql::db do failed: Table 'REPOID.subject__rindex' doesn't exist
at /usr/share/eprints/bin/../perl_lib/EPrints/Database.pm line 3052,
&lt;STDIN&gt; line 1.
SQL ERROR (do): ALTER IGNORE TABLE subject__rindex MODIFY field
VARCHAR(64) CHARACTER SET UTF8, MODIFY word VARCHAR(128) CHARACTER SET
UTF8, DEFAULT CHARACTER SET UTF8, ADD PRIMARY
KEY(field,word,`subjectid`)
SQL ERROR (do): Table 'REPOID.subject__rindex' doesn't exist (#1146)

And everything stops here:
Upgrading dataset metafield

------------------------------------------------------------------
---------------- EPrints System Error ----------------------------
------------------------------------------------------------------
An unexpected error occurred while attempting to convert tables to UTF-8.

------------------------------------------------------------------
EPrints System Error inducing stack dump
 at /usr/share/eprints/bin/../perl_lib/EPrints.pm line 147, &lt;STDIN&gt; line 1.
        EPrints::abort() called at /usr/share/eprints/bin/epadmin line 2753
        main::upgrade_mysql_charset('EPrints::Repository=HASH(0xb9fc80)',
'EPrints::Database::mysql=HASH(0x384b458)') called at
/usr/share/eprints/bin/epadmin line 3008
        main::upgrade_3_1_2_to_3_2_0('EPrints::Repository=HASH(0xb9fc80)',
'EPrints::Database::mysql=HASH(0x384b458)') called at
/usr/share/eprints/bin/epadmin line 2887
        main::upgrade('REPOID') called at
/usr/share/eprints/bin/epadmin line 320

How to fix these errors and complete repository upgrade?

*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818594006%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=bTxDLTiKMZTJhBFOZ8%2BjVOeNlSCV7o4R61aaFTb5Q6g%3D&amp;reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="biJGfVx4cY4CmtWzmN1/445SriM9PXELMlvAiThBhUEsVwRa4snO0PO1QlPNsaiG/GTaUzIhnNe38peBgjtqnGHp6bGkc+CPvADZlf8cNrvcS1Aq6ejt8yXBYDo6zNPqJe6gnaB3pRaYih0wBab/Fjh6Yi5ws8q1YuM7l2NFTg0=" target="_blank">https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;amp;data=04%7C01%7Cdrn%40ecs.soton.ac.uk%7C80641a7b0bb64e32af1808d8ba494561%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464171151379183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;amp;sdata=HhJbYby71iR6yf1Dz2kJu5kBgLpM%2BSxmur8JA5VV75Q%3D&amp;amp;reserved=0</a>
*** EPrints community wiki: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818604004%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=EEtQHpAh6pYGIhNdfbPnOfoNrIvJrHWv18v13EoZe1U%3D&amp;reserved=0" originalSrc="http://wiki.eprints.org/" shash="zk40ABoIL10EdJK/JY0jWQm01roojL5t+GLUsHJbtYE6cQ8RCzaTBLeabxBNs7C42yv7LksxsbhxPe6qnXZgqJlQahnUx/0Q6GcAu+h4Y4UsJpTKnIw3KdEpUpov+HnnzZNsbIB+rBGIwhQXGYm/u+tlw85ycaQa8cEzaFHlRJk=" target="_blank">https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;amp;data=04%7C01%7Cdrn%40ecs.soton.ac.uk%7C80641a7b0bb64e32af1808d8ba494561%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464171151379183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;amp;sdata=RrZj2YwOClqbT8Q8Act3TtVAUim5cof4MzIVMxtHyLo%3D&amp;amp;reserved=0</a>
</pre>
</blockquote>
<div id="gmail-m_-8446128859125049684gmail-m_-6312468162313403187DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2">
<br>
<table style="border-top:1px solid rgb(211,212,222)">
<tbody>
<tr>
<td style="width:55px;padding-top:13px"><a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.avg.com%2Femail-signature%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818604004%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=FgeYL8CkHXHw3NKdfUky9VgCPjA2k39MU%2B7dTOf8vko%3D&amp;reserved=0" originalSrc="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" shash="idCvyMY8k3AhQ6rKSZW+PAXRtNsbCQwdFVSVR78+QdMU5kvhgYuNsOOAZUxd/tDIhk5mrThu8Fn+oGpEiZlXsGSTmbR2uH7oHJ56kQZjR9tkamF9ruZ5S8ywxF+fSg5BJTAxTnkRaXp36E56hu92XKPl4XsUbo9htsYit4TRi+U=" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png" alt="" style="width: 46px; height: 29px;" width="46" height="29"></a></td>
<td style="width:470px;padding-top:12px;color:rgb(65,66,78);font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">
Virus-free. <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.avg.com%2Femail-signature%3Futm_medium%3Demail%26utm_source%3Dlink%26utm_campaign%3Dsig-email%26utm_content%3Demailclient&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818613990%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=0krlDgVmYw3z6tEXlzs5%2BpqIqOJkqQfDnN2u09e44SA%3D&amp;reserved=0" originalSrc="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" shash="ntfiF1IFB0dxjfOpEhZOz7VWq4vJaa/zjOVfminUQ20uzm/NVx7fDxcH43RqkbBjBEca7WAk3rPHyKYV6gbtEC88vxZfeI3kyX0bZXfTUT8bJ0PPoQtI1SeH1dKJ5BO30b0kKVokUIdQWZa/fjYsAmP7C4oKZRNdI36tKIYQ9vc=" style="color:rgb(68,83,234)" target="_blank">
www.avg.com</a> </td>
</tr>
</tbody>
</table>
</div>
</div>
</blockquote>
</div>
</div>
<br>
<fieldset></fieldset>
<pre>*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" target="_blank">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818613990%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=gNVhWv56oLpSDhnQpJDQCPSo6iOeawKGdf9u3AdCGxA%3D&amp;reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="yzANO7I0HQ5eUFFvhn0gG/ye83M857f2VSQNd81QGyDl2bxjm9k9LCtqxAaU9F2fJ32+mo+1GfUSTojbVJA+L2EPfThKYS0bcdOV3ufnv2cexBmqUPMKEPA71ZG4xEUxhKcvPxTuFShVJ6nvAORwZbhzI8VjoeCphq8Lybyvo6I=" target="_blank">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818623985%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=o96%2FFQPw4dRAweVVDaIPbojzIXVwxVM70GQ1udjV%2F%2FM%3D&amp;reserved=0" originalSrc="http://wiki.eprints.org/" shash="teb7e4eXXsmRIql3BEbBVRFFONJF4XFCQLnA4A2E/WD2q00L1H8kDuwSpVsS1AGtlLcS9z8B7oHRS793lNy9GOoMH6YCaq0035RoppG7FHlSpz20ZcwZCE8O4nfd4LscoR3fx3ll5Z0rMHCm5IOBuPn461WgZsHH2L4ZBsJcEzI=" target="_blank">http://wiki.eprints.org/</a></pre>
</blockquote>
</div>
*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech" rel="noreferrer" target="_blank">
http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
*** Archive: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818623985%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=PWE6lA%2Bvc0nOOp8D2%2BoQ6XAOcMtlAevybYxKxK%2FIQSo%3D&amp;reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="TP3g5D7Hg5O2f4cRJvjMpV5KaEKfJMTF8YduP5+IsE/JYES5Yr3NrP1LHb+8+RIN8TuJ9h6pXjqVTMrurZMxlVv0aUmP1PN02QWQdDsEdSZd3FAtk9BhVoidJWGRy+P1rlLleuzHRtE5Up2vXeDoG+WYs7cmwzmpSR55BR9d0lQ=" rel="noreferrer" target="_blank">
http://www.eprints.org/tech.php/</a><br>
*** EPrints community wiki: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C87598e2eab184bbfd42e08d8bf95a971%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637469996818633981%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=7ZF3qeDNcQe4m1yZ9Wh4nFnXccgMKOAwR9F03O4LEJM%3D&amp;reserved=0" originalSrc="http://wiki.eprints.org/" shash="DcdEF57Kr2s0r9jjbA4LsuLnsfBRQVp9UNZHMeW4DCUUsq8wGEVPjkfyV4MomKA+yMOsJJyPu9q1jpueKKZsOWN/OlYpKzBlNPkQS4b4ljAuvj+ic06NLDVCMffrngqjd4rkKTLeYk+9TvSFG8HcWx3CA3imWk70+ljj4EEIubk=" rel="noreferrer" target="_blank">
http://wiki.eprints.org/</a></blockquote>
</div>
</div>
</body>
</html>