[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] Re: Advanced Search by date
A precision : I just used the same last query with eprints user and I
received a "Empty set".
Le 06/10/2015 11:12, J?r?my RAINGEARD a ?crit :
> I used this query as root. EPrints use "eprints" user.
>
>
>
> Le 06/10/2015 10:42, Adam Field a ?crit :
>> 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).
>>
>> --
>> Adam Field
>> Business Relationship Manager and Community Lead
>> EPrints Services
>>
>>
>>
>> On 6 Oct 2015, at 09:17, J?r?my RAINGEARD
>> <jeremy.raingeard at univ-tlse3.fr> wrote:
>>
>>> Hi,
>>>
>>> Any idea with this previous query ? What should I do here ?
>>>
>>> Thanks,
>>>
>>> Jeremy
>>>
>>>
>>>
>>> Le 28/09/2015 10:44, J?r?my RAINGEARD a ?crit :
>>>> This time, there were 5 rows in set. Another query or should I try
>>>> again your previous solution ?
>>>>
>>>> Jeremy
>>>>
>>>>
>>>>
>>>> Le 28/09/2015 10:36, Adam Field a ?crit :
>>>>> SELECT * FROM event_queue LIMIT 10
>>>>>
>>>>> ?
>>>>>
>>>>> --
>>>>> Adam Field
>>>>> Business Relationship Manager and Community Lead
>>>>> EPrints Services
>>>>>
>>>>>
>>>>>
>>>>> On 28 Sep 2015, at 09:24, J?r?my RAINGEARD
>>>>> <jeremy.raingeard at univ-tlse3.fr> wrote:
>>>>>
>>>>>> Hi.
>>>>>>
>>>>>> "Empty set" again.
>>>>>>
>>>>>> Jeremy
>>>>>>
>>>>>>
>>>>>>
>>>>>> Le 25/09/2015 10:34, Field A.N. a ?crit :
>>>>>>> How about:
>>>>>>>
>>>>>>> SELECT `event_queue`.`eventqueueid` FROM `event_queue`
>>>>>>> LEFT JOIN `event_queue__ordervalues_fr`
>>>>>>> ON
>>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>>> WHERE
>>>>>>> `event_queue`.`status` = 'waiting'
>>>>>>> GROUP BY `event_queue`.`eventqueueid`,
>>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>>> `event_queue__ordervalues_fr`.`start_time`
>>>>>>> ORDER BY `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>>> LIMIT 10
>>>>>>>
>>>>>>> --
>>>>>>> Adam Field
>>>>>>> Business Relationship Manager and Community Lead
>>>>>>> EPrints Services
>>>>>>> +44 (0)23 8059 8814
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On 25 Sep 2015, at 08:25, J?r?my RAINGEARD wrote:
>>>>>>>
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> I have a "Empty set (0.00 sec)" answer with your query.
>>>>>>>>
>>>>>>>> Jeremy
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Le 23/09/2015 17:00, Adam Field a ?crit :
>>>>>>>>> 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):
>>>>>>>>>
>>>>>>>>> SELECT `event_queue`.`eventqueueid` FROM `event_queue`
>>>>>>>>> LEFT JOIN `event_queue__ordervalues_fr`
>>>>>>>>> ON
>>>>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>>>>> WHERE
>>>>>>>>> `event_queue`.`status` = 'waiting'
>>>>>>>>> AND (
>>>>>>>>> (`event_queue`.`start_time_year` < 2015 )
>>>>>>>>> OR (`event_queue`.`start_time_year` = 2015 AND
>>>>>>>>> `event_queue`.`start_time_month` < 9 )
>>>>>>>>> OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>> `event_queue`.`start_time_day` < 17 )
>>>>>>>>> OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>> `event_queue`.`start_time_day` = 17 )
>>>>>>>>> )
>>>>>>>>> GROUP BY `event_queue`.`eventqueueid`,
>>>>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>>>>> `event_queue__ordervalues_fr`.`start_time`
>>>>>>>>> ORDER BY `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> ...and let me know what happens.
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Adam Field
>>>>>>>>> Business Relationship Manager and Community Lead
>>>>>>>>> EPrints Services
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On 23 Sep 2015, at 09:47, J?r?my RAINGEARD
>>>>>>>>> <jeremy.raingeard at univ-tlse3.fr> wrote:
>>>>>>>>>
>>>>>>>>>> Actually, there are a lot of warnings, probably more than 30.
>>>>>>>>>> I won't copy all, it's the same each time :
>>>>>>>>>>
>>>>>>>>>> "warning : X (1 to 3 here) client(s) is using or
>>>>>>>>>> hasn't/haven't closed the table properly. Status : OK"
>>>>>>>>>>
>>>>>>>>>> Jeremy
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Le 23/09/2015 10:11, Adam Field a ?crit :
>>>>>>>>>>> Well, nothing jumps out at me.
>>>>>>>>>>>
>>>>>>>>>>> Can you try running mysqlcheck on the eprints database?
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> Adam Field
>>>>>>>>>>> Business Relationship Manager and Community Lead
>>>>>>>>>>> EPrints Services
>>>>>>>>>>>
>>>>>>>>>>> I am currently not working in the UK. Due to timezone
>>>>>>>>>>> differences (GMT -9) email responses may take longer.
>>>>>>>>>>>
>>>>>>>>>>> On 23 Sep 2015, at 08:33, J?r?my RAINGEARD
>>>>>>>>>>> <jeremy.raingeard at univ-tlse3.fr> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Hi Adam and thanks again.
>>>>>>>>>>>>
>>>>>>>>>>>> First, we're running mysql with "mysql" user and the
>>>>>>>>>>>> permissions of our database "thesesups" are : 700 mysql:mysql
>>>>>>>>>>>>
>>>>>>>>>>>> Finally, here are all our tables :
>>>>>>>>>>>>
>>>>>>>>>>>> +---------------------------------+
>>>>>>>>>>>> | Tables_in_thesesups |
>>>>>>>>>>>> +---------------------------------+
>>>>>>>>>>>> | access |
>>>>>>>>>>>> | access__ordervalues_en |
>>>>>>>>>>>> | access__ordervalues_fr |
>>>>>>>>>>>> | cache615369 |
>>>>>>>>>>>> | cache615370 |
>>>>>>>>>>>> | cache615371 |
>>>>>>>>>>>> | cache615372 |
>>>>>>>>>>>> | cache615373 |
>>>>>>>>>>>> | cache615374 |
>>>>>>>>>>>> | cache615375 |
>>>>>>>>>>>> | cache615376 |
>>>>>>>>>>>> | cache615377 |
>>>>>>>>>>>> | cache615378 |
>>>>>>>>>>>> | cache615379 |
>>>>>>>>>>>> | cache615380 |
>>>>>>>>>>>> | cache615381 |
>>>>>>>>>>>> | cache615382 |
>>>>>>>>>>>> | cache615383 |
>>>>>>>>>>>> | cache615384 |
>>>>>>>>>>>> | cache615385 |
>>>>>>>>>>>> | cache615386 |
>>>>>>>>>>>> | cache615387 |
>>>>>>>>>>>> | cache615388 |
>>>>>>>>>>>> | cache615389 |
>>>>>>>>>>>> | cache615390 |
>>>>>>>>>>>> | cache615391 |
>>>>>>>>>>>> | cache615392 |
>>>>>>>>>>>> | cache615393 |
>>>>>>>>>>>> | cache615395 |
>>>>>>>>>>>> | cache615397 |
>>>>>>>>>>>> | cache615398 |
>>>>>>>>>>>> | cache615399 |
>>>>>>>>>>>> | cache615400 |
>>>>>>>>>>>> | cache615401 |
>>>>>>>>>>>> | cache615402 |
>>>>>>>>>>>> | cache615403 |
>>>>>>>>>>>> | cache615404 |
>>>>>>>>>>>> | cache615405 |
>>>>>>>>>>>> | cache615406 |
>>>>>>>>>>>> | cache615407 |
>>>>>>>>>>>> | cache615408 |
>>>>>>>>>>>> | cache615409 |
>>>>>>>>>>>> | cache615410 |
>>>>>>>>>>>> | cache615411 |
>>>>>>>>>>>> | cache615412 |
>>>>>>>>>>>> | cache615413 |
>>>>>>>>>>>> | cache615414 |
>>>>>>>>>>>> | cache615415 |
>>>>>>>>>>>> | cache615416 |
>>>>>>>>>>>> | cache615417 |
>>>>>>>>>>>> | cache615418 |
>>>>>>>>>>>> | cache615420 |
>>>>>>>>>>>> | cache615421 |
>>>>>>>>>>>> | cache615422 |
>>>>>>>>>>>> | cache615425 |
>>>>>>>>>>>> | cache615427 |
>>>>>>>>>>>> | cache615429 |
>>>>>>>>>>>> | cache615432 |
>>>>>>>>>>>> | cache615433 |
>>>>>>>>>>>> | cache615437 |
>>>>>>>>>>>> | cache615438 |
>>>>>>>>>>>> | cache615439 |
>>>>>>>>>>>> | cache615441 |
>>>>>>>>>>>> | cache615443 |
>>>>>>>>>>>> | cache615445 |
>>>>>>>>>>>> | cache615448 |
>>>>>>>>>>>> | cache615449 |
>>>>>>>>>>>> | cache615452 |
>>>>>>>>>>>> | cache615453 |
>>>>>>>>>>>> | cache615456 |
>>>>>>>>>>>> | cache615457 |
>>>>>>>>>>>> | cache615460 |
>>>>>>>>>>>> | cache615461 |
>>>>>>>>>>>> | cache615464 |
>>>>>>>>>>>> | cache615465 |
>>>>>>>>>>>> | cache615467 |
>>>>>>>>>>>> | cache615468 |
>>>>>>>>>>>> | cache615470 |
>>>>>>>>>>>> | cache615473 |
>>>>>>>>>>>> | cache615474 |
>>>>>>>>>>>> | cache615475 |
>>>>>>>>>>>> | cache615477 |
>>>>>>>>>>>> | cache615479 |
>>>>>>>>>>>> | cache615481 |
>>>>>>>>>>>> | cache615483 |
>>>>>>>>>>>> | cache615486 |
>>>>>>>>>>>> | cache615487 |
>>>>>>>>>>>> | cache615491 |
>>>>>>>>>>>> | cache615492 |
>>>>>>>>>>>> | cache615493 |
>>>>>>>>>>>> | cache615495 |
>>>>>>>>>>>> | cache615497 |
>>>>>>>>>>>> | cache615499 |
>>>>>>>>>>>> | cache615501 |
>>>>>>>>>>>> | cache615503 |
>>>>>>>>>>>> | cache615505 |
>>>>>>>>>>>> | cache615507 |
>>>>>>>>>>>> | cache615509 |
>>>>>>>>>>>> | cache615511 |
>>>>>>>>>>>> | cache615513 |
>>>>>>>>>>>> | cache615515 |
>>>>>>>>>>>> | cache615517 |
>>>>>>>>>>>> | cache615518 |
>>>>>>>>>>>> | cache615519 |
>>>>>>>>>>>> | cache615520 |
>>>>>>>>>>>> | cache615522 |
>>>>>>>>>>>> | cache615524 |
>>>>>>>>>>>> | cache615526 |
>>>>>>>>>>>> | cache615529 |
>>>>>>>>>>>> | cache615530 |
>>>>>>>>>>>> | cache615534 |
>>>>>>>>>>>> | cache615535 |
>>>>>>>>>>>> | cache615536 |
>>>>>>>>>>>> | cache615538 |
>>>>>>>>>>>> | cache615540 |
>>>>>>>>>>>> | cache615542 |
>>>>>>>>>>>> | cache615544 |
>>>>>>>>>>>> | cache615546 |
>>>>>>>>>>>> | cache615548 |
>>>>>>>>>>>> | cache615550 |
>>>>>>>>>>>> | cache615552 |
>>>>>>>>>>>> | cache615554 |
>>>>>>>>>>>> | cache615556 |
>>>>>>>>>>>> | cache615558 |
>>>>>>>>>>>> | cache615560 |
>>>>>>>>>>>> | cache615562 |
>>>>>>>>>>>> | cache615564 |
>>>>>>>>>>>> | cache615566 |
>>>>>>>>>>>> | cache615567 |
>>>>>>>>>>>> | cache615568 |
>>>>>>>>>>>> | cache615570 |
>>>>>>>>>>>> | cache615571 |
>>>>>>>>>>>> | cache615572 |
>>>>>>>>>>>> | cache615573 |
>>>>>>>>>>>> | cache615575 |
>>>>>>>>>>>> | cache615577 |
>>>>>>>>>>>> | cache615579 |
>>>>>>>>>>>> | cache615581 |
>>>>>>>>>>>> | cache615583 |
>>>>>>>>>>>> | cache615586 |
>>>>>>>>>>>> | cache615587 |
>>>>>>>>>>>> | cache615591 |
>>>>>>>>>>>> | cache615592 |
>>>>>>>>>>>> | cache615593 |
>>>>>>>>>>>> | cache615595 |
>>>>>>>>>>>> | cache615597 |
>>>>>>>>>>>> | cache615599 |
>>>>>>>>>>>> | cache615601 |
>>>>>>>>>>>> | cache615603 |
>>>>>>>>>>>> | cache615605 |
>>>>>>>>>>>> | cache615607 |
>>>>>>>>>>>> | cache615609 |
>>>>>>>>>>>> | cache615611 |
>>>>>>>>>>>> | cache615613 |
>>>>>>>>>>>> | cache615616 |
>>>>>>>>>>>> | cache615617 |
>>>>>>>>>>>> | cache615621 |
>>>>>>>>>>>> | cache615622 |
>>>>>>>>>>>> | cache615623 |
>>>>>>>>>>>> | cache615625 |
>>>>>>>>>>>> | cache615627 |
>>>>>>>>>>>> | cache615629 |
>>>>>>>>>>>> | cache615630 |
>>>>>>>>>>>> | cache615631 |
>>>>>>>>>>>> | cache615632 |
>>>>>>>>>>>> | cache615633 |
>>>>>>>>>>>> | cache615634 |
>>>>>>>>>>>> | cache615636 |
>>>>>>>>>>>> | cache615638 |
>>>>>>>>>>>> | cache615640 |
>>>>>>>>>>>> | cache615642 |
>>>>>>>>>>>> | cache615644 |
>>>>>>>>>>>> | cache615646 |
>>>>>>>>>>>> | cache615648 |
>>>>>>>>>>>> | cache615650 |
>>>>>>>>>>>> | cache615652 |
>>>>>>>>>>>> | cache615654 |
>>>>>>>>>>>> | cache615656 |
>>>>>>>>>>>> | cache615658 |
>>>>>>>>>>>> | cache615661 |
>>>>>>>>>>>> | cache615662 |
>>>>>>>>>>>> | cache615666 |
>>>>>>>>>>>> | cache615667 |
>>>>>>>>>>>> | cache615668 |
>>>>>>>>>>>> | cache615670 |
>>>>>>>>>>>> | cache615672 |
>>>>>>>>>>>> | cachemap |
>>>>>>>>>>>> | cachemap__ordervalues_fr |
>>>>>>>>>>>> | counters |
>>>>>>>>>>>> | document |
>>>>>>>>>>>> | document__index |
>>>>>>>>>>>> | document__index_grep |
>>>>>>>>>>>> | document__ordervalues_en |
>>>>>>>>>>>> | document__ordervalues_fr |
>>>>>>>>>>>> | document__rindex |
>>>>>>>>>>>> | document_permission_group |
>>>>>>>>>>>> | document_relation_type |
>>>>>>>>>>>> | document_relation_uri |
>>>>>>>>>>>> | eprint |
>>>>>>>>>>>> | eprint__index |
>>>>>>>>>>>> | eprint__index_grep |
>>>>>>>>>>>> | eprint__ordervalues_en |
>>>>>>>>>>>> | eprint__ordervalues_fr |
>>>>>>>>>>>> | eprint__rindex |
>>>>>>>>>>>> | eprint_accompaniment |
>>>>>>>>>>>> | eprint_conductors_id |
>>>>>>>>>>>> | eprint_conductors_name |
>>>>>>>>>>>> | eprint_copyright_holders |
>>>>>>>>>>>> | eprint_corp_creators |
>>>>>>>>>>>> | eprint_creators_id |
>>>>>>>>>>>> | eprint_creators_name |
>>>>>>>>>>>> | eprint_dircreators_name |
>>>>>>>>>>>> | eprint_divisions |
>>>>>>>>>>>> | eprint_editors_id |
>>>>>>>>>>>> | eprint_editors_name |
>>>>>>>>>>>> | eprint_exhibitors_id |
>>>>>>>>>>>> | eprint_exhibitors_name |
>>>>>>>>>>>> | eprint_funders |
>>>>>>>>>>>> | eprint_item_issues_comment |
>>>>>>>>>>>> | eprint_item_issues_description |
>>>>>>>>>>>> | eprint_item_issues_id |
>>>>>>>>>>>> | eprint_item_issues_reported_by |
>>>>>>>>>>>> | eprint_item_issues_resolved_by |
>>>>>>>>>>>> | eprint_item_issues_status |
>>>>>>>>>>>> | eprint_item_issues_timestamp |
>>>>>>>>>>>> | eprint_item_issues_type |
>>>>>>>>>>>> | eprint_language |
>>>>>>>>>>>> | eprint_lyricists_id |
>>>>>>>>>>>> | eprint_lyricists_name |
>>>>>>>>>>>> | eprint_producers_id |
>>>>>>>>>>>> | eprint_producers_name |
>>>>>>>>>>>> | eprint_projects |
>>>>>>>>>>>> | eprint_related_url_type |
>>>>>>>>>>>> | eprint_related_url_url |
>>>>>>>>>>>> | eprint_relation_type |
>>>>>>>>>>>> | eprint_relation_uri |
>>>>>>>>>>>> | eprint_skill_areas |
>>>>>>>>>>>> | eprint_subjects |
>>>>>>>>>>>> | event_queue |
>>>>>>>>>>>> | event_queue__ordervalues_fr |
>>>>>>>>>>>> | file |
>>>>>>>>>>>> | file__ordervalues_fr |
>>>>>>>>>>>> | file_copies_pluginid |
>>>>>>>>>>>> | file_copies_sourceid |
>>>>>>>>>>>> | history |
>>>>>>>>>>>> | history__index |
>>>>>>>>>>>> | history__index_grep |
>>>>>>>>>>>> | history__ordervalues_en |
>>>>>>>>>>>> | history__ordervalues_fr |
>>>>>>>>>>>> | history__rindex |
>>>>>>>>>>>> | import |
>>>>>>>>>>>> | import__ordervalues_fr |
>>>>>>>>>>>> | index_queue |
>>>>>>>>>>>> | loginticket |
>>>>>>>>>>>> | loginticket__ordervalues_fr |
>>>>>>>>>>>> | message |
>>>>>>>>>>>> | message__ordervalues_fr |
>>>>>>>>>>>> | mf |
>>>>>>>>>>>> | mf__ordervalues_fr |
>>>>>>>>>>>> | mf_fields_allow_null |
>>>>>>>>>>>> | mf_fields_browse_link |
>>>>>>>>>>>> | mf_fields_datasetid |
>>>>>>>>>>>> | mf_fields_default_value |
>>>>>>>>>>>> | mf_fields_export_as_xml |
>>>>>>>>>>>> | mf_fields_family_first |
>>>>>>>>>>>> | mf_fields_hide_honourific |
>>>>>>>>>>>> | mf_fields_hide_lineage |
>>>>>>>>>>>> | mf_fields_input_boxes |
>>>>>>>>>>>> | mf_fields_input_cols |
>>>>>>>>>>>> | mf_fields_input_ordered |
>>>>>>>>>>>> | mf_fields_input_rows |
>>>>>>>>>>>> | mf_fields_input_style |
>>>>>>>>>>>> | mf_fields_maxlength |
>>>>>>>>>>>> | mf_fields_mfremoved |
>>>>>>>>>>>> | mf_fields_min_resolution |
>>>>>>>>>>>> | mf_fields_options |
>>>>>>>>>>>> | mf_fields_render_input |
>>>>>>>>>>>> | mf_fields_render_order |
>>>>>>>>>>>> | mf_fields_render_value |
>>>>>>>>>>>> | mf_fields_required |
>>>>>>>>>>>> | mf_fields_set_name |
>>>>>>>>>>>> | mf_fields_sql_counter |
>>>>>>>>>>>> | mf_fields_sql_index |
>>>>>>>>>>>> | mf_fields_sub_name |
>>>>>>>>>>>> | mf_fields_top |
>>>>>>>>>>>> | mf_fields_type |
>>>>>>>>>>>> | mf_fields_volatile |
>>>>>>>>>>>> | mf_phrase_help_lang |
>>>>>>>>>>>> | mf_phrase_help_text |
>>>>>>>>>>>> | mf_phrase_name_lang |
>>>>>>>>>>>> | mf_phrase_name_text |
>>>>>>>>>>>> | request |
>>>>>>>>>>>> | request__index |
>>>>>>>>>>>> | request__index_grep |
>>>>>>>>>>>> | request__ordervalues_en |
>>>>>>>>>>>> | request__ordervalues_fr |
>>>>>>>>>>>> | request__rindex |
>>>>>>>>>>>> | saved_search |
>>>>>>>>>>>> | saved_search__index |
>>>>>>>>>>>> | saved_search__index_grep |
>>>>>>>>>>>> | saved_search__ordervalues_en |
>>>>>>>>>>>> | saved_search__ordervalues_fr |
>>>>>>>>>>>> | saved_search__rindex |
>>>>>>>>>>>> | subject |
>>>>>>>>>>>> | subject__index |
>>>>>>>>>>>> | subject__index_grep |
>>>>>>>>>>>> | subject__ordervalues_en |
>>>>>>>>>>>> | subject__ordervalues_fr |
>>>>>>>>>>>> | subject__rindex |
>>>>>>>>>>>> | subject_ancestors |
>>>>>>>>>>>> | subject_name_lang |
>>>>>>>>>>>> | subject_name_name |
>>>>>>>>>>>> | subject_parents |
>>>>>>>>>>>> | triple |
>>>>>>>>>>>> | triple__ordervalues_fr |
>>>>>>>>>>>> | upload_progress |
>>>>>>>>>>>> | upload_progress__ordervalues_fr |
>>>>>>>>>>>> | user |
>>>>>>>>>>>> | user__index |
>>>>>>>>>>>> | user__index_grep |
>>>>>>>>>>>> | user__ordervalues_en |
>>>>>>>>>>>> | user__ordervalues_fr |
>>>>>>>>>>>> | user__rindex |
>>>>>>>>>>>> | user_editperms |
>>>>>>>>>>>> | user_items_fields |
>>>>>>>>>>>> | user_permission_group |
>>>>>>>>>>>> | user_review_fields |
>>>>>>>>>>>> | user_roles |
>>>>>>>>>>>> | version |
>>>>>>>>>>>> +---------------------------------+
>>>>>>>>>>>>
>>>>>>>>>>>> Is there anything you need or did I give you enough details ?
>>>>>>>>>>>>
>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>
>>>>>>>>>>>> Jeremy
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> Le 22/09/2015 21:56, Adam Field a ?crit :
>>>>>>>>>>>>> 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).
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> --
>>>>>>>>>>>>> Adam Field
>>>>>>>>>>>>> Business Relationship Manager and Community Lead
>>>>>>>>>>>>> EPrints Services
>>>>>>>>>>>>>
>>>>>>>>>>>>>> On 18 Sep 2015, at 13:44, J?r?my RAINGEARD
>>>>>>>>>>>>>> <jeremy.raingeard at univ-tlse3.fr> wrote:
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Hi Adam,
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> I tried your solution and it did nothing : not sorted out
>>>>>>>>>>>>>> well and it
>>>>>>>>>>>>>> didn't appear in my eprint__ordervalues_fr table - I
>>>>>>>>>>>>>> don't know if it's
>>>>>>>>>>>>>> useful or not. But I checked my logs after some tries and
>>>>>>>>>>>>>> this is what I
>>>>>>>>>>>>>> found in it :
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372,
>>>>>>>>>>>>>> <DATA> line 151.
>>>>>>>>>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>>>>>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>>>>>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>>>>>>>>>> WHERE
>>>>>>>>>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>>>>>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>>>>>>>>>> SQL ERROR (execute): Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm'
>>>>>>>>>>>>>> (errno: 24)
>>>>>>>>>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line
>>>>>>>>>>>>>> 565, <DATA> line
>>>>>>>>>>>>>> 151.
>>>>>>>>>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372,
>>>>>>>>>>>>>> <DATA> line 151.
>>>>>>>>>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>>>>>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>>>>>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>>>>>>>>>> WHERE
>>>>>>>>>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>>>>>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>>>>>>>>>> SQL ERROR (execute): Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm'
>>>>>>>>>>>>>> (errno: 24)
>>>>>>>>>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line
>>>>>>>>>>>>>> 565, <DATA> line
>>>>>>>>>>>>>> 151.
>>>>>>>>>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372,
>>>>>>>>>>>>>> <DATA> line 151.
>>>>>>>>>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>>>>>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>>>>>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>>>>>>>>>> WHERE
>>>>>>>>>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>>>>>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>>>>>>>>>> SQL ERROR (execute): Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm'
>>>>>>>>>>>>>> (errno: 24)
>>>>>>>>>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line
>>>>>>>>>>>>>> 565, <DATA> line
>>>>>>>>>>>>>> 151.
>>>>>>>>>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372,
>>>>>>>>>>>>>> <DATA> line 151.
>>>>>>>>>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>>>>>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>>>>>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>>>>>>>>>> WHERE
>>>>>>>>>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>>>>>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>>>>>>>>>> SQL ERROR (execute): Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm'
>>>>>>>>>>>>>> (errno: 24)
>>>>>>>>>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line
>>>>>>>>>>>>>> 565, <DATA> line
>>>>>>>>>>>>>> 151.
>>>>>>>>>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372,
>>>>>>>>>>>>>> <DATA> line 151.
>>>>>>>>>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>>>>>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>>>>>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>>>>>>>>>> WHERE
>>>>>>>>>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>>>>>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>>>>>>>>>> SQL ERROR (execute): Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm'
>>>>>>>>>>>>>> (errno: 24)
>>>>>>>>>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line
>>>>>>>>>>>>>> 565, <DATA> line
>>>>>>>>>>>>>> 151.
>>>>>>>>>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372,
>>>>>>>>>>>>>> <DATA> line 151.
>>>>>>>>>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>>>>>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>>>>>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>>>>>>>>>> WHERE
>>>>>>>>>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>>>>>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>>>>>>>>>> SQL ERROR (execute): Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm'
>>>>>>>>>>>>>> (errno: 24)
>>>>>>>>>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line
>>>>>>>>>>>>>> 565, <DATA> line
>>>>>>>>>>>>>> 151.
>>>>>>>>>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372,
>>>>>>>>>>>>>> <DATA> line 151.
>>>>>>>>>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>>>>>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>>>>>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>>>>>>>>>> WHERE
>>>>>>>>>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>>>>>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>>>>>>>>>> SQL ERROR (execute): Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm'
>>>>>>>>>>>>>> (errno: 24)
>>>>>>>>>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line
>>>>>>>>>>>>>> 565, <DATA> line
>>>>>>>>>>>>>> 151.
>>>>>>>>>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372,
>>>>>>>>>>>>>> <DATA> line 151.
>>>>>>>>>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>>>>>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>>>>>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>>>>>>>>>> WHERE
>>>>>>>>>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>>>>>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>>>>>>>>>> SQL ERROR (execute): Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm'
>>>>>>>>>>>>>> (errno: 24)
>>>>>>>>>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line
>>>>>>>>>>>>>> 565, <DATA> line
>>>>>>>>>>>>>> 151.
>>>>>>>>>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372,
>>>>>>>>>>>>>> <DATA> line 151.
>>>>>>>>>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>>>>>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>>>>>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>>>>>>>>>> WHERE
>>>>>>>>>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>>>>>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>>>>>>>>>> SQL ERROR (execute): Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm'
>>>>>>>>>>>>>> (errno: 24)
>>>>>>>>>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line
>>>>>>>>>>>>>> 565, <DATA> line
>>>>>>>>>>>>>> 151.
>>>>>>>>>>>>>> DBD::mysql::st execute failed: Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm' (errno: 24) at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Database.pm line 3372,
>>>>>>>>>>>>>> <DATA> line 151.
>>>>>>>>>>>>>> SQL ERROR (execute): SELECT `event_queue`.`eventqueueid` FROM
>>>>>>>>>>>>>> `event_queue` LEFT JOIN `event_queue__ordervalues_fr` ON
>>>>>>>>>>>>>> `event_queue`.`eventqueueid`=`event_queue__ordervalues_fr`.`eventqueueid`
>>>>>>>>>>>>>> WHERE
>>>>>>>>>>>>>> `event_queue`.`status` = 'waiting' AND ((
>>>>>>>>>>>>>> `event_queue`.`start_time_year` < 2015 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` < 9 ) OR (
>>>>>>>>>>>>>> `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> < 17 ) OR ( `event_queue`.`start_time_year` = 2015 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_month` = 9 AND
>>>>>>>>>>>>>> `event_queue`.`start_time_day`
>>>>>>>>>>>>>> = 17 )) GROUP BY `event_queue`.`eventqueueid`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority`,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` ORDER BY
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`priority` DESC,
>>>>>>>>>>>>>> `event_queue__ordervalues_fr`.`start_time` DESC
>>>>>>>>>>>>>> SQL ERROR (execute): Can't open file:
>>>>>>>>>>>>>> './thesesups/event_queue.frm'
>>>>>>>>>>>>>> (errno: 24)
>>>>>>>>>>>>>> DBD::mysql::st fetch failed: fetch() without execute() at
>>>>>>>>>>>>>> /opt/eprints3/perl_lib/EPrints/Search/Condition.pm line
>>>>>>>>>>>>>> 565, <DATA> line
>>>>>>>>>>>>>> 151.
>>>>>>>>>>>>>> [Fri Sep 18 14:28:09 2015] ** Indexer process stopping
>>>>>>>>>>>>>> [Fri Sep 18 14:28:17 2015] ** Indexer process started
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> I don't find this event_queue.frm - because it's a
>>>>>>>>>>>>>> temporary file for
>>>>>>>>>>>>>> MySQL ? - so I can't even see if it's a permission
>>>>>>>>>>>>>> problem. Any idea
>>>>>>>>>>>>>> about this ?
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Thank you.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Jeremy
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Le 17/09/2015 16:09, Field A.N. a ?crit :
>>>>>>>>>>>>>>> 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:
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> epadmin reindex *repository_id* eprint *eprint_id*
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> ...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.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> 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.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Let me know how it goes.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>> Adam Field
>>>>>>>>>>>>>>> Business Relationship Manager and Community Lead
>>>>>>>>>>>>>>> EPrints Services
>>>>>>>>>>>>>>> +44 (0)23 8059 8814
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> On 17 Sep 2015, at 14:36, J?r?my RAINGEARD wrote:
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Hi Adam and thank you.
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> You can find our repository at this address - some
>>>>>>>>>>>>>>>> thesis are public,
>>>>>>>>>>>>>>>> some not : http://thesesups.ups-tlse.fr/
>>>>>>>>>>>>>>>> Just choose a subject for example and let the last
>>>>>>>>>>>>>>>> option as it is
>>>>>>>>>>>>>>>> ("trier les r?sultats").
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Now, this is the advanced search aprt of my search.pl
>>>>>>>>>>>>>>>> file - hope it's
>>>>>>>>>>>>>>>> what you need :
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> $c->{search}->{advanced} =
>>>>>>>>>>>>>>>> {
>>>>>>>>>>>>>>>> search_fields => [
>>>>>>>>>>>>>>>> { meta_fields => [ $EPrints::Utils::FULLTEXT ] },
>>>>>>>>>>>>>>>> { meta_fields => [ "title" ] },
>>>>>>>>>>>>>>>> { meta_fields => [ "creators_name" ] },
>>>>>>>>>>>>>>>> { meta_fields => [ "dircreators_name" ] },
>>>>>>>>>>>>>>>> { meta_fields => [ "abstract" ] },
>>>>>>>>>>>>>>>> { meta_fields => [ "keywords" ] },
>>>>>>>>>>>>>>>> { meta_fields => [ "subjects" ] },
>>>>>>>>>>>>>>>> #{ meta_fields => [ "type" ] },
>>>>>>>>>>>>>>>> { meta_fields => [ "divisions" ] },
>>>>>>>>>>>>>>>> { meta_fields => [ "department" ] },
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> #{ meta_fields => [ "ispublished" ] },
>>>>>>>>>>>>>>>> #{ meta_fields => [ "refereed" ] },
>>>>>>>>>>>>>>>> #{ meta_fields => [ "publication" ] },
>>>>>>>>>>>>>>>> { meta_fields => [ "date" ] },
>>>>>>>>>>>>>>>> ],
>>>>>>>>>>>>>>>> preamble_phrase => "cgi/advsearch:preamble",
>>>>>>>>>>>>>>>> title_phrase => "cgi/advsearch:adv_search",
>>>>>>>>>>>>>>>> citation => "result",
>>>>>>>>>>>>>>>> page_size => 20,
>>>>>>>>>>>>>>>> order_methods => {
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> "byyear" => "-date/creators_name/title",
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> "byyearoldest" => "date/creators_name/title",
>>>>>>>>>>>>>>>> "byname" => "creators_name/-date/title",
>>>>>>>>>>>>>>>> "bytitle" => "title/creators_name/-date"
>>>>>>>>>>>>>>>> },
>>>>>>>>>>>>>>>> default_order => "byyear",
>>>>>>>>>>>>>>>> };
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> If necessary, I can add more content of this file or
>>>>>>>>>>>>>>>> give you more details.
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Thanks,
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> J?r?my
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Le 17/09/2015 14:21, Field A.N. a ?crit :
>>>>>>>>>>>>>>>>> Hi J?r?my
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> 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!
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> 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.
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> Best WIshes
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>>>>>> Adam Field
>>>>>>>>>>>>>>>>> Business Relationship Manager and Community Lead
>>>>>>>>>>>>>>>>> EPrints Services
>>>>>>>>>>>>>>>>> +44 (0)23 8059 8814
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> On 17 Sep 2015, at 09:18, J?r?my RAINGEARD wrote:
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> Hello,
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> My university asked me to help them with some eprints
>>>>>>>>>>>>>>>>>> problems - I
>>>>>>>>>>>>>>>>>> didn't even know what eprints was - in only 2 weeks.
>>>>>>>>>>>>>>>>>> I managed to
>>>>>>>>>>>>>>>>>> correct all problems thanks to your documentation,
>>>>>>>>>>>>>>>>>> but I'm stuck with
>>>>>>>>>>>>>>>>>> the last problem and I have no error message to help
>>>>>>>>>>>>>>>>>> me to resolve it.
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> First, when we used our advanced search and sorted
>>>>>>>>>>>>>>>>>> results by date, it
>>>>>>>>>>>>>>>>>> only sorted it by author name even if we had a date >
>>>>>>>>>>>>>>>>>> author > title
>>>>>>>>>>>>>>>>>> sorting. Now, I manage to sort it by date, but only
>>>>>>>>>>>>>>>>>> from 2010 to 2015.
>>>>>>>>>>>>>>>>>> Before - probably an upgrade of eprints they told me
>>>>>>>>>>>>>>>>>> - it's sometimes in
>>>>>>>>>>>>>>>>>> the right order, but sometimes not and, in this case,
>>>>>>>>>>>>>>>>>> the order is by
>>>>>>>>>>>>>>>>>> the author name.
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> I don't know how to reorder the wrong ones. I checked
>>>>>>>>>>>>>>>>>> my tables and saw
>>>>>>>>>>>>>>>>>> an "eprints__order_values_fr" - we don't use it's EN
>>>>>>>>>>>>>>>>>> version. I don't
>>>>>>>>>>>>>>>>>> know if the problem is there but when thesis are in
>>>>>>>>>>>>>>>>>> the good order, they
>>>>>>>>>>>>>>>>>> appear in this table and when they're in the wrong
>>>>>>>>>>>>>>>>>> order, they're not in
>>>>>>>>>>>>>>>>>> it.
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> Could you please tell me how to correct this wrong
>>>>>>>>>>>>>>>>>> behavior please ?
>>>>>>>>>>>>>>>>>> Thank you.
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> J?r?my
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> *** Options:
>>>>>>>>>>>>>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>>>>>>>>>>>>> *** Archive: http://www.eprints.org/tech.php/
>>>>>>>>>>>>>>>>>> *** EPrints community wiki: http://wiki.eprints.org/
>>>>>>>>>>>>>>>>>> *** EPrints developers Forum: http://forum.eprints.org/
>>>>>>>>>>>>>>>>> *** Options:
>>>>>>>>>>>>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>>>>>>>>>>>> *** Archive: http://www.eprints.org/tech.php/
>>>>>>>>>>>>>>>>> *** EPrints community wiki: http://wiki.eprints.org/
>>>>>>>>>>>>>>>>> *** EPrints developers Forum: http://forum.eprints.org/
>>>>>>>>>>>>>>>> *** Options:
>>>>>>>>>>>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>>>>>>>>>>> *** Archive: http://www.eprints.org/tech.php/
>>>>>>>>>>>>>>>> *** EPrints community wiki: http://wiki.eprints.org/
>>>>>>>>>>>>>>>> *** EPrints developers Forum: http://forum.eprints.org/
>>>>>>>>>>>>>>> *** Options:
>>>>>>>>>>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>>>>>>>>>> *** Archive: http://www.eprints.org/tech.php/
>>>>>>>>>>>>>>> *** EPrints community wiki: http://wiki.eprints.org/
>>>>>>>>>>>>>>> *** EPrints developers Forum: http://forum.eprints.org/
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> *** Options:
>>>>>>>>>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>>>>>>>>> *** Archive: http://www.eprints.org/tech.php/
>>>>>>>>>>>>>> *** EPrints community wiki: http://wiki.eprints.org/
>>>>>>>>>>>>>> *** EPrints developers Forum: http://forum.eprints.org/
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> *** Options:
>>>>>>>>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>>>>>>>>
>>>>>>>>>>>>> *** Archive:
>>>>>>>>>>>>> http://www.eprints.org/tech.php/
>>>>>>>>>>>>>
>>>>>>>>>>>>> *** EPrints community wiki:
>>>>>>>>>>>>> http://wiki.eprints.org/
>>>>>>>>>>>>>
>>>>>>>>>>>>> *** EPrints developers Forum:
>>>>>>>>>>>>> http://forum.eprints.org/
>>>>>>>>>>>> *** Options:
>>>>>>>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>>>>>>> *** Archive: http://www.eprints.org/tech.php/
>>>>>>>>>>>> *** EPrints community wiki: http://wiki.eprints.org/
>>>>>>>>>>>> *** EPrints developers Forum: http://forum.eprints.org/
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> *** Options:
>>>>>>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>>>>>>
>>>>>>>>>>> *** Archive:
>>>>>>>>>>> http://www.eprints.org/tech.php/
>>>>>>>>>>>
>>>>>>>>>>> *** EPrints community wiki:
>>>>>>>>>>> http://wiki.eprints.org/
>>>>>>>>>>>
>>>>>>>>>>> *** EPrints developers Forum:
>>>>>>>>>>> http://forum.eprints.org/
>>>>>>>>>> *** Options:
>>>>>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>>>>> *** Archive: http://www.eprints.org/tech.php/
>>>>>>>>>> *** EPrints community wiki: http://wiki.eprints.org/
>>>>>>>>>> *** EPrints developers Forum: http://forum.eprints.org/
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> *** Options:
>>>>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>>>>
>>>>>>>>> *** Archive:
>>>>>>>>> http://www.eprints.org/tech.php/
>>>>>>>>>
>>>>>>>>> *** EPrints community wiki:
>>>>>>>>> http://wiki.eprints.org/
>>>>>>>>>
>>>>>>>>> *** EPrints developers Forum:
>>>>>>>>> http://forum.eprints.org/
>>>>>>>> *** Options:
>>>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>>> *** Archive: http://www.eprints.org/tech.php/
>>>>>>>> *** EPrints community wiki: http://wiki.eprints.org/
>>>>>>>> *** EPrints developers Forum: http://forum.eprints.org/
>>>>>>>
>>>>>>> *** Options:
>>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>>> *** Archive: http://www.eprints.org/tech.php/
>>>>>>> *** EPrints community wiki: http://wiki.eprints.org/
>>>>>>> *** EPrints developers Forum: http://forum.eprints.org/
>>>>>>
>>>>>>
>>>>>> *** Options:
>>>>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>>> *** Archive: http://www.eprints.org/tech.php/
>>>>>> *** EPrints community wiki: http://wiki.eprints.org/
>>>>>> *** EPrints developers Forum: http://forum.eprints.org/
>>>>>
>>>>>
>>>>>
>>>>> *** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>>> *** Archive:http://www.eprints.org/tech.php/
>>>>> *** EPrints community wiki:http://wiki.eprints.org/
>>>>> *** EPrints developers Forum:http://forum.eprints.org/
>>>>
>>>>
>>>>
>>>> *** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>>> *** Archive:http://www.eprints.org/tech.php/
>>>> *** EPrints community wiki:http://wiki.eprints.org/
>>>> *** EPrints developers Forum:http://forum.eprints.org/
>>>
>>> *** Options:
>>> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>>> *** Archive: http://www.eprints.org/tech.php/
>>> *** EPrints community wiki: http://wiki.eprints.org/
>>> *** EPrints developers Forum: http://forum.eprints.org/
>>
>>
>>
>> *** Options:http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
>> *** Archive:http://www.eprints.org/tech.php/
>> *** EPrints community wiki:http://wiki.eprints.org/
>> *** EPrints developers Forum:http://forum.eprints.org/
>
>
>
> *** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** Archive: http://www.eprints.org/tech.php/
> *** EPrints community wiki: http://wiki.eprints.org/
> *** EPrints developers Forum: http://forum.eprints.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20151006/ca4b1fbf/attachment-0001.html