Fulltextsearch

[heural]

Hi Aimeos-Team,

we have trouble with the search function (jsonapi).
We have many products "photobook" and a search for that ends up in a Mysql-memory-error.
(we need more ram
at this query:

Code: Select all

SELECT COUNT(*) AS count
FROM (
SELECT mpro.id
FROM mshop_product mpro
LEFT JOIN mshop_index_catalog AS mindca USE INDEX (idx_msindca_s_ca_lt_po, unq_msindca_p_s_cid_lt_po) ON mindca.prodid = mpro.id
LEFT JOIN mshop_index_text AS mindte ON mindte.prodid = mpro.id
WHERE ( ( mpro.siteid IN ('','1.') ) AND ( ( mindca.catid IS NOT NULL AND ( ( mindte.siteid IN ('','1.') ) AND mindte.langid = 'de' AND MATCH( mindte.content ) AGAINST( '\'fotobuch* \"fotobuch\"\'' IN BOOLEAN MODE ) > 0 OR mpro.code LIKE 'fotobuch%' ESCAPE '#' ) AND ( ( mpro.status = 1 ) AND ( mpro.type = 'event' OR mpro.start IS NULL OR mpro.start = '2025-06-05 09:46:00' ) ) ) AND ( ( mpro.status = 1 ) AND ( mpro.type = 'event' OR mpro.start IS NULL OR mpro.start = '2025-06-05 09:46:00' ) ) ) )
GROUP BY mpro.id
ORDER BY mpro.id
LIMIT 1000 OFFSET 0
) AS list

However, in investigating for that problem we found that

• the indexer is not filtering html-Tags out

• the "last AND part" is twice

[aimeos]

Thanks for your report. Are you able to create a PR with the necessary changes to improve the full text search?