<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">Hi,
<div><br>
</div>
<div>My experience when upgrading from 3.3.12 to 3.4 in 1998 is not complicated, and the instructions at <a href="https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.eprints.org%2Fw%2FUpgrading_3.3.12%252B_to_3.4&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314595692%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=%2BCNgybybpWaiH6EppkDoH6VXaQQaYjS%2BEoe1XcwhVl0%3D&reserved=0" originalSrc="https://wiki.eprints.org/w/Upgrading_3.3.12%2B_to_3.4" shash="Yu3a38/N5nzhHXHXNfkjCn1YXgCOlSI8xrT57q3elbBLPK7pMBwLAKOle85wRYqra+KkLBgAPz/qbrH1ha7TBdnw4LKsTSKQ1DJMeJT/8b6aU0QHoLXI6upp/ikG7QVJtSwQz3aXqRUhBjwNN2uYhkaSVR6d8nxip5So+e6sgu4=" target="_blank">https://wiki.eprints.org/w/Upgrading_3.3.12%2B_to_3.4</a> very
helpful.</div>
<div>until now my repository <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Frepository.dinamika.ac.id%2F&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314595692%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=hLTJ4kjNVDFwgYqVseNslnuJ3LClqOzraKPQkrewL9Y%3D&reserved=0" originalSrc="http://repository.dinamika.ac.id/" shash="Rq5PdRmQC6VWIWZm9EgbhvrvA14Mwegx2tfChNLpb5iykuAD8fID1bzH5nl0IntwmLEmcqCf8ScFk2h2CZUOsH8szylAEF38SiXw8XCc0WIW5geZ4r8OqLu+3WB+cG9X+uCIFubeR/TMX1hWtKo8AS6zWLh9U7HmcXhfA3Kg2p4=">http://repository.dinamika.ac.id/</a> still running well without no problems.</div>
<div><br>
</div>
<div>Regards,</div>
<div>Agung</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Sun, Jan 17, 2021 at 11:14 PM David R Newman via Eprints-tech <<a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a>> 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 "epadmin upgrade" 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? 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 "Upgrading rindex and grep tables for subject" is still down to a foreign key constraint which I am surprised to see once you have set the flag as I suggested. 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. 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. This will create a lot of noise when you run "epadmin upgrade" but it should allow you to spot the specific query that has an issue (i.e. the last one before the script fails). 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. 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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314605647%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Pa8R0DW1Sr26cLnGtF1PIkkoTg2BkPWxSzAdWpQuFGg%3D&reserved=0" originalSrc="https://wiki.eprints.org/w/Upgrading_3.3.12%2B_to_3.4" shash="tUxUyE2hn5qc6UXeunH6qUYhioHrZTtR8fe7qBZtPRIl7zD0XYX1MNP0n/O3SR0eKWBm50La3+cve0bUP5TIQH8sHk+gQVYJhX44y8slAo6+KefTuTi03ARxvvt5zj831sekbi/NVUCJPoHdabxg6euBajbLNqxDsUNDLLuRTmA=" 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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314605647%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=0Ig59RxvHu3%2FAQUOEZlO4h6gskWTgZqiRUmJlCd6%2Fxs%3D&reserved=0" originalSrc="https://wiki.eprints.org/w/Upgrading_from_3.1" shash="W7Quh1KBOayMitbzD48iQ5iFzDERUH3w6587uud3A2YvHoF+Ps/dVF/hDk30U7K4mcHuReDCRcZ8QXATLGAu9JLbng4VVpAk0n3W6yGboXmSupWMe0V7dtcl+0x5MPa0c3RYgTa17/KJimzODRoaeiJGETbDOn5EMjUlPdc2gyU=" 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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314615590%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=eAXJ6%2FlUhWTgKOOpfBCYYiYY0zvLSBcx%2FeFyrkZxQrY%3D&reserved=0" originalSrc="https://wiki.eprints.org/w/Upgrading_from_3.2" shash="g54viXlhdguqJWw59YCJzdnDbqBRUSTCXr9Ba7JPLxEY+qUItnNkm++Dzntu5audKjYKno3bgMF5IUOj3xpe5XLTRApbudnLn7w6VN3k421g9zdTBza/2AuJp0zqAbWVrfmqSySWtSpe2SOM+IOXBmw5ZQeW1Fm/H5rjV6SJu/A=" 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. 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. Then you can import your old database update the
<a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fdatabase.pl%2F&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314615590%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=pWpmAYNEdXtRBlqXJjj1j8GY7NRBtYcX9hdFurnzGsk%3D&reserved=0" originalSrc="http://database.pl/" shash="ug26a/mfpgVxkd3go1klzeDpC2vj+HU40obfgmXAqtjV4ZJfPF8rbcREs7wwueY0dOamaUuigR1vpFgayOxn9ejxBTRcZEHdGRsIxdhHKQTTp1kQG3j8a7f1it9vMBhJJEaG4j5Ys9Aip+pyEwGgpsZaY467Ky2F5r1iZgdTV6w=" target="_blank">database.pl</a> configuration to point at it an drun "epadmin upgrade" 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, <STDIN> 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>
at /usr/share/eprints/bin/../perl_lib/EPrints.pm line 147, <STDIN> line 1.<br>
EPrints::abort() called at /usr/share/eprints/bin/epadmin line 2753<br>
main::upgrade_mysql_charset('EPrints::Repository=HASH(0x13dec90)', 'EPrints::Database::mysql=HASH(0x408a3b8)') called at /usr/share/eprints/bin/epadmin line 3008<br>
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>
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 <<a href="mailto:drn@ecs.soton.ac.uk" target="_blank">drn@ecs.soton.ac.uk</a>> 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. 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. <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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314625560%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=x%2FNaaC9OtDN2iuO8DcVHbno%2FcjYU52BVAd7uZQ6lTuI%3D&reserved=0" originalSrc="http://mysql.pm/" shash="S9f9HuicOCsp3w83RiYiMgnu47rqH25J0NufeYbLFX4xEt66C1xrE8KTT3pKxoHKqyfmD1yxOWoEvegv90ctvsUXA679Tnx8kV/D98EHsSPkXmdsncK5WUBBG6ZSzLVemorCiyepxR/KTtMSOfSczjG4m+MrI2Sge1INZSmlgzA=" target="_blank">mysql.pm</a>
(for EPrints 3.3.16) after line 243:</p>
<pre><code><span> $self->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. 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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314625560%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=x%2FNaaC9OtDN2iuO8DcVHbno%2FcjYU52BVAd7uZQ6lTuI%3D&reserved=0" originalSrc="http://mysql.pm/" shash="S9f9HuicOCsp3w83RiYiMgnu47rqH25J0NufeYbLFX4xEt66C1xrE8KTT3pKxoHKqyfmD1yxOWoEvegv90ctvsUXA679Tnx8kV/D98EHsSPkXmdsncK5WUBBG6ZSzLVemorCiyepxR/KTtMSOfSczjG4m+MrI2Sge1INZSmlgzA=" target="_blank">
mysql.pm</a>. 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. 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 "epadmin upgrade" will have left the database in an inconsistent state, so it may be worth restoring the database from a backup be re-running "epadmin upgrade" with the change I have suggested
to <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmysql.pm%2F&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314625560%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=x%2FNaaC9OtDN2iuO8DcVHbno%2FcjYU52BVAd7uZQ6lTuI%3D&reserved=0" originalSrc="http://mysql.pm/" shash="S9f9HuicOCsp3w83RiYiMgnu47rqH25J0NufeYbLFX4xEt66C1xrE8KTT3pKxoHKqyfmD1yxOWoEvegv90ctvsUXA679Tnx8kV/D98EHsSPkXmdsncK5WUBBG6ZSzLVemorCiyepxR/KTtMSOfSczjG4m+MrI2Sge1INZSmlgzA=" target="_blank">
mysql.pm</a>.</div>
<div><br>
</div>
<div>Let me know how it goes. I may be able to help if you still have problems but I have really much worked with EPrints prior to 3.2. 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, <STDIN> 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,
<STDIN> 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,
<STDIN> 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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314635524%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=l9BPr%2F%2FFhUvA%2FxxEOnAg4al%2BNiT%2B6dv7mhkCe4HHGiY%3D&reserved=0" originalSrc="http://mysql.pm/" shash="ZYPk/RSDsonLuk+CSpSAK6Qn16O2k2oCBneSifnR6G9FGnFrf1LvdvkC4IV0Xa5GKzjoJ03KnFNWF+mxtQ3zUETULcRQc6UQ0DIa5u/1R2R5L+VOqj+EYDlw4qHnu8ov7bdUePxjQ1M0JMwied6EuX7gkuatapjJ2QrkUW/giZU=" target="_blank">mysql.pm</a> line
423, <STDIN> 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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314635524%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=l9BPr%2F%2FFhUvA%2FxxEOnAg4al%2BNiT%2B6dv7mhkCe4HHGiY%3D&reserved=0" originalSrc="http://mysql.pm/" shash="ZYPk/RSDsonLuk+CSpSAK6Qn16O2k2oCBneSifnR6G9FGnFrf1LvdvkC4IV0Xa5GKzjoJ03KnFNWF+mxtQ3zUETULcRQc6UQ0DIa5u/1R2R5L+VOqj+EYDlw4qHnu8ov7bdUePxjQ1M0JMwied6EuX7gkuatapjJ2QrkUW/giZU=" target="_blank">mysql.pm</a> line 426,
<STDIN> line 1.
DBD::mysql::st execute failed: Table 'REPOID.subject__rindex' doesn't
exist at /usr/share/eprints/bin/epadmin line 2769, <STDIN> line 1.
DBD::mysql::st fetch failed: fetch() without execute() at
/usr/share/eprints/bin/epadmin line 2770, <STDIN> 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,
<STDIN> 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, <STDIN> 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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314645472%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=IbYxidBXhxSj1oK3b7BLwzGiRv%2Bwn6UFFoYt%2BlzoOKI%3D&reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="v1kpVtvEQoy5tgGICkZvb8AsU2ZoPjhkhAIKdemkEaeqTQTOfLKrwChRXl+kfvKPd4aT/vb4EvhumNwv/vLmq8TDUE8t+2hOgO84T2kUYbQUzjPmAo4q2kJeXMhmV9RHuahUJJZG4i+suRH8fJl/liFrFEFutpyccOOEDx+ENg8=" target="_blank">https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.eprints.org%2Ftech.php%2F&amp;data=04%7C01%7Cdrn%40ecs.soton.ac.uk%7C80641a7b0bb64e32af1808d8ba494561%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464171151379183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=HhJbYby71iR6yf1Dz2kJu5kBgLpM%2BSxmur8JA5VV75Q%3D&amp;reserved=0</a>
*** EPrints community wiki: <a href="https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314645472%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=ycXs4ERCLCnTctoy6e%2FAoUXdc2qnzp%2FYhvwsNBuw2GQ%3D&reserved=0" originalSrc="http://wiki.eprints.org/" shash="nd75h+CmWMOUhUnWfkjQCv8twEc867vzAhWPDj6xQ4IHWkmbsx6FG828fJgCSrKnEJ1OihGK6+w/2UcUfT/5daJyYVX4ZzxtNxK/KZAuox7RS8imaBHaO6m1TcIRC44TCykX0P+XIRfeC70RT/XkwV0LRyBJCkL8xh5bkQ+Ezyo=" target="_blank">https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwiki.eprints.org%2F&amp;data=04%7C01%7Cdrn%40ecs.soton.ac.uk%7C80641a7b0bb64e32af1808d8ba494561%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637464171151379183%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=RrZj2YwOClqbT8Q8Act3TtVAUim5cof4MzIVMxtHyLo%3D&amp;reserved=0</a>
</pre>
</blockquote>
<div id="gmail-m_1935770172829827901gmail-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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314655431%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=WrKTLwYMLQlNxe13Dai40z2V8EUWWhb2v1ECcYny3nw%3D&reserved=0" originalSrc="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" shash="sXid4FSA0r7Apxy6tvtiWnyy+wCJOzwiEqAZACXObqv0BDptwTPIgH9EiPw5J56jDmeAD3aQhAn2/UtnCZB+WbFNiybOBB/ad+4BT0DhGws/iJ8rqixNmlM8xtHPHmNvZvvaQT4O16/GvyHL/f6uotLEhUIXaQa/x7YQJruOvfo=" 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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314655431%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=WrKTLwYMLQlNxe13Dai40z2V8EUWWhb2v1ECcYny3nw%3D&reserved=0" originalSrc="http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient" shash="sXid4FSA0r7Apxy6tvtiWnyy+wCJOzwiEqAZACXObqv0BDptwTPIgH9EiPw5J56jDmeAD3aQhAn2/UtnCZB+WbFNiybOBB/ad+4BT0DhGws/iJ8rqixNmlM8xtHPHmNvZvvaQT4O16/GvyHL/f6uotLEhUIXaQa/x7YQJruOvfo=" 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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314665386%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=VGeJVH3Ko%2FTKAwKTnOQVKhvR%2BgVlOJUdE%2FukKIRLYWY%3D&reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="h1M480pRo8KdF8XjLYXrFF0uYdhkbqDRN7cey61SI5mju4xJiI6x1wDV/fP8190+c9I0oSF3tHGhTcltLv0DOCl2iAalXc5s7+SqDq7261Ep1g491FVNz12lYOQJopSypBNSGmHxM67RhOY2dgCdBjAbUsMcSGwlfoxqUH3uuWw=" 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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314665386%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=vQYsXK6cEqlUDRODshEJZPopkJb5NSHYxvZcG84gwT8%3D&reserved=0" originalSrc="http://wiki.eprints.org/" shash="h225aiFT+HHqxCbuyC6MD3eNM2TRIjlaHce6iEYbD0hCu1aI+sC3OG3DifWPl2qNaKr5xCIlMZEm3pwUgyRCVfc2EAykOm+KuwNcsoYLtdgGs+ww0Cs6IANkjJYbUOkE63yyhNGzEYpzlrzTl/bFoBi2jqEFwty8J29U2jPcv1E=" 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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314675337%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=RZ6%2B%2BENnWAJq%2FQGg8HpW3brfunzBGjYz%2BJQ6c4sYfPA%3D&reserved=0" originalSrc="http://www.eprints.org/tech.php/" shash="Gn3ePo2J/LzNtcjEyOI4u7/Qc7ZmJNm3jymay9HHks4t7z6EMfdK3S7PlqPVMFbd8Rfa9fE+/gHFT4nP6mKehxEeAnCnlgGTWG7a1lSo9XLsO9SW5mkodB8n94ajnqyX1HwlOwn7SObyhm5U4FRv3srWM5+g/t+BFM1MXHs/Vr4=" 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&data=04%7C01%7Ceprints-tech%40ecs.soton.ac.uk%7C0cb4e0cdebd0459be90608d8bb5de9bd%7C4a5378f929f44d3ebe89669d03ada9d8%7C0%7C0%7C637465359314675337%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=zvMZi%2BosSyjQu5hXPSW39liRv56Pq6V37H%2BbVKGydZQ%3D&reserved=0" originalSrc="http://wiki.eprints.org/" shash="QMbOqRNICKEfv/pSHzmPIkrftooW6HjhbQuT0HN8E3GDLnsVrnoLlF9B7/xCu9nulsAM04n6XLbofWjOduA0g/IYMiEztfT0SlHYW8+4crjf0HvDphH/UENeGcZlE0L2oit7er3FtW0EpjILWcTcafpT9n5OuhZ5iYSrrTTZqn8=" rel="noreferrer" target="_blank">
http://wiki.eprints.org/</a></blockquote>
</div>
</div>
</body>
</html>