<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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 :)<br>
<br>
<div class="moz-cite-prefix">On 11-02-2015 01:05,
<a class="moz-txt-link-abbreviated" href="mailto:mohdizwan8733@salam.uitm.edu.my">mohdizwan8733@salam.uitm.edu.my</a> wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|7f548ca72422614be5d97923c7c6db18r1A0QY14eprints-tech-bounces|ecs.soton.ac.uk|OF604E6B1E.926FBA67-ON48257DE9.00005DA1-48257DE9.00008073@uitm.edu.my"
type="cite"><tt><font size="2">Run that ./epadmin upgrade
repository_id</font></tt>
<br>
<br>
<br>
<font color="#a1009f" face="Calibri" size="2">Mohd Izwan Bin Salim</font>
<br>
<font color="#a1009f" face="Calibri" size="2">Pustakawan | Unit
Pembangunan
Web | Bahagian Pengurusan Perpustakaan Digital (BPPD),</font>
<br>
<font color="#a1009f" face="Calibri" size="2">Perpustakaan Tun
Abdul Razak,
</font>
<br>
<font color="#a1009f" face="Calibri" size="2">Universiti Teknologi
MARA,
40450 Shah Alam, Selangor Darul Ehsan</font>
<br>
<br>
<font color="#a1009f" face="Calibri" size="2">Email:
<a class="moz-txt-link-abbreviated" href="mailto:mohdizwan8733@salam.uitm.edu.my">mohdizwan8733@salam.uitm.edu.my</a>
/ <a class="moz-txt-link-abbreviated" href="mailto:kizbye@gmail.com">kizbye@gmail.com</a></font>
<br>
<font color="#a1009f" face="Calibri" size="2">Phone: 03 5544 3770
/ 012
912 9094<br>
</font>
<br>
<br>
<br>
<br>
<font color="#5f5f5f" face="sans-serif" size="1">From:
</font><font face="sans-serif" size="1">Lizz Jennings
<a class="moz-txt-link-rfc2396E" href="mailto:E.Jennings@bath.ac.uk"><E.Jennings@bath.ac.uk></a></font>
<br>
<font color="#5f5f5f" face="sans-serif" size="1">To:
</font><font face="sans-serif" size="1"><a class="moz-txt-link-rfc2396E" href="mailto:eprints-tech@ecs.soton.ac.uk">"eprints-tech@ecs.soton.ac.uk"</a>
<a class="moz-txt-link-rfc2396E" href="mailto:eprints-tech@ecs.soton.ac.uk"><eprints-tech@ecs.soton.ac.uk></a>,
</font>
<br>
<font color="#5f5f5f" face="sans-serif" size="1">Date:
</font><font face="sans-serif" size="1">10/02/2015 08:23 PM</font>
<br>
<font color="#5f5f5f" face="sans-serif" size="1">Subject:
</font><font face="sans-serif" size="1">[EP-tech] Re:
Errors on generate_views after 3.3.12 to 3.3.13 upgrade</font>
<br>
<font color="#5f5f5f" face="sans-serif" size="1">Sent by:
</font><font face="sans-serif" size="1"><a class="moz-txt-link-abbreviated" href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a></font>
<br>
<hr noshade="noshade">
<br>
<br>
<br>
<font color="#004080" face="Calibri" size="2">You should just be
able to
click the Update Database button in the Admin screen for config
tools.</font>
<br>
<font color="#004080" face="Calibri" size="2"> </font>
<br>
<font color="#004080" face="Calibri" size="2">Lizz</font>
<br>
<font color="#004080" face="Calibri" size="2"> </font>
<br>
<font color="#004080" face="Calibri" size="2">--</font>
<br>
<font color="#004080" face="Calibri" size="2">Lizz Jennings BA MSc
ACLIP
MCLIP (Revalidated 2014)</font>
<br>
<font color="#004080" face="Calibri" size="2">Technical Data
Officer</font>
<br>
<font color="#004080" face="Calibri" size="2">The Library 4.10,
University
of Bath, Bath, BA2 7AY UK</font>
<br>
<font color="#004080" face="Calibri" size="2">Ext. 3570 (External
01225
383570)</font>
<br>
<a moz-do-not-send="true" href="mailto:E.Jennings@bath.ac.uk"><font
color="#0082bf" face="Calibri" size="2"><u>E.Jennings@bath.ac.uk</u></font></a>
<br>
<font color="#004080" face="Calibri" size="2">Research Data
Management:
</font><a moz-do-not-send="true"
href="http://www.bath.ac.uk/research/data"><font color="#0082bf"
face="Calibri" size="2"><u>http://www.bath.ac.uk/research/data</u></font></a>
<br>
<font color="#004080" face="Calibri" size="2"> </font>
<br>
<font color="#004080" face="Calibri" size="2"> </font>
<br>
<font face="Calibri" size="2"><b>From:</b>
<a class="moz-txt-link-abbreviated" href="mailto:eprints-tech-bounces@ecs.soton.ac.uk">eprints-tech-bounces@ecs.soton.ac.uk</a>
[</font><a moz-do-not-send="true"
href="mailto:eprints-tech-bounces@ecs.soton.ac.uk"><font
face="Calibri" size="2">mailto:eprints-tech-bounces@ecs.soton.ac.uk</font></a><font
face="Calibri" size="2">]
<b>On Behalf Of </b>Jacob Wenzel<b><br>
Sent:</b> 10 February 2015 12:06<b><br>
To:</b> <a class="moz-txt-link-abbreviated" 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</font>
<br>
<font face="Times New Roman" size="3"> </font>
<br>
<font face="Times New Roman" size="3">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:</font><font color="red"
face="Times New Roman" size="3"><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</font><font face="Times New Roman" size="3"><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</font><tt><font size="2">*** Options: </font></tt><a
moz-do-not-send="true"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"><tt><font
size="2">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</font></tt></a><tt><font
size="2"><br>
*** Archive: </font></tt><a moz-do-not-send="true"
href="http://www.eprints.org/tech.php/"><tt><font size="2">http://www.eprints.org/tech.php/</font></tt></a><tt><font
size="2"><br>
*** EPrints community wiki: </font></tt><a
moz-do-not-send="true" href="http://wiki.eprints.org/"><tt><font
size="2">http://wiki.eprints.org/</font></tt></a><tt><font
size="2"><br>
*** EPrints developers Forum: </font></tt><a
moz-do-not-send="true" href="http://forum.eprints.org/"><tt><font
size="2">http://forum.eprints.org/</font></tt></a><tt><font
size="2"><br>
</font></tt>
<br>
<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>