[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] Re: Autocomplete broken after upgrade
- Subject: [EP-tech] Re: Autocomplete broken after upgrade
- From: jw at energiakademiet.dk (Jacob Wenzel)
- Date: Fri, 30 Jan 2015 15:49:05 +0100
- In-reply-to: <EMEW3|e63de68125867942e04027f7c9c3d14fr0YEGl14eprints-tech-bounces|ecs.soton.ac.uk|1422627291.2544.107.camel@orville>
- References: <54CB5F4A.5060908@energiakademiet.dk> <EMEW3|6d02d23382ba2e3a230b8d0ac1104822r0YAdY14eprints-tech-bounces|ecs.soton.ac.uk|54CB5F4A.5060908@energiakademiet.dk> <794503398D03434AA2EB11513B5EBD02071C2C18@ASH.open.ac.uk> <1422627291.2544.107.camel@orville> <EMEW3|e63de68125867942e04027f7c9c3d14fr0YEGl14eprints-tech-bounces|ecs.soton.ac.uk|1422627291.2544.107.camel@orville>
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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20150130/98d43780/attachment-0001.html