<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Hi, <br>
      <br>
      Any idea with this previous query ? What should I do here ?<br>
      <br>
      Thanks,<br>
      <br>
      Jeremy<br>
      <br>
      <br>
      <br>
      Le 28/09/2015 10:44, Jérémy RAINGEARD a écrit :<br>
    </div>
    <blockquote
cite="mid:EMEW3|66ecd35e543c6b3c53b471fe1af4ab44r8R9ir14eprints-tech-bounces|ecs.soton.ac.uk|5608FDD7.1010007@univ-tlse3.fr"
      type="cite">
      <meta content="text/html; charset=windows-1252"
        http-equiv="Content-Type">
      <div class="moz-cite-prefix">This time, there were 5 rows in set.
        Another query or should I try again your previous solution ?<br>
        <br>
        Jeremy<br>
        <br>
        <br>
        <br>
        Le 28/09/2015 10:36, Adam Field a écrit :<br>
      </div>
      <blockquote
cite="mid:EMEW3|8917ac7dc3c18062f10dfa0e5144380br8R9c114eprints-tech-bounces|ecs.soton.ac.uk|C5A1633A-6D43-4615-9029-BD3C2CAB304D@ecs.soton.ac.uk"
        type="cite">
        <meta http-equiv="Content-Type" content="text/html;
          charset=windows-1252">
        <div>SELECT * FROM event_queue LIMIT 10</div>
        <div><br>
        </div>
        <div>?</div>
        <br>
        <div>
          <div style="color: rgb(0, 0, 0); letter-spacing: normal;
            orphans: auto; text-align: start; text-indent: 0px;
            text-transform: none; white-space: normal; widows: auto;
            word-spacing: 0px; -webkit-text-stroke-width: 0px;
            word-wrap: break-word; -webkit-nbsp-mode: space;
            -webkit-line-break: after-white-space;">
            <div style="color: rgb(0, 0, 0); letter-spacing: normal;
              orphans: auto; text-align: start; text-indent: 0px;
              text-transform: none; white-space: normal; widows: auto;
              word-spacing: 0px; -webkit-text-stroke-width: 0px;
              word-wrap: break-word; -webkit-nbsp-mode: space;
              -webkit-line-break: after-white-space;">
              <div>--<br>
                Adam Field<br>
                Business Relationship Manager and Community Lead<br>
                EPrints Services</div>
              <div><br>
              </div>
            </div>
          </div>
          <br class="Apple-interchange-newline">
        </div>
        <br>
        <div>
          <div>On 28 Sep 2015, at 09:24, Jérémy RAINGEARD &lt;<a
              moz-do-not-send="true" class="moz-txt-link-abbreviated"
              href="mailto:jeremy.raingeard@univ-tlse3.fr"><a class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a></a>&gt;

            wrote:</div>
          <br class="Apple-interchange-newline">
          <blockquote type="cite">Hi.<br>
            <br>
            "Empty set" again.<br>
            <br>
            Jeremy<br>
            <br>
            <br>
            <br>
            Le 25/09/2015 10:34, Field A.N. a écrit :<br>
            <blockquote type="cite">How about:<br>
              <br>
              SELECT `event_queue`.`eventqueueid` FROM `event_queue`<br>
              <span class="Apple-tab-span" style="white-space:pre">        </span>LEFT

              JOIN `event_queue__ordervalues_fr`<br>
              <span class="Apple-tab-span" style="white-space:pre">        </span>ON
`event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`<br>
              WHERE<br>
              <span class="Apple-tab-span" style="white-space:pre">        </span>`event_queue`.`status`

              = 'waiting'<br>
              GROUP BY `event_queue`.`eventqueueid`,
              `event_queue__ordervalues_fr`.`priority`,
              `event_queue__ordervalues_fr`.`start_time`<br>
              ORDER BY `event_queue__ordervalues_fr`.`priority` DESC,
              `event_queue__ordervalues_fr`.`start_time` DESC<br>
              LIMIT 10<br>
              <br>
              --<br>
              Adam Field<br>
              Business Relationship Manager and Community Lead<br>
              EPrints Services<br>
              +44 (0)23 8059 8814<br>
              <br>
              <br>
              <br>
              <br>
              <br>
              On 25 Sep 2015, at 08:25, Jérémy RAINGEARD wrote:<br>
              <br>
              <blockquote type="cite">Hi,<br>
                <br>
                I have a "Empty set (0.00 sec)" answer with your query.<br>
                <br>
                Jeremy<br>
                <br>
                <br>
                <br>
                Le 23/09/2015 17:00, Adam Field a écrit :<br>
                <blockquote type="cite">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):<br>
                  <br>
                  SELECT `event_queue`.`eventqueueid` FROM `event_queue`<br>
                  <span class="Apple-tab-span" style="white-space:pre">        </span>LEFT

                  JOIN `event_queue__ordervalues_fr`<br>
                  <span class="Apple-tab-span" style="white-space:pre">        </span>ON
