<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">I used this query as root. EPrints use
      "eprints" user.<br>
      <br>
      <br>
      <br>
      Le 06/10/2015 10:42, Adam Field a écrit :<br>
    </div>
    <blockquote
cite="mid:EMEW3|0686edc5bbf838c2b4bf36bd72292967r959hF14eprints-tech-bounces|ecs.soton.ac.uk|4B9BB6AF-5CC0-4BF9-87F9-9A79C587D8ED@ecs.soton.ac.uk"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <div>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).</div>
      <div><br>
      </div>
      <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 6 Oct 2015, at 09:17, Jérémy RAINGEARD &lt;<a
            moz-do-not-send="true"
            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">
          <meta content="text/html; charset=windows-1252"
            http-equiv="Content-Type">
          <div 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="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="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">jeremy.raingeard@univ-tlse3.fr</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">jeremy.raingeard@univ-tlse3.fr</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">jeremy.raingeard@univ-tlse3.fr</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/"><a class="moz-txt-link-freetext" href="http://thesesups.ups-tlse.fr/">http://thesesups.ups-tlse.fr/</a></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/">http://wiki.eprints.org/</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"
                                            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/">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"><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"><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>
                                    <br>
                                    *** 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>
                                  <br>
                                  <br>
                                  *** 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>
                                  <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"
                              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"
                          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"
                        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"
                        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>
                    *** 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"
                      href="http://forum.eprints.org/"><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></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 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>
          </div>
          *** 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 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>