Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    The search filter date does not work in customfield after upgrade

    Scheduled Pinned Locked Moved General
    6 Posts 4 Posters 259 Views 1 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • I Offline
      inasutin
      last edited by

      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...
      7e6c6081-8b27-46ad-ad37-36e4145b12c7-image.png
      Can you help me find the fault?
      Regards,
      Inna

      StefanP74S 1 Reply Last reply Reply Quote 0
      • StefanP74S Offline
        StefanP74 @inasutin
        last edited by

        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

        I 2 Replies Last reply Reply Quote 0
        • I Offline
          inasutin @StefanP74
          last edited by

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

          1 Reply Last reply Reply Quote 0
          • I Offline
            inasutin @StefanP74
            last edited by

            @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

            LFischerL 1 Reply Last reply Reply Quote 0
            • LFischerL Offline
              LFischer @inasutin
              last edited by

              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

              1 Reply Last reply Reply Quote 0
              • L Offline
                leobaer
                last edited by

                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

                1 Reply Last reply Reply Quote 0
                • First post
                  Last post