[EP-tech] We have messed up our EPrints

[Adam Field]

Hi

 

                At the command line run the command:

 

<eprints_root>/bin/epadmin update <repository_id>

 

                …and then restart the webserver.  Let us know what happened.

 

--

Adam

 

 

From: <eprints-tech-bounces at ecs.soton.ac.uk> on behalf of Andras Holl <holl at konkoly.hu>
Reply-To: <eprints-tech at ecs.soton.ac.uk>
Date: Tuesday, 27 June 2017 07:38
To: <eprints-tech at ecs.soton.ac.uk>
Subject: [EP-tech] We have messed up our EPrints

 

 

 

Hi,

 

We have tried to install a plugin, but run into problems. Then we have tried

uninstalling it. We ended up with error messages:

 

Undefined phrase: lib/searchfield:help_counter (en) at line 757 in

/usr/share/eprints3/perl_lib/EPrints/Search/Field.pm

Undefined phrase: eprint_fieldname_creators_orcid (en) at line 423 in

/usr/share/eprints3/perl_lib/EPrints/MetaField.pm

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.

DBD::mysql::st execute failed: Table 'REALDB.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 ('subjects')

SQL ERROR (execute): Table 'REALDB.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 'REALDB.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 ('subjects')

SQL ERROR (execute): Table 'REALDB.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 'REALDB.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 ('subjects')

SQL ERROR (execute): Table 'REALDB.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.

[Tue Jun 27 07:44:41 2017] [error] Can't use an undefined value as an ARRAY

reference at

/usr/share/eprints3/perl_lib/EPrints/Plugin/InputForm/Component/Field/Subject.pm

line 392.\n

 

Could anyone help?

 

With best regards,

 

Andras Holl

Library and Information Centre, Hungarian Academy of Sciences

 

 

--------------------------------------------------------------------------------

Andras Holl / Holl Andras                e-mail: holl at konkoly.hu

--------------------------------------------------------------------------------

 

*** 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/20170627/402b2a1a/attachment-0001.html