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

[EP-tech] Re: advanced search without subject list (3.3.13)?



Hi Adam,

> Can you post your advanced search configuration, and I'll take a look at it.
browse view for division & subject is empty as well ...

I tend to search for some missing perl modules (due to a silently failed upgrade or whatever) and parsed some log files.
An `bin/generate_views <repoID> --verbose --verbose` reported the following:

DBD::mysql::st execute failed: Unknown column 'subject__ordervalues_en.sortvalue_sortvalue' in 'order clause' at /opt/eprints3/eprints-3.3.13/bin/../perl_lib/EPrints/Database.pm line 3211, <DATA> line 960.
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 /opt/eprints3/eprints-3.3.13/bin/../perl_lib/EPrints/Search/Condition.pm line 588, <DATA> line 960
:
Database execute debug: SELECT DISTINCT D0,D1 FROM (SELECT `distinctby_190861452`.`document_tags` AS D0,`distinctby_190861452`.`eprintid` AS D1 FROM `eprint`, `eprint_document_tags` AS `distinctby_190861452`, `eprint_document_tags` AS `eprint_document_tags` WHERE `eprint`.`eprintid`=`distinctby_190861452`.`eprintid` AND `eprint`.`eprintid`=`eprint_document_tags`.`eprintid` AND (`eprint`.`metadata_visibility` = 'show' AND `eprint`.`eprint_status` = 'archive' AND ( `eprint_document_tags`.`document_tags` != ''))) AS D
Database execute debug: SELECT DISTINCT D0,D1 FROM (SELECT `distinctby_191058660`.`document_tags` AS D0,`distinctby_191058660`.`eprintid` AS D1 FROM `eprint`, `eprint_document_tags` AS `distinctby_191058660`, `eprint_document_tags` AS `eprint_document_tags` WHERE `eprint`.`eprintid`=`distinctby_191058660`.`eprintid` AND `eprint`.`eprintid`=`eprint_document_tags`.`eprintid` AND (`eprint`.`metadata_visibility` = 'show' AND `eprint`.`eprint_status` = 'archive' AND ( `eprint_document_tags`.`document_tags` != ''))) AS D
Database execute debug: SELECT DISTINCT D0,D1 FROM (SELECT `distinctby_191033580`.`document_tags` AS D0,`distinctby_191033580`.`eprintid` AS D1 FROM `eprint`, `eprint_document_tags` AS `distinctby_191033580`, `eprint_document_tags` AS `eprint_document_tags` WHERE `eprint`.`eprintid`=`distinctby_191033580`.`eprintid` AND `eprint`.`eprintid`=`eprint_document_tags`.`eprintid` AND (`eprint`.`metadata_visibility` = 'show' AND `eprint`.`eprint_status` = 'archive' AND ( `eprint_document_tags`.`document_tags` != ''))) AS D
Warning! No values were found for eprint.view.document_tags [document_tags] - configuration may be wrong

Thanks in advance
Thomas

P.S.: http://wiki.eprints.org/w/Required_software and http://wiki.eprints.org/w/Installing_Perl_modules should be updated ...?!
P.P.S.: The full-text indexer reported some redefinitions in /opt/eprints/perl_lib/EPrints/XML/DOM.pm ...