<tt><font size=2>Run that ./epadmin upgrade repository_id</font></tt>
<br>
<br>
<br><font size=2 color=#a1009f face="Calibri">Mohd Izwan Bin Salim</font>
<br><font size=2 color=#a1009f face="Calibri">Pustakawan | Unit Pembangunan
Web | Bahagian Pengurusan Perpustakaan Digital (BPPD),</font>
<br><font size=2 color=#a1009f face="Calibri">Perpustakaan Tun Abdul Razak,
</font>
<br><font size=2 color=#a1009f face="Calibri">Universiti Teknologi MARA,
40450 Shah Alam, Selangor Darul Ehsan</font>
<br>
<br><font size=2 color=#a1009f face="Calibri">Email: mohdizwan8733@salam.uitm.edu.my
/ kizbye@gmail.com</font>
<br><font size=2 color=#a1009f face="Calibri">Phone: 03 5544 3770 / 012
912 9094<br>
</font>
<br>
<br>
<br>
<br><font size=1 color=#5f5f5f face="sans-serif">From:
</font><font size=1 face="sans-serif">Lizz Jennings <E.Jennings@bath.ac.uk></font>
<br><font size=1 color=#5f5f5f face="sans-serif">To:
</font><font size=1 face="sans-serif">"eprints-tech@ecs.soton.ac.uk"
<eprints-tech@ecs.soton.ac.uk>, </font>
<br><font size=1 color=#5f5f5f face="sans-serif">Date:
</font><font size=1 face="sans-serif">10/02/2015 08:23 PM</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Subject:
</font><font size=1 face="sans-serif">[EP-tech] Re:
Errors on generate_views after 3.3.12 to 3.3.13 upgrade</font>
<br><font size=1 color=#5f5f5f face="sans-serif">Sent by:
</font><font size=1 face="sans-serif">eprints-tech-bounces@ecs.soton.ac.uk</font>
<br>
<hr noshade>
<br>
<br>
<br><font size=2 color=#004080 face="Calibri">You should just be able to
click the Update Database button in the Admin screen for config tools.</font>
<br><font size=2 color=#004080 face="Calibri"> </font>
<br><font size=2 color=#004080 face="Calibri">Lizz</font>
<br><font size=2 color=#004080 face="Calibri"> </font>
<br><font size=2 color=#004080 face="Calibri">--</font>
<br><font size=2 color=#004080 face="Calibri">Lizz Jennings BA MSc ACLIP
MCLIP (Revalidated 2014)</font>
<br><font size=2 color=#004080 face="Calibri">Technical Data Officer</font>
<br><font size=2 color=#004080 face="Calibri">The Library 4.10, University
of Bath, Bath, BA2 7AY UK</font>
<br><font size=2 color=#004080 face="Calibri">Ext. 3570 (External 01225
383570)</font>
<br><a href=mailto:E.Jennings@bath.ac.uk><font size=2 color=#0082bf face="Calibri"><u>E.Jennings@bath.ac.uk</u></font></a>
<br><font size=2 color=#004080 face="Calibri">Research Data Management:
</font><a href=http://www.bath.ac.uk/research/data><font size=2 color=#0082bf face="Calibri"><u>http://www.bath.ac.uk/research/data</u></font></a>
<br><font size=2 color=#004080 face="Calibri"> </font>
<br><font size=2 color=#004080 face="Calibri"> </font>
<br><font size=2 face="Calibri"><b>From:</b> eprints-tech-bounces@ecs.soton.ac.uk
[</font><a href="mailto:eprints-tech-bounces@ecs.soton.ac.uk"><font size=2 face="Calibri">mailto:eprints-tech-bounces@ecs.soton.ac.uk</font></a><font size=2 face="Calibri">]
<b>On Behalf Of </b>Jacob Wenzel<b><br>
Sent:</b> 10 February 2015 12:06<b><br>
To:</b> eprints-tech@ecs.soton.ac.uk<b><br>
Subject:</b> [EP-tech] Errors on generate_views after 3.3.12 to 3.3.13
upgrade</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">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 size=3 color=red face="Times New Roman"><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 size=3 face="Times New Roman"><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 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 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 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 href=http://forum.eprints.org/><tt><font size=2>http://forum.eprints.org/</font></tt></a><tt><font size=2><br>
</font></tt>
<br>