[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] Re: Advanced Search by date
If there are no more ideas in some days, do you think we should delete
all past thesis and make them again ?
Le 06/10/2015 12:11, Adam Field a ?crit :
> OK, I'm out of ideas, I'm afraid. Anyone else have any thoughts?
>
> --
> Adam Field
> Business Relationship Manager and Community Lead
> EPrints Services
>
>
>
> On 6 Oct 2015, at 10:26, J?r?my RAINGEARD
> <jeremy.raingeard at univ-tlse3.fr
> <mailto:jeremy.raingeard at univ-tlse3.fr>> wrote:
>
>> After a "show grants", I have this : "GRANT ALL PRIVILEGES ON
>> `thesesups`.* TO 'eprints'@'localhost'"
>>
>>
>> Le 06/10/2015 11:20, Adam Field a ?crit :
>>> Can you check the permissions that the eprints user has?
>>>
>>> --
>>> Adam Field
>>> Business Relationship Manager and Community Lead
>>> EPrints Services
>>>
>>>
>>>
>>> On 6 Oct 2015, at 10:18, J?r?my RAINGEARD
>>> <jeremy.raingeard at univ-tlse3.fr> wrote:
>>>
>>>> A precision : I just used the same last query with eprints user and
>>>> I received a "Empty set".
>>>>
>>>>
>>>>
>>>> Le 06/10/2015 11:12, J?r?my RAINGEARD a ?crit :
>>>>> 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> 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/
>>>>>
>>>>>
>>>>>
>>>>> *** 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/e6f44ed3/attachment-0001.html