Mutterz108
-
Posts
6 -
Joined
-
Last visited
Content Type
Downloads
Release Notes
IPS4 Guides
IPS4 Developer Documentation
Invision Community Blog
Development Blog
Deprecation Tracker
Providers Directory
Forums
Events
Store
Gallery
Posts posted by Mutterz108
-
-
SELECT main.*, ((MATCH(index_title) AGAINST ('breeze' IN BOOLEAN MODE)*5)+(MATCH(index_content,index_title) AGAINST ('breeze' 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 `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\\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 ('breeze' IN BOOLEAN MODE) AND ( index_permissions = '*' OR ( FIND_IN_SET(4,index_permissions) OR FIND_IN_SET('m1',index_permissions) OR FIND_IN_SET('ca',index_permissions) OR FIND_IN_SET('cm',index_permissions) OR FIND_IN_SET('c121',index_permissions) OR FIND_IN_SET('c1',index_permissions) OR FIND_IN_SET('c2',index_permissions) OR FIND_IN_SET('c12532',index_permissions) OR FIND_IN_SET('cm1',index_permissions) OR FIND_IN_SET('cm2',index_permissions) OR FIND_IN_SET('cm12532',index_permissions) ) ) ORDER BY calcscore DESC LIMIT 0,25
IPS\Db\Exception: DOUBLE value is out of range in '(match `cruise`.`main`.`index_title` against ('breeze' in boolean mode)) * 5 + (match `cruise`.`main`.`index_content`,`cruise`.`main`.`index_title` against ('breeze' in boolean mode))' (1690)
#0 /www/wwwroot/*********.com/system/Db/Select.php(446): IPS\Db\_Select->runQuery()
#1 [internal function]: IPS\Db\_Select->rewind()
#2 /www/wwwroot/*********.com/system/Content/Search/Mysql/Query.php(1336): iterator_to_array()
#3 /www/wwwroot/*********.com/applications/core/modules/front/search/search.php(761): IPS\Content\Search\Mysql\_Query->search()
#4 /www/wwwroot/*********.com/applications/core/modules/front/search/search.php(126): IPS\core\modules\front\search\_search->_results()
#5 /www/wwwroot/*********.com/system/Dispatcher/Controller.php(118): IPS\core\modules\front\search\_search->manage()
#6 /www/wwwroot/*********.com/system/Dispatcher/Dispatcher.php(153): IPS\Dispatcher\_Controller->execute()
#7 /www/wwwroot/*********.com/index.php(13): IPS\_Dispatcher->run()
#8 {main} -
Sorry if I missed this someplace but when using the giveaway option are people able to return daily for additional entries or is it only one entry for each person? Thanks in advance!
-
6 hours ago, Jim M said:
I checked your software download and all applications are included. Please double check that you are uploading the files to the correct spot on your server. Then you will need to install them at ACP -> System -> Applications, applications not installed would show up at the bottom.
Thanks! I found them at the bottom.
-
With this addon can it automatically create the Images and Topics pages for each Club made? Or can it be used to add them with a one click sort of thing during creation?
-
I did the upgrade to the monthly payment a few days ago but I don't seem to have the Commerce, Pages or Blog under my applications tab. I did redownload the latest package and upload it thinking that may do it but still nothing. When I check my license key in the ACP it says I have access to everything. Any ideas?
Getting this error when using search on my boards
in Classic self-hosted technical help
Posted
Updated