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 '%soe methylcobalamin methyl b mg ml ml methyl b methylcobalamin%',0,IF(pd.products_keywords LIKE '%soe methylcobalamin methyl b mg ml ml methyl b methylcobalamin%',1,IF(pd.products_name LIKE ('% soe%') or pd.products_name LIKE ('% methylcobalamin%') or pd.products_name LIKE ('% methyl%') or pd.products_name LIKE ('% b%') or pd.products_name LIKE ('% mg%') or pd.products_name LIKE ('% ml%') or pd.products_name LIKE ('% ml%') or pd.products_name LIKE ('% methyl%') or pd.products_name LIKE ('% b%') or pd.products_name LIKE ('% methylcobalamin%'),2,IF(pd.products_description LIKE ('% soe%') or pd.products_description LIKE ('% methylcobalamin%') or pd.products_description LIKE ('% methyl%') or pd.products_description LIKE ('% b%') or pd.products_description LIKE ('% mg%') or pd.products_description LIKE ('% ml%') or pd.products_description LIKE ('% ml%') or pd.products_description LIKE ('% methyl%') or pd.products_description LIKE ('% b%') or pd.products_description LIKE ('% methylcobalamin%'),3,4)))) AS searchorder,
match (pd.products_name, pd.products_description, pd.products_keywords) against ('SOE Methylcobalamin Methyl B mg ml ml methyl B methylcobalamin' 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 ('SOE Methylcobalamin Methyl B mg ml ml methyl B methylcobalamin' IN BOOLEAN MODE)
or match (pd.products_description) against ('SOE Methylcobalamin Methyl B mg ml ml methyl B methylcobalamin' IN BOOLEAN MODE)
or match (pd.products_keywords) against ('SOE Methylcobalamin Methyl B mg ml ml methyl B methylcobalamin' 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 ('192')

order by head_relevance desc, searchorder
limit 20
---------------------------------------
Server Name : ecohealthstore.com
Remote Address: 216.73.217.153
Referer :
Requested : /methylcobalamin-methyl-b12-25mgml-10ml.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]

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