[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] Re: Advanced Search by date
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
>> <mailto: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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.ecs.soton.ac.uk/pipermail/eprints-tech/attachments/20150923/ca651ec9/attachment-0001.html