<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 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 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:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
tt
{mso-style-priority:99;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle20
{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=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Just a guess… try reindexing the dataset:<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>bin/epadmin reindex ARCHIVEID subject<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><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I’m not sure if this will actually cause the index tables to be recreated, or just emptied/refilled (and it may just generate lots more of the same error).<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><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Whenever I see the ‘ordervalues’ stuff, I think ‘indexing’ (this might not be the right thing to think though!). <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><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Having said that, if you don’t use subjects, it’s probably safe to ignore – but might be worth checking you don’t have any references to subjects in any views.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I think the line (in generate_views):<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>$session->cache_subjects;<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>is causing the error.<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><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Cheers,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>John<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><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","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> 11 February 2015 07:53<br><b>To:</b> eprints-tech@ecs.soton.ac.uk<br><b>Subject:</b> [EP-tech] Re: 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 style='margin-bottom:12.0pt'>Thank you, but that was what I had already done.<br><br>Pressing "Update database" from the admin screen in the repository like Lizz suggested did the trick :)<o:p></o:p></p><div><p class=MsoNormal>On 11-02-2015 01:05, <a href="mailto:mohdizwan8733@salam.uitm.edu.my">mohdizwan8733@salam.uitm.edu.my</a> wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><tt><span style='font-size:10.0pt'>Run that ./epadmin upgrade repository_id</span></tt> <br><br><br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#A1009F'>Mohd Izwan Bin Salim</span> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#A1009F'>Pustakawan | Unit Pembangunan Web | Bahagian Pengurusan Perpustakaan Digital (BPPD),</span> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#A1009F'>Perpustakaan Tun Abdul Razak, </span><br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#A1009F'>Universiti Teknologi MARA, 40450 Shah Alam, Selangor Darul Ehsan</span> <br><br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#A1009F'>Email: <a href="mailto:mohdizwan8733@salam.uitm.edu.my">mohdizwan8733@salam.uitm.edu.my</a> / <a href="mailto:kizbye@gmail.com">kizbye@gmail.com</a></span> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#A1009F'>Phone: 03 5544 3770 / 012 912 9094<br></span><br><br><br><br><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F'>From: </span><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'>Lizz Jennings <a href="mailto:E.Jennings@bath.ac.uk"><E.Jennings@bath.ac.uk></a></span> <br><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F'>To: </span><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'><a href="mailto:eprints-tech@ecs.soton.ac.uk">"eprints-tech@ecs.soton.ac.uk"</a> <a href="mailto:eprints-tech@ecs.soton.ac.uk"><eprints-tech@ecs.soton.ac.uk></a>, </span><br><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F'>Date: </span><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'>10/02/2015 08:23 PM</span> <br><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F'>Subject: </span><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'>[EP-tech] Re: Errors on generate_views after 3.3.12 to 3.3.13 upgrade</span> <br><span style='font-size:7.5pt;font-family:"Arial","sans-serif";color:#5F5F5F'>Sent by: </span><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'><a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a></span> <o:p></o:p></p><div class=MsoNormal align=center style='text-align:center'><hr size=2 width="100%" noshade style='color:#A0A0A0' align=center></div><p class=MsoNormal><br><br><br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#004080'>You should just be able to click the Update Database button in the Admin screen for config tools.</span> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#004080'> </span> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#004080'>Lizz</span> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#004080'> </span> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#004080'>--</span> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#004080'>Lizz Jennings BA MSc ACLIP MCLIP (Revalidated 2014)</span> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#004080'>Technical Data Officer</span> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#004080'>The Library 4.10, University of Bath, Bath, BA2 7AY UK</span> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#004080'>Ext. 3570 (External 01225 383570)</span> <br><a href="mailto:E.Jennings@bath.ac.uk"><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#0082BF'>E.Jennings@bath.ac.uk</span></a> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#004080'>Research Data Management: </span><a href="http://www.bath.ac.uk/research/data"><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#0082BF'>http://www.bath.ac.uk/research/data</span></a> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#004080'> </span> <br><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";color:#004080'> </span> <br><b><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'> <a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a> [</span><a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk"><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>mailto:eprints-tech-bounces@ecs.soton.ac.uk</span></a><span style='font-size:10.0pt;font-family:"Calibri","sans-serif"'>] <b>On Behalf Of </b>Jacob Wenzel<b><br>Sent:</b> 10 February 2015 12:06<b><br>To:</b> <a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a><b><br>Subject:</b> [EP-tech] Errors on generate_views after 3.3.12 to 3.3.13 upgrade</span> <br> <br>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:<span style='color:red'><br>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<tt><span style='font-size:10.0pt'>*** Options: </span></tt><a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"><tt><span style='font-size:10.0pt'>http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</span></tt></a><span style='font-size:10.0pt;font-family:"Courier New"'><br><tt>*** Archive: </tt></span><a href="http://www.eprints.org/tech.php/"><tt><span style='font-size:10.0pt'>http://www.eprints.org/tech.php/</span></tt></a><span style='font-size:10.0pt;font-family:"Courier New"'><br><tt>*** EPrints community wiki: </tt></span><a href="http://wiki.eprints.org/"><tt><span style='font-size:10.0pt'>http://wiki.eprints.org/</span></tt></a><span style='font-size:10.0pt;font-family:"Courier New"'><br><tt>*** EPrints developers Forum: </tt></span><a href="http://forum.eprints.org/"><tt><span style='font-size:10.0pt'>http://forum.eprints.org/</span></tt></a><span style='font-size:10.0pt;font-family:"Courier New"'><br></span><br><br><br><br><o:p></o:p></p><pre>*** 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></pre><pre>*** Archive: <a href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><o:p></o:p></pre><pre>*** EPrints community wiki: <a href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><o:p></o:p></pre><pre>*** EPrints developers Forum: <a href="http://forum.eprints.org/">http://forum.eprints.org/</a><o:p></o:p></pre></blockquote><p class=MsoNormal><o:p> </o:p></p></div></body></html>