<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">"Empty set" for all queries.<br>
      <br>
      <br>
      <br>
      Le 06/10/2015 11:14, Adam Field a écrit :<br>
    </div>
    <blockquote
cite="mid:EMEW3|c80ea052271b11c4b4cf460c3af96d59r95AEf14eprints-tech-bounces|ecs.soton.ac.uk|F36C7126-A874-409A-BCBD-2A569EBE5B67@ecs.soton.ac.uk"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      Please run the queries again as the eprints user.
      <div><br>
        <div>
          <div style="color: rgb(0, 0, 0); letter-spacing: normal;
            orphans: auto; text-align: start; text-indent: 0px;
            text-transform: none; white-space: normal; widows: auto;
            word-spacing: 0px; -webkit-text-stroke-width: 0px;
            word-wrap: break-word; -webkit-nbsp-mode: space;
            -webkit-line-break: after-white-space;">
            <div style="color: rgb(0, 0, 0); letter-spacing: normal;
              orphans: auto; text-align: start; text-indent: 0px;
              text-transform: none; white-space: normal; widows: auto;
              word-spacing: 0px; -webkit-text-stroke-width: 0px;
              word-wrap: break-word; -webkit-nbsp-mode: space;
              -webkit-line-break: after-white-space;">
              <div>--<br>
                Adam Field<br>
                Business Relationship Manager and Community Lead<br>
                EPrints Services</div>
              <div><br>
              </div>
            </div>
          </div>
          <br class="Apple-interchange-newline">
        </div>
        <br>
        <div style="">
          <div>On 6 Oct 2015, at 10:12, 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">I used this query as root.
                EPrints use "eprints" user.<br>
                <br>
                <br>
                <br>
                Le 06/10/2015 10:42, Adam Field a écrit :<br>
              </div>
              <blockquote
cite="mid:EMEW3|0686edc5bbf838c2b4bf36bd72292967r959hF14eprints-tech-bounces|ecs.soton.ac.uk|4B9BB6AF-5CC0-4BF9-87F9-9A79C587D8ED@ecs.soton.ac.uk"
                type="cite">
                <meta http-equiv="Content-Type" content="text/html;
                  charset=windows-1252">
                <div>What user are you logged into mysql as when you run
                  this?  What user does EPrints use (check your
                  archives/[archiveid]/cfg/cfg.d/database.pl files).</div>
                <div><br>
                </div>
                <div>
                  <div style="letter-spacing: normal; orphans: auto;
                    text-align: start; text-indent: 0px; text-transform:
                    none; white-space: normal; widows: auto;
                    word-spacing: 0px; -webkit-text-stroke-width: 0px;
                    word-wrap: break-word; -webkit-nbsp-mode: space;
                    -webkit-line-break: after-white-space;">
                    <div style="letter-spacing: normal; orphans: auto;
                      text-align: start; text-indent: 0px;
                      text-transform: none; white-space: normal; widows:
                      auto; word-spacing: 0px;
                      -webkit-text-stroke-width: 0px; word-wrap:
                      break-word; -webkit-nbsp-mode: space;
                      -webkit-line-break: after-white-space;">
                      <div>--<br>
                        Adam Field<br>
                        Business Relationship Manager and Community Lead<br>
                        EPrints Services</div>
                      <div><br>
                      </div>
                    </div>
                  </div>
                  <br class="Apple-interchange-newline">
                </div>
                <br>
                <div>
                  <div>On 6 Oct 2015, at 09:17, Jérémy RAINGEARD &lt;<a
                      moz-do-not-send="true"
                      class="moz-txt-link-abbreviated"
                      href="mailto:jeremy.raingeard@univ-tlse3.fr"><a class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a></a>&gt;

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



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



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



                                = 'waiting'<br>
                                GROUP BY `event_queue`.`eventqueueid`,
                                `event_queue__ordervalues_fr`.`priority`,
