<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">After a "show grants", I have this :
      "GRANT ALL PRIVILEGES ON `thesesups`.* TO 'eprints'@'localhost'"<br>
      <br>
      <br>
      Le 06/10/2015 11:20, Adam Field a écrit :<br>
    </div>
    <blockquote
cite="mid:EMEW3|938e843e3bca973d8ef0f6d33d514f33r95AKQ14eprints-tech-bounces|ecs.soton.ac.uk|127E8E59-45BF-484F-8CA1-2C1086DA0065@ecs.soton.ac.uk"
      type="cite">
      <meta http-equiv="Content-Type" content="text/html;
        charset=windows-1252">
      <div>Can you check the permissions that the eprints user has?</div>
      <br>
      <div>
        <div>
          <div style="color: rgb(0, 0, 0); letter-spacing: normal;
            orphans: auto; text-align: start; text-indent: 0px;
            text-transform: none; white-space: normal; widows: auto;
            word-spacing: 0px; -webkit-text-stroke-width: 0px;
            word-wrap: break-word; -webkit-nbsp-mode: space;
            -webkit-line-break: after-white-space;">
            <div style="color: rgb(0, 0, 0); letter-spacing: normal;
              orphans: auto; text-align: start; text-indent: 0px;
              text-transform: none; white-space: normal; widows: auto;
              word-spacing: 0px; -webkit-text-stroke-width: 0px;
              word-wrap: break-word; -webkit-nbsp-mode: space;
              -webkit-line-break: after-white-space;">
              <div>--<br>
                Adam Field<br>
                Business Relationship Manager and Community Lead<br>
                EPrints Services</div>
              <div><br>
              </div>
            </div>
          </div>
          <br class="Apple-interchange-newline">
        </div>
        <br>
        <div style="">
          <div>On 6 Oct 2015, at 10:18, 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">A precision : I just used the
                same last query with eprints user and I received a
                "Empty set".<br>
                <br>
                <br>
                <br>
                Le 06/10/2015 11:12, Jérémy RAINGEARD a écrit :<br>
              </div>
              <blockquote
cite="mid:EMEW3|265e857aa9b3f87ce8fa1cdc93af169dr95ACs14eprints-tech-bounces|ecs.soton.ac.uk|56139070.1080100@univ-tlse3.fr"
                type="cite">
                <meta content="text/html; charset=windows-1252"
                  http-equiv="Content-Type">
                <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"
                                              class="moz-txt-link-freetext"
href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"><a class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a></a><br>
                                            *** Archive: <a
                                              moz-do-not-send="true"
                                              class="moz-txt-link-freetext"
href="http://www.eprints.org/tech.php/"><a class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a></a><br>
                                            *** EPrints community wiki:
                                            <a moz-do-not-send="true"
                                              class="moz-txt-link-freetext"
href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>
                                            *** EPrints developers
                                            Forum: <a
                                              moz-do-not-send="true"
                                              class="moz-txt-link-freetext"
href="http://forum.eprints.org/"><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a></a><br>
                                          </blockquote>
                                          <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"><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">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>
                <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>