The search filter date does not work in customfield after upgrade

inasutin

Hello!
After upgrade from 30 PRO to 33 version i-Doit does not search for anything from the custom made "Maintenance service" section from the search window, and this is not good...

Can you help me find the fault?
Regards,
Inna

StefanP74

Hi @inasutin,

maybe a rebuild of the search-index can help you?
we do it every day at 5am ... and all of our search problems are gone.

cron-job-entry:
0 5 * * * sudo -u www-data php /var/www/html/console.php search-index --user admin --password XXXXXXXXX --tenantId 1

Regards,
Stefan

inasutin

@StefanP74 Thank you for your answer, I will try at 05 a.m.

inasutin

@StefanP74 Hello, I have problem with re-new search index, I executed the command in the console,and the command did not complete due to an error-
PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 12288 bytes) in /var/www/html/src/classes/components/isys_component_database_mysqli.c lass.php on line 275

That solves this problem?
Regards,
Inna

LFischer

Hello @inasutin

the error tells us that your machine (or rather PHP) does not have enough memory to index all your data.

The simple solution would be to increase the memory limit for PHP.

The "proper" solution would be to find out which category is causing this issue and also re-evaluate if the data that is currently being indexed in terms of "do we really need to index this?"

In order to do so you can manually re-index the search by running the command @StefanP74 supplied but add the -vvv option to see all details. You will see which categories gets indexed and the amount of entries (please note: the process will slow down due to this output).
This can help you find the culprit (= the category that causes the memory issue).

sudo -u www-data php /var/www/html/console.php search-index --user admin --password XXXXXXXXX --tenantId 1 -vvv

Afterwards you can try to adjust the indexing. For example you can prevent certain categories from beeing indexed as you might not need them to be searchable - that will free up resources!

For this you can call the search-index command and pass a list of categories that you actually want to be indexed via --category ... This will be a bit tedious, but ideally you'll only have to do it once.

sudo -u www-data php /var/www/html/console.php search-index --user admin --password XXXXXXXXX --tenantId 1 --category C__CATG__GLOBAL --category C__CATG__CPU

Best regards,
Leo

leobaer

Hi,

you may look at my answer in the German section:
https://community.i-doit.com/topic/5282/das-suchfilterdatum-funktioniert-nach-dem-upgrade-nicht-im-benutzerdefinierten-feld.

If you have large i-doit database with (ten) thousands of objects and some object types / categories which need to be searched you have to increase the php memory.

In our php.ini we have
memory_limit = 8192M

Regards
Leo

elenabaggins

You should verify the category is set to be searchable, then rebuild the search index via the UI or CLI, and check for any related system or database errors.