IPS\Db\Exception: DOUBLE value is out of range in

[topek]

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]

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]

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]

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]

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]

-del- (doesn't work)

Edited March 9, 2022 by topek

[Jim M]

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]

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 Stridgen]

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]

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 Stridgen]

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

[topek]

Yes 🙂

[Marc Stridgen]

This is very likely what is causing your issues. You need to ensure you are running stock unaltered files

 

[topek]

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]

right after rebuild it is ok then there is a problem.

[Marc Stridgen]

You will now need to reindex

[topek]

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 Stridgen]

I have created a ticket for you, and someone till be in touch as soon as possible

[topek]

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 Stridgen]

Did moving to your new hosting company resolve this issue?

[topek]

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 Stridgen]

No problem at all. Glad to hear the issue was resolved.