[EP-tech] Re: Advanced Search by date
Jérémy RAINGEARD
jeremy.raingeard at univ-tlse3.fr
Tue Oct 6 10:12:16 BST 2015
I used this query as root. EPrints use "eprints" user.
Le 06/10/2015 10:42, Adam Field a écrit :
> What user are you logged into mysql as when you run this? What user
> does EPrints use (check your
> archives/[archiveid]/cfg/cfg.d/database.pl files).
>
> --
> Adam Field
> Business Relationship Manager and Community Lead
> EPrints Services
>
>
>
> On 6 Oct 2015, at 09:17, Jérémy RAINGEARD
> <jeremy.raingeard at univ-tlse3.fr
> <mailto:jeremy.raingeard at univ-tlse3.fr>> wrote:
>
>> Hi,
>>
>> Any idea with this previous query ? What should I do here ?
>>
>> Thanks,
>>
>> Jeremy
>>
>>
>>
>> Le 28/09/2015 10:44, Jérémy RAINGEARD a écrit :
>>> This time, there were 5 rows in set. Another query or should I try
>>> again your previous solution ?
>>>
>>> Jeremy
>>>
>>>
>>>
>>> Le 28/09/2015 10:36, Adam Field a écrit :
>>>> SELECT * FROM event_queue LIMIT 10
>>>>
>>>> ?
>>>>
>>>> --
>>>> Adam Field
>>>> Business Relationship Manager and Community Lead
>>>> EPrints Services
>>>>
>>>>
>>>>
>>>> On 28 Sep 2015, at 09:24, Jérémy RAINGEARD
>>>> <jeremy.raingeard at univ-tlse3.fr> wrote:
>>>>
>>>>> Hi.
>>>>>
>>>>> "Empty set" again.
>>>>>
>>>>> Jeremy
>>>>>
>>>>>
>>>>>
>>>>> Le 25/09/2015 10:34, Field A.N. a écrit :
>>>>>> How about:
>>>>>>
>>>>>> 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'
>>>>>> 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
>>>>>> LIMIT 10
>>>>>>
>>>>>> --
>>>>>> Adam Field
>>>>>> Business Relationship Manager and Community Lead
>>>>>> EPrints Services
>>>>>> +44 (0)23 8059 8814
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On 25 Sep 2015, at 08:25, Jérémy RAINGEARD wrote:
>>>>>>
>>>>>>> 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> 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> 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/
>>>>>>> *** 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/20151006/da67b919/attachment-0001.html
More information about the Eprints-tech
mailing list