<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
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!<br>
<br>
<div class="moz-cite-prefix">On 30-01-2015 15:49, Jacob Wenzel
wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|77355ec3c567b88a0bbd90910f666ca6r0YEna14eprints-tech-bounces|ecs.soton.ac.uk|54CB99E1.7020706@energiakademiet.dk"
type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
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>
<font 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 moz-do-not-send="true"
class="moz-txt-link-freetext" 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>
</font><br>
Thank you all again, have a nice weekend!!<br>
<br>
<div class="moz-cite-prefix">On 30-01-2015 15:14, David R Newman
wrote:<br>
</div>
<blockquote
cite="mid:EMEW3|e63de68125867942e04027f7c9c3d14fr0YEGl14eprints-tech-bounces|ecs.soton.ac.uk|1422627291.2544.107.camel@orville"
type="cite">
<pre wrap="">Hi Jacob/Alan,
I will have a look into this as I have been sorting other issues with
the Debian package upgrade. This means I have some VM snapshots I can
quickly swap between pre and post upgrade to see whether this breaks
during the upgrade.
Unfortunately, I probably won't have time to have a look before the
weekend but I should be able to sometime Monday/Tuesday next week.
Regards
David Newman
EPrints Services
On Fri, 2015-01-30 at 12:38 +0000, Alan.Stiles wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I would expect to see some errors in the httpd error_log if the autocomplete is failing - anything in there?
Alan
-----Original Message-----
From: Jacob Wenzel [<a moz-do-not-send="true" class="moz-txt-link-freetext" href="mailto:jw@energiakademiet.dk">mailto:jw@energiakademiet.dk</a>]
Sent: 30 January 2015 10:39
To: <a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:eprints-tech@ecs.soton.ac.uk">eprints-tech@ecs.soton.ac.uk</a>
Subject: [EP-tech] Autocomplete broken after upgrade
Hi guys!
I just did a successful upgrade from 3.3.12 --> 3.3.13 and most went smoothe.
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:
<a moz-do-not-send="true" class="moz-txt-link-freetext" 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>
I just checked, and everything seems to look like it did before the upgrade.
I have already run bin/epadmin upgrade [repoid], and I have restartet apache and the indexer.
Help or pointers will be greatly appreciated, thank you in advance.
Have a nice weekend everyone!!
/Jacob
*** Options: <a moz-do-not-send="true" 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 moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
-- 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.
*** Options: <a moz-do-not-send="true" 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 moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<pre wrap="">
*** Options: <a moz-do-not-send="true" 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 moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<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>