MYSQL ERROR REPORT
- 14/08/2026 09:08:20
---------------------------------------
1191 - Can't find FULLTEXT index matching the column list

select
p.products_id,
p.label_id,
p.products_image,
p.products_quantity,
p.products_price,
p.products_fsk18,
p.products_ordered,
p.products_model,
pd.products_name,
pd.products_short_description,
pd.products_meta_title,
pd.products_meta_description,
pd.products_description,
pd.products_keywords,
IF(pd.products_name LIKE '%швабр для мыт пол смеща boomjoy e y куп по низк цен%',0,IF(pd.products_keywords LIKE '%швабр для мыт пол смеща boomjoy e y куп по низк цен%',1,IF(pd.products_name LIKE ('% швабр%') or pd.products_name LIKE ('% для%') or pd.products_name LIKE ('% мыт%') or pd.products_name LIKE ('% пол%') or pd.products_name LIKE ('% смеща%') or pd.products_name LIKE ('% boomjoy%') or pd.products_name LIKE ('% e%') or pd.products_name LIKE ('% y%') or pd.products_name LIKE ('% куп%') or pd.products_name LIKE ('% по%') or pd.products_name LIKE ('% низк%') or pd.products_name LIKE ('% цен%'),2,IF(pd.products_description LIKE ('% швабр%') or pd.products_description LIKE ('% для%') or pd.products_description LIKE ('% мыт%') or pd.products_description LIKE ('% пол%') or pd.products_description LIKE ('% смеща%') or pd.products_description LIKE ('% boomjoy%') or pd.products_description LIKE ('% e%') or pd.products_description LIKE ('% y%') or pd.products_description LIKE ('% куп%') or pd.products_description LIKE ('% по%') or pd.products_description LIKE ('% низк%') or pd.products_description LIKE ('% цен%'),3,4)))) AS searchorder,
match (pd.products_name, pd.products_description, pd.products_keywords) against ('Швабра для мытья полов смещающаяся BOOMJOY E Y купить по низкой цене' IN BOOLEAN MODE) AS head_relevance
from products_description pd
left join products p
on (p.products_id = pd.products_id)
where (match (pd.products_name) against ('Швабра для мытья полов смещающаяся BOOMJOY E Y купить по низкой цене' IN BOOLEAN MODE)
or match (pd.products_description) against ('Швабра для мытья полов смещающаяся BOOMJOY E Y купить по низкой цене' IN BOOLEAN MODE)
or match (pd.products_keywords) against ('Швабра для мытья полов смещающаяся BOOMJOY E Y купить по низкой цене' IN BOOLEAN MODE)
)
and p.products_status = '1'
and pd.language_id = '1'
and pd.products_id NOT IN ('179')

order by head_relevance desc, searchorder
limit 20
---------------------------------------
Server Name : alltorg.net
Remote Address: 2600:1f28:365:80b0:6254:d19a:12c4:4b
Referer :
Requested : /boomjoy-e-y-500.html
Trace Back : #0 vam_db_error() called at [/home/a/aseven/new.alltorg.net/public_html/inc/vam_db_query.inc.php:34]
#1 vam_db_query() called at [/home/a/aseven/new.alltorg.net/public_html/includes/classes/product.php:395]
#2 product->getSimilarProducts() called at [/home/a/aseven/new.alltorg.net/public_html/includes/modules/similar_products.php:7]
#3 include(/home/a/aseven/new.alltorg.net/public_html/includes/modules/similar_products.php) called at [/home/a/aseven/new.alltorg.net/public_html/includes/modules/product_info.php:351]
#4 include(/home/a/aseven/new.alltorg.net/public_html/includes/modules/product_info.php) called at [/home/a/aseven/new.alltorg.net/public_html/product_info.php:58]
#5 include(/home/a/aseven/new.alltorg.net/public_html/product_info.php) called at [/home/a/aseven/new.alltorg.net/public_html/manager.php:109]

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