Mutterz108

Updated

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!

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?