[EP-tech] Re: Advanced Search by date
Jérémy RAINGEARD
jeremy.raingeard at univ-tlse3.fr
Fri Sep 25 08:25:53 BST 2015
Hi,
I have a "Empty set (0.00 sec)" answer with your query.
Jeremy
Le 23/09/2015 17:00, Adam Field a écrit :
> Hmmm... Sorry, I'm stabbing in the dark here, trying to get more
> clues. What happens if you run the following query in mysql (in your
> repository's database):
>
> SELECT `event_queue`.`eventqueueid` FROM `event_queue`
> LEFT JOIN `event_queue__ordervalues_fr`
> ON `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
> WHERE
> `event_queue`.`status` = 'waiting'
> AND (
> (`event_queue`.`start_time_year` < 2015 )
> OR (`event_queue`.`start_time_year` = 2015
> AND `event_queue`.`start_time_month` < 9 )
> OR ( `event_queue`.`start_time_year` = 2015
> AND `event_queue`.`start_time_month` = 9 AND
> `event_queue`.`start_time_day` < 17 )
> OR ( `event_queue`.`start_time_year` = 2015
> AND `event_queue`.`start_time_month` = 9 AND
> `event_queue`.`start_time_day` = 17 )
> )
> GROUP BY
> `event_queue`.`eventqueueid`, `event_queue__ordervalues_fr`.`priority`, `event_queue__ordervalues_fr`.`start_time`
> ORDER BY `event_queue__ordervalues_fr`.`priority`
> DESC, `event_queue__ordervalues_fr`.`start_time` DESC
>
>
> ...and let me know what happens.
>
> --
> Adam Field
> Business Relationship Manager and Community Lead
> EPrints Services
>
>
>
> On 23 Sep 2015, at 09:47, Jérémy RAINGEARD
> <jeremy.raingeard at univ-tlse3.fr
> <mailto:jeremy.raingeard at univ-tlse3.fr>> wrote:
>
>> Actually, there are a lot of warnings, probably more than 30. I won't
>> copy all, it's the same each time :
>>
>> "warning : X (1 to 3 here) client(s) is using or hasn't/haven't
>> closed the table properly. Status : OK"
>>
>> Jeremy
>>
>>
>>
>> Le 23/09/2015 10:11, Adam Field a écrit :
>>> Well, nothing jumps out at me.
>>>
>>> Can you try running mysqlcheck on the eprints database?
>>>
>>> --
>>> Adam Field
>>> Business Relationship Manager and Community Lead
>>> EPrints Services
>>>
>>> I am currently not working in the UK. Due to timezone differences
>>> (GMT -9) email responses may take longer.
>>>
>>> On 23 Sep 2015, at 08:33, Jérémy RAINGEARD
>>> <jeremy.raingeard at univ-tlse3.fr> wrote:
>>>
>>>> Hi Adam and thanks again.
>>>>
>>>> First, we're running mysql with "mysql" user and the permissions of
>>>> our database "thesesups" are : 700 mysql:mysql
>>>>
>>>> Finally, here are all our tables :
>>>>
>>>> +---------------------------------+
>>>> | Tables_in_thesesups |
>>>> +---------------------------------+
>>>> | access |
>>>> | access__ordervalues_en |
>>>> | access__ordervalues_fr |
>>>> | cache615369 |
>>>> | cache615370 |
>>>> | cache615371 |
>>>> | cache615372 |
>>>> | cache615373 |
>>>> | cache615374 |
>>>> | cache615375 |
>>>> | cache615376 |
>>>> | cache615377 |
>>>> | cache615378 |
>>>> | cache615379 |
>>>> | cache615380 |
>>>> | cache615381 |
>>>> | cache615382 |
>>>> | cache615383 |
>>>> | cache615384 |
>>>> | cache615385 |
>>>> | cache615386 |
>>>> | cache615387 |
>>>> | cache615388 |
>>>> | cache615389 |
>>>> | cache615390 |
>>>> | cache615391 |
>>>> | cache615392 |
>>>> | cache615393 |
>>>> | cache615395 |
>>>> | cache615397 |
>>>> | cache615398 |
>>>> | cache615399 |
>>>> | cache615400 |
>>>> | cache615401 |
>>>> | cache615402 |
>>>> | cache615403 |
>>>> | cache615404 |
>>>> | cache615405 |
>>>> | cache615406 |
>>>> | cache615407 |
>>>> | cache615408 |
>>>> | cache615409 |
>>>> | cache615410 |
>>>> | cache615411 |
>>>> | cache615412 |
>>>> | cache615413 |
>>>> | cache615414 |
>>>> | cache615415 |
>>>> | cache615416 |
>>>> | cache615417 |
>>>> | cache615418 |
>>>> | cache615420 |
>>>> | cache615421 |
>>>> | cache615422 |
>>>> | cache615425 |
>>>> | cache615427 |
>>>> | cache615429 |
>>>> | cache615432 |
>>>> | cache615433 |
>>>> | cache615437 |
>>>> | cache615438 |
>>>> | cache615439 |
>>>> | cache615441 |
>>>> | cache615443 |
>>>> | cache615445 |
>>>> | cache615448 |
>>>> | cache615449 |
>>>> | cache615452 |
>>>> | cache615453 |
>>>> | cache615456 |
>>>> | cache615457 |
>>>> | cache615460 |
>>>> | cache615461 |
>>>> | cache615464 |
>>>> | cache615465 |
>>>> | cache615467 |
>>>> | cache615468 |
>>>> | cache615470 |
>>>> | cache615473 |
>>>> | cache615474 |
>>>> | cache615475 |
>>>> | cache615477 |
>>>> | cache615479 |
>>>> | cache615481 |
>>>> | cache615483 |
>>>> | cache615486 |
>>>> | cache615487 |
>>>> | cache615491 |
>>>> | cache615492 |
>>>> | cache615493 |
>>>> | cache615495 |
>>>> | cache615497 |
>>>> | cache615499 |
>>>> | cache615501 |
>>>> | cache615503 |
>>>> | cache615505 |
>>>> | cache615507 |
>>>> | cache615509 |
>>>> | cache615511 |
>>>> | cache615513 |
>>>> | cache615515 |
>>>> | cache615517 |
>>>> | cache615518 |
>>>> | cache615519 |
>>>> | cache615520 |
>>>> | cache615522 |
>>>> | cache615524 |
>>>> | cache615526 |
>>>> | cache615529 |
>>>> | cache615530 |
>>>> | cache615534 |
>>>> | cache615535 |
>>>> | cache615536 |
>>>> | cache615538 |
>>>> | cache615540 |
>>>> | cache615542 |
>>>> | cache615544 |
>>>> | cache615546 |
>>>> | cache615548 |
>>>> | cache615550 |
>>>> | cache615552 |
>>>> | cache615554 |
>>>> | cache615556 |
>>>> | cache615558 |
>>>> | cache615560 |
>>>> | cache615562 |
>>>> | cache615564 |
>>>> | cache615566 |
>>>> | cache615567 |
>>>> | cache615568 |
>>>> | cache615570 |
>>>> | cache615571 |
>>>> | cache615572 |
>>>> | cache615573 |
>>>> | cache615575 |
>>>> | cache615577 |
>>>> | cache615579 |
>>>> | cache615581 |
>>>> | cache615583 |
>>>> | cache615586 |
>>>> | cache615587 |
>>>> | cache615591 |
>>>> | cache615592 |
>>>> | cache615593 |
>>>> | cache615595 |
>>>> | cache615597 |
>>>> | cache615599 |
>>>> | cache615601 |
>>>> | cache615603 |
>>>> | cache615605 |
>>>> | cache615607 |
>>>> | cache615609 |
>>>> | cache615611 |
>>>> | cache615613 |
>>>> | cache615616 |
>>>> | cache615617 |
>>>> | cache615621 |
>>>> | cache615622 |
>>>> | cache615623 |
>>>> | cache615625 |
>>>> | cache615627 |
>>>> | cache615629 |
>>>> | cache615630 |
>>>> | cache615631 |
>>>> | cache615632 |
>>>> | cache615633 |
>>>> | cache615634 |
>>>> | cache615636 |
>>>> | cache615638 |
>>>> | cache615640 |
>>>> | cache615642 |
>>>> | cache615644 |
>>>> | cache615646 |
>>>> | cache615648 |
>>>> | cache615650 |
>>>> | cache615652 |
>>>> | cache615654 |
>>>> | cache615656 |
>>>> | cache615658 |
>>>> | cache615661 |
>>>> | cache615662 |
>>>> | cache615666 |
>>>> | cache615667 |
>>>> | cache615668 |
>>>> | cache615670 |
>>>> | cache615672 |
>>>> | cachemap |
>>>> | cachemap__ordervalues_fr |
>>>> | counters |
>>>> | document |
>>>> | document__index |
>>>> | document__index_grep |
>>>> | document__ordervalues_en |
>>>> | document__ordervalues_fr |
>>>> | document__rindex |
>>>> | document_permission_group |
>>>> | document_relation_type |
>>>> | document_relation_uri |
>>>> | eprint |
>>>> | eprint__index |
>>>> | eprint__index_grep |
>>>> | eprint__ordervalues_en |
>>>> | eprint__ordervalues_fr |
>>>> | eprint__rindex |
>>>> | eprint_accompaniment |
>>>> | eprint_conductors_id |
>>>> | eprint_conductors_name |
>>>> | eprint_copyright_holders |
>>>> | eprint_corp_creators |
>>>> | eprint_creators_id |
>>>> | eprint_creators_name |
>>>> | eprint_dircreators_name |
>>>> | eprint_divisions |
>>>> | eprint_editors_id |
>>>> | eprint_editors_name |
>>>> | eprint_exhibitors_id |
>>>> | eprint_exhibitors_name |
>>>> | eprint_funders |
>>>> | eprint_item_issues_comment |
>>>> | eprint_item_issues_description |
>>>> | eprint_item_issues_id |
>>>> | eprint_item_issues_reported_by |
>>>> | eprint_item_issues_resolved_by |
>>>> | eprint_item_issues_status |
>>>> | eprint_item_issues_timestamp |
>>>> | eprint_item_issues_type |
>>>> | eprint_language |
>>>> | eprint_lyricists_id |
>>>> | eprint_lyricists_name |
>>>> | eprint_producers_id |
>>>> | eprint_producers_name |
>>>> | eprint_projects |
>>>> | eprint_related_url_type |
>>>> | eprint_related_url_url |
>>>> | eprint_relation_type |
>>>> | eprint_relation_uri |
>>>> | eprint_skill_areas |
>>>> | eprint_subjects |
>>>> | event_queue |
>>>> | event_queue__ordervalues_fr |
>>>> | file |
>>>> | file__ordervalues_fr |
>>>> | file_copies_pluginid |
>>>> | file_copies_sourceid |
>>>> | history |
>>>> | history__index |
>>>> | history__index_grep |
>>>> | history__ordervalues_en |
>>>> | history__ordervalues_fr |
>>>> | history__rindex |
>>>> | import |
>>>> | import__ordervalues_fr |
>>>> | index_queue |
>>>> | loginticket |
>>>> | loginticket__ordervalues_fr |
>>>> | message |
>>>> | message__ordervalues_fr |
>>>> | mf |
>>>> | mf__ordervalues_fr |
>>>> | mf_fields_allow_null |
>>>> | mf_fields_browse_link |
>>>> | mf_fields_datasetid |
>>>> | mf_fields_default_value |
>>>> | mf_fields_export_as_xml |
>>>> | mf_fields_family_first |
>>>> | mf_fields_hide_honourific |
>>>> | mf_fields_hide_lineage |
>>>> | mf_fields_input_boxes |
>>>> | mf_fields_input_cols |
>>>> | mf_fields_input_ordered |
>>>> | mf_fields_input_rows |
>>>> | mf_fields_input_style |
>>>> | mf_fields_maxlength |
>>>> | mf_fields_mfremoved |
>>>> | mf_fields_min_resolution |
>>>> | mf_fields_options |
>>>> | mf_fields_render_input |
>>>> | mf_fields_render_order |
>>>> | mf_fields_render_value |
>>>> | mf_fields_required |
>>>> | mf_fields_set_name |
>>>> | mf_fields_sql_counter |
>>>> | mf_fields_sql_index |
>>>> | mf_fields_sub_name |
>>>> | mf_fields_top |
>>>> | mf_fields_type |
>>>> | mf_fields_volatile |
>>>> | mf_phrase_help_lang |
>>>> | mf_phrase_help_text |
>>>> | mf_phrase_name_lang |
>>>> | mf_phrase_name_text |
>>>> | request |
>>>> | request__index |
>>>> | request__index_grep |
>>>> | request__ordervalues_en |
>>>> | request__ordervalues_fr |
>>>> | request__rindex |
>>>> | saved_search |
>>>> | saved_search__index |
>>>> | saved_search__index_grep |
>>>> | saved_search__ordervalues_en |
>>>> | saved_search__ordervalues_fr |
>>>> | saved_search__rindex |
>>>> | subject |
>>>> | subject__index |
>>>> | subject__index_grep |
>>>> | subject__ordervalues_en |
>>>> | subject__ordervalues_fr |
>>>> | subject__rindex |
>>>> | subject_ancestors |
>>>> | subject_name_lang |
>>>> | subject_name_name |
>>>> | subject_parents |
>>>> | triple |
>>>> | triple__ordervalues_fr |
>>>> | upload_progress |
>>>> | upload_progress__ordervalues_fr |
>>>> | user |
>>>> | user__index |
>>>> | user__index_grep |
>>>> | user__ordervalues_en |
>>>> | user__ordervalues_fr |
>>>> | user__rindex |
>>>> | user_editperms |
>>>> | user_items_fields |
>>>> | user_permission_group |
>>>> | user_review_fields |
>>>> | user_roles |
>>>> | version |
>>>> +---------------------------------+
>>>>
>>>> Is there anything you need or did I give you enough details ?
>>>>
>>>> Thanks,
>>>>
>>>> Jeremy
>>>>
>>>>
>>>>
>>>>
>>>> Le 22/09/2015 21:56, Adam Field a écrit :
>>>>> 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).
>>>>>
>>>>>
>>>>> --
>>>>> Adam Field
>>>>> Business Relationship Manager and Community Lead
>>>>> EPrints Services
>>>>>
>>>>>> On 18 Sep 2015, at 13:44, Jérémy RAINGEARD
>>>>>> <jeremy.raingeard at univ-tlse3.fr
>>>>>> <mailto:jeremy.raingeard at univ-tlse3.fr>> wrote:
>>>>>>
>>>>>> Hi Adam,
>>>>>>
>>>>>> I tried your solution and it did nothing : not sorted out well
>>>>>> and it
>>>>>> didn't appear in my eprint__ordervalues_fr table - I don't know
>>>>>> if it's
>>>>>> useful or not. But I checked my logs after some tries and this is
>>>>>> what I
>>>>>> found in it :
>>>>>>
>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372, <DATA> line
>>>>>> 151.
>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>> WHERE
>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>> SQL ERROR (execute): Can't open file: './thesesups/event_queue.frm'
>>>>>> (errno: 24)
>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line 565,
>>>>>> <DATA> line
>>>>>> 151.
>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372, <DATA> line
>>>>>> 151.
>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>> WHERE
>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>> SQL ERROR (execute): Can't open file: './thesesups/event_queue.frm'
>>>>>> (errno: 24)
>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line 565,
>>>>>> <DATA> line
>>>>>> 151.
>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372, <DATA> line
>>>>>> 151.
>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>> WHERE
>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>> SQL ERROR (execute): Can't open file: './thesesups/event_queue.frm'
>>>>>> (errno: 24)
>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line 565,
>>>>>> <DATA> line
>>>>>> 151.
>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372, <DATA> line
>>>>>> 151.
>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>> WHERE
>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>> SQL ERROR (execute): Can't open file: './thesesups/event_queue.frm'
>>>>>> (errno: 24)
>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line 565,
>>>>>> <DATA> line
>>>>>> 151.
>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372, <DATA> line
>>>>>> 151.
>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>> WHERE
>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>> SQL ERROR (execute): Can't open file: './thesesups/event_queue.frm'
>>>>>> (errno: 24)
>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line 565,
>>>>>> <DATA> line
>>>>>> 151.
>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372, <DATA> line
>>>>>> 151.
>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>> WHERE
>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>> SQL ERROR (execute): Can't open file: './thesesups/event_queue.frm'
>>>>>> (errno: 24)
>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line 565,
>>>>>> <DATA> line
>>>>>> 151.
>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372, <DATA> line
>>>>>> 151.
>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>> WHERE
>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>> SQL ERROR (execute): Can't open file: './thesesups/event_queue.frm'
>>>>>> (errno: 24)
>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line 565,
>>>>>> <DATA> line
>>>>>> 151.
>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372, <DATA> line
>>>>>> 151.
>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>> WHERE
>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>> SQL ERROR (execute): Can't open file: './thesesups/event_queue.frm'
>>>>>> (errno: 24)
>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line 565,
>>>>>> <DATA> line
>>>>>> 151.
>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372, <DATA> line
>>>>>> 151.
>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>> WHERE
>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>> SQL ERROR (execute): Can't open file: './thesesups/event_queue.frm'
>>>>>> (errno: 24)
>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line 565,
>>>>>> <DATA> line
>>>>>> 151.
>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372, <DATA> line
>>>>>> 151.
>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>> WHERE
>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>> `event_queue`.`start_time_day`
>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>> SQL ERROR (execute): Can't open file: './thesesups/event_queue.frm'
>>>>>> (errno: 24)
>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line 565,
>>>>>> <DATA> line
>>>>>> 151.
>>>>>> [Fri Sep 18 14:28:09 2015] ** Indexer process stopping
>>>>>> [Fri Sep 18 14:28:17 2015] ** Indexer process started
>>>>>>
>>>>>> I don't find this event_queue.frm - because it's a temporary file
>>>>>> for
>>>>>> MySQL ? - so I can't even see if it's a permission problem. Any idea
>>>>>> about this ?
>>>>>>
>>>>>> Thank you.
>>>>>>
>>>>>> Jeremy
>>>>>>
>>>>>>
>>>>>> Le 17/09/2015 16:09, Field A.N. a écrit :
>>>>>>> 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:
>>>>>>>
>>>>>>> epadmin reindex *repository_id* eprint *eprint_id*
>>>>>>>
>>>>>>> ...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.
>>>>>>>
>>>>>>> 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.
>>>>>>>
>>>>>>> Let me know how it goes.
>>>>>>>
>>>>>>> --
>>>>>>> Adam Field
>>>>>>> Business Relationship Manager and Community Lead
>>>>>>> EPrints Services
>>>>>>> +44 (0)23 8059 8814
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On 17 Sep 2015, at 14:36, Jérémy RAINGEARD wrote:
>>>>>>>
>>>>>>>> Hi Adam and thank you.
>>>>>>>>
>>>>>>>> You can find our repository at this address - some thesis are
>>>>>>>> public,
>>>>>>>> some not : http://thesesups.ups-tlse.fr/
>>>>>>>> Just choose a subject for example and let the last option as it is
>>>>>>>> ("trier les résultats").
>>>>>>>>
>>>>>>>> Now, this is the advanced search aprt of my search.pl file -
>>>>>>>> hope it's
>>>>>>>> what you need :
>>>>>>>>
>>>>>>>> $c->{search}->{advanced} =
>>>>>>>> {
>>>>>>>> search_fields => [
>>>>>>>> { meta_fields => [ $EPrints::Utils::FULLTEXT ] },
>>>>>>>> { meta_fields => [ "title" ] },
>>>>>>>> { meta_fields => [ "creators_name" ] },
>>>>>>>> { meta_fields => [ "dircreators_name" ] },
>>>>>>>> { meta_fields => [ "abstract" ] },
>>>>>>>> { meta_fields => [ "keywords" ] },
>>>>>>>> { meta_fields => [ "subjects" ] },
>>>>>>>> #{ meta_fields => [ "type" ] },
>>>>>>>> { meta_fields => [ "divisions" ] },
>>>>>>>> { meta_fields => [ "department" ] },
>>>>>>>>
>>>>>>>> #{ meta_fields => [ "ispublished" ] },
>>>>>>>> #{ meta_fields => [ "refereed" ] },
>>>>>>>> #{ meta_fields => [ "publication" ] },
>>>>>>>> { meta_fields => [ "date" ] },
>>>>>>>> ],
>>>>>>>> preamble_phrase => "cgi/advsearch:preamble",
>>>>>>>> title_phrase => "cgi/advsearch:adv_search",
>>>>>>>> citation => "result",
>>>>>>>> page_size => 20,
>>>>>>>> order_methods => {
>>>>>>>>
>>>>>>>> "byyear" => "-date/creators_name/title",
>>>>>>>>
>>>>>>>> "byyearoldest" => "date/creators_name/title",
>>>>>>>> "byname" => "creators_name/-date/title",
>>>>>>>> "bytitle" => "title/creators_name/-date"
>>>>>>>> },
>>>>>>>> default_order => "byyear",
>>>>>>>> };
>>>>>>>>
>>>>>>>> If necessary, I can add more content of this file or give you
>>>>>>>> more details.
>>>>>>>>
>>>>>>>> Thanks,
>>>>>>>>
>>>>>>>> Jérémy
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Le 17/09/2015 14:21, Field A.N. a écrit :
>>>>>>>>> Hi Jérémy
>>>>>>>>>
>>>>>>>>> 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!
>>>>>>>>>
>>>>>>>>> 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.
>>>>>>>>>
>>>>>>>>> Best WIshes
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Adam Field
>>>>>>>>> Business Relationship Manager and Community Lead
>>>>>>>>> EPrints Services
>>>>>>>>> +44 (0)23 8059 8814
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On 17 Sep 2015, at 09:18, Jérémy RAINGEARD wrote:
>>>>>>>>>
>>>>>>>>>> Hello,
>>>>>>>>>>
>>>>>>>>>> My university asked me to help them with some eprints
>>>>>>>>>> problems - I
>>>>>>>>>> didn't even know what eprints was - in only 2 weeks. I managed to
>>>>>>>>>> correct all problems thanks to your documentation, but I'm
>>>>>>>>>> stuck with
>>>>>>>>>> the last problem and I have no error message to help me to
>>>>>>>>>> resolve it.
>>>>>>>>>>
>>>>>>>>>> First, when we used our advanced search and sorted results by
>>>>>>>>>> date, it
>>>>>>>>>> only sorted it by author name even if we had a date > author
>>>>>>>>>> > title
>>>>>>>>>> sorting. Now, I manage to sort it by date, but only from
>>>>>>>>>> 2010 to 2015.
>>>>>>>>>> Before - probably an upgrade of eprints they told me - it's
>>>>>>>>>> sometimes in
>>>>>>>>>> the right order, but sometimes not and, in this case, the
>>>>>>>>>> order is by
>>>>>>>>>> the author name.
>>>>>>>>>>
>>>>>>>>>> I don't know how to reorder the wrong ones. I checked my
>>>>>>>>>> tables and saw
>>>>>>>>>> an "eprints__order_values_fr" - we don't use it's EN version.
>>>>>>>>>> I don't
>>>>>>>>>> know if the problem is there but when thesis are in the good
>>>>>>>>>> order, they
>>>>>>>>>> appear in this table and when they're in the wrong order,
>>>>>>>>>> they're not in
>>>>>>>>>> it.
>>>>>>>>>>
>>>>>>>>>> Could you please tell me how to correct this wrong behavior
>>>>>>>>>> please ?
>>>>>>>>>> Thank you.
>>>>>>>>>>
>>>>>>>>>> Jérémy
>>>>>>>>>>
>>>>>>>>>> *** 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/
>>>>>>
>>>>>>
>>>>>> *** 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/
>>
>> *** 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/20150925/031c5e21/attachment-0001.html
More information about the Eprints-tech
mailing list