<html xmlns:v="urn:schemas-microsoft-com:vml" 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 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",serif;
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body bgcolor="white" lang="EN-GB" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">You should just be able to click the Update Database button in the Admin screen for config tools.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Lizz<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">--<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Lizz Jennings BA MSc ACLIP MCLIP (Revalidated 2014)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Technical Data Officer<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">The Library 4.10, University of Bath, Bath, BA2 7AY UK<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="SV" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D">Ext. 3570 (External 01225 383570)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><a href="mailto:E.Jennings@bath.ac.uk"><span lang="SV">E.Jennings@bath.ac.uk</span></a></span><u><span lang="SV" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#0563C1"><o:p></o:p></span></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Research Data Management:
<a href="http://www.bath.ac.uk/research/data">http://www.bath.ac.uk/research/data</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"> eprints-tech-bounces@ecs.soton.ac.uk
[mailto:eprints-tech-bounces@ecs.soton.ac.uk] <b>On Behalf Of </b>Jacob Wenzel<br>
<b>Sent:</b> 10 February 2015 12:06<br>
<b>To:</b> eprints-tech@ecs.soton.ac.uk<br>
<b>Subject:</b> [EP-tech] Errors on generate_views after 3.3.12 to 3.3.13 upgrade<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi guys!<br>
<br>
After upgrading my repository from 3.3.12 to 3.3.13, the generate_views gives me these errors in the console:<br>
<span style="color:red">DBD::mysql::st execute failed: Unknown column 'subject__ordervalues_en.sortvalue_sortvalue' in 'order clause' at /usr/share/eprints3/bin/../perl_lib/EPrints/Database.pm line 3211.<br>
SQL ERROR (execute): SELECT `subject`.`subjectid` FROM `subject` LEFT JOIN `subject__ordervalues_en` ON `subject`.`subjectid`=`subject__ordervalues_en`.`subjectid` WHERE 1=1 GROUP BY `subject`.`subjectid`, `subject__ordervalues_en`.`sortvalue_sortvalue`, `subject__ordervalues_en`.`name_name`
ORDER BY `subject__ordervalues_en`.`sortvalue_sortvalue` ASC, `subject__ordervalues_en`.`name_name` ASC<br>
SQL ERROR (execute): Unknown column 'subject__ordervalues_en.sortvalue_sortvalue' in 'order clause'<br>
DBD::mysql::st fetch failed: fetch() without execute() at /usr/share/eprints3/bin/../perl_lib/EPrints/Search/Condition.pm line 588.<br>
Warning! No values were found for eprint.view.subjects [subjects] - configuration may be wrong<br>
Warning! No values were found for eprint.view.divisions [divisions] - configuration may be wrong</span><br>
<br>
I don't use subjects or divisions in my repository (I have one division and one subject), so the warnings in the end are expected and were there before the upgrade. But the errors above it are new. A have made no changes to Database.pm or Condition.pm.<br>
<br>
All view pages generate correctly, so I am wondering if I should just ignore it. Any thought or help on this topic would be greatly appreciated.<br>
<br>
Have a nice day everyone!<br>
<br>
/Jacob<o:p></o:p></p>
</div>
</body>
</html>