Using rebuildSearchIndex.php in OJS 3.1.2

Hello all,

This week I’m finishing my upgrade from OJS 2.4.7 to 3.1.2, and still have some doubts about rebuildSearchIndex.php. Runing it in this version gets me thousands of:

PHP Warning:  Illegal offset type in /home/ojs/rc-3.1.2/lib/pkp/classes/search/SubmissionSearchDAO.inc.php on line 48
PHP Warning:  Illegal offset type in isset or empty in /home/ojs/rc-3.1.2/lib/pkp/classes/search/SubmissionSearchDAO.inc.php on line 26
PHP Warning:  Illegal offset type in /home/ojs/rc-3.1.2/lib/pkp/classes/search/SubmissionSearchDAO.inc.php on line 48
PHP Warning:  Illegal offset type in isset or empty in /home/ojs/rc-3.1.2/lib/pkp/classes/search/SubmissionSearchDAO.inc.php on line 26

But the submission_search_keyword_list, submission_search_object_keywords and submission_search_objects tables are populated. Also, select in submission_search_keyword_list shows me this:

mysql> select * from submission_search_keyword_list;
+------------+-------------------------+
| keyword_id | keyword_text            |
+------------+-------------------------+
|    3146969 | roberto                 |
|    3146970 | ribeiro                 |
|    3146971 | baldino                 |
|    3146972 | mundo-real              |
|    3146973 | dia-a-dia               |
|    3146974 | produção              |
|    3146975 | significados            |
|    3146976 | matemáticos            |
|    3146977 | bolema                  |
|    3146978 | ano                     |
|    3146979 | artigo                  |
|    3146980 | recentes                |
|    3146981 | tentativas              |
|    3146982 | pensar                  |
|    3146983 | educação              |
|    3146984 | matemática             |
|    3146985 | partir                  |
|    3146986 | significado             |
|    3146987 | portanto                |

Is this correct?

Inside my config.inc.php I have

[i18n]

locale = pt_BR
client_charset = utf-8
connection_charset = utf-8
database_charset = utf-8

index[application/pdf] = “/usr/bin/pdftotext -enc UTF-8 -nopgbrk %s - | /usr/bin/tr ‘[:cntrl:]’ ’ '”

I’m using php 7.2.17-0ubuntu0.18.04.1 (cli) (built: Apr 18 2019 14:12:38) ( NTS )

Regards,

Oberdan

I coincidentally was looking at this as well yesterday. There is a bug in 3.1.2 where locallized (translated or translatable) strings are not being indexed correctly. I’ll be filing a bug report shortly.

Hello @ctgraham,

I’ll ask people to test the system and put it in production if they think its OK. The rebuildSearchIndex procedure will be run when this is fixed. Thanks for you help.

Regards,

Oberdan

You can track this issue here:
https://github.com/pkp/pkp-lib/issues/4720