<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)"><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;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
color:black;}
.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'>I think that EPrints used to have a ‘succeeds’ and a ‘replacedby’ field.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>By defaults it now just has a ‘succeeds’ field. It sounds like somewhere you’ve got a reference to ‘replacedby’ – that doesn’t exist?<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> 03 February 2015 13:12<br><b>To:</b> eprints-tech@ecs.soton.ac.uk<br><b>Subject:</b> [EP-tech] Re: Autocomplete broken after 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'>I don't mean to bug, but did you get a chance to look into this David? I don't understand the errors in the log.<br><br>Thank you in advance<br><br>/Jacob!<o:p></o:p></p><div><p class=MsoNormal>On 30-01-2015 15:49, Jacob Wenzel wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal style='margin-bottom:12.0pt'>Thanks a lot for the both of you.<br><br>No problem at all David, it is just a minor issue, actually I was pleased to find how easy the upgrade process went.<br><br>I forgot to mention my server is running Ubuntu x64 12.04 LTS.<br><br>This is all I see in the log Alan. I have replaced my actual repository ID with [repoid].<br><br>I have no idea where the reference to xxx-ru.com comes from, I suspect it is some kind of spammer.<br><br>error.log:<br><span style='color:#000099'>------------------------------------------------------------------<br>---------------- EPrints System Error ----------------------------<br>------------------------------------------------------------------<br>Attempt to get value from not existent field: eprint/replacedby<br>------------------------------------------------------------------<br> at /usr/share/eprints3/perl_lib/EPrints/DataObj.pm line 702<br> EPrints::DataObj::get_value('EPrints::DataObj::EPrint=HASH(0x7f3dcd0dd780)', 'replacedby') called at /usr/share/eprints3/lib/plugins/EPrints/Plugin/Collection.pm line 113<br> EPrints::DataObj::EPrint::render('EPrints::DataObj::EPrint=HASH(0x7f3dcd0dd780)') called at /usr/share/eprints3/perl_lib/EPrints/DataObj/EPrint.pm line 1406<br> EPrints::DataObj::EPrint::generate_static('EPrints::DataObj::EPrint=HASH(0x7f3dcd0dd780)') called at /usr/share/eprints3/perl_lib/EPrints/Update/Abstract.pm line 66<br> EPrints::Update::Abstract::update('EPrints::Repository=HASH(0x7f3dc7d6ce80)', 'en', 499, '/archive/00/00/04/99') called at /usr/share/eprints3/perl_lib/EPrints/Apache/Rewrite.pm line 472<br> EPrints::Apache::Rewrite::handler('Apache2::RequestRec=SCALAR(0x7f3dc912af18)') called at -e line 0<br> eval {...} called at -e line 0<br>[Fri Jan 30 15:09:12 2015] [error] [client 37.115.186.0] EPrints::abort()\n, referer: <a href="http://xxx-ru.com/">http://xxx-ru.com/</a><br>DBD::mysql::st execute failed: Table '[repoid].subject_name_sortvalue' doesn't exist at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 3211.<br>SQL ERROR (execute): SELECT `subjectid`,`pos`,`name_sortvalue` FROM `subject_name_sortvalue` WHERE `subjectid` IN ('divisions')<br>SQL ERROR (execute): Table '[repoid].subject_name_sortvalue' doesn't exist<br>DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 2674.<br>DBD::mysql::st execute failed: Table '[repoid].subject_sortvalue_sortvalue' doesn't exist at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 3211.<br>SQL ERROR (execute): SELECT `subjectid`,`pos`,`sortvalue_sortvalue` FROM `subject_sortvalue_sortvalue` WHERE `subjectid` IN ('divisions')<br>SQL ERROR (execute): Table '[repoid].subject_sortvalue_sortvalue' doesn't exist<br>DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 2674.<br>DBD::mysql::st execute failed: Table '[repoid].subject_sortvalue_lang' doesn't exist at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 3211.<br>SQL ERROR (execute): SELECT `subjectid`,`pos`,`sortvalue_lang` FROM `subject_sortvalue_lang` WHERE `subjectid` IN ('divisions')<br>SQL ERROR (execute): Table '[repoid].subject_sortvalue_lang' doesn't exist<br>DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 2674.<br>DBD::mysql::st execute failed: Unknown column 'subject__ordervalues_en.sortvalue_sortvalue' in 'order clause' at /usr/share/eprints3/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/perl_lib/EPrints/Search/Condition.pm line 588.<br></span><br>Thank you all again, have a nice weekend!!<o:p></o:p></p><div><p class=MsoNormal>On 30-01-2015 15:14, David R Newman wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><pre>Hi Jacob/Alan,<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>I will have a look into this as I have been sorting other issues with<o:p></o:p></pre><pre>the Debian package upgrade. This means I have some VM snapshots I can<o:p></o:p></pre><pre>quickly swap between pre and post upgrade to see whether this breaks<o:p></o:p></pre><pre>during the upgrade.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Unfortunately, I probably won't have time to have a look before the<o:p></o:p></pre><pre>weekend but I should be able to sometime Monday/Tuesday next week.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Regards<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>David Newman<o:p></o:p></pre><pre>EPrints Services<o:p></o:p></pre><pre><o:p> </o:p></pre><pre><o:p> </o:p></pre><pre>On Fri, 2015-01-30 at 12:38 +0000, Alan.Stiles wrote:<o:p></o:p></pre><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><pre>I would expect to see some errors in the httpd error_log if the autocomplete is failing - anything in there?<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Alan<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>-----Original Message-----<o:p></o:p></pre><pre>From: Jacob Wenzel [<a href="mailto:jw@energiakademiet.dk">mailto:jw@energiakademiet.dk</a>]<o:p></o:p></pre><pre>Sent: 30 January 2015 10:39<o:p></o:p></pre><pre>To: <a href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a><o:p></o:p></pre><pre>Subject: [EP-tech] Autocomplete broken after upgrade<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Hi guys!<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>I just did a successful upgrade from 3.3.12 --> 3.3.13 and most went smoothe.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>However my simple autocomplete files for the "Projects" field, does not load anymore. I followed this guide, and I was working just fine before the upgrade:<o:p></o:p></pre><pre><a href="http://wiki.eprints.org/w/Autocompletion_and_Authority_Files_%28Romeo_Autocomplete%29">http://wiki.eprints.org/w/Autocompletion_and_Authority_Files_%28Romeo_Autocomplete%29</a><o:p></o:p></pre><pre><o:p> </o:p></pre><pre>I just checked, and everything seems to look like it did before the upgrade.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>I have already run bin/epadmin upgrade [repoid], and I have restartet apache and the indexer.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Help or pointers will be greatly appreciated, thank you in advance.<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>Have a nice weekend everyone!!<o:p></o:p></pre><pre><o:p> </o:p></pre><pre>/Jacob<o:p></o:p></pre><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><pre>-- The Open University is incorporated by Royal Charter (RC 000391), an exempt charity in England & Wales and a charity registered in Scotland (SC 038302). The Open University is authorised and regulated by the Financial Conduct Authority.<o:p></o:p></pre><pre><o:p> </o:p></pre><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><pre><o:p> </o:p></pre><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><pre><o:p> </o:p></pre></blockquote><p class=MsoNormal><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>