MYSQL ERROR REPORT
- 21/07/2026 01:07:37
---------------------------------------
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 '%швабр для пол с выжиман leifheit picobello plus куп по низк цен%',0,IF(pd.products_keywords LIKE '%швабр для пол с выжиман leifheit picobello plus куп по низк цен%',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 ('% leifheit%') or pd.products_name LIKE ('% picobello%') or pd.products_name LIKE ('% plus%') 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 ('% leifheit%') or pd.products_description LIKE ('% picobello%') or pd.products_description LIKE ('% plus%') 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 ('Швабра для пола с выжиманием LEIFHEIT PICOBELLO PLUS купить по низкой цене' 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 ('Швабра для пола с выжиманием LEIFHEIT PICOBELLO PLUS купить по низкой цене' IN BOOLEAN MODE)
or match (pd.products_description) against ('Швабра для пола с выжиманием LEIFHEIT PICOBELLO PLUS купить по низкой цене' IN BOOLEAN MODE)
or match (pd.products_keywords) against ('Швабра для пола с выжиманием LEIFHEIT PICOBELLO PLUS купить по низкой цене' IN BOOLEAN MODE)
)
and p.products_status = '1'
and pd.language_id = '1'
and pd.products_id NOT IN ('178')

order by head_relevance desc, searchorder
limit 20
---------------------------------------
Server Name : alltorg.net
Remote Address: 2600:1f28:365:80b0:2b2a:1ff8:c7eb:5149
Referer :
Requested : /leifheit-57000-picobello-plus.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]

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