`event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`<br>
                  WHERE<br>
                  <span class="Apple-tab-span" style="white-space:pre">        </span>`event_queue`.`status`

                  = 'waiting'<br>
                  <span class="Apple-tab-span" style="white-space:pre">        </span>AND

                  (<br>
                  <span class="Apple-tab-span" style="white-space:pre">        </span><span class="Apple-tab-span" style="white-space:pre">        </span>(`event_queue`.`start_time_year`

                  &lt; 2015 )<br>
                  <span class="Apple-tab-span" style="white-space:pre">        </span><span class="Apple-tab-span" style="white-space:pre">        </span>OR

                  (`event_queue`.`start_time_year` = 2015 AND
                  `event_queue`.`start_time_month` &lt; 9 )<br>
                  <span class="Apple-tab-span" style="white-space:pre">        </span><span class="Apple-tab-span" style="white-space:pre">        </span>OR

                  ( `event_queue`.`start_time_year` = 2015 AND
                  `event_queue`.`start_time_month` = 9 AND
                  `event_queue`.`start_time_day` &lt; 17 )<br>
                  <span class="Apple-tab-span" style="white-space:pre">        </span><span class="Apple-tab-span" style="white-space:pre">        </span>OR

                  ( `event_queue`.`start_time_year` = 2015 AND
                  `event_queue`.`start_time_month` = 9 AND
                  `event_queue`.`start_time_day` = 17 )<br>
                  <span class="Apple-tab-span" style="white-space:pre">        </span>)<br>
                  GROUP BY `event_queue`.`eventqueueid`,
                  `event_queue__ordervalues_fr`.`priority`,
                  `event_queue__ordervalues_fr`.`start_time`<br>
                  ORDER BY `event_queue__ordervalues_fr`.`priority`
                  DESC, `event_queue__ordervalues_fr`.`start_time` DESC<br>
                  <br>
                  <br>
                  ...and let me know what happens.<br>
                  <br>
                  --<br>
                  Adam Field<br>
                  Business Relationship Manager and Community Lead<br>
                  EPrints Services<br>
                  <br>
                  <br>
                  <br>
                  On 23 Sep 2015, at 09:47, Jérémy RAINGEARD &lt;<a
                    moz-do-not-send="true"
                    class="moz-txt-link-abbreviated"
                    href="mailto:jeremy.raingeard@univ-tlse3.fr"><a class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a></a>&gt;

                  wrote:<br>
                  <br>
                  <blockquote type="cite">Actually, there are a lot of
                    warnings, probably more than 30. I won't copy all,
                    it's the same each time :<br>
                    <br>
                    "warning : X (1 to 3 here) client(s) is using or
                    hasn't/haven't closed the table properly. Status :
                    OK"<br>
                    <br>
                    Jeremy<br>
                    <br>
                    <br>
                    <br>
                    Le 23/09/2015 10:11, Adam Field a écrit :<br>
                    <blockquote type="cite">Well, nothing jumps out at
                      me.<br>
                      <br>
                      Can you try running mysqlcheck on the eprints
                      database?<br>
                      <br>
                      --<br>
                      Adam Field<br>
                      Business Relationship Manager and Community Lead<br>
                      EPrints Services<br>
                      <br>
                      I am currently not working in the UK.  Due to
                      timezone differences (GMT -9) email responses may
                      take longer.<br>
                      <br>
                      On 23 Sep 2015, at 08:33, Jérémy RAINGEARD &lt;<a
                        moz-do-not-send="true"
                        class="moz-txt-link-abbreviated"
                        href="mailto:jeremy.raingeard@univ-tlse3.fr"><a class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a></a>&gt;

                      wrote:<br>
                      <br>
                      <blockquote type="cite">Hi Adam and thanks again.<br>
                        <br>
                        First, we're running mysql with "mysql" user and
                        the permissions of our database "thesesups" are
                        : 700 mysql:mysql<br>
                        <br>
                        Finally, here are all our tables :<br>
                        <br>
                        +---------------------------------+<br>
                        | Tables_in_thesesups             |<br>
                        +---------------------------------+<br>
                        | access                          |<br>
                        | access__ordervalues_en          |<br>
                        | access__ordervalues_fr          |<br>
                        | cache615369                     |<br>
                        | cache615370                     |<br>
                        | cache615371                     |<br>
                        | cache615372                     |<br>
                        | cache615373                     |<br>
                        | cache615374                     |<br>
                        | cache615375                     |<br>
                        | cache615376                     |<br>
                        | cache615377                     |<br>
                        | cache615378                     |<br>
                        | cache615379                     |<br>
                        | cache615380                     |<br>
                        | cache615381                     |<br>
                        | cache615382                     |<br>
                        | cache615383                     |<br>
                        | cache615384                     |<br>
                        | cache615385                     |<br>
                        | cache615386                     |<br>
                        | cache615387                     |<br>
                        | cache615388                     |<br>
                        | cache615389                     |<br>
                        | cache615390                     |<br>
                        | cache615391                     |<br>
                        | cache615392                     |<br>
                        | cache615393                     |<br>
                        | cache615395                     |<br>
                        | cache615397                     |<br>
                        | cache615398                     |<br>
                        | cache615399                     |<br>
                        | cache615400                     |<br>
                        | cache615401                     |<br>
                        | cache615402                     |<br>
                        | cache615403                     |<br>
                        | cache615404                     |<br>
                        | cache615405                     |<br>
                        | cache615406                     |<br>
                        | cache615407                     |<br>
                        | cache615408                     |<br>
                        | cache615409                     |<br>
                        | cache615410                     |<br>
                        | cache615411                     |<br>
                        | cache615412                     |<br>
                        | cache615413                     |<br>
                        | cache615414                     |<br>
                        | cache615415                     |<br>
                        | cache615416                     |<br>
                        | cache615417                     |<br>
                        | cache615418                     |<br>
                        | cache615420                     |<br>
                        | cache615421                     |<br>
                        | cache615422                     |<br>
                        | cache615425                     |<br>
                        | cache615427                     |<br>
                        | cache615429                     |<br>
                        | cache615432                     |<br>
                        | cache615433                     |<br>
                        | cache615437                     |<br>
                        | cache615438                     |<br>
                        | cache615439                     |<br>
                        | cache615441                     |<br>
                        | cache615443                     |<br>
                        | cache615445                     |<br>
                        | cache615448                     |<br>
                        | cache615449                     |<br>
                        | cache615452                     |<br>
                        | cache615453                     |<br>
                        | cache615456                     |<br>
                        | cache615457                     |<br>
                        | cache615460                     |<br>
                        | cache615461                     |<br>
                        | cache615464                     |<br>
                        | cache615465                     |<br>
                        | cache615467                     |<br>
                        | cache615468                     |<br>
                        | cache615470                     |<br>
                        | cache615473                     |<br>
                        | cache615474                     |<br>
                        | cache615475                     |<br>
                        | cache615477                     |<br>
                        | cache615479                     |<br>
                        | cache615481                     |<br>
                        | cache615483                     |<br>
                        | cache615486                     |<br>
                        | cache615487                     |<br>
                        | cache615491                     |<br>
                        | cache615492                     |<br>
                        | cache615493                     |<br>
                        | cache615495                     |<br>
                        | cache615497                     |<br>
                        | cache615499                     |<br>
                        | cache615501                     |<br>
                        | cache615503                     |<br>
                        | cache615505                     |<br>
                        | cache615507                     |<br>
                        | cache615509                     |<br>
                        | cache615511                     |<br>
                        | cache615513                     |<br>
                        | cache615515                     |<br>
                        | cache615517                     |<br>
                        | cache615518                     |<br>
                        | cache615519                     |<br>
                        | cache615520                     |<br>
                        | cache615522                     |<br>
                        | cache615524                     |<br>
                        | cache615526                     |<br>
                        | cache615529                     |<br>
                        | cache615530                     |<br>
                        | cache615534                     |<br>
                        | cache615535                     |<br>
                        | cache615536                     |<br>
                        | cache615538                     |<br>
                        | cache615540                     |<br>
                        | cache615542                     |<br>
                        | cache615544                     |<br>
                        | cache615546                     |<br>
                        | cache615548                     |<br>
                        | cache615550                     |<br>
                        | cache615552                     |<br>
                        | cache615554                     |<br>
                        | cache615556                     |<br>
                        | cache615558                     |<br>
                        | cache615560                     |<br>
                        | cache615562                     |<br>
                        | cache615564                     |<br>
                        | cache615566                     |<br>
                        | cache615567                     |<br>
                        | cache615568                     |<br>
                        | cache615570                     |<br>
                        | cache615571                     |<br>
                        | cache615572                     |<br>
                        | cache615573                     |<br>
                        | cache615575                     |<br>
                        | cache615577                     |<br>
                        | cache615579                     |<br>
                        | cache615581                     |<br>
                        | cache615583                     |<br>
                        | cache615586                     |<br>
                        | cache615587                     |<br>
                        | cache615591                     |<br>
                        | cache615592                     |<br>
                        | cache615593                     |<br>
                        | cache615595                     |<br>
                        | cache615597                     |<br>
                        | cache615599                     |<br>
                        | cache615601                     |<br>
                        | cache615603                     |<br>
                        | cache615605                     |<br>
                        | cache615607                     |<br>
                        | cache615609                     |<br>
                        | cache615611                     |<br>
                        | cache615613                     |<br>
                        | cache615616                     |<br>
                        | cache615617                     |<br>
                        | cache615621                     |<br>
                        | cache615622                     |<br>
                        | cache615623                     |<br>
                        | cache615625                     |<br>
                        | cache615627                     |<br>
                        | cache615629                     |<br>
                        | cache615630                     |<br>
                        | cache615631                     |<br>
                        | cache615632                     |<br>
                        | cache615633                     |<br>
                        | cache615634                     |<br>
                        | cache615636                     |<br>
                        | cache615638                     |<br>
                        | cache615640                     |<br>
                        | cache615642                     |<br>
                        | cache615644                     |<br>
                        | cache615646                     |<br>
                        | cache615648                     |<br>
                        | cache615650                     |<br>
                        | cache615652                     |<br>
                        | cache615654                     |<br>
                        | cache615656                     |<br>
                        | cache615658                     |<br>
                        | cache615661                     |<br>
                        | cache615662                     |<br>
                        | cache615666                     |<br>
                        | cache615667                     |<br>
                        | cache615668                     |<br>
                        | cache615670                     |<br>
                        | cache615672                     |<br>
                        | cachemap                        |<br>
                        | cachemap__ordervalues_fr        |<br>
                        | counters                        |<br>
                        | document                        |<br>
                        | document__index                 |<br>
                        | document__index_grep            |<br>
                        | document__ordervalues_en        |<br>
                        | document__ordervalues_fr        |<br>
                        | document__rindex                |<br>
                        | document_permission_group       |<br>
                        | document_relation_type          |<br>
                        | document_relation_uri           |<br>
                        | eprint                          |<br>
                        | eprint__index                   |<br>
                        | eprint__index_grep              |<br>
                        | eprint__ordervalues_en          |<br>
                        | eprint__ordervalues_fr          |<br>
                        | eprint__rindex                  |<br>
                        | eprint_accompaniment            |<br>
                        | eprint_conductors_id            |<br>
                        | eprint_conductors_name          |<br>
                        | eprint_copyright_holders        |<br>
                        | eprint_corp_creators            |<br>
                        | eprint_creators_id              |<br>
                        | eprint_creators_name            |<br>
                        | eprint_dircreators_name         |<br>
                        | eprint_divisions                |<br>
                        | eprint_editors_id               |<br>
                        | eprint_editors_name             |<br>
                        | eprint_exhibitors_id            |<br>
                        | eprint_exhibitors_name          |<br>
                        | eprint_funders                  |<br>
                        | eprint_item_issues_comment      |<br>
                        | eprint_item_issues_description  |<br>
                        | eprint_item_issues_id           |<br>
                        | eprint_item_issues_reported_by  |<br>
                        | eprint_item_issues_resolved_by  |<br>
                        | eprint_item_issues_status       |<br>
                        | eprint_item_issues_timestamp    |<br>
                        | eprint_item_issues_type         |<br>
                        | eprint_language                 |<br>
                        | eprint_lyricists_id             |<br>
                        | eprint_lyricists_name           |<br>
                        | eprint_producers_id             |<br>
                        | eprint_producers_name           |<br>
                        | eprint_projects                 |<br>
                        | eprint_related_url_type         |<br>
                        | eprint_related_url_url          |<br>
                        | eprint_relation_type            |<br>
                        | eprint_relation_uri             |<br>
                        | eprint_skill_areas              |<br>
                        | eprint_subjects                 |<br>
                        | event_queue                     |<br>
                        | event_queue__ordervalues_fr     |<br>
                        | file                            |<br>
                        | file__ordervalues_fr            |<br>
                        | file_copies_pluginid            |<br>
                        | file_copies_sourceid            |<br>
                        | history                         |<br>
                        | history__index                  |<br>
                        | history__index_grep             |<br>
                        | history__ordervalues_en         |<br>
                        | history__ordervalues_fr         |<br>
                        | history__rindex                 |<br>
                        | import                          |<br>
                        | import__ordervalues_fr          |<br>
                        | index_queue                     |<br>
                        | loginticket                     |<br>
                        | loginticket__ordervalues_fr     |<br>
                        | message                         |<br>
                        | message__ordervalues_fr         |<br>
                        | mf                              |<br>
                        | mf__ordervalues_fr              |<br>
                        | mf_fields_allow_null            |<br>
                        | mf_fields_browse_link           |<br>
                        | mf_fields_datasetid             |<br>
                        | mf_fields_default_value         |<br>
                        | mf_fields_export_as_xml         |<br>
                        | mf_fields_family_first          |<br>
                        | mf_fields_hide_honourific       |<br>
                        | mf_fields_hide_lineage          |<br>
                        | mf_fields_input_boxes           |<br>
                        | mf_fields_input_cols            |<br>
                        | mf_fields_input_ordered         |<br>
                        | mf_fields_input_rows            |<br>
                        | mf_fields_input_style           |<br>
                        | mf_fields_maxlength             |<br>
                        | mf_fields_mfremoved             |<br>
                        | mf_fields_min_resolution        |<br>
                        | mf_fields_options               |<br>
                        | mf_fields_render_input          |<br>
                        | mf_fields_render_order          |<br>
                        | mf_fields_render_value          |<br>
                        | mf_fields_required              |<br>
                        | mf_fields_set_name              |<br>
                        | mf_fields_sql_counter           |<br>
                        | mf_fields_sql_index             |<br>
                        | mf_fields_sub_name              |<br>
                        | mf_fields_top                   |<br>
                        | mf_fields_type                  |<br>
                        | mf_fields_volatile              |<br>
                        | mf_phrase_help_lang             |<br>
                        | mf_phrase_help_text             |<br>
                        | mf_phrase_name_lang             |<br>
                        | mf_phrase_name_text             |<br>
                        | request                         |<br>
                        | request__index                  |<br>
                        | request__index_grep             |<br>
                        | request__ordervalues_en         |<br>
                        | request__ordervalues_fr         |<br>
                        | request__rindex                 |<br>
                        | saved_search                    |<br>
                        | saved_search__index             |<br>
                        | saved_search__index_grep        |<br>
                        | saved_search__ordervalues_en    |<br>
                        | saved_search__ordervalues_fr    |<br>
                        | saved_search__rindex            |<br>
                        | subject                         |<br>
                        | subject__index                  |<br>
                        | subject__index_grep             |<br>
                        | subject__ordervalues_en         |<br>
                        | subject__ordervalues_fr         |<br>
                        | subject__rindex                 |<br>
                        | subject_ancestors               |<br>
                        | subject_name_lang               |<br>
                        | subject_name_name               |<br>
                        | subject_parents                 |<br>
                        | triple                          |<br>
                        | triple__ordervalues_fr          |<br>
                        | upload_progress                 |<br>
                        | upload_progress__ordervalues_fr |<br>
                        | user                            |<br>
                        | user__index                     |<br>
                        | user__index_grep                |<br>
                        | user__ordervalues_en            |<br>
                        | user__ordervalues_fr            |<br>
                        | user__rindex                    |<br>
                        | user_editperms                  |<br>
                        | user_items_fields               |<br>
                        | user_permission_group           |<br>
                        | user_review_fields              |<br>
                        | user_roles                      |<br>
                        | version                         |<br>
                        +---------------------------------+<br>
                        <br>
                        Is there anything you need or did I give you
                        enough details ?<br>
                        <br>
                        Thanks,<br>
                        <br>
                        Jeremy<br>
                        <br>
                        <br>
                        <br>
                        <br>
                        Le 22/09/2015 21:56, Adam Field a écrit :<br>
                        <blockquote type="cite">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).<br>
                          <br>
                          <br>
                          --<br>
                          Adam Field<br>
                          Business Relationship Manager and Community
                          Lead<br>
                          EPrints Services<br>
                          <br>
                          <blockquote type="cite">On 18 Sep 2015, at
                            13:44, Jérémy RAINGEARD &lt;<a
                              moz-do-not-send="true"
                              class="moz-txt-link-abbreviated"
                              href="mailto:jeremy.raingeard@univ-tlse3.fr"><a class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a></a>&gt;

                            wrote:<br>
                            <br>
                            Hi Adam,<br>
                            <br>
                            I tried your solution and it did nothing :
                            not sorted out well and it<br>
                            didn't appear in my eprint__ordervalues_fr
                            table - I don't know if it's<br>
                            useful or not. But I checked my logs after
                            some tries and this is what I<br>
                            found in it :<br>
                            <br>
                            DBD::mysql::st execute failed: Can't open
                            file:<br>
                            './thesesups/event_queue.frm' (errno: 24) at<br>
                            /opt/eprints3/perl_lib/EPrints/Database.pm
                            line 3372, &lt;DATA&gt; line 151.<br>
                            SQL ERROR (execute): SELECT
                            `event_queue`.`eventqueueid` FROM<br>
                            `event_queue` LEFT JOIN
                            `event_queue__ordervalues_fr` ON<br>
                            `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`

                            WHERE<br>
                            `event_queue`.`status` = 'waiting' AND ((<br>
                            `event_queue`.`start_time_year` &lt; 2015 )
                            OR (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` &lt; 9 ) OR
                            (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            &lt; 17 ) OR (
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            = 17 )) GROUP BY
                            `event_queue`.`eventqueueid`,<br>
                            `event_queue__ordervalues_fr`.`priority`,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            ORDER BY<br>
                            `event_queue__ordervalues_fr`.`priority`
                            DESC,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            DESC<br>
                            SQL ERROR (execute): Can't open file:
                            './thesesups/event_queue.frm'<br>
                            (errno: 24)<br>
                            DBD::mysql::st fetch failed: fetch() without
                            execute() at<br>
                            /opt/eprints3/perl_lib/EPrints/Search/Condition.pm

                            line 565, &lt;DATA&gt; line<br>
                            151.<br>
                            DBD::mysql::st execute failed: Can't open
                            file:<br>
                            './thesesups/event_queue.frm' (errno: 24) at<br>
                            /opt/eprints3/perl_lib/EPrints/Database.pm
                            line 3372, &lt;DATA&gt; line 151.<br>
                            SQL ERROR (execute): SELECT
                            `event_queue`.`eventqueueid` FROM<br>
                            `event_queue` LEFT JOIN
                            `event_queue__ordervalues_fr` ON<br>
                            `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`

                            WHERE<br>
                            `event_queue`.`status` = 'waiting' AND ((<br>
                            `event_queue`.`start_time_year` &lt; 2015 )
                            OR (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` &lt; 9 ) OR
                            (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            &lt; 17 ) OR (
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            = 17 )) GROUP BY
                            `event_queue`.`eventqueueid`,<br>
                            `event_queue__ordervalues_fr`.`priority`,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            ORDER BY<br>
                            `event_queue__ordervalues_fr`.`priority`
                            DESC,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            DESC<br>
                            SQL ERROR (execute): Can't open file:
                            './thesesups/event_queue.frm'<br>
                            (errno: 24)<br>
                            DBD::mysql::st fetch failed: fetch() without
                            execute() at<br>
                            /opt/eprints3/perl_lib/EPrints/Search/Condition.pm

                            line 565, &lt;DATA&gt; line<br>
                            151.<br>
                            DBD::mysql::st execute failed: Can't open
                            file:<br>
                            './thesesups/event_queue.frm' (errno: 24) at<br>
                            /opt/eprints3/perl_lib/EPrints/Database.pm
                            line 3372, &lt;DATA&gt; line 151.<br>
                            SQL ERROR (execute): SELECT
                            `event_queue`.`eventqueueid` FROM<br>
                            `event_queue` LEFT JOIN
                            `event_queue__ordervalues_fr` ON<br>
                            `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`

                            WHERE<br>
                            `event_queue`.`status` = 'waiting' AND ((<br>
                            `event_queue`.`start_time_year` &lt; 2015 )
                            OR (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` &lt; 9 ) OR
                            (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            &lt; 17 ) OR (
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            = 17 )) GROUP BY
                            `event_queue`.`eventqueueid`,<br>
                            `event_queue__ordervalues_fr`.`priority`,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            ORDER BY<br>
                            `event_queue__ordervalues_fr`.`priority`
                            DESC,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            DESC<br>
                            SQL ERROR (execute): Can't open file:
                            './thesesups/event_queue.frm'<br>
                            (errno: 24)<br>
                            DBD::mysql::st fetch failed: fetch() without
                            execute() at<br>
                            /opt/eprints3/perl_lib/EPrints/Search/Condition.pm

                            line 565, &lt;DATA&gt; line<br>
                            151.<br>
                            DBD::mysql::st execute failed: Can't open
                            file:<br>
                            './thesesups/event_queue.frm' (errno: 24) at<br>
                            /opt/eprints3/perl_lib/EPrints/Database.pm
                            line 3372, &lt;DATA&gt; line 151.<br>
                            SQL ERROR (execute): SELECT
                            `event_queue`.`eventqueueid` FROM<br>
                            `event_queue` LEFT JOIN
                            `event_queue__ordervalues_fr` ON<br>
                            `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`

                            WHERE<br>
                            `event_queue`.`status` = 'waiting' AND ((<br>
                            `event_queue`.`start_time_year` &lt; 2015 )
                            OR (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` &lt; 9 ) OR
                            (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            &lt; 17 ) OR (
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            = 17 )) GROUP BY
                            `event_queue`.`eventqueueid`,<br>
                            `event_queue__ordervalues_fr`.`priority`,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            ORDER BY<br>
                            `event_queue__ordervalues_fr`.`priority`
                            DESC,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            DESC<br>
                            SQL ERROR (execute): Can't open file:
                            './thesesups/event_queue.frm'<br>
                            (errno: 24)<br>
                            DBD::mysql::st fetch failed: fetch() without
                            execute() at<br>
                            /opt/eprints3/perl_lib/EPrints/Search/Condition.pm

                            line 565, &lt;DATA&gt; line<br>
                            151.<br>
                            DBD::mysql::st execute failed: Can't open
                            file:<br>
                            './thesesups/event_queue.frm' (errno: 24) at<br>
                            /opt/eprints3/perl_lib/EPrints/Database.pm
                            line 3372, &lt;DATA&gt; line 151.<br>
                            SQL ERROR (execute): SELECT
                            `event_queue`.`eventqueueid` FROM<br>
                            `event_queue` LEFT JOIN
                            `event_queue__ordervalues_fr` ON<br>
                            `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`

                            WHERE<br>
                            `event_queue`.`status` = 'waiting' AND ((<br>
                            `event_queue`.`start_time_year` &lt; 2015 )
                            OR (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` &lt; 9 ) OR
                            (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            &lt; 17 ) OR (
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            = 17 )) GROUP BY
                            `event_queue`.`eventqueueid`,<br>
                            `event_queue__ordervalues_fr`.`priority`,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            ORDER BY<br>
                            `event_queue__ordervalues_fr`.`priority`
                            DESC,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            DESC<br>
                            SQL ERROR (execute): Can't open file:
                            './thesesups/event_queue.frm'<br>
                            (errno: 24)<br>
                            DBD::mysql::st fetch failed: fetch() without
                            execute() at<br>
                            /opt/eprints3/perl_lib/EPrints/Search/Condition.pm

                            line 565, &lt;DATA&gt; line<br>
                            151.<br>
                            DBD::mysql::st execute failed: Can't open
                            file:<br>
                            './thesesups/event_queue.frm' (errno: 24) at<br>
                            /opt/eprints3/perl_lib/EPrints/Database.pm
                            line 3372, &lt;DATA&gt; line 151.<br>
                            SQL ERROR (execute): SELECT
                            `event_queue`.`eventqueueid` FROM<br>
                            `event_queue` LEFT JOIN
                            `event_queue__ordervalues_fr` ON<br>
                            `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`

                            WHERE<br>
                            `event_queue`.`status` = 'waiting' AND ((<br>
                            `event_queue`.`start_time_year` &lt; 2015 )
                            OR (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` &lt; 9 ) OR
                            (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            &lt; 17 ) OR (
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            = 17 )) GROUP BY
                            `event_queue`.`eventqueueid`,<br>
                            `event_queue__ordervalues_fr`.`priority`,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            ORDER BY<br>
                            `event_queue__ordervalues_fr`.`priority`
                            DESC,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            DESC<br>
                            SQL ERROR (execute): Can't open file:
                            './thesesups/event_queue.frm'<br>
                            (errno: 24)<br>
                            DBD::mysql::st fetch failed: fetch() without
                            execute() at<br>
                            /opt/eprints3/perl_lib/EPrints/Search/Condition.pm

                            line 565, &lt;DATA&gt; line<br>
                            151.<br>
                            DBD::mysql::st execute failed: Can't open
                            file:<br>
                            './thesesups/event_queue.frm' (errno: 24) at<br>
                            /opt/eprints3/perl_lib/EPrints/Database.pm
                            line 3372, &lt;DATA&gt; line 151.<br>
                            SQL ERROR (execute): SELECT
                            `event_queue`.`eventqueueid` FROM<br>
                            `event_queue` LEFT JOIN
                            `event_queue__ordervalues_fr` ON<br>
                            `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`

                            WHERE<br>
                            `event_queue`.`status` = 'waiting' AND ((<br>
                            `event_queue`.`start_time_year` &lt; 2015 )
                            OR (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` &lt; 9 ) OR
                            (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            &lt; 17 ) OR (
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            = 17 )) GROUP BY
                            `event_queue`.`eventqueueid`,<br>
                            `event_queue__ordervalues_fr`.`priority`,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            ORDER BY<br>
                            `event_queue__ordervalues_fr`.`priority`
                            DESC,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            DESC<br>
                            SQL ERROR (execute): Can't open file:
                            './thesesups/event_queue.frm'<br>
                            (errno: 24)<br>
                            DBD::mysql::st fetch failed: fetch() without
                            execute() at<br>
                            /opt/eprints3/perl_lib/EPrints/Search/Condition.pm

                            line 565, &lt;DATA&gt; line<br>
                            151.<br>
                            DBD::mysql::st execute failed: Can't open
                            file:<br>
                            './thesesups/event_queue.frm' (errno: 24) at<br>
                            /opt/eprints3/perl_lib/EPrints/Database.pm
                            line 3372, &lt;DATA&gt; line 151.<br>
                            SQL ERROR (execute): SELECT
                            `event_queue`.`eventqueueid` FROM<br>
                            `event_queue` LEFT JOIN
                            `event_queue__ordervalues_fr` ON<br>
                            `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`

                            WHERE<br>
                            `event_queue`.`status` = 'waiting' AND ((<br>
                            `event_queue`.`start_time_year` &lt; 2015 )
                            OR (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` &lt; 9 ) OR
                            (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            &lt; 17 ) OR (
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            = 17 )) GROUP BY
                            `event_queue`.`eventqueueid`,<br>
                            `event_queue__ordervalues_fr`.`priority`,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            ORDER BY<br>
                            `event_queue__ordervalues_fr`.`priority`
                            DESC,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            DESC<br>
                            SQL ERROR (execute): Can't open file:
                            './thesesups/event_queue.frm'<br>
                            (errno: 24)<br>
                            DBD::mysql::st fetch failed: fetch() without
                            execute() at<br>
                            /opt/eprints3/perl_lib/EPrints/Search/Condition.pm

                            line 565, &lt;DATA&gt; line<br>
                            151.<br>
                            DBD::mysql::st execute failed: Can't open
                            file:<br>
                            './thesesups/event_queue.frm' (errno: 24) at<br>
                            /opt/eprints3/perl_lib/EPrints/Database.pm
                            line 3372, &lt;DATA&gt; line 151.<br>
                            SQL ERROR (execute): SELECT
                            `event_queue`.`eventqueueid` FROM<br>
                            `event_queue` LEFT JOIN
                            `event_queue__ordervalues_fr` ON<br>
                            `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`

                            WHERE<br>
                            `event_queue`.`status` = 'waiting' AND ((<br>
                            `event_queue`.`start_time_year` &lt; 2015 )
                            OR (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` &lt; 9 ) OR
                            (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            &lt; 17 ) OR (
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            = 17 )) GROUP BY
                            `event_queue`.`eventqueueid`,<br>
                            `event_queue__ordervalues_fr`.`priority`,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            ORDER BY<br>
                            `event_queue__ordervalues_fr`.`priority`
                            DESC,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            DESC<br>
                            SQL ERROR (execute): Can't open file:
                            './thesesups/event_queue.frm'<br>
                            (errno: 24)<br>
                            DBD::mysql::st fetch failed: fetch() without
                            execute() at<br>
                            /opt/eprints3/perl_lib/EPrints/Search/Condition.pm

                            line 565, &lt;DATA&gt; line<br>
                            151.<br>
                            DBD::mysql::st execute failed: Can't open
                            file:<br>
                            './thesesups/event_queue.frm' (errno: 24) at<br>
                            /opt/eprints3/perl_lib/EPrints/Database.pm
                            line 3372, &lt;DATA&gt; line 151.<br>
                            SQL ERROR (execute): SELECT
                            `event_queue`.`eventqueueid` FROM<br>
                            `event_queue` LEFT JOIN
                            `event_queue__ordervalues_fr` ON<br>
                            `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`

                            WHERE<br>
                            `event_queue`.`status` = 'waiting' AND ((<br>
                            `event_queue`.`start_time_year` &lt; 2015 )
                            OR (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` &lt; 9 ) OR
                            (<br>
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            &lt; 17 ) OR (
                            `event_queue`.`start_time_year` = 2015 AND<br>
                            `event_queue`.`start_time_month` = 9 AND
                            `event_queue`.`start_time_day`<br>
                            = 17 )) GROUP BY
                            `event_queue`.`eventqueueid`,<br>
                            `event_queue__ordervalues_fr`.`priority`,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            ORDER BY<br>
                            `event_queue__ordervalues_fr`.`priority`
                            DESC,<br>
                            `event_queue__ordervalues_fr`.`start_time`
                            DESC<br>
                            SQL ERROR (execute): Can't open file:
                            './thesesups/event_queue.frm'<br>
                            (errno: 24)<br>
                            DBD::mysql::st fetch failed: fetch() without
                            execute() at<br>
                            /opt/eprints3/perl_lib/EPrints/Search/Condition.pm

                            line 565, &lt;DATA&gt; line<br>
                            151.<br>
                            [Fri Sep 18 14:28:09 2015] ** Indexer
                            process stopping<br>
                            [Fri Sep 18 14:28:17 2015] ** Indexer
                            process started<br>
                            <br>
                            I don't find this event_queue.frm - because
                            it's a temporary file for<br>
                            MySQL ? - so I can't even see if it's a
                            permission problem. Any idea<br>
                            about this ?<br>
                            <br>
                            Thank you.<br>
                            <br>
                            Jeremy<br>
                            <br>
                            <br>
                            Le 17/09/2015 16:09, Field A.N. a écrit :<br>
                            <blockquote type="cite">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:<br>
                              <br>
                              epadmin reindex *repository_id* eprint
                              *eprint_id*<br>
                              <br>
                              ...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.<br>
                              <br>
                              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.<br>
                              <br>
                              Let me know how it goes.<br>
                              <br>
                              --<br>
                              Adam Field<br>
                              Business Relationship Manager and
                              Community Lead<br>
                              EPrints Services<br>
                              +44 (0)23 8059 8814<br>
                              <br>
                              <br>
                              <br>
                              <br>
                              <br>
                              On 17 Sep 2015, at 14:36, Jérémy RAINGEARD
                              wrote:<br>
                              <br>
                              <blockquote type="cite">Hi Adam and thank
                                you.<br>
                                <br>
                                You can find our repository at this
                                address - some thesis are public,<br>
                                some not : <a moz-do-not-send="true"
                                  href="http://thesesups.ups-tlse.fr/">http://thesesups.ups-tlse.fr/</a><br>
                                Just choose a subject for example and
                                let the last option as it is<br>
                                ("trier les résultats").<br>
                                <br>
                                Now, this is the advanced search aprt of
                                my search.pl file - hope it's<br>
                                what you need :<br>
                                <br>
                                $c-&gt;{search}-&gt;{advanced} =<br>
                                {<br>
                                    search_fields =&gt; [<br>
                                        { meta_fields =&gt; [
                                $EPrints::Utils::FULLTEXT ] },<br>
                                        { meta_fields =&gt; [ "title" ]
                                },<br>
                                        { meta_fields =&gt; [
                                "creators_name" ] },<br>
                                        { meta_fields =&gt; [
                                "dircreators_name" ] },<br>
                                        { meta_fields =&gt; [ "abstract"
                                ] },<br>
                                        { meta_fields =&gt; [ "keywords"
                                ] },<br>
                                        { meta_fields =&gt; [ "subjects"
                                ] },<br>
                                        #{ meta_fields =&gt; [ "type" ]
                                },<br>
                                        { meta_fields =&gt; [
                                "divisions" ] },<br>
                                        { meta_fields =&gt; [
                                "department" ] },<br>
                                <br>
                                        #{ meta_fields =&gt; [
                                "ispublished" ] },<br>
                                        #{ meta_fields =&gt; [
                                "refereed" ] },<br>
                                        #{ meta_fields =&gt; [
                                "publication" ] },<br>
                                        { meta_fields =&gt; [ "date" ]
                                },<br>
                                    ],<br>
                                    preamble_phrase =&gt;
                                "cgi/advsearch:preamble",<br>
                                    title_phrase =&gt;
                                "cgi/advsearch:adv_search",<br>
                                    citation =&gt; "result",<br>
                                    page_size =&gt; 20,<br>
                                    order_methods =&gt; {<br>
                                <br>
                                        "byyear"      =&gt;
                                "-date/creators_name/title",<br>
                                <br>
                                        "byyearoldest"     =&gt;
                                "date/creators_name/title",<br>
                                        "byname"       =&gt;
                                "creators_name/-date/title",<br>
                                        "bytitle"      =&gt;
                                "title/creators_name/-date"<br>
                                    },<br>
                                    default_order =&gt; "byyear",<br>
                                };<br>
                                <br>
                                If necessary, I can add more content of
                                this file or give you more details.<br>
                                <br>
                                Thanks,<br>
                                <br>
                                Jérémy<br>
                                <br>
                                <br>
                                <br>
                                Le 17/09/2015 14:21, Field A.N. a écrit
                                :<br>
                                <blockquote type="cite">Hi Jérémy<br>
                                  <br>
                                  <span class="Apple-tab-span" style="white-space:pre">        </span>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!<br>
                                  <br>
                                  <span class="Apple-tab-span" style="white-space:pre">        </span>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.<br>
                                  <br>
                                  <span class="Apple-tab-span" style="white-space:pre">        </span>Best

                                  WIshes<br>
                                  <br>
                                  --<br>
                                  Adam Field<br>
                                  Business Relationship Manager and
                                  Community Lead<br>
                                  EPrints Services<br>
                                  +44 (0)23 8059 8814<br>
                                  <br>
                                  <br>
                                  <br>
                                  <br>
                                  <br>
                                  On 17 Sep 2015, at 09:18, Jérémy
                                  RAINGEARD wrote:<br>
                                  <br>
                                  <blockquote type="cite">Hello,<br>
                                    <br>
                                    My university asked me to help them
                                    with some eprints problems - I<br>
                                    didn't even know what eprints was -
                                    in only 2 weeks. I managed to<br>
                                    correct all problems thanks to your
                                    documentation, but I'm stuck with<br>
                                    the last problem and I have no error
                                    message to help me to resolve it.<br>
                                    <br>
                                    First, when we used our advanced
                                    search and sorted results by date,
                                    it<br>
                                    only sorted it by author name even
                                    if we had a date &gt; author &gt;
                                    title<br>
                                    sorting.  Now, I manage to sort it
                                    by date, but only from 2010 to 2015.<br>
                                    Before - probably an upgrade of
                                    eprints they told me - it's
                                    sometimes in<br>
                                    the right order, but sometimes not
                                    and, in this case, the order is by<br>
                                    the author name.<br>
                                    <br>
                                    I don't know how to reorder the
                                    wrong ones. I checked my tables and
                                    saw<br>
                                    an "eprints__order_values_fr" - we
                                    don't use it's EN version. I don't<br>
                                    know if the problem is there but
                                    when thesis are in the good order,
                                    they<br>
                                    appear in this table and when
                                    they're in the wrong order, they're
                                    not in<br>
                                    it.<br>
                                    <br>
                                    Could you please tell me how to
                                    correct this wrong behavior please ?<br>
                                    Thank you.<br>
                                    <br>
                                    Jérémy<br>
                                    <br>
                                    *** Options: <a
                                      moz-do-not-send="true"
                                      class="moz-txt-link-freetext"
                                      href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"><a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a></a><br>
                                    *** Archive: <a
                                      moz-do-not-send="true"
                                      class="moz-txt-link-freetext"
                                      href="http://www.eprints.org/tech.php/"><a class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a></a><br>
                                    *** EPrints community wiki: <a
                                      moz-do-not-send="true"
                                      class="moz-txt-link-freetext"
                                      href="http://wiki.eprints.org/"><a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></a><br>
                                    *** EPrints developers Forum: <a
                                      moz-do-not-send="true"
                                      class="moz-txt-link-freetext"
                                      href="http://forum.eprints.org/"><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br>
                                  </blockquote>
                                  *** Options: <a
                                    moz-do-not-send="true"
                                    href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"><a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a></a><br>
                                  *** Archive: <a
                                    moz-do-not-send="true"
                                    href="http://www.eprints.org/tech.php/"><a class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a></a><br>
                                  *** EPrints community wiki: <a
                                    moz-do-not-send="true"
                                    class="moz-txt-link-freetext"
                                    href="http://wiki.eprints.org/"><a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></a><br>
                                  *** EPrints developers Forum: <a
                                    moz-do-not-send="true"
                                    class="moz-txt-link-freetext"
                                    href="http://forum.eprints.org/"><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br>
                                </blockquote>
                                *** Options: <a moz-do-not-send="true"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
                                *** Archive: <a moz-do-not-send="true"
