<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div>OK, I'm out of ideas, I'm afraid. Anyone else have any thoughts?</div><br><div>
<div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div style="color: rgb(0, 0, 0); letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div>--<br>Adam Field<br>Business Relationship Manager and Community Lead<br>EPrints Services</div><div><br></div></div></div><br class="Apple-interchange-newline">
</div>
<br><div><div>On 6 Oct 2015, at 10:26, Jérémy RAINGEARD <<a href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a>> 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">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="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 style="">
<div>On 6 Oct 2015, at 10:18, Jérémy RAINGEARD <<a moz-do-not-send="true" href="mailto:jeremy.raingeard@univ-tlse3.fr"></a><a class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a>>
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 <<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr"></a><a class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a>>
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 <<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a>>
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`
< 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`
< 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`
< 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 <<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr"></a><a class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a>>
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 <<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr"></a><a class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a>>
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 <<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr"></a><a class="moz-txt-link-abbreviated" href="mailto:jeremy.raingeard@univ-tlse3.fr">jeremy.raingeard@univ-tlse3.fr</a>>
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, <DATA>
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`
< 2015 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
< 9 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
= 9 AND
`event_queue`.`start_time_day`<br>
< 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, <DATA>
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, <DATA>
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`
< 2015 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
< 9 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
= 9 AND
`event_queue`.`start_time_day`<br>
< 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, <DATA>
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, <DATA>
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`
< 2015 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
< 9 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
= 9 AND
`event_queue`.`start_time_day`<br>
< 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, <DATA>
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, <DATA>
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`
< 2015 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
< 9 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
= 9 AND
`event_queue`.`start_time_day`<br>
< 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, <DATA>
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, <DATA>
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`
< 2015 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
< 9 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
= 9 AND
`event_queue`.`start_time_day`<br>
< 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, <DATA>
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, <DATA>
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`
< 2015 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
< 9 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
= 9 AND
`event_queue`.`start_time_day`<br>
< 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, <DATA>
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, <DATA>
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`
< 2015 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
< 9 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
= 9 AND
`event_queue`.`start_time_day`<br>
< 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, <DATA>
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, <DATA>
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`
< 2015 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
< 9 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
= 9 AND
`event_queue`.`start_time_day`<br>
< 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, <DATA>
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, <DATA>
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`
< 2015 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
< 9 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
= 9 AND
`event_queue`.`start_time_day`<br>
< 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, <DATA>
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, <DATA>
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`
< 2015 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
< 9 ) OR (<br>
`event_queue`.`start_time_year`
= 2015 AND<br>
`event_queue`.`start_time_month`
= 9 AND
`event_queue`.`start_time_day`<br>
< 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, <DATA>
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><a class="moz-txt-link-freetext" href="http://thesesups.ups-tlse.fr/">http://thesesups.ups-tlse.fr/</a><br>
Just choose a
subject for example
and let the last
option as it is<br>
("trier les
résultats").<br>
<br>
Now, this is the
advanced search aprt
of my search.pl file
- hope it's<br>
what you need :<br>
<br>
$c->{search}->{advanced}
=<br>
{<br>
search_fields
=> [<br>
{
meta_fields => [
$EPrints::Utils::FULLTEXT
] },<br>
{
meta_fields => [
"title" ] },<br>
{
meta_fields => [
"creators_name" ] },<br>
{
meta_fields => [
"dircreators_name" ]
},<br>
{
meta_fields => [
"abstract" ] },<br>
{
meta_fields => [
"keywords" ] },<br>
{
meta_fields => [
"subjects" ] },<br>
#{
meta_fields => [
"type" ] },<br>
{
meta_fields => [
"divisions" ] },<br>
{
meta_fields => [
"department" ] },<br>
<br>
#{
meta_fields => [
"ispublished" ] },<br>
#{
meta_fields => [
"refereed" ] },<br>
#{
meta_fields => [
"publication" ] },<br>
{
meta_fields => [
"date" ] },<br>
],<br>
preamble_phrase
=>
"cgi/advsearch:preamble",<br>
title_phrase
=>
"cgi/advsearch:adv_search",<br>
citation =>
"result",<br>
page_size =>
20,<br>
order_methods
=> {<br>
<br>
"byyear"
=>
"-date/creators_name/title",<br>
<br>
"byyearoldest"
=>
"date/creators_name/title",<br>
"byname"
=>
"creators_name/-date/title",<br>
"bytitle"
=>
"title/creators_name/-date"<br>
},<br>
default_order
=> "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 > author
> 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><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><br>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/"></a><a class="moz-txt-link-freetext" 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><a 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><a 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><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><br>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/"></a><a class="moz-txt-link-freetext" 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><a 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><a 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><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><br>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/"></a><a class="moz-txt-link-freetext" 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><a 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><a 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><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><br>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/"></a><a class="moz-txt-link-freetext" 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><a 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><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</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><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><br>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/"></a><a class="moz-txt-link-freetext" 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><a 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><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
</blockquote>
<br>
<br>
*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"></a><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><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><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><br>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/"></a><a class="moz-txt-link-freetext" 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/">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><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
</blockquote>
<br>
<br>
*** Options: <a moz-do-not-send="true" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"></a><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><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><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><br>
*** Archive: <a moz-do-not-send="true" href="http://www.eprints.org/tech.php/"></a><a class="moz-txt-link-freetext" 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><a 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><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
</blockquote>
<br>
<br>
*** Options: <a moz-do-not-send="true" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"></a><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><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><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><br>
*** Archive: <a moz-do-not-send="true" href="http://www.eprints.org/tech.php/"></a><a class="moz-txt-link-freetext" 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><a 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><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
</blockquote>
<br>
*** Options: <a moz-do-not-send="true" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech"></a><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><br>
*** Archive: <a moz-do-not-send="true" href="http://www.eprints.org/tech.php/"></a><a class="moz-txt-link-freetext" 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><a 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><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
</blockquote>
<br>
<br>
*** Options: <a moz-do-not-send="true" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">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><a 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><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
</blockquote>
</div>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a 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><a 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" href="http://forum.eprints.org/"></a><a class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a><br>
</blockquote>
</div>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a>
*** Archive: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a>
*** EPrints community wiki: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://wiki.eprints.org/">http://wiki.eprints.org/</a>
*** EPrints developers Forum: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://forum.eprints.org/">http://forum.eprints.org/</a>
</pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">*** Options: <a 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>
</div>
*** Options: <a 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 href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>*** EPrints community wiki: <a href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>*** EPrints developers Forum: <a href="http://forum.eprints.org/">http://forum.eprints.org/</a><br></blockquote></div><br></body></html>