<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Title content=""><meta name=Keywords content=""><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Calibri;
color:windowtext;}
span.msoIns
{mso-style-type:export-only;
mso-style-name:"";
text-decoration:underline;
color:teal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:595.0pt 842.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style></head><body bgcolor=white lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:Calibri'>Hi<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:Calibri'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:Calibri'> At the command line run the command:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:Calibri'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:Calibri'><eprints_root>/bin/epadmin update <repository_id><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:Calibri'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:Calibri'> …and then restart the webserver. Let us know what happened.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:Calibri'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:Calibri'>--<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:Calibri'>Adam<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:Calibri'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:Calibri'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal style='margin-left:36.0pt'><b><span style='font-family:Calibri;color:black'>From: </span></b><span style='font-family:Calibri;color:black'><eprints-tech-bounces@ecs.soton.ac.uk> on behalf of Andras Holl <holl@konkoly.hu><br><b>Reply-To: </b><eprints-tech@ecs.soton.ac.uk><br><b>Date: </b>Tuesday, 27 June 2017 07:38<br><b>To: </b><eprints-tech@ecs.soton.ac.uk><br><b>Subject: </b>[EP-tech] We have messed up our EPrints<o:p></o:p></span></p></div><div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>Hi,<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>We have tried to install a plugin, but run into problems. Then we have tried<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>uninstalling it. We ended up with error messages:<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>Undefined phrase: lib/searchfield:help_counter (en) at line 757 in<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>/usr/share/eprints3/perl_lib/EPrints/Search/Field.pm<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>Undefined phrase: eprint_fieldname_creators_orcid (en) at line 423 in<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>/usr/share/eprints3/perl_lib/EPrints/MetaField.pm<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>DBD::mysql::st execute failed: Unknown column<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>'subject__ordervalues_en.sortvalue_sortvalue' in 'order clause' at<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>/usr/share/eprints3/perl_lib/EPrints/<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>Database.pm line 3211.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>SQL ERROR (execute): SELECT `subject`.`subjectid` FROM `subject` LEFT JOIN<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>`subject__ordervalues_en` ON<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>`subject`.`subjectid`=`subject__ordervalues_en`.`subjectid` WHERE 1=1 GROUP BY<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>`subject`.`subjectid`, `subject__ordervalues_en`.`sortvalue_sortvalue`,<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>`subject__ordervalues_en`.`name_name` ORDER BY<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>`subject__ordervalues_en`.`sortvalue_sortvalue` ASC,<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>`subject__ordervalues_en`.`name_name` ASC<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>SQL ERROR (execute): Unknown column<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>'subject__ordervalues_en.sortvalue_sortvalue' in 'order clause'<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>DBD::mysql::st fetch failed: fetch() without execute() at<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>/usr/share/eprints3/perl_lib/EPrints/Search/Condition.pm line 588.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>DBD::mysql::st execute failed: Table 'REALDB.subject_name_sortvalue' doesn't<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>exist at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 3211.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>SQL ERROR (execute): SELECT `subjectid`,`pos`,`name_sortvalue` FROM<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>`subject_name_sortvalue` WHERE `subjectid` IN ('subjects')<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>SQL ERROR (execute): Table 'REALDB.subject_name_sortvalue' doesn't exist<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>DBD::mysql::st fetchrow_array failed: fetch() without execute() at<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>/usr/share/eprints3/perl_lib/EPrints/Database.pm line 2674.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>DBD::mysql::st execute failed: Table 'REALDB.subject_sortvalue_sortvalue'<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>doesn't exist at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 3211.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>SQL ERROR (execute): SELECT `subjectid`,`pos`,`sortvalue_sortvalue` FROM<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>`subject_sortvalue_sortvalue` WHERE `subjectid` IN ('subjects')<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>SQL ERROR (execute): Table 'REALDB.subject_sortvalue_sortvalue' doesn't exist<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>DBD::mysql::st fetchrow_array failed: fetch() without execute() at<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>/usr/share/eprints3/perl_lib/EPrints/Database.pm line 2674.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>DBD::mysql::st execute failed: Table 'REALDB.subject_sortvalue_lang' doesn't<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>exist at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 3211.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>SQL ERROR (execute): SELECT `subjectid`,`pos`,`sortvalue_lang` FROM<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>`subject_sortvalue_lang` WHERE `subjectid` IN ('subjects')<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>SQL ERROR (execute): Table 'REALDB.subject_sortvalue_lang' doesn't exist<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>DBD::mysql::st fetchrow_array failed: fetch() without execute() at<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>/usr/share/eprints3/perl_lib/EPrints/Database.pm line 2674.<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>[Tue Jun 27 07:44:41 2017] [error] Can't use an undefined value as an ARRAY<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>reference at<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>/usr/share/eprints3/perl_lib/EPrints/Plugin/InputForm/Component/Field/Subject.pm<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>line 392.\n<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>Could anyone help?<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>With best regards,<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>Andras Holl<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>Library and Information Centre, Hungarian Academy of Sciences<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>--------------------------------------------------------------------------------<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>Andras Holl / Holl Andras e-mail: <a href="mailto:holl@konkoly.hu">holl@konkoly.hu</a><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>--------------------------------------------------------------------------------<o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>*** Archive: <a href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>*** EPrints community wiki: <a href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'>*** EPrints developers Forum: <a href="http://forum.eprints.org/">http://forum.eprints.org/</a><o:p></o:p></p></div><div><p class=MsoNormal style='margin-left:36.0pt'><o:p> </o:p></p></div></div></body></html>