Jump to content

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


Go to solution Solved by topek,

Recommended Posts

Posted

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.

Posted

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.

Posted

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.

Posted
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.

Posted

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:

obraz.png.f868933ed27d06283e641f3b09d40c75.png

 

What next then?

Posted

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. 

 

Posted
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

Posted

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

Posted

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

Posted
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

Posted

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}

 

Posted

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.

  • 3 weeks later...
  • 4 weeks later...
  • Solution
Posted
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.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...