<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Thanks a lot Lizz!<br>
<br>
I was sure I had already done that, but now the errors are gone.<br>
<br>
/Jacob<br>
<br>
<div class="moz-cite-prefix">On 10-02-2015 13:16, Lizz Jennings
wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|d3e860e0f3fa6d969b006cf63b64309ar19CKH14eprints-tech-bounces|ecs.soton.ac.uk|28ca6a981ddd4ac198cd65f1463a37c8@exch01.campus.bath.ac.uk"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<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]-->
<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
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D"
lang="SV">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
moz-do-not-send="true"
href="mailto:E.Jennings@bath.ac.uk"><span lang="SV">E.Jennings@bath.ac.uk</span></a></span><u><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#0563C1"
lang="SV"><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 moz-do-not-send="true"
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
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"
lang="EN-US">From:</span></b><span
style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:windowtext"
lang="EN-US"> <a class="moz-txt-link-abbreviated" href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a>
[<a class="moz-txt-link-freetext" href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">mailto:eprints-tech-bounces@ecs.soton.ac.uk</a>] <b>On
Behalf Of </b>Jacob Wenzel<br>
<b>Sent:</b> 10 February 2015 12:06<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a><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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
</body>
</html>