Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
topek Posted March 9, 2022 Posted March 9, 2022 Hello, I have problem with default search option. Maybe someone have an idea what it might be and how to fix it? Error: SELECT main.*, ((MATCH(index_title) AGAINST ('Sindelfingen' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('Sindelfingen' IN BOOLEAN MODE)))/POWER(( ( UNIX_TIMESTAMP( NOW() ) - ( CASE WHEN index_date_updated <= UNIX_TIMESTAMP( NOW() ) THEN index_date_updated ELSE 0 END )) / 3600 ) + 2,1.5) AS calcscore FROM `ibpo_core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\forums\Topic\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) OR index_class='IPS\form\Log' OR index_class='IPS\cms\Pages\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\tutorials\\Article','IPS\\tutorials\\Article\\Comment','IPS\\tutorials\\Article\\Review') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR index_class='IPS\sdstelmeter\Image' OR ( index_class IN('IPS\\quizzes\\Quiz','IPS\\quizzes\\Quiz\\Comment','IPS\\quizzes\\Quiz\\Review') ) OR ( index_class IN('IPS\\communitymap\\Markers','IPS\\communitymap\\Markers\\Comment','IPS\\communitymap\\Markers\\Review') ) ) AND MATCH(index_content,index_title) AGAINST ('Sindelfingen' IN BOOLEAN MODE) AND ( index_permissions = '*' OR ( FIND_IN_SET(3,index_permissions) OR FIND_IN_SET('m14380',index_permissions) OR FIND_IN_SET('ca',index_permissions) OR FIND_IN_SET('c2',index_permissions) OR FIND_IN_SET('c5',index_permissions) OR FIND_IN_SET('c20',index_permissions) ) ) AND index_hidden=0 ORDER BY calcscore DESC LIMIT 0,25 IPS\Db\Exception: DOUBLE value is out of range in '(((match `ciya3o_opiekunk`.`main`.`index_title` against ('Sindelfingen' in boolean mode)) * 5) + (match `ciya3o_opiekunk`.`main`.`index_content`,`ciya3o_opiekunk`.`main`.`index_title` against ('Sindelfingen' in boolean mode)))' (1690) #0 /home/klient.dhosting.pl/mediatop/Opiekunka/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #1 [internal function]: IPS\Db\_Select->rewind() #2 /home/klient.dhosting.pl/mediatop/Opiekunka/system/Content/Search/Mysql/Query.php(1302): iterator_to_array(Object(IPS\Db\Select)) #3 //applications/core/modules/front/search/search.php(728): IPS\Content\Search\Mysql\_Query->search('Sindelfingen', NULL, 17, 'or') #4 //applications/core/modules/front/search/search.php(109): IPS\core\modules\front\search\_search->_results() #5 //system/Dispatcher/Controller.php(101): IPS\core\modules\front\search\_search->manage() #6 //system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 //index.php(13): IPS\_Dispatcher->run() #8 {main} Important part I think: IPS\Db\Exception: DOUBLE value is out of range in '(((match `ciya3o_opiekunk`.`main`.`index_title` against ('Sindelfingen' in boolean mode)) * 5) + (match `ciya3o_opiekunk`.`main`.`index_content`,`ciya3o_opiekunk`.`main`.`index_title` against ('Sindelfingen' in boolean mode)))' (1690) What is exactly out of range and what would be the solution then? Thanks in advance! P.s. my developer added here the same question but I think it would be better place.
Jim M Posted March 9, 2022 Posted March 9, 2022 The number being calculated there is outside the range of a double defined in the database. There are a few third party items being recorded in there in the search index. You may wish to ensure that your database structure is correct in ACP -> Support. If this is in process of searching, please disable all third party applications/plugins and try again.
topek Posted March 9, 2022 Author Posted March 9, 2022 Hello, could you be more specific what number and how to fix it? It's a default search operation. I have 3rd party apps but the problem is in the main search code so please give me an advice how should I fix it. Thanks.
Jim M Posted March 9, 2022 Posted March 9, 2022 5 minutes ago, topek said: Hello, could you be more specific what number and how to fix it? It's a default search operation. I have 3rd party apps but the problem is in the main search code so please give me an advice how should I fix it. Thanks. Steps to fix it were included in the reply above. Please perform the following: There are a few third party items being recorded in there in the search index. You may wish to ensure that your database structure is correct in ACP -> Support. If this is in process of searching, please disable all third party applications/plugins and try again. If you continue to have issues after performing the above, we would need to inspect the installation so please ensure your access details are up to date in the Client Area.
topek Posted March 9, 2022 Author Posted March 9, 2022 Disabled all 3rd part apps and...: SELECT main.*, ((MATCH(index_title) AGAINST ('opiekunka' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('opiekunka' IN BOOLEAN MODE)))/POWER(( ( UNIX_TIMESTAMP( NOW() ) - ( CASE WHEN index_date_updated <= UNIX_TIMESTAMP( NOW() ) THEN index_date_updated ELSE 0 END )) / 3600 ) + 2,1.5) AS calcscore FROM `ibpo_core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\forums\Topic\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) OR index_class='IPS\cms\Pages\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records3','IPS\\cms\\Records\\Comment3','IPS\\cms\\Records\\Review3') ) OR ( index_class IN('IPS\\cms\\Records4','IPS\\cms\\Records\\Comment4','IPS\\cms\\Records\\Review4') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) ) AND MATCH(index_content,index_title) AGAINST ('opiekunka' IN BOOLEAN MODE) AND ( index_permissions = '*' OR ( FIND_IN_SET(4,index_permissions) OR FIND_IN_SET('m1093',index_permissions) OR FIND_IN_SET('ca',index_permissions) OR FIND_IN_SET('cm',index_permissions) ) ) ORDER BY calcscore DESC LIMIT 0,25 IPS\Db\Exception: DOUBLE value is out of range in '(((match `ciya3o_opiekunk`.`main`.`index_title` against ('opiekunka' in boolean mode)) * 5) + (match `ciya3o_opiekunk`.`main`.`index_content`,`ciya3o_opiekunk`.`main`.`index_title` against ('opiekunka' in boolean mode)))' (1690) #0 //system/Db/Select.php(446): IPS\Db\_Select->runQuery() #1 [internal function]: IPS\Db\_Select->rewind() #2 //system/Content/Search/Mysql/Query.php(1302): iterator_to_array(Object(IPS\Db\Select)) #3 //applications/core/modules/front/search/search.php(729): IPS\Content\Search\Mysql\_Query->search('opiekunka', NULL, 17, 'or') #4 //applications/core/modules/front/search/search.php(109): IPS\core\modules\front\search\_search->_results() #5 //system/Dispatcher/Controller.php(101): IPS\core\modules\front\search\_search->manage() #6 //system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 //index.php(13): IPS\_Dispatcher->run() #8 {main} SQL support tool: What next then?
topek Posted March 9, 2022 Author Posted March 9, 2022 (edited) -del- (doesn't work) Edited March 9, 2022 by topek
Jim M Posted March 9, 2022 Posted March 9, 2022 We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you.
topek Posted March 10, 2022 Author Posted March 10, 2022 8 hours ago, Jim M said: Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. Hello, updated. Please help. Thanks
Marc Posted March 10, 2022 Posted March 10, 2022 Before we do anything further, please rebuild the search index with those items switched off, then test again once the index is done. You can do this from system>Settings>Search using the button in the top right
topek Posted March 10, 2022 Author Posted March 10, 2022 Hello, Marc, we've done that before and nothing. The bug is with the built-in search engine and the search runs randomly rather than that all the time. Please help. Thanks
Marc Posted March 10, 2022 Posted March 10, 2022 18 minutes ago, topek said: Hello, Marc, we've done that before and nothing. The bug is with the built-in search engine and the search runs randomly rather than that all the time. Please help. Thanks Sorry, could I please just confirm you have run this with all plugins switched off? I can continue and take a closer look if that is the case
Marc Posted March 10, 2022 Posted March 10, 2022 This is very likely what is causing your issues. You need to ensure you are running stock unaltered files
topek Posted March 10, 2022 Author Posted March 10, 2022 Files were restored but the error still occur: SELECT main.*, ((MATCH(index_title) AGAINST ('opiekunka' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('opiekunka' IN BOOLEAN MODE)))/POWER(( ( UNIX_TIMESTAMP( NOW() ) - ( CASE WHEN index_date_updated <= UNIX_TIMESTAMP( NOW() ) THEN index_date_updated ELSE 0 END )) / 3600 ) + 2,1.5) AS calcscore FROM `ibpo_core_search_index` AS `main` WHERE ( ( index_class IN('IPS\\core\\Statuses\\Status','IPS\\core\\Statuses\\Reply') ) OR index_class='IPS\forums\Topic\Post' OR ( index_class IN('IPS\\calendar\\Event','IPS\\calendar\\Event\\Comment','IPS\\calendar\\Event\\Review') ) OR index_class='IPS\form\Log' OR index_class='IPS\cms\Pages\PageItem' OR ( index_class IN('IPS\\cms\\Records1','IPS\\cms\\Records\\Comment1','IPS\\cms\\Records\\Review1') ) OR ( index_class IN('IPS\\cms\\Records3','IPS\\cms\\Records\\Comment3','IPS\\cms\\Records\\Review3') ) OR ( index_class IN('IPS\\cms\\Records4','IPS\\cms\\Records\\Comment4','IPS\\cms\\Records\\Review4') ) OR ( index_class IN('IPS\\blog\\Entry','IPS\\blog\\Entry\\Comment') ) OR ( index_class IN('IPS\\tutorials\\Article','IPS\\tutorials\\Article\\Comment','IPS\\tutorials\\Article\\Review') ) OR ( index_class IN('IPS\\nexus\\Package\\Item','IPS\\nexus\\Package\\Review') ) OR ( index_class IN('IPS\\gallery\\Image','IPS\\gallery\\Image\\Comment','IPS\\gallery\\Image\\Review') ) OR ( index_class IN('IPS\\gallery\\Album\\Item','IPS\\gallery\\Album\\Comment','IPS\\gallery\\Album\\Review') ) OR index_class='IPS\sdstelmeter\Image' OR ( index_class IN('IPS\\quizzes\\Quiz','IPS\\quizzes\\Quiz\\Comment','IPS\\quizzes\\Quiz\\Review') ) OR ( index_class IN('IPS\\communitymap\\Markers','IPS\\communitymap\\Markers\\Comment','IPS\\communitymap\\Markers\\Review') ) ) AND MATCH(index_content,index_title) AGAINST ('opiekunka' IN BOOLEAN MODE) AND ( index_permissions = '*' OR ( FIND_IN_SET(4,index_permissions) OR FIND_IN_SET('m1093',index_permissions) OR FIND_IN_SET('ca',index_permissions) OR FIND_IN_SET('cm',index_permissions) ) ) ORDER BY calcscore DESC LIMIT 0,25 IPS\Db\Exception: DOUBLE value is out of range in '(((match `ciya3o_opiekunk`.`main`.`index_title` against ('opiekunka' in boolean mode)) * 5) + (match `ciya3o_opiekunk`.`main`.`index_content`,`ciya3o_opiekunk`.`main`.`index_title` against ('opiekunka' in boolean mode)))' (1690) #0 /home/klient.dhosting.pl/mediatop/Opiekunka/system/Db/Select.php(446): IPS\Db\_Select->runQuery() #1 [internal function]: IPS\Db\_Select->rewind() #2 /home/klient.dhosting.pl/mediatop/Opiekunka/system/Content/Search/Mysql/Query.php(1302): iterator_to_array(Object(IPS\Db\Select)) #3 /home/klient.dhosting.pl/mediatop/Opiekunka/applications/core/modules/front/search/search.php(729): IPS\Content\Search\Mysql\_Query->search('opiekunka', NULL, 17, 'or') #4 /home/klient.dhosting.pl/mediatop/Opiekunka/applications/core/modules/front/search/search.php(109): IPS\core\modules\front\search\_search->_results() #5 /home/klient.dhosting.pl/mediatop/Opiekunka/system/Dispatcher/Controller.php(101): IPS\core\modules\front\search\_search->manage() #6 /home/klient.dhosting.pl/mediatop/Opiekunka/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute() #7 /home/klient.dhosting.pl/mediatop/Opiekunka/index.php(13): IPS\_Dispatcher->run() #8 {main}
topek Posted March 10, 2022 Author Posted March 10, 2022 right after rebuild it is ok then there is a problem.
topek Posted March 10, 2022 Author Posted March 10, 2022 Indexed. The problem remained. We did it in different ways yesterday. We gave up. We fought for days. right after rebuild it is ok then there is a problem.
Marc Posted March 10, 2022 Posted March 10, 2022 I have created a ticket for you, and someone till be in touch as soon as possible
topek Posted March 10, 2022 Author Posted March 10, 2022 1 hour ago, Marc Stridgen said: I have created a ticket for you, and someone till be in touch as soon as possible Thanks!
Marc Posted March 28, 2022 Posted March 28, 2022 Did moving to your new hosting company resolve this issue?
Solution topek Posted April 20, 2022 Author Solution Posted April 20, 2022 On 3/28/2022 at 4:44 PM, Marc Stridgen said: Did moving to your new hosting company resolve this issue? Yes. The old hosting insisted that it was IPB's fault. Thanks for your help.
Marc Posted April 20, 2022 Posted April 20, 2022 No problem at all. Glad to hear the issue was resolved.
Recommended Posts