EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #03898

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Re: Autocomplete broken after upgrade

Thanks a lot David and John!
I thought you were right at first David, as I did remember adding some javascript, but I have just checked, and I have only added some new features to 90_local.js
I do see the spinning box very briefly, but I have tried several entries copied directly from my autocomplete list, and they just don't show up, neither at the right place nor top or anywhere else on the screen for that madder.
Furthermore I can see, that all the js-files have been changed at the day of the upgrade.
70_autocomplete.js is present in two places on my installation: "/lib/static/javascript/auto/" and "/archives/[repoID]/html/en/javascript/auto/" (the later was created this morning through cron, generate static). 

Both have the correct line 12:

Element.clonePosition(element, $(target), {
I have attached the only JavaScript customizations I have done. I don't think they should cause a problem, but I am not sure. 



On 04-02-2015 13:16, David R Newman wrote:

Hi Jacob,

I have had a chance to test an upgrade from 3.3.12 to 3.3.13 and
Unfortunately, I cannot replicate the problem you are having.  However,
I did note an issue with the Javascript for the Debian package for
3.3.12, which has been subsequently fixed in 3.3.13.  However, if you
had made a local copy of this file
(/usr/share/eprints3/lib/static/javascript/auto/70_autocomplete.js) in
your archive then this local copy would override what the updated
version under /usr/share/eprints3/lib/ and may cause an issue with your
autocomplete fields.

One way to test whether this is an issue is to type the start of a
project name you know exists in you autocomplete file into the project
input field.  Do you very briefly see a box with a spinning icon? If so
scroll to the top of the page to see if you can see a box containing the
project you started to type in.  If not, if you could do the following
things:

run a "sudo updatedb" and then a locate 70_autocomplete.js and send me
the results of the locate.  Also
check /usr/share/eprints3/lib/static/javascript/auto/70_autocomplete.js
to make sure that on line 12 (or there about) says:

Element.clonePosition(element, $(target), {

rather than:

Position.clone(element, $(target), {

If there are any other occurrences of this file anyway other than this
check to make sure they have the former rather than latter line as well.

This became an issue because recent versions of PrototypeJS did not
support the Position.clone function call.  However, if you are upgrading
you should have versions of 20_prototype.js and 70_autocomplete.js that
are known to work together, unless you made a local copy of one of these
in your archive at some point in the past.

Regards

David Newman

On Fri, 2015-01-30 at 15:49 +0100, Jacob Wenzel wrote:

Thanks a lot for the both of you.

No problem at all David, it is just a minor issue, actually I was
pleased to find how easy the upgrade process went.

I forgot to mention my server is running Ubuntu x64 12.04 LTS.

This is all I see in the log Alan. I have replaced my actual
repository ID with [repoid].

I have no idea where the reference to xxx-ru.com comes from, I suspect
it is some kind of spammer.

error.log:
------------------------------------------------------------------
---------------- EPrints System Error ----------------------------
------------------------------------------------------------------
Attempt to get value from not existent field: eprint/replacedby
------------------------------------------------------------------
  at /usr/share/eprints3/perl_lib/EPrints/DataObj.pm line 702

EPrints::DataObj::get_value('EPrints::DataObj::EPrint=HASH(0x7f3dcd0dd780)', 'replacedby') called at /usr/share/eprints3/lib/plugins/EPrints/Plugin/Collection.pm line 113

EPrints::DataObj::EPrint::render('EPrints::DataObj::EPrint=HASH(0x7f3dcd0dd780)') called at /usr/share/eprints3/perl_lib/EPrints/DataObj/EPrint.pm line 1406

EPrints::DataObj::EPrint::generate_static('EPrints::DataObj::EPrint=HASH(0x7f3dcd0dd780)') called at /usr/share/eprints3/perl_lib/EPrints/Update/Abstract.pm line 66

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

EPrints::Apache::Rewrite::handler('Apache2::RequestRec=SCALAR(0x7f3dc912af18)') called at -e line 0
     eval {...} called at -e line 0
[Fri Jan 30 15:09:12 2015] [error] [client 37.115.186.0]
EPrints::abort()\n, referer:http://xxx-ru.com/
DBD::mysql::st execute failed: Table '[repoid].subject_name_sortvalue'
doesn't exist at /usr/share/eprints3/perl_lib/EPrints/Database.pm line
3211.
SQL ERROR (execute): SELECT `subjectid`,`pos`,`name_sortvalue` FROM
`subject_name_sortvalue` WHERE `subjectid` IN ('divisions')
SQL ERROR (execute): Table '[repoid].subject_name_sortvalue' doesn't
exist
DBD::mysql::st fetchrow_array failed: fetch() without execute()
at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 2674.
DBD::mysql::st execute failed: Table
'[repoid].subject_sortvalue_sortvalue' doesn't exist
at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 3211.
SQL ERROR (execute): SELECT `subjectid`,`pos`,`sortvalue_sortvalue`
FROM `subject_sortvalue_sortvalue` WHERE `subjectid` IN ('divisions')
SQL ERROR (execute): Table '[repoid].subject_sortvalue_sortvalue'
doesn't exist
DBD::mysql::st fetchrow_array failed: fetch() without execute()
at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 2674.
DBD::mysql::st execute failed: Table '[repoid].subject_sortvalue_lang'
doesn't exist at /usr/share/eprints3/perl_lib/EPrints/Database.pm line
3211.
SQL ERROR (execute): SELECT `subjectid`,`pos`,`sortvalue_lang` FROM
`subject_sortvalue_lang` WHERE `subjectid` IN ('divisions')
SQL ERROR (execute): Table '[repoid].subject_sortvalue_lang' doesn't
exist
DBD::mysql::st fetchrow_array failed: fetch() without execute()
at /usr/share/eprints3/perl_lib/EPrints/Database.pm line 2674.
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.
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
SQL ERROR (execute): Unknown column
'subject__ordervalues_en.sortvalue_sortvalue' in 'order clause'
DBD::mysql::st fetch failed: fetch() without execute()
at /usr/share/eprints3/perl_lib/EPrints/Search/Condition.pm line 588.

Thank you all again, have a nice weekend!!

On 30-01-2015 15:14, David R Newman wrote:


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:

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 [mailto:jw@energiakademiet.dk]
Sent: 30 January 2015 10:39
To:eprints-tech@ecs.soton.ac.uk
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:
http://wiki.eprints.org/w/Autocompletion_and_Authority_Files_%28Romeo_Autocomplete%29

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:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive:http://www.eprints.org/tech.php/
*** EPrints community wiki:http://wiki.eprints.org/
*** EPrints developers Forum:http://forum.eprints.org/
-- 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:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive:http://www.eprints.org/tech.php/
*** EPrints community wiki:http://wiki.eprints.org/
*** EPrints developers Forum:http://forum.eprints.org/

*** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive:http://www.eprints.org/tech.php/
*** EPrints community wiki:http://wiki.eprints.org/
*** EPrints developers Forum:http://forum.eprints.org/


*** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive:http://www.eprints.org/tech.php/
*** EPrints community wiki:http://wiki.eprints.org/
*** EPrints developers Forum:http://forum.eprints.org/

*** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** Archive:http://www.eprints.org/tech.php/
*** EPrints community wiki:http://wiki.eprints.org/
*** EPrints developers Forum:http://forum.eprints.org/

Attachment: 90_local.js
Description: JavaScript source