zincdigitalwp

Thanks Mikko

We have created the table and built the index

Ah ok thanks for clarifying. No nothing found when debugging https://postimg.cc/njVr1crP

Thanks for responding so quickly. I’ve disabled the yoast plugin and tried again and same outcome.

I’ve pasted what shown on the front-end below which seems to be finding posts data ok

Indexing post ID 1614… Custom fields to index: _wc_review_count, _wc_rating_count, _wc_average_rating, total_sales, _sku, _regular_price, _tax_status, _tax_class, _manage_stock, _backorders, _sold_individually, _virtual, _downloadable, _download_limit, _download_expiry, _stock, _stock_status, _product_attributes, _product_version, _price, _yoast_wpseo_focuskw_text_input, _product_image_gallery Key: _wc_review_count – value: 0 Key: _wc_rating_count – value: 0 Key: _wc_average_rating – value: 0 Key: total_sales – value: 0 Key: _sku – value: SV38/CT Key: _regular_price – value: 119.15 Key: _tax_status – value: none Key: _tax_class – value: Key: _manage_stock – value: no Key: _backorders – value: no Key: _sold_individually – value: no Key: _virtual – value: no Key: _downloadable – value: no Key: _download_limit – value: -1 Key: _download_expiry – value: -1 Key: _stock – value: Key: _stock_status – value: instock Key: _product_attributes – value: pa_diameter 1 0 0 1 Key: _product_version – value: 9.9.5 Key: _price – value: 119.15 Key: _yoast_wpseo_focuskw_text_input – value: Key: _product_image_gallery – value: Indexing post excerpt: Crevice Tool for Internal cleaning Indexing post title. Title, tokenized: crevice tool Indexing post content. Post content after relevanssi_post_content: Uniquely shaped crevice tool for the removal of inaccessible dust and waste. Connects to cleaning head via safety locking mechanism to ensure no risk of separation during operation. Content, tokenized: uniquely shaped crevice tool removal inaccessible dust waste connects cleaning head safety locking mechanism ensure risk separation operation Final indexing query: INSERT IGNORE INTO wp_relevanssi (doc, term, term_reverse, content, title, comment, tag, link, author, category, excerpt, taxonomy, customfield, type, taxonomy_detail, customfield_detail, mysqlcolumn, mysqlcolumn_detail) VALUES (1614, ‘sv38’, REVERSE(‘sv38’), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, ‘post’, ”, ”, 0, ”), (1614, ‘11915’, REVERSE(‘11915’), 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, ‘post’, ”, ”, 0, ”), (1614, ‘instock’, REVERSE(‘instock’), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, ‘post’, ”, ”, 0, ”), (1614, ‘diameter’, REVERSE(‘diameter’), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, ‘post’, ”, ”, 0, ”), (1614, ‘995’, REVERSE(‘995’), 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, ‘post’, ”, ”, 0, ”), (1614, ‘crevice’, REVERSE(‘crevice’), 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘tool’, REVERSE(‘tool’), 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘internal’, REVERSE(‘internal’), 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘cleaning’, REVERSE(‘cleaning’), 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘uniquely’, REVERSE(‘uniquely’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘shaped’, REVERSE(‘shaped’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘removal’, REVERSE(‘removal’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘inaccessible’, REVERSE(‘inaccessible’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘dust’, REVERSE(‘dust’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘waste’, REVERSE(‘waste’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘connects’, REVERSE(‘connects’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘head’, REVERSE(‘head’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘safety’, REVERSE(‘safety’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘locking’, REVERSE(‘locking’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘mechanism’, REVERSE(‘mechanism’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘ensure’, REVERSE(‘ensure’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘risk’, REVERSE(‘risk’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘separation’, REVERSE(‘separation’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”), (1614, ‘operation’, REVERSE(‘operation’), 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, ‘post’, ”, ”, 0, ”)

Hi Mikko

Weirdly it says it can’t find anything for the ID (or for any others tested) but the what does the post look like in the database section pulls the content fine. We have catalogue visibility set to Shop and search results for all products. Example included below:

Debugging
The ID: 1614
Nothing found for ID 1614.

What does the post look like in the database?
The ID: 1614
“Uniquely shaped crevice tool for the removal of inaccessible dust and waste. Connects to cleaning head via safety locking mechanism to ensure no risk of separation during operation.”

Thanks for this suggestion. Followed the instructions but unfortunately the issue still remains.