[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[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 at energiakademiet.dk]
>>>> Sent: 30 January 2015 10:39
>>>> To:eprints-tech at 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/
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: 90_local.js
Type: application/x-javascript
Size: 5757 bytes
Desc: not available
Url : http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20150209/7c21b5eb/attachment.js