`event_queue__ordervalues_fr`.`start_time`<br>
                                ORDER BY
                                `event_queue__ordervalues_fr`.`priority`
                                DESC,
                                `event_queue__ordervalues_fr`.`start_time`
                                DESC<br>
                                LIMIT 10<br>
                                <br>
                                --<br>
                                Adam Field<br>
                                Business Relationship Manager and
                                Community Lead<br>
                                EPrints Services<br>
                                +44 (0)23 8059 8814<br>
                                <br>
                                <br>
                                <br>
                                <br>
                                <br>
                                On 25 Sep 2015, at 08:25, Jérémy
                                RAINGEARD wrote:<br>
                                <br>
                                <blockquote type="cite">Hi,<br>
                                  <br>
                                  I have a "Empty set (0.00 sec)" answer
                                  with your query.<br>
                                  <br>
                                  Jeremy<br>
                                  <br>
                                  <br>
                                  <br>
                                  Le 23/09/2015 17:00, Adam Field a
                                  écrit :<br>
                                  <blockquote type="cite">Hmmm...
                                     Sorry, I'm stabbing in the dark
                                    here, trying to get more clues.
                                     What happens if you run the
                                    following query in mysql (in your
                                    repository's database):<br>
                                    <br>
                                    SELECT `event_queue`.`eventqueueid`
                                    FROM `event_queue`<br>
                                    <span class="Apple-tab-span" style="white-space:pre">        </span>LEFT



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



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



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



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



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



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



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



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



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



                                              wrote:<br>
                                              <br>
                                              Hi Adam,<br>
                                              <br>
                                              I tried your solution and
                                              it did nothing : not
                                              sorted out well and it<br>
                                              didn't appear in my
                                              eprint__ordervalues_fr
                                              table - I don't know if
                                              it's<br>
                                              useful or not. But I
                                              checked my logs after some
                                              tries and this is what I<br>
                                              found in it :<br>
                                              <br>
                                              DBD::mysql::st execute
                                              failed: Can't open file:<br>
                                              './thesesups/event_queue.frm'

                                              (errno: 24) at<br>
                                              /opt/eprints3/perl_lib/EPrints/Database.pm


                                              line 3372, &lt;DATA&gt;
                                              line 151.<br>
                                              SQL ERROR (execute):
                                              SELECT
                                              `event_queue`.`eventqueueid`
                                              FROM<br>
                                              `event_queue` LEFT JOIN
                                              `event_queue__ordervalues_fr`
                                              ON<br>
                                              `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`



                                              WHERE<br>
                                              `event_queue`.`status` =
                                              'waiting' AND ((<br>
                                              `event_queue`.`start_time_year`
                                              &lt; 2015 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`

                                              &lt; 9 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              &lt; 17 ) OR (
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              = 17 )) GROUP BY
                                              `event_queue`.`eventqueueid`,<br>
`event_queue__ordervalues_fr`.`priority`,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              ORDER BY<br>
                                              `event_queue__ordervalues_fr`.`priority`


                                              DESC,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              DESC<br>
                                              SQL ERROR (execute): Can't
                                              open file:
                                              './thesesups/event_queue.frm'<br>
                                              (errno: 24)<br>
                                              DBD::mysql::st fetch
                                              failed: fetch() without
                                              execute() at<br>
                                              /opt/eprints3/perl_lib/EPrints/Search/Condition.pm



                                              line 565, &lt;DATA&gt;
                                              line<br>
                                              151.<br>
                                              DBD::mysql::st execute
                                              failed: Can't open file:<br>
                                              './thesesups/event_queue.frm'

                                              (errno: 24) at<br>
                                              /opt/eprints3/perl_lib/EPrints/Database.pm


                                              line 3372, &lt;DATA&gt;
                                              line 151.<br>
                                              SQL ERROR (execute):
                                              SELECT
                                              `event_queue`.`eventqueueid`
                                              FROM<br>
                                              `event_queue` LEFT JOIN
                                              `event_queue__ordervalues_fr`
                                              ON<br>
                                              `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`



                                              WHERE<br>
                                              `event_queue`.`status` =
                                              'waiting' AND ((<br>
                                              `event_queue`.`start_time_year`
                                              &lt; 2015 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`

                                              &lt; 9 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              &lt; 17 ) OR (
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              = 17 )) GROUP BY
                                              `event_queue`.`eventqueueid`,<br>
`event_queue__ordervalues_fr`.`priority`,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              ORDER BY<br>
                                              `event_queue__ordervalues_fr`.`priority`


                                              DESC,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              DESC<br>
                                              SQL ERROR (execute): Can't
                                              open file:
                                              './thesesups/event_queue.frm'<br>
                                              (errno: 24)<br>
                                              DBD::mysql::st fetch
                                              failed: fetch() without
                                              execute() at<br>
                                              /opt/eprints3/perl_lib/EPrints/Search/Condition.pm



                                              line 565, &lt;DATA&gt;
                                              line<br>
                                              151.<br>
                                              DBD::mysql::st execute
                                              failed: Can't open file:<br>
                                              './thesesups/event_queue.frm'

                                              (errno: 24) at<br>
                                              /opt/eprints3/perl_lib/EPrints/Database.pm


                                              line 3372, &lt;DATA&gt;
                                              line 151.<br>
                                              SQL ERROR (execute):
                                              SELECT
                                              `event_queue`.`eventqueueid`
                                              FROM<br>
                                              `event_queue` LEFT JOIN
                                              `event_queue__ordervalues_fr`
                                              ON<br>
                                              `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`



                                              WHERE<br>
                                              `event_queue`.`status` =
                                              'waiting' AND ((<br>
                                              `event_queue`.`start_time_year`
                                              &lt; 2015 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`

                                              &lt; 9 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              &lt; 17 ) OR (
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              = 17 )) GROUP BY
                                              `event_queue`.`eventqueueid`,<br>
`event_queue__ordervalues_fr`.`priority`,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              ORDER BY<br>
                                              `event_queue__ordervalues_fr`.`priority`


                                              DESC,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              DESC<br>
                                              SQL ERROR (execute): Can't
                                              open file:
                                              './thesesups/event_queue.frm'<br>
                                              (errno: 24)<br>
                                              DBD::mysql::st fetch
                                              failed: fetch() without
                                              execute() at<br>
                                              /opt/eprints3/perl_lib/EPrints/Search/Condition.pm



                                              line 565, &lt;DATA&gt;
                                              line<br>
                                              151.<br>
                                              DBD::mysql::st execute
                                              failed: Can't open file:<br>
                                              './thesesups/event_queue.frm'

                                              (errno: 24) at<br>
                                              /opt/eprints3/perl_lib/EPrints/Database.pm


                                              line 3372, &lt;DATA&gt;
                                              line 151.<br>
                                              SQL ERROR (execute):
                                              SELECT
                                              `event_queue`.`eventqueueid`
                                              FROM<br>
                                              `event_queue` LEFT JOIN
                                              `event_queue__ordervalues_fr`
                                              ON<br>
                                              `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`



                                              WHERE<br>
                                              `event_queue`.`status` =
                                              'waiting' AND ((<br>
                                              `event_queue`.`start_time_year`
                                              &lt; 2015 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`

                                              &lt; 9 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              &lt; 17 ) OR (
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              = 17 )) GROUP BY
                                              `event_queue`.`eventqueueid`,<br>
`event_queue__ordervalues_fr`.`priority`,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              ORDER BY<br>
                                              `event_queue__ordervalues_fr`.`priority`


                                              DESC,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              DESC<br>
                                              SQL ERROR (execute): Can't
                                              open file:
                                              './thesesups/event_queue.frm'<br>
                                              (errno: 24)<br>
                                              DBD::mysql::st fetch
                                              failed: fetch() without
                                              execute() at<br>
                                              /opt/eprints3/perl_lib/EPrints/Search/Condition.pm



                                              line 565, &lt;DATA&gt;
                                              line<br>
                                              151.<br>
                                              DBD::mysql::st execute
                                              failed: Can't open file:<br>
                                              './thesesups/event_queue.frm'

                                              (errno: 24) at<br>
                                              /opt/eprints3/perl_lib/EPrints/Database.pm


                                              line 3372, &lt;DATA&gt;
                                              line 151.<br>
                                              SQL ERROR (execute):
                                              SELECT
                                              `event_queue`.`eventqueueid`
                                              FROM<br>
                                              `event_queue` LEFT JOIN
                                              `event_queue__ordervalues_fr`
                                              ON<br>
                                              `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`



                                              WHERE<br>
                                              `event_queue`.`status` =
                                              'waiting' AND ((<br>
                                              `event_queue`.`start_time_year`
                                              &lt; 2015 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`

                                              &lt; 9 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              &lt; 17 ) OR (
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              = 17 )) GROUP BY
                                              `event_queue`.`eventqueueid`,<br>
`event_queue__ordervalues_fr`.`priority`,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              ORDER BY<br>
                                              `event_queue__ordervalues_fr`.`priority`


                                              DESC,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              DESC<br>
                                              SQL ERROR (execute): Can't
                                              open file:
                                              './thesesups/event_queue.frm'<br>
                                              (errno: 24)<br>
                                              DBD::mysql::st fetch
                                              failed: fetch() without
                                              execute() at<br>
                                              /opt/eprints3/perl_lib/EPrints/Search/Condition.pm



                                              line 565, &lt;DATA&gt;
                                              line<br>
                                              151.<br>
                                              DBD::mysql::st execute
                                              failed: Can't open file:<br>
                                              './thesesups/event_queue.frm'

                                              (errno: 24) at<br>
                                              /opt/eprints3/perl_lib/EPrints/Database.pm


                                              line 3372, &lt;DATA&gt;
                                              line 151.<br>
                                              SQL ERROR (execute):
                                              SELECT
                                              `event_queue`.`eventqueueid`
                                              FROM<br>
                                              `event_queue` LEFT JOIN
                                              `event_queue__ordervalues_fr`
                                              ON<br>
                                              `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`



                                              WHERE<br>
                                              `event_queue`.`status` =
                                              'waiting' AND ((<br>
                                              `event_queue`.`start_time_year`
                                              &lt; 2015 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`

                                              &lt; 9 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              &lt; 17 ) OR (
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              = 17 )) GROUP BY
                                              `event_queue`.`eventqueueid`,<br>
`event_queue__ordervalues_fr`.`priority`,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              ORDER BY<br>
                                              `event_queue__ordervalues_fr`.`priority`


                                              DESC,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              DESC<br>
                                              SQL ERROR (execute): Can't
                                              open file:
                                              './thesesups/event_queue.frm'<br>
                                              (errno: 24)<br>
                                              DBD::mysql::st fetch
                                              failed: fetch() without
                                              execute() at<br>
                                              /opt/eprints3/perl_lib/EPrints/Search/Condition.pm



                                              line 565, &lt;DATA&gt;
                                              line<br>
                                              151.<br>
                                              DBD::mysql::st execute
                                              failed: Can't open file:<br>
                                              './thesesups/event_queue.frm'

                                              (errno: 24) at<br>
                                              /opt/eprints3/perl_lib/EPrints/Database.pm


                                              line 3372, &lt;DATA&gt;
                                              line 151.<br>
                                              SQL ERROR (execute):
                                              SELECT
                                              `event_queue`.`eventqueueid`
                                              FROM<br>
                                              `event_queue` LEFT JOIN
                                              `event_queue__ordervalues_fr`
                                              ON<br>
                                              `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`



                                              WHERE<br>
                                              `event_queue`.`status` =
                                              'waiting' AND ((<br>
                                              `event_queue`.`start_time_year`
                                              &lt; 2015 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`

                                              &lt; 9 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              &lt; 17 ) OR (
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              = 17 )) GROUP BY
                                              `event_queue`.`eventqueueid`,<br>
`event_queue__ordervalues_fr`.`priority`,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              ORDER BY<br>
                                              `event_queue__ordervalues_fr`.`priority`


                                              DESC,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              DESC<br>
                                              SQL ERROR (execute): Can't
                                              open file:
                                              './thesesups/event_queue.frm'<br>
                                              (errno: 24)<br>
                                              DBD::mysql::st fetch
                                              failed: fetch() without
                                              execute() at<br>
                                              /opt/eprints3/perl_lib/EPrints/Search/Condition.pm



                                              line 565, &lt;DATA&gt;
                                              line<br>
                                              151.<br>
                                              DBD::mysql::st execute
                                              failed: Can't open file:<br>
                                              './thesesups/event_queue.frm'

                                              (errno: 24) at<br>
                                              /opt/eprints3/perl_lib/EPrints/Database.pm


                                              line 3372, &lt;DATA&gt;
                                              line 151.<br>
                                              SQL ERROR (execute):
                                              SELECT
                                              `event_queue`.`eventqueueid`
                                              FROM<br>
                                              `event_queue` LEFT JOIN
                                              `event_queue__ordervalues_fr`
                                              ON<br>
                                              `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`



                                              WHERE<br>
                                              `event_queue`.`status` =
                                              'waiting' AND ((<br>
                                              `event_queue`.`start_time_year`
                                              &lt; 2015 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`

                                              &lt; 9 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              &lt; 17 ) OR (
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              = 17 )) GROUP BY
                                              `event_queue`.`eventqueueid`,<br>
`event_queue__ordervalues_fr`.`priority`,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              ORDER BY<br>
                                              `event_queue__ordervalues_fr`.`priority`


                                              DESC,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              DESC<br>
                                              SQL ERROR (execute): Can't
                                              open file:
                                              './thesesups/event_queue.frm'<br>
                                              (errno: 24)<br>
                                              DBD::mysql::st fetch
                                              failed: fetch() without
                                              execute() at<br>
                                              /opt/eprints3/perl_lib/EPrints/Search/Condition.pm



                                              line 565, &lt;DATA&gt;
                                              line<br>
                                              151.<br>
                                              DBD::mysql::st execute
                                              failed: Can't open file:<br>
                                              './thesesups/event_queue.frm'

                                              (errno: 24) at<br>
                                              /opt/eprints3/perl_lib/EPrints/Database.pm


                                              line 3372, &lt;DATA&gt;
                                              line 151.<br>
                                              SQL ERROR (execute):
                                              SELECT
                                              `event_queue`.`eventqueueid`
                                              FROM<br>
                                              `event_queue` LEFT JOIN
                                              `event_queue__ordervalues_fr`
                                              ON<br>
                                              `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`



                                              WHERE<br>
                                              `event_queue`.`status` =
                                              'waiting' AND ((<br>
                                              `event_queue`.`start_time_year`
                                              &lt; 2015 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`

                                              &lt; 9 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              &lt; 17 ) OR (
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              = 17 )) GROUP BY
                                              `event_queue`.`eventqueueid`,<br>
`event_queue__ordervalues_fr`.`priority`,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              ORDER BY<br>
                                              `event_queue__ordervalues_fr`.`priority`


                                              DESC,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              DESC<br>
                                              SQL ERROR (execute): Can't
                                              open file:
                                              './thesesups/event_queue.frm'<br>
                                              (errno: 24)<br>
                                              DBD::mysql::st fetch
                                              failed: fetch() without
                                              execute() at<br>
                                              /opt/eprints3/perl_lib/EPrints/Search/Condition.pm



                                              line 565, &lt;DATA&gt;
                                              line<br>
                                              151.<br>
                                              DBD::mysql::st execute
                                              failed: Can't open file:<br>
                                              './thesesups/event_queue.frm'

                                              (errno: 24) at<br>
                                              /opt/eprints3/perl_lib/EPrints/Database.pm


                                              line 3372, &lt;DATA&gt;
                                              line 151.<br>
                                              SQL ERROR (execute):
                                              SELECT
                                              `event_queue`.`eventqueueid`
                                              FROM<br>
                                              `event_queue` LEFT JOIN
                                              `event_queue__ordervalues_fr`
                                              ON<br>
                                              `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`



                                              WHERE<br>
                                              `event_queue`.`status` =
                                              'waiting' AND ((<br>
                                              `event_queue`.`start_time_year`
                                              &lt; 2015 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`

                                              &lt; 9 ) OR (<br>
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              &lt; 17 ) OR (
                                              `event_queue`.`start_time_year`
                                              = 2015 AND<br>
                                              `event_queue`.`start_time_month`
                                              = 9 AND
                                              `event_queue`.`start_time_day`<br>
                                              = 17 )) GROUP BY
                                              `event_queue`.`eventqueueid`,<br>
`event_queue__ordervalues_fr`.`priority`,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              ORDER BY<br>
                                              `event_queue__ordervalues_fr`.`priority`


                                              DESC,<br>
                                              `event_queue__ordervalues_fr`.`start_time`


                                              DESC<br>
                                              SQL ERROR (execute): Can't
                                              open file:
                                              './thesesups/event_queue.frm'<br>
                                              (errno: 24)<br>
                                              DBD::mysql::st fetch
                                              failed: fetch() without
                                              execute() at<br>
                                              /opt/eprints3/perl_lib/EPrints/Search/Condition.pm



                                              line 565, &lt;DATA&gt;
                                              line<br>
                                              151.<br>
                                              [Fri Sep 18 14:28:09 2015]
                                              ** Indexer process
                                              stopping<br>
                                              [Fri Sep 18 14:28:17 2015]
                                              ** Indexer process started<br>
                                              <br>
                                              I don't find this
                                              event_queue.frm - because
                                              it's a temporary file for<br>
                                              MySQL ? - so I can't even
                                              see if it's a permission
                                              problem. Any idea<br>
                                              about this ?<br>
                                              <br>
                                              Thank you.<br>
                                              <br>
                                              Jeremy<br>
                                              <br>
                                              <br>
                                              Le 17/09/2015 16:09, Field
                                              A.N. a écrit :<br>
                                              <blockquote type="cite">Ah,
                                                if they aren't in the
                                                table, then they haven't
                                                been indexed.  Choose an
                                                item that isn't ordering
                                                correctly, find its ID,
                                                then run:<br>
                                                <br>
                                                epadmin reindex
                                                *repository_id* eprint
                                                *eprint_id*<br>
                                                <br>
                                                ...and see if it sorts
                                                itself out.  Note that
                                                this queues it on the
                                                indexer rather than
                                                doing the work, so check
                                                whether the indexer is
                                                running (the 'status'
                                                button on the 'system
                                                toos' tab of the 'Admin'
                                                screen [though if your
                                                interface is in French,
                                                this might vary]).  On
                                                the status page, you
                                                should see the number of
                                                index tasks decreasing.<br>
                                                <br>
                                                If running that command
                                                sorts out that item,
                                                then run it again, but
                                                without the ID at the
                                                end.  This will index
                                                all items, and might
                                                take a while, but it
                                                shouldn't be too long,
                                                as you only have 2572
                                                eprints.<br>
                                                <br>
                                                Let me know how it goes.<br>
                                                <br>
                                                --<br>
                                                Adam Field<br>
                                                Business Relationship
                                                Manager and Community
                                                Lead<br>
                                                EPrints Services<br>
                                                +44 (0)23 8059 8814<br>
                                                <br>
                                                <br>
                                                <br>
                                                <br>
                                                <br>
                                                On 17 Sep 2015, at
                                                14:36, Jérémy RAINGEARD
                                                wrote:<br>
                                                <br>
                                                <blockquote type="cite">Hi
                                                  Adam and thank you.<br>
                                                  <br>
                                                  You can find our
                                                  repository at this
                                                  address - some thesis
                                                  are public,<br>
                                                  some not : <a
                                                    moz-do-not-send="true"
class="moz-txt-link-freetext" href="http://thesesups.ups-tlse.fr/"><a class="moz-txt-link-freetext" href="http://thesesups.ups-tlse.fr/">http://thesesups.ups-tlse.fr/</a></a><br>
                                                  Just choose a subject
                                                  for example and let
                                                  the last option as it
                                                  is<br>
                                                  ("trier les
                                                  résultats").<br>
                                                  <br>
                                                  Now, this is the
                                                  advanced search aprt
                                                  of my search.pl file -
                                                  hope it's<br>
                                                  what you need :<br>
                                                  <br>
                                                  $c-&gt;{search}-&gt;{advanced}
                                                  =<br>
                                                  {<br>
                                                      search_fields
                                                  =&gt; [<br>
                                                          { meta_fields
                                                  =&gt; [
                                                  $EPrints::Utils::FULLTEXT
                                                  ] },<br>
                                                          { meta_fields
                                                  =&gt; [ "title" ] },<br>
                                                          { meta_fields
                                                  =&gt; [
                                                  "creators_name" ] },<br>
                                                          { meta_fields
                                                  =&gt; [
                                                  "dircreators_name" ]
                                                  },<br>
                                                          { meta_fields
                                                  =&gt; [ "abstract" ]
                                                  },<br>
                                                          { meta_fields
                                                  =&gt; [ "keywords" ]
                                                  },<br>
                                                          { meta_fields
                                                  =&gt; [ "subjects" ]
                                                  },<br>
                                                          #{ meta_fields
                                                  =&gt; [ "type" ] },<br>
                                                          { meta_fields
                                                  =&gt; [ "divisions" ]
                                                  },<br>
                                                          { meta_fields
                                                  =&gt; [ "department" ]
                                                  },<br>
                                                  <br>
                                                          #{ meta_fields
                                                  =&gt; [ "ispublished"
                                                  ] },<br>
                                                          #{ meta_fields
                                                  =&gt; [ "refereed" ]
                                                  },<br>
                                                          #{ meta_fields
                                                  =&gt; [ "publication"
                                                  ] },<br>
                                                          { meta_fields
                                                  =&gt; [ "date" ] },<br>
                                                      ],<br>
                                                      preamble_phrase
                                                  =&gt;
                                                  "cgi/advsearch:preamble",<br>
                                                      title_phrase =&gt;