href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
                                *** EPrints community wiki: <a
                                  moz-do-not-send="true"
                                  class="moz-txt-link-freetext"
                                  href="http://wiki.eprints.org/"><a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></a><br>
                                *** EPrints developers Forum: <a
                                  moz-do-not-send="true"
                                  class="moz-txt-link-freetext"
                                  href="http://forum.eprints.org/"><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br>
                              </blockquote>
                              *** Options: <a moz-do-not-send="true"
                                href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
                              *** Archive: <a moz-do-not-send="true"
                                href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
                              *** EPrints community wiki: <a
                                moz-do-not-send="true"
                                class="moz-txt-link-freetext"
                                href="http://wiki.eprints.org/"><a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></a><br>
                              *** EPrints developers Forum: <a
                                moz-do-not-send="true"
                                class="moz-txt-link-freetext"
                                href="http://forum.eprints.org/"><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br>
                            </blockquote>
                            <br>
                            *** Options: <a moz-do-not-send="true"
                              href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
                            *** Archive: <a moz-do-not-send="true"
                              href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
                            *** EPrints community wiki: <a
                              moz-do-not-send="true"
                              class="moz-txt-link-freetext"
                              href="http://wiki.eprints.org/"><a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></a><br>
                            *** EPrints developers Forum: <a
                              moz-do-not-send="true"
                              class="moz-txt-link-freetext"
                              href="http://forum.eprints.org/"><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br>
                          </blockquote>
                          <br>
                          <br>
                          *** Options: <a moz-do-not-send="true"
                            href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
                          <br>
                          *** Archive:<br>
                          <a moz-do-not-send="true"
                            href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
                          <br>
                          *** EPrints community wiki:<br>
                          <a moz-do-not-send="true"
                            class="moz-txt-link-freetext"
                            href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>
                          <br>
                          *** EPrints developers Forum:<br>
                          <a moz-do-not-send="true"
                            class="moz-txt-link-freetext"
                            href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
                        </blockquote>
                        *** Options: <a moz-do-not-send="true"
                          href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
                        *** Archive: <a moz-do-not-send="true"
                          href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
                        *** EPrints community wiki: <a
                          moz-do-not-send="true"
                          class="moz-txt-link-freetext"
                          href="http://wiki.eprints.org/"><a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></a><br>
                        *** EPrints developers Forum: <a
                          moz-do-not-send="true"
                          class="moz-txt-link-freetext"
                          href="http://forum.eprints.org/"><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br>
                      </blockquote>
                      <br>
                      <br>
                      *** Options: <a moz-do-not-send="true"
                        href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
                      <br>
                      *** Archive:<br>
                      <a moz-do-not-send="true"
                        href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
                      <br>
                      *** EPrints community wiki:<br>
                      <a moz-do-not-send="true"
                        class="moz-txt-link-freetext"
                        href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>
                      <br>
                      *** EPrints developers Forum:<br>
                      <a moz-do-not-send="true"
                        class="moz-txt-link-freetext"
                        href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
                    </blockquote>
                    *** Options: <a moz-do-not-send="true"
                      href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
                    *** Archive: <a moz-do-not-send="true"
                      href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
                    *** EPrints community wiki: <a
                      moz-do-not-send="true"
                      href="http://wiki.eprints.org/"><a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a></a><br>
                    *** EPrints developers Forum: <a
                      moz-do-not-send="true"
                      class="moz-txt-link-freetext"
                      href="http://forum.eprints.org/"><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br>
                  </blockquote>
                  <br>
                  <br>
                  *** Options: <a moz-do-not-send="true"
                    href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
                  <br>
                  *** Archive:<br>
                  <a moz-do-not-send="true"
                    href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
                  <br>
                  *** EPrints community wiki:<br>
                  <a moz-do-not-send="true"
                    class="moz-txt-link-freetext"
                    href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>
                  <br>
                  *** EPrints developers Forum:<br>
                  <a moz-do-not-send="true"
                    class="moz-txt-link-freetext"
                    href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
                </blockquote>
                *** Options: <a moz-do-not-send="true"
                  href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
                *** Archive: <a moz-do-not-send="true"
                  href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
                *** EPrints community wiki: <a moz-do-not-send="true"
                  href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>
                *** EPrints developers Forum: <a moz-do-not-send="true"
                  href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
              </blockquote>
              <br>
              *** Options: <a moz-do-not-send="true"
                href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
              *** Archive: <a moz-do-not-send="true"
                href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
              *** EPrints community wiki: <a moz-do-not-send="true"
                href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>
              *** EPrints developers Forum: <a moz-do-not-send="true"
                href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
            </blockquote>
            <br>
            <br>
            *** Options: <a moz-do-not-send="true"
              href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>
            *** Archive: <a moz-do-not-send="true"
              href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>
            *** EPrints community wiki: <a moz-do-not-send="true"
              href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>
            *** EPrints developers Forum: <a moz-do-not-send="true"
              href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
          </blockquote>
        </div>
        <br>
        <br>
        <fieldset class="mimeAttachmentHeader"></fieldset>
        <br>
        <pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
      </blockquote>
      <br>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">*** Options: <a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>