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

[EP-tech] Re: Advanced Search by date



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/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20151006/b3ee7276/attachment-0001.html