<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Hi,<br>
      <br>
      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>
    </div>
    <blockquote
cite="mid:EMEW3|38613dc2953d212cac0558fef5963e96r8MG1814eprints-tech-bounces|ecs.soton.ac.uk|7B77A789-373A-4FF7-849F-30990CAED1B1@ecs.soton.ac.uk"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      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):
      <div><br>
      </div>
      <div>SELECT `event_queue`.`eventqueueid` FROM `event_queue`</div>
      <div><span class="Apple-tab-span" style="white-space:pre">        </span>LEFT
        JOIN `event_queue__ordervalues_fr`</div>
      <div><span class="Apple-tab-span" style="white-space:pre">        </span>ON `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`</div>
      <div>WHERE </div>
      <div><span class="Apple-tab-span" style="white-space:pre">        </span>`event_queue`.`status`
        = 'waiting' </div>
      <div><span class="Apple-tab-span" style="white-space:pre">        </span>AND
        (</div>
      <div><span class="Apple-tab-span" style="white-space:pre">                </span>(`event_queue`.`start_time_year`
        &lt; 2015 )</div>
      <div><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 )</div>
      <div><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 )</div>
      <div><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 )</div>
      <div><span class="Apple-tab-span" style="white-space:pre">        </span>)</div>
      <div>GROUP BY
`event_queue`.`eventqueueid`, `event_queue__ordervalues_fr`.`priority`, `event_queue__ordervalues_fr`.`start_time`</div>
      <div>ORDER BY `event_queue__ordervalues_fr`.`priority`
        DESC, `event_queue__ordervalues_fr`.`start_time` DESC<br>
        <div>
          <div><br>
          </div>
          <div><br>
          </div>
          <div>...and let me know what happens.</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 23 Sep 2015, at 09:47, 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">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>
                </div>
                <blockquote
cite="mid:EMEW3|141e75b57b5b50f274e767f093b344e5r8M9Db14eprints-tech-bounces|ecs.soton.ac.uk|E1DE9430-8DED-4B6A-A884-295B05050248@ecs.soton.ac.uk"
                  type="cite">
                  <meta http-equiv="Content-Type" content="text/html;
                    charset=windows-1252">
                  <div>Well, nothing jumps out at me.</div>
                  <div><br>
                  </div>
                  Can you try running mysqlcheck on the eprints
                  database?
                  <div><br>
                    <div apple-content-edited="true">
                      <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>I am currently not working in the UK.  Due
                          to timezone differences (GMT -9) email
                          responses may take longer.</div>
                      </div>
                    </div>
                    <br>
                    <div>
                      <div>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:</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 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>
                          </div>
                          <blockquote
cite="mid:EMEW3|41fcab88ea46711899fb6ffdd05b5515r8LKvR14eprints-tech-bounces|ecs.soton.ac.uk|A4959991-AC2E-4B6B-BD0D-B04871D5178F@ecs.soton.ac.uk"
                            type="cite">
                            <meta http-equiv="Content-Type"
                              content="text/html; charset=windows-1252">
                            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).
                            <div class=""><br class="">
                            </div>
                            <div class=""><br class="">
                              <div class="">
                                <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;" class="">
                                  <div class="">--</div>
                                  <div class="">Adam Field</div>
                                  <div class="">Business Relationship
                                    Manager and Community Lead<br
                                      class="">
                                    EPrints Services</div>
                                </div>
                              </div>
                              <br class="">
                              <div>
                                <blockquote type="cite" class="">
                                  <div class="">On 18 Sep 2015, at
                                    13:44, Jérémy RAINGEARD &lt;<a
                                      moz-do-not-send="true"
                                      href="mailto:jeremy.raingeard@univ-tlse3.fr"
                                      class=""><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">
                                  <div class="">Hi Adam,<br class="">
                                    <br class="">
                                    I tried your solution and it did
                                    nothing : not sorted out well and it
                                    <br class="">
                                    didn't appear in my
                                    eprint__ordervalues_fr table - I
                                    don't know if it's <br class="">
                                    useful or not. But I checked my logs
                                    after some tries and this is what I
                                    <br class="">
                                    found in it :<br class="">
                                    <br class="">
                                    DBD::mysql::st execute failed: Can't
                                    open file: <br class="">
                                    './thesesups/event_queue.frm'
                                    (errno: 24) at <br class="">
                                    /opt/eprints3/perl_lib/EPrints/Database.pm
                                    line 3372, &lt;DATA&gt; line 151.<br
                                      class="">
                                    SQL ERROR (execute): SELECT
                                    `event_queue`.`eventqueueid` FROM <br
                                      class="">
                                    `event_queue` LEFT JOIN
                                    `event_queue__ordervalues_fr` ON <br
                                      class="">
                                    `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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

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


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