<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Actually, there are a lot of warnings,
probably more than 30. I won't copy all, it's the same each time :
<br>
<br>
"warning : X (1 to 3 here) client(s) is using or hasn't/haven't
closed the table properly. Status : OK"<br>
<br>
Jeremy<br>
<br>
<br>
<br>
Le 23/09/2015 10:11, Adam Field a écrit :<br>
</div>
<blockquote
cite="mid:EMEW3|141e75b57b5b50f274e767f093b344e5r8M9Db14eprints-tech-bounces|ecs.soton.ac.uk|E1DE9430-8DED-4B6A-A884-295B05050248@ecs.soton.ac.uk"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<div>Well, nothing jumps out at me.</div>
<div><br>
</div>
Can you try running mysqlcheck on the eprints database?
<div><br>
<div apple-content-edited="true">
<div style="color: rgb(0, 0, 0); letter-spacing: normal;
orphans: auto; text-align: start; text-indent: 0px;
text-transform: none; white-space: normal; widows: auto;
word-spacing: 0px; -webkit-text-stroke-width: 0px;
word-wrap: break-word; -webkit-nbsp-mode: space;
-webkit-line-break: after-white-space;">
<div>--<br>
Adam Field<br>
Business Relationship Manager and Community Lead<br>
EPrints Services</div>
<div><br>
</div>
<div>I am currently not working in the UK. Due to timezone
differences (GMT -9) email responses may take longer.</div>
</div>
</div>
<br>
<div>
<div>On 23 Sep 2015, at 08:33, Jérémy RAINGEARD <<a
moz-do-not-send="true"
href="mailto:jeremy.raingeard@univ-tlse3.fr"><a class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a></a>>
wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
<div text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi Adam and thanks again.<br>
<br>
First, we're running mysql with "mysql" user and the
permissions of our database "thesesups" are : 700
mysql:mysql<br>
<br>
Finally, here are all our tables : <br>
<br>
+---------------------------------+<br>
| Tables_in_thesesups |<br>
+---------------------------------+<br>
| access | <br>
| access__ordervalues_en | <br>
| access__ordervalues_fr | <br>
| cache615369 | <br>
| cache615370 | <br>
| cache615371 | <br>
| cache615372 | <br>
| cache615373 | <br>
| cache615374 | <br>
| cache615375 | <br>
| cache615376 | <br>
| cache615377 | <br>
| cache615378 | <br>
| cache615379 | <br>
| cache615380 | <br>
| cache615381 | <br>
| cache615382 | <br>
| cache615383 | <br>
| cache615384 | <br>
| cache615385 | <br>
| cache615386 | <br>
| cache615387 | <br>
| cache615388 | <br>
| cache615389 | <br>
| cache615390 | <br>
| cache615391 | <br>
| cache615392 | <br>
| cache615393 | <br>
| cache615395 | <br>
| cache615397 | <br>
| cache615398 | <br>
| cache615399 | <br>
| cache615400 | <br>
| cache615401 | <br>
| cache615402 | <br>
| cache615403 | <br>
| cache615404 | <br>
| cache615405 | <br>
| cache615406 | <br>
| cache615407 | <br>
| cache615408 | <br>
| cache615409 | <br>
| cache615410 | <br>
| cache615411 | <br>
| cache615412 | <br>
| cache615413 | <br>
| cache615414 | <br>
| cache615415 | <br>
| cache615416 | <br>
| cache615417 | <br>
| cache615418 | <br>
| cache615420 | <br>
| cache615421 | <br>
| cache615422 | <br>
| cache615425 | <br>
| cache615427 | <br>
| cache615429 | <br>
| cache615432 | <br>
| cache615433 | <br>
| cache615437 | <br>
| cache615438 | <br>
| cache615439 | <br>
| cache615441 | <br>
| cache615443 | <br>
| cache615445 | <br>
| cache615448 | <br>
| cache615449 | <br>
| cache615452 | <br>
| cache615453 | <br>
| cache615456 | <br>
| cache615457 | <br>
| cache615460 | <br>
| cache615461 | <br>
| cache615464 | <br>
| cache615465 | <br>
| cache615467 | <br>
| cache615468 | <br>
| cache615470 | <br>
| cache615473 | <br>
| cache615474 | <br>
| cache615475 | <br>
| cache615477 | <br>
| cache615479 | <br>
| cache615481 | <br>
| cache615483 | <br>
| cache615486 | <br>
| cache615487 | <br>
| cache615491 | <br>
| cache615492 | <br>
| cache615493 | <br>
| cache615495 | <br>
| cache615497 | <br>
| cache615499 | <br>
| cache615501 | <br>
| cache615503 | <br>
| cache615505 | <br>
| cache615507 | <br>
| cache615509 | <br>
| cache615511 | <br>
| cache615513 | <br>
| cache615515 | <br>
| cache615517 | <br>
| cache615518 | <br>
| cache615519 | <br>
| cache615520 | <br>
| cache615522 | <br>
| cache615524 | <br>
| cache615526 | <br>
| cache615529 | <br>
| cache615530 | <br>
| cache615534 | <br>
| cache615535 | <br>
| cache615536 | <br>
| cache615538 | <br>
| cache615540 | <br>
| cache615542 | <br>
| cache615544 | <br>
| cache615546 | <br>
| cache615548 | <br>
| cache615550 | <br>
| cache615552 | <br>
| cache615554 | <br>
| cache615556 | <br>
| cache615558 | <br>
| cache615560 | <br>
| cache615562 | <br>
| cache615564 | <br>
| cache615566 | <br>
| cache615567 | <br>
| cache615568 | <br>
| cache615570 | <br>
| cache615571 | <br>
| cache615572 | <br>
| cache615573 | <br>
| cache615575 | <br>
| cache615577 | <br>
| cache615579 | <br>
| cache615581 | <br>
| cache615583 | <br>
| cache615586 | <br>
| cache615587 | <br>
| cache615591 | <br>
| cache615592 | <br>
| cache615593 | <br>
| cache615595 | <br>
| cache615597 | <br>
| cache615599 | <br>
| cache615601 | <br>
| cache615603 | <br>
| cache615605 | <br>
| cache615607 | <br>
| cache615609 | <br>
| cache615611 | <br>
| cache615613 | <br>
| cache615616 | <br>
| cache615617 | <br>
| cache615621 | <br>
| cache615622 | <br>
| cache615623 | <br>
| cache615625 | <br>
| cache615627 | <br>
| cache615629 | <br>
| cache615630 | <br>
| cache615631 | <br>
| cache615632 | <br>
| cache615633 | <br>
| cache615634 | <br>
| cache615636 | <br>
| cache615638 | <br>
| cache615640 | <br>
| cache615642 | <br>
| cache615644 | <br>
| cache615646 | <br>
| cache615648 | <br>
| cache615650 | <br>
| cache615652 | <br>
| cache615654 | <br>
| cache615656 | <br>
| cache615658 | <br>
| cache615661 | <br>
| cache615662 | <br>
| cache615666 | <br>
| cache615667 | <br>
| cache615668 | <br>
| cache615670 | <br>
| cache615672 | <br>
| cachemap | <br>
| cachemap__ordervalues_fr | <br>
| counters | <br>
| document | <br>
| document__index | <br>
| document__index_grep | <br>
| document__ordervalues_en | <br>
| document__ordervalues_fr | <br>
| document__rindex | <br>
| document_permission_group | <br>
| document_relation_type | <br>
| document_relation_uri | <br>
| eprint | <br>
| eprint__index | <br>
| eprint__index_grep | <br>
| eprint__ordervalues_en | <br>
| eprint__ordervalues_fr | <br>
| eprint__rindex | <br>
| eprint_accompaniment | <br>
| eprint_conductors_id | <br>
| eprint_conductors_name | <br>
| eprint_copyright_holders | <br>
| eprint_corp_creators | <br>
| eprint_creators_id | <br>
| eprint_creators_name | <br>
| eprint_dircreators_name | <br>
| eprint_divisions | <br>
| eprint_editors_id | <br>
| eprint_editors_name | <br>
| eprint_exhibitors_id | <br>
| eprint_exhibitors_name | <br>
| eprint_funders | <br>
| eprint_item_issues_comment | <br>
| eprint_item_issues_description | <br>
| eprint_item_issues_id | <br>
| eprint_item_issues_reported_by | <br>
| eprint_item_issues_resolved_by | <br>
| eprint_item_issues_status | <br>
| eprint_item_issues_timestamp | <br>
| eprint_item_issues_type | <br>
| eprint_language | <br>
| eprint_lyricists_id | <br>
| eprint_lyricists_name | <br>
| eprint_producers_id | <br>
| eprint_producers_name | <br>
| eprint_projects | <br>
| eprint_related_url_type | <br>
| eprint_related_url_url | <br>
| eprint_relation_type | <br>
| eprint_relation_uri | <br>
| eprint_skill_areas | <br>
| eprint_subjects | <br>
| event_queue | <br>
| event_queue__ordervalues_fr | <br>
| file | <br>
| file__ordervalues_fr | <br>
| file_copies_pluginid | <br>
| file_copies_sourceid | <br>
| history | <br>
| history__index | <br>
| history__index_grep | <br>
| history__ordervalues_en | <br>
| history__ordervalues_fr | <br>
| history__rindex | <br>
| import | <br>
| import__ordervalues_fr | <br>
| index_queue | <br>
| loginticket | <br>
| loginticket__ordervalues_fr | <br>
| message | <br>
| message__ordervalues_fr | <br>
| mf | <br>
| mf__ordervalues_fr | <br>
| mf_fields_allow_null | <br>
| mf_fields_browse_link | <br>
| mf_fields_datasetid | <br>
| mf_fields_default_value | <br>
| mf_fields_export_as_xml | <br>
| mf_fields_family_first | <br>
| mf_fields_hide_honourific | <br>
| mf_fields_hide_lineage | <br>
| mf_fields_input_boxes | <br>
| mf_fields_input_cols | <br>
| mf_fields_input_ordered | <br>
| mf_fields_input_rows | <br>
| mf_fields_input_style | <br>
| mf_fields_maxlength | <br>
| mf_fields_mfremoved | <br>
| mf_fields_min_resolution | <br>
| mf_fields_options | <br>
| mf_fields_render_input | <br>
| mf_fields_render_order | <br>
| mf_fields_render_value | <br>
| mf_fields_required | <br>
| mf_fields_set_name | <br>
| mf_fields_sql_counter | <br>
| mf_fields_sql_index | <br>
| mf_fields_sub_name | <br>
| mf_fields_top | <br>
| mf_fields_type | <br>
| mf_fields_volatile | <br>
| mf_phrase_help_lang | <br>
| mf_phrase_help_text | <br>
| mf_phrase_name_lang | <br>
| mf_phrase_name_text | <br>
| request | <br>
| request__index | <br>
| request__index_grep | <br>
| request__ordervalues_en | <br>
| request__ordervalues_fr | <br>
| request__rindex | <br>
| saved_search | <br>
| saved_search__index | <br>
| saved_search__index_grep | <br>
| saved_search__ordervalues_en | <br>
| saved_search__ordervalues_fr | <br>
| saved_search__rindex | <br>
| subject | <br>
| subject__index | <br>
| subject__index_grep | <br>
| subject__ordervalues_en | <br>
| subject__ordervalues_fr | <br>
| subject__rindex | <br>
| subject_ancestors | <br>
| subject_name_lang | <br>
| subject_name_name | <br>
| subject_parents | <br>
| triple | <br>
| triple__ordervalues_fr | <br>
| upload_progress | <br>
| upload_progress__ordervalues_fr | <br>
| user | <br>
| user__index | <br>
| user__index_grep | <br>
| user__ordervalues_en | <br>
| user__ordervalues_fr | <br>
| user__rindex | <br>
| user_editperms | <br>
| user_items_fields | <br>
| user_permission_group | <br>
| user_review_fields | <br>
| user_roles | <br>
| version | <br>
+---------------------------------+<br>
<br>
Is there anything you need or did I give you enough
details ? <br>
<br>
Thanks,<br>
<br>
Jeremy<br>
<br>
<br>
<br>
<br>
Le 22/09/2015 21:56, Adam Field a écrit :<br>
</div>
<blockquote
cite="mid:EMEW3|41fcab88ea46711899fb6ffdd05b5515r8LKvR14eprints-tech-bounces|ecs.soton.ac.uk|A4959991-AC2E-4B6B-BD0D-B04871D5178F@ecs.soton.ac.uk"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
It appears you have database issues. I haven't seen the
index table just disappearing. What user is mysql
running as, and what are the permissions on the database
directory? Can you post the tables you do have (i.e.
what's returned by a SHOW TABELS command in the
database).
<div class=""><br class="">
</div>
<div class=""><br class="">
<div class="">
<div style="letter-spacing: normal; orphans: auto;
text-align: start; text-indent: 0px;
text-transform: none; white-space: normal; widows:
auto; word-spacing: 0px;
-webkit-text-stroke-width: 0px; word-wrap:
break-word; -webkit-nbsp-mode: space;
-webkit-line-break: after-white-space;" class="">
<div class="">--</div>
<div class="">Adam Field</div>
<div class="">Business Relationship Manager and
Community Lead<br class="">
EPrints Services</div>
</div>
</div>
<br class="">
<div>
<blockquote type="cite" class="">
<div class="">On 18 Sep 2015, at 13:44, Jérémy
RAINGEARD <<a moz-do-not-send="true"
href="mailto:jeremy.raingeard@univ-tlse3.fr"
class="">jeremy.raingeard@univ-tlse3.fr</a>>
wrote:</div>
<br class="Apple-interchange-newline">
<div class="">Hi Adam,<br class="">
<br class="">
I tried your solution and it did nothing : not
sorted out well and it <br class="">
didn't appear in my eprint__ordervalues_fr table
- I don't know if it's <br class="">
useful or not. But I checked my logs after some
tries and this is what I <br class="">
found in it :<br class="">
<br class="">
DBD::mysql::st execute failed: Can't open file:
<br class="">
'./thesesups/event_queue.frm' (errno: 24) at <br
class="">
/opt/eprints3/perl_lib/EPrints/Database.pm line
3372, <DATA> line 151.<br class="">
SQL ERROR (execute): SELECT
`event_queue`.`eventqueueid` FROM <br class="">
`event_queue` LEFT JOIN
`event_queue__ordervalues_fr` ON <br class="">
`event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
WHERE <br class="">
`event_queue`.`status` = 'waiting' AND (( <br
class="">
`event_queue`.`start_time_year` < 2015 ) OR (
<br class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` < 9 ) OR ( <br
class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
< 17 ) OR ( `event_queue`.`start_time_year` =
2015 AND <br class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
= 17 )) GROUP BY `event_queue`.`eventqueueid`, <br
class="">
`event_queue__ordervalues_fr`.`priority`, <br
class="">
`event_queue__ordervalues_fr`.`start_time` ORDER
BY <br class="">
`event_queue__ordervalues_fr`.`priority` DESC, <br
class="">
`event_queue__ordervalues_fr`.`start_time` DESC<br
class="">
SQL ERROR (execute): Can't open file:
'./thesesups/event_queue.frm' <br class="">
(errno: 24)<br class="">
DBD::mysql::st fetch failed: fetch() without
execute() at <br class="">
/opt/eprints3/perl_lib/EPrints/Search/Condition.pm
line 565, <DATA> line <br class="">
151.<br class="">
DBD::mysql::st execute failed: Can't open file:
<br class="">
'./thesesups/event_queue.frm' (errno: 24) at <br
class="">
/opt/eprints3/perl_lib/EPrints/Database.pm line
3372, <DATA> line 151.<br class="">
SQL ERROR (execute): SELECT
`event_queue`.`eventqueueid` FROM <br class="">
`event_queue` LEFT JOIN
`event_queue__ordervalues_fr` ON <br class="">
`event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
WHERE <br class="">
`event_queue`.`status` = 'waiting' AND (( <br
class="">
`event_queue`.`start_time_year` < 2015 ) OR (
<br class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` < 9 ) OR ( <br
class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
< 17 ) OR ( `event_queue`.`start_time_year` =
2015 AND <br class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
= 17 )) GROUP BY `event_queue`.`eventqueueid`, <br
class="">
`event_queue__ordervalues_fr`.`priority`, <br
class="">
`event_queue__ordervalues_fr`.`start_time` ORDER
BY <br class="">
`event_queue__ordervalues_fr`.`priority` DESC, <br
class="">
`event_queue__ordervalues_fr`.`start_time` DESC<br
class="">
SQL ERROR (execute): Can't open file:
'./thesesups/event_queue.frm' <br class="">
(errno: 24)<br class="">
DBD::mysql::st fetch failed: fetch() without
execute() at <br class="">
/opt/eprints3/perl_lib/EPrints/Search/Condition.pm
line 565, <DATA> line <br class="">
151.<br class="">
DBD::mysql::st execute failed: Can't open file:
<br class="">
'./thesesups/event_queue.frm' (errno: 24) at <br
class="">
/opt/eprints3/perl_lib/EPrints/Database.pm line
3372, <DATA> line 151.<br class="">
SQL ERROR (execute): SELECT
`event_queue`.`eventqueueid` FROM <br class="">
`event_queue` LEFT JOIN
`event_queue__ordervalues_fr` ON <br class="">
`event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
WHERE <br class="">
`event_queue`.`status` = 'waiting' AND (( <br
class="">
`event_queue`.`start_time_year` < 2015 ) OR (
<br class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` < 9 ) OR ( <br
class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
< 17 ) OR ( `event_queue`.`start_time_year` =
2015 AND <br class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
= 17 )) GROUP BY `event_queue`.`eventqueueid`, <br
class="">
`event_queue__ordervalues_fr`.`priority`, <br
class="">
`event_queue__ordervalues_fr`.`start_time` ORDER
BY <br class="">
`event_queue__ordervalues_fr`.`priority` DESC, <br
class="">
`event_queue__ordervalues_fr`.`start_time` DESC<br
class="">
SQL ERROR (execute): Can't open file:
'./thesesups/event_queue.frm' <br class="">
(errno: 24)<br class="">
DBD::mysql::st fetch failed: fetch() without
execute() at <br class="">
/opt/eprints3/perl_lib/EPrints/Search/Condition.pm
line 565, <DATA> line <br class="">
151.<br class="">
DBD::mysql::st execute failed: Can't open file:
<br class="">
'./thesesups/event_queue.frm' (errno: 24) at <br
class="">
/opt/eprints3/perl_lib/EPrints/Database.pm line
3372, <DATA> line 151.<br class="">
SQL ERROR (execute): SELECT
`event_queue`.`eventqueueid` FROM <br class="">
`event_queue` LEFT JOIN
`event_queue__ordervalues_fr` ON <br class="">
`event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
WHERE <br class="">
`event_queue`.`status` = 'waiting' AND (( <br
class="">
`event_queue`.`start_time_year` < 2015 ) OR (
<br class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` < 9 ) OR ( <br
class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
< 17 ) OR ( `event_queue`.`start_time_year` =
2015 AND <br class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
= 17 )) GROUP BY `event_queue`.`eventqueueid`, <br
class="">
`event_queue__ordervalues_fr`.`priority`, <br
class="">
`event_queue__ordervalues_fr`.`start_time` ORDER
BY <br class="">
`event_queue__ordervalues_fr`.`priority` DESC, <br
class="">
`event_queue__ordervalues_fr`.`start_time` DESC<br
class="">
SQL ERROR (execute): Can't open file:
'./thesesups/event_queue.frm' <br class="">
(errno: 24)<br class="">
DBD::mysql::st fetch failed: fetch() without
execute() at <br class="">
/opt/eprints3/perl_lib/EPrints/Search/Condition.pm
line 565, <DATA> line <br class="">
151.<br class="">
DBD::mysql::st execute failed: Can't open file:
<br class="">
'./thesesups/event_queue.frm' (errno: 24) at <br
class="">
/opt/eprints3/perl_lib/EPrints/Database.pm line
3372, <DATA> line 151.<br class="">
SQL ERROR (execute): SELECT
`event_queue`.`eventqueueid` FROM <br class="">
`event_queue` LEFT JOIN
`event_queue__ordervalues_fr` ON <br class="">
`event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
WHERE <br class="">
`event_queue`.`status` = 'waiting' AND (( <br
class="">
`event_queue`.`start_time_year` < 2015 ) OR (
<br class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` < 9 ) OR ( <br
class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
< 17 ) OR ( `event_queue`.`start_time_year` =
2015 AND <br class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
= 17 )) GROUP BY `event_queue`.`eventqueueid`, <br
class="">
`event_queue__ordervalues_fr`.`priority`, <br
class="">
`event_queue__ordervalues_fr`.`start_time` ORDER
BY <br class="">
`event_queue__ordervalues_fr`.`priority` DESC, <br
class="">
`event_queue__ordervalues_fr`.`start_time` DESC<br
class="">
SQL ERROR (execute): Can't open file:
'./thesesups/event_queue.frm' <br class="">
(errno: 24)<br class="">
DBD::mysql::st fetch failed: fetch() without
execute() at <br class="">
/opt/eprints3/perl_lib/EPrints/Search/Condition.pm
line 565, <DATA> line <br class="">
151.<br class="">
DBD::mysql::st execute failed: Can't open file:
<br class="">
'./thesesups/event_queue.frm' (errno: 24) at <br
class="">
/opt/eprints3/perl_lib/EPrints/Database.pm line
3372, <DATA> line 151.<br class="">
SQL ERROR (execute): SELECT
`event_queue`.`eventqueueid` FROM <br class="">
`event_queue` LEFT JOIN
`event_queue__ordervalues_fr` ON <br class="">
`event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
WHERE <br class="">
`event_queue`.`status` = 'waiting' AND (( <br
class="">
`event_queue`.`start_time_year` < 2015 ) OR (
<br class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` < 9 ) OR ( <br
class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
< 17 ) OR ( `event_queue`.`start_time_year` =
2015 AND <br class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
= 17 )) GROUP BY `event_queue`.`eventqueueid`, <br
class="">
`event_queue__ordervalues_fr`.`priority`, <br
class="">
`event_queue__ordervalues_fr`.`start_time` ORDER
BY <br class="">
`event_queue__ordervalues_fr`.`priority` DESC, <br
class="">
`event_queue__ordervalues_fr`.`start_time` DESC<br
class="">
SQL ERROR (execute): Can't open file:
'./thesesups/event_queue.frm' <br class="">
(errno: 24)<br class="">
DBD::mysql::st fetch failed: fetch() without
execute() at <br class="">
/opt/eprints3/perl_lib/EPrints/Search/Condition.pm
line 565, <DATA> line <br class="">
151.<br class="">
DBD::mysql::st execute failed: Can't open file:
<br class="">
'./thesesups/event_queue.frm' (errno: 24) at <br
class="">
/opt/eprints3/perl_lib/EPrints/Database.pm line
3372, <DATA> line 151.<br class="">
SQL ERROR (execute): SELECT
`event_queue`.`eventqueueid` FROM <br class="">
`event_queue` LEFT JOIN
`event_queue__ordervalues_fr` ON <br class="">
`event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
WHERE <br class="">
`event_queue`.`status` = 'waiting' AND (( <br
class="">
`event_queue`.`start_time_year` < 2015 ) OR (
<br class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` < 9 ) OR ( <br
class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
< 17 ) OR ( `event_queue`.`start_time_year` =
2015 AND <br class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
= 17 )) GROUP BY `event_queue`.`eventqueueid`, <br
class="">
`event_queue__ordervalues_fr`.`priority`, <br
class="">
`event_queue__ordervalues_fr`.`start_time` ORDER
BY <br class="">
`event_queue__ordervalues_fr`.`priority` DESC, <br
class="">
`event_queue__ordervalues_fr`.`start_time` DESC<br
class="">
SQL ERROR (execute): Can't open file:
'./thesesups/event_queue.frm' <br class="">
(errno: 24)<br class="">
DBD::mysql::st fetch failed: fetch() without
execute() at <br class="">
/opt/eprints3/perl_lib/EPrints/Search/Condition.pm
line 565, <DATA> line <br class="">
151.<br class="">
DBD::mysql::st execute failed: Can't open file:
<br class="">
'./thesesups/event_queue.frm' (errno: 24) at <br
class="">
/opt/eprints3/perl_lib/EPrints/Database.pm line
3372, <DATA> line 151.<br class="">
SQL ERROR (execute): SELECT
`event_queue`.`eventqueueid` FROM <br class="">
`event_queue` LEFT JOIN
`event_queue__ordervalues_fr` ON <br class="">
`event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
WHERE <br class="">
`event_queue`.`status` = 'waiting' AND (( <br
class="">
`event_queue`.`start_time_year` < 2015 ) OR (
<br class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` < 9 ) OR ( <br
class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
< 17 ) OR ( `event_queue`.`start_time_year` =
2015 AND <br class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
= 17 )) GROUP BY `event_queue`.`eventqueueid`, <br
class="">
`event_queue__ordervalues_fr`.`priority`, <br
class="">
`event_queue__ordervalues_fr`.`start_time` ORDER
BY <br class="">
`event_queue__ordervalues_fr`.`priority` DESC, <br
class="">
`event_queue__ordervalues_fr`.`start_time` DESC<br
class="">
SQL ERROR (execute): Can't open file:
'./thesesups/event_queue.frm' <br class="">
(errno: 24)<br class="">
DBD::mysql::st fetch failed: fetch() without
execute() at <br class="">
/opt/eprints3/perl_lib/EPrints/Search/Condition.pm
line 565, <DATA> line <br class="">
151.<br class="">
DBD::mysql::st execute failed: Can't open file:
<br class="">
'./thesesups/event_queue.frm' (errno: 24) at <br
class="">
/opt/eprints3/perl_lib/EPrints/Database.pm line
3372, <DATA> line 151.<br class="">
SQL ERROR (execute): SELECT
`event_queue`.`eventqueueid` FROM <br class="">
`event_queue` LEFT JOIN
`event_queue__ordervalues_fr` ON <br class="">
`event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
WHERE <br class="">
`event_queue`.`status` = 'waiting' AND (( <br
class="">
`event_queue`.`start_time_year` < 2015 ) OR (
<br class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` < 9 ) OR ( <br
class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
< 17 ) OR ( `event_queue`.`start_time_year` =
2015 AND <br class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
= 17 )) GROUP BY `event_queue`.`eventqueueid`, <br
class="">
`event_queue__ordervalues_fr`.`priority`, <br
class="">
`event_queue__ordervalues_fr`.`start_time` ORDER
BY <br class="">
`event_queue__ordervalues_fr`.`priority` DESC, <br
class="">
`event_queue__ordervalues_fr`.`start_time` DESC<br
class="">
SQL ERROR (execute): Can't open file:
'./thesesups/event_queue.frm' <br class="">
(errno: 24)<br class="">
DBD::mysql::st fetch failed: fetch() without
execute() at <br class="">
/opt/eprints3/perl_lib/EPrints/Search/Condition.pm
line 565, <DATA> line <br class="">
151.<br class="">
DBD::mysql::st execute failed: Can't open file:
<br class="">
'./thesesups/event_queue.frm' (errno: 24) at <br
class="">
/opt/eprints3/perl_lib/EPrints/Database.pm line
3372, <DATA> line 151.<br class="">
SQL ERROR (execute): SELECT
`event_queue`.`eventqueueid` FROM <br class="">
`event_queue` LEFT JOIN
`event_queue__ordervalues_fr` ON <br class="">
`event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
WHERE <br class="">
`event_queue`.`status` = 'waiting' AND (( <br
class="">
`event_queue`.`start_time_year` < 2015 ) OR (
<br class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` < 9 ) OR ( <br
class="">
`event_queue`.`start_time_year` = 2015 AND <br
class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
< 17 ) OR ( `event_queue`.`start_time_year` =
2015 AND <br class="">
`event_queue`.`start_time_month` = 9 AND
`event_queue`.`start_time_day` <br class="">
= 17 )) GROUP BY `event_queue`.`eventqueueid`, <br
class="">
`event_queue__ordervalues_fr`.`priority`, <br
class="">
`event_queue__ordervalues_fr`.`start_time` ORDER
BY <br class="">
`event_queue__ordervalues_fr`.`priority` DESC, <br
class="">
`event_queue__ordervalues_fr`.`start_time` DESC<br
class="">
SQL ERROR (execute): Can't open file:
'./thesesups/event_queue.frm' <br class="">
(errno: 24)<br class="">
DBD::mysql::st fetch failed: fetch() without
execute() at <br class="">
/opt/eprints3/perl_lib/EPrints/Search/Condition.pm
line 565, <DATA> line <br class="">
151.<br class="">
[Fri Sep 18 14:28:09 2015] ** Indexer process
stopping<br class="">
[Fri Sep 18 14:28:17 2015] ** Indexer process
started<br class="">
<br class="">
I don't find this event_queue.frm - because it's
a temporary file for <br class="">
MySQL ? - so I can't even see if it's a
permission problem. Any idea <br class="">
about this ?<br class="">
<br class="">
Thank you.<br class="">
<br class="">
Jeremy<br class="">
<br class="">
<br class="">
Le 17/09/2015 16:09, Field A.N. a écrit :<br
class="">
<blockquote type="cite" class="">Ah, if they
aren't in the table, then they haven't been
indexed. Choose an item that isn't ordering
correctly, find its ID, then run:<br class="">
<br class="">
epadmin reindex *repository_id* eprint
*eprint_id*<br class="">
<br class="">
...and see if it sorts itself out. Note that
this queues it on the indexer rather than
doing the work, so check whether the indexer
is running (the 'status' button on the 'system
toos' tab of the 'Admin' screen [though if
your interface is in French, this might
vary]). On the status page, you should see
the number of index tasks decreasing.<br
class="">
<br class="">
If running that command sorts out that item,
then run it again, but without the ID at the
end. This will index all items, and might
take a while, but it shouldn't be too long, as
you only have 2572 eprints.<br class="">
<br class="">
Let me know how it goes.<br class="">
<br class="">
--<br class="">
Adam Field<br class="">
Business Relationship Manager and Community
Lead<br class="">
EPrints Services<br class="">
+44 (0)23 8059 8814<br class="">
<br class="">
<br class="">
<br class="">
<br class="">
<br class="">
On 17 Sep 2015, at 14:36, Jérémy RAINGEARD
wrote:<br class="">
<br class="">
<blockquote type="cite" class="">Hi Adam and
thank you.<br class="">
<br class="">
You can find our repository at this address
- some thesis are public,<br class="">
some not : <a moz-do-not-send="true"
href="http://thesesups.ups-tlse.fr/"
class="">http://thesesups.ups-tlse.fr/</a><br
class="">
Just choose a subject for example and let
the last option as it is<br class="">
("trier les résultats").<br class="">
<br class="">
Now, this is the advanced search aprt of my
search.pl file - hope it's<br class="">
what you need :<br class="">
<br class="">
$c->{search}->{advanced} =<br class="">
{<br class="">
search_fields => [<br class="">
{ meta_fields => [
$EPrints::Utils::FULLTEXT ] },<br class="">
{ meta_fields => [ "title" ] },<br
class="">
{ meta_fields => [
"creators_name" ] },<br class="">
{ meta_fields => [
"dircreators_name" ] },<br class="">
{ meta_fields => [ "abstract" ]
},<br class="">
{ meta_fields => [ "keywords" ]
},<br class="">
{ meta_fields => [ "subjects" ]
},<br class="">
#{ meta_fields => [ "type" ] },<br
class="">
{ meta_fields => [ "divisions" ]
},<br class="">
{ meta_fields => [ "department" ]
},<br class="">
<br class="">
#{ meta_fields => [ "ispublished"
] },<br class="">
#{ meta_fields => [ "refereed" ]
},<br class="">
#{ meta_fields => [ "publication"
] },<br class="">
{ meta_fields => [ "date" ] },<br
class="">
],<br class="">
preamble_phrase =>
"cgi/advsearch:preamble",<br class="">
title_phrase =>
"cgi/advsearch:adv_search",<br class="">
citation => "result",<br class="">
page_size => 20,<br class="">
order_methods => {<br class="">
<br class="">
"byyear" =>
"-date/creators_name/title",<br class="">
<br class="">
"byyearoldest" =>
"date/creators_name/title",<br class="">
"byname" =>
"creators_name/-date/title",<br class="">
"bytitle" =>
"title/creators_name/-date"<br class="">
},<br class="">
default_order => "byyear",<br
class="">
};<br class="">
<br class="">
If necessary, I can add more content of this
file or give you more details.<br class="">
<br class="">
Thanks,<br class="">
<br class="">
Jérémy<br class="">
<br class="">
<br class="">
<br class="">
Le 17/09/2015 14:21, Field A.N. a écrit :<br
class="">
<blockquote type="cite" class="">Hi Jérémy<br
class="">
<br class="">
<span class="Apple-tab-span" style="white-space:pre"> </span>Firstly,
welcome to the community. I so happy that
you've been able to work through most of
your problems using our documentation, and
in only two weeks!<br class="">
<br class="">
<span class="Apple-tab-span" style="white-space:pre"> </span>Is
your repository publicly visible? Can you
give me its address so that I can have a
play? Also, please post your advanced
search configuration.<br class="">
<br class="">
<span class="Apple-tab-span" style="white-space:pre"> </span>Best
WIshes<br class="">
<br class="">
--<br class="">
Adam Field<br class="">
Business Relationship Manager and
Community Lead<br class="">
EPrints Services<br class="">
+44 (0)23 8059 8814<br class="">
<br class="">
<br class="">
<br class="">
<br class="">
<br class="">
On 17 Sep 2015, at 09:18, Jérémy RAINGEARD
wrote:<br class="">
<br class="">
<blockquote type="cite" class="">Hello,<br
class="">
<br class="">
My university asked me to help them with
some eprints problems - I<br class="">
didn't even know what eprints was - in
only 2 weeks. I managed to<br class="">
correct all problems thanks to your
documentation, but I'm stuck with<br
class="">
the last problem and I have no error
message to help me to resolve it.<br
class="">
<br class="">
First, when we used our advanced search
and sorted results by date, it<br
class="">
only sorted it by author name even if we
had a date > author > title<br
class="">
sorting. Now, I manage to sort it by
date, but only from 2010 to 2015.<br
class="">
Before - probably an upgrade of eprints
they told me - it's sometimes in<br
class="">
the right order, but sometimes not and,
in this case, the order is by<br
class="">
the author name.<br class="">
<br class="">
I don't know how to reorder the wrong
ones. I checked my tables and saw<br
class="">
an "eprints__order_values_fr" - we don't
use it's EN version. I don't<br class="">
know if the problem is there but when
thesis are in the good order, they<br
class="">
appear in this table and when they're in
the wrong order, they're not in<br
class="">
it.<br class="">
<br class="">
Could you please tell me how to correct
this wrong behavior please ?<br class="">
Thank you.<br class="">
<br class="">
Jérémy<br class="">
<br class="">
*** Options: <a moz-do-not-send="true"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"
class="">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br
class="">
*** Archive: <a moz-do-not-send="true"
href="http://www.eprints.org/tech.php/" class="">http://www.eprints.org/tech.php/</a><br
class="">
*** EPrints community wiki: <a
moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://wiki.eprints.org/"><a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></a><br
class="">
*** EPrints developers Forum: <a
moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://forum.eprints.org/"><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br
class="">
</blockquote>
*** Options: <a moz-do-not-send="true"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"
class="">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br
class="">
*** Archive: <a moz-do-not-send="true"
href="http://www.eprints.org/tech.php/"
class="">http://www.eprints.org/tech.php/</a><br
class="">
*** EPrints community wiki: <a
moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://wiki.eprints.org/"><a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></a><br
class="">
*** EPrints developers Forum: <a
moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://forum.eprints.org/"><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br
class="">
</blockquote>
<br class="">
*** Options: <a moz-do-not-send="true"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"
class="">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br
class="">
*** Archive: <a moz-do-not-send="true"
href="http://www.eprints.org/tech.php/"
class="">http://www.eprints.org/tech.php/</a><br
class="">
*** EPrints community wiki: <a
moz-do-not-send="true"
href="http://wiki.eprints.org/" class=""><a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></a><br
class="">
*** EPrints developers Forum: <a
moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://forum.eprints.org/"><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br
class="">
</blockquote>
<br class="">
*** Options: <a moz-do-not-send="true"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"
class="">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br
class="">
*** Archive: <a moz-do-not-send="true"
href="http://www.eprints.org/tech.php/"
class="">http://www.eprints.org/tech.php/</a><br
class="">
*** EPrints community wiki: <a
moz-do-not-send="true"
href="http://wiki.eprints.org/" class=""><a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></a><br
class="">
*** EPrints developers Forum: <a
moz-do-not-send="true"
href="http://forum.eprints.org/" class=""><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br
class="">
</blockquote>
<br class="">
<br class="">
*** Options: <a moz-do-not-send="true"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"
class="">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br
class="">
*** Archive: <a moz-do-not-send="true"
href="http://www.eprints.org/tech.php/"
class="">http://www.eprints.org/tech.php/</a><br
class="">
*** EPrints community wiki: <a
moz-do-not-send="true"
href="http://wiki.eprints.org/" class=""><a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></a><br
class="">
*** EPrints developers Forum: <a
moz-do-not-send="true"
href="http://forum.eprints.org/" class=""><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br
class="">
</div>
</blockquote>
</div>
<br class="">
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
</div>
*** Options: <a moz-do-not-send="true"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
*** Archive: <a moz-do-not-send="true"
href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
*** EPrints community wiki: <a moz-do-not-send="true"
href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>
*** EPrints developers Forum: <a moz-do-not-send="true"
href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
</body>
</html>