MYSQL ERROR REPORT
- 06/06/2026 06:06:27
---------------------------------------
1191 - Can't find FULLTEXT index matching the column list

select p.*, pd.*, cd.*,
IF(pd.products_name LIKE '%bk propolis nasal spray ml propolis alcohol free gluten free non gmo dairy free organic xylitol%',0,IF(pd.products_keywords LIKE '%bk propolis nasal spray ml propolis alcohol free gluten free non gmo dairy free organic xylitol%',1,IF(pd.products_name LIKE ('% bk%') or pd.products_name LIKE ('% propolis%') or pd.products_name LIKE ('% nasal%') or pd.products_name LIKE ('% spray%') or pd.products_name LIKE ('% ml%') or pd.products_name LIKE ('% propolis%') or pd.products_name LIKE ('% alcohol%') or pd.products_name LIKE ('% free%') or pd.products_name LIKE ('% gluten%') or pd.products_name LIKE ('% free%') or pd.products_name LIKE ('% non%') or pd.products_name LIKE ('% gmo%') or pd.products_name LIKE ('% dairy%') or pd.products_name LIKE ('% free%') or pd.products_name LIKE ('% organic%') or pd.products_name LIKE ('% xylitol%'),2,IF(pd.products_description LIKE ('% bk%') or pd.products_description LIKE ('% propolis%') or pd.products_description LIKE ('% nasal%') or pd.products_description LIKE ('% spray%') or pd.products_description LIKE ('% ml%') or pd.products_description LIKE ('% propolis%') or pd.products_description LIKE ('% alcohol%') or pd.products_description LIKE ('% free%') or pd.products_description LIKE ('% gluten%') or pd.products_description LIKE ('% free%') or pd.products_description LIKE ('% non%') or pd.products_description LIKE ('% gmo%') or pd.products_description LIKE ('% dairy%') or pd.products_description LIKE ('% free%') or pd.products_description LIKE ('% organic%') or pd.products_description LIKE ('% xylitol%'),3,4)))) AS searchorder,
match (pd.products_name, pd.products_description, pd.products_keywords) against ('BK Propolis Nasal Spray mL propolis alcohol free gluten free non gmo dairy free organic xylitol' IN BOOLEAN MODE) AS head_relevance
FROM
products p,
products_description pd,
products_to_categories p2c,
categories c,
categories_description cd
where (match (pd.products_name) against ('BK Propolis Nasal Spray mL propolis alcohol free gluten free non gmo dairy free organic xylitol' IN BOOLEAN MODE)
or match (pd.products_description) against ('BK Propolis Nasal Spray mL propolis alcohol free gluten free non gmo dairy free organic xylitol' IN BOOLEAN MODE)
or match (pd.products_keywords) against ('BK Propolis Nasal Spray mL propolis alcohol free gluten free non gmo dairy free organic xylitol' IN BOOLEAN MODE)
)
and p.products_id = p2c.products_id and p.products_id=pd.products_id
and p2c.categories_id = c.categories_id
and cd.categories_id = c.categories_id
and p.products_status = '1'
and pd.language_id = '2'
and pd.products_id NOT IN ('194')

order by head_relevance desc, searchorder
limit 20
---------------------------------------
Server Name : ecohealthstore.com
Remote Address: 216.73.217.153
Referer :
Requested : /bk-propolis-nasal-spray-30-ml.html
Trace Back : #0 vam_db_error() called at [/home/u359380756/domains/ecohealthstore.com/public_html/inc/vam_db_query.inc.php:34]
#1 vam_db_query() called at [/home/u359380756/domains/ecohealthstore.com/public_html/includes/classes/product.php:398]
#2 product->getSimilarProducts() called at [/home/u359380756/domains/ecohealthstore.com/public_html/includes/modules/similar_products.php:7]
#3 include(/home/u359380756/domains/ecohealthstore.com/public_html/includes/modules/similar_products.php) called at [/home/u359380756/domains/ecohealthstore.com/public_html/includes/modules/product_info.php:352]
#4 include(/home/u359380756/domains/ecohealthstore.com/public_html/includes/modules/product_info.php) called at [/home/u359380756/domains/ecohealthstore.com/public_html/product_info.php:58]
#5 include(/home/u359380756/domains/ecohealthstore.com/public_html/product_info.php) called at [/home/u359380756/domains/ecohealthstore.com/public_html/manager.php:109]

==========================================================================