[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] Re: Advanced Search by date
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
> <mailto: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
>>>>> <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
>>>>>>> <mailto: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/
>>>> *** 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/20150928/75094e83/attachment-0001.html