"cgi/advsearch:adv_search",<br>
                                                      citation =&gt;
                                                  "result",<br>
                                                      page_size =&gt;
                                                  20,<br>
                                                      order_methods
                                                  =&gt; {<br>
                                                  <br>
                                                          "byyear"
                                                       =&gt;
                                                  "-date/creators_name/title",<br>
                                                  <br>
                                                          "byyearoldest"
                                                      =&gt;
                                                  "date/creators_name/title",<br>
                                                          "byname"
                                                        =&gt;
                                                  "creators_name/-date/title",<br>
                                                          "bytitle"
                                                       =&gt;
                                                  "title/creators_name/-date"<br>
                                                      },<br>
                                                      default_order
                                                  =&gt; "byyear",<br>
                                                  };<br>
                                                  <br>
                                                  If necessary, I can
                                                  add more content of
                                                  this file or give you
                                                  more details.<br>
                                                  <br>
                                                  Thanks,<br>
                                                  <br>
                                                  Jérémy<br>
                                                  <br>
                                                  <br>
                                                  <br>
                                                  Le 17/09/2015 14:21,
                                                  Field A.N. a écrit :<br>
                                                  <blockquote
                                                    type="cite">Hi
                                                    Jérémy<br>
                                                    <br>
                                                    <span class="Apple-tab-span" style="white-space:pre">        </span>Firstly,



                                                    welcome to the
                                                    community.  I so
                                                    happy that you've
                                                    been able to work
                                                    through most of your
                                                    problems using our
                                                    documentation, and
                                                    in only two weeks!<br>
                                                    <br>
                                                    <span class="Apple-tab-span" style="white-space:pre">        </span>Is



                                                    your repository
                                                    publicly visible?
                                                     Can you give me its
                                                    address so that I
                                                    can have a play?
                                                     Also, please post
                                                    your advanced search
                                                    configuration.<br>
                                                    <br>
                                                    <span class="Apple-tab-span" style="white-space:pre">        </span>Best



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