EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #04862

[EP-tech] Re: Advanced Search by date

To: eprints-tech@ecs.soton.ac.uk
Subject: [EP-tech] Re: Advanced Search by date
From: Adam Field <af05v@ecs.soton.ac.uk>
Date: Tue, 6 Oct 2015 11:11:14 +0100

OK, I'm out of ideas, I'm afraid. Anyone else have any thoughts?

--
Adam Field
Business Relationship Manager and Community Lead
EPrints Services

On 6 Oct 2015, at 10:26, Jérémy RAINGEARD <jeremy.raingeard@univ-tlse3.fr> wrote:

After a "show grants", I have this : "GRANT ALL PRIVILEGES ON `thesesups`.* TO 'eprints'@'localhost'"

Le 06/10/2015 11:20, Adam Field a écrit :
Can you check the permissions that the eprints user has?
--
Adam Field
Business Relationship Manager and Community Lead
EPrints Services
On 6 Oct 2015, at 10:18, Jérémy RAINGEARD <jeremy.raingeard@univ-tlse3.fr> wrote:
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@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@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@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@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@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/
*** 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/

References:
- [EP-tech] Advanced Search by date
  - From: Jérémy RAINGEARD <jeremy.raingeard@univ-tlse3.fr>
- [EP-tech] Re: Advanced Search by date
  - From: Adam Field <af05v@ecs.soton.ac.uk>
- [EP-tech] Re: Advanced Search by date
  - From: Jérémy RAINGEARD <jeremy.raingeard@univ-tlse3.fr>
- [EP-tech] Re: Advanced Search by date
  - From: Jérémy RAINGEARD <jeremy.raingeard@univ-tlse3.fr>
- [EP-tech] Re: Advanced Search by date
  - From: Adam Field <af05v@ecs.soton.ac.uk>
- [EP-tech] Re: Advanced Search by date
  - From: Jérémy RAINGEARD <jeremy.raingeard@univ-tlse3.fr>
- [EP-tech] Re: Advanced Search by date
  - From: Jérémy RAINGEARD <jeremy.raingeard@univ-tlse3.fr>
- [EP-tech] Re: Advanced Search by date
  - From: Adam Field <af05v@ecs.soton.ac.uk>
- [EP-tech] Re: Advanced Search by date
  - From: Jérémy RAINGEARD <jeremy.raingeard@univ-tlse3.fr>

Prev by Date: [EP-tech] Re: Errors from event queue
Next by Date: [EP-tech] Re: How to set a field to be multilang (search)
Previous by thread: [EP-tech] Re: Advanced Search by date
Next by thread: [EP-tech] Re: Advanced Search by date
Index(es):
- Date
- Thread