[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