Index building error – Ivory search 5.2
-
Hi there,
after updating Ivory search to the latest one (5.2) I noticed my search no longer works. After looking around the settings and comparing to my earlier version of the web I notice there’s an option to “build the index” which I did.However, upon building the index I got the error message as per below :
Could I get some assistance please.Content Status 2985 contents can be indexed. Index Status 0 unique content in the index 0 unique terms in the index 0 index records 1 index error(s): [post_id] 3991 - [error] Could not save index rows sql: INSERT INTO wp_is_inverted_index (post_id, term, term_reverse, score, title, content, excerpt, author, comment, tag, category, taxonomy, customfield, taxonomy_detail, customfield_detail, type, lang) VALUES (3991, 'atom', 'mota', 6, 1, 0, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'bulan', 'nalub', 6, 1, 0, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'super', 'repus', 7, 1, 1, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'bihun', 'nuhib', 8, 1, 2, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'kuah', 'hauk', 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 'product', 'en_US' ), (3991, 'instant', 'tnatsni', 7, 1, 1, 0, 0, 0, 0, 0, 1, 0, '{\"product_cat\":1}', '', 'product', 'en_US' ), (3991, 'rice', 'ecir', 6, 1, 1, 0, 0, 0, 0, 0, 0, 0, '', '', 'product', 'en_US' ), (3991, 'noodle', 'eldoon', 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 'product', 'en_US' ), (3991, 'soup', 'puos', 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 'product', 'en_US' ), (3991, '51g', 'g15', 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 'product', 'en_US' ), (3991, '5pcs', 'scp5', 5, 1, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 'product', 'en_US' ), (3991, 'noodles', 'seldoon', 2, 0, 1, 0, 0, 0, 0, 0, 1, 0, '{\"product_cat\":1}', '', 'product', 'en_US' ), (3991, 'instan', 'natsni', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, '', '', 'product', 'en_US' ), (3991, 'product', 'tcudorp', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, '', '', 'product', 'en_US' ), (3991, 'indonesia', 'aisenodni', 2, 0, 1, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'expiry', 'yripxe', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, '', '', 'product', 'en_US' ), (3991, 'date', 'etad', 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, '', '', 'product', 'en_US' ), (3991, '2022', '2202', 3, 0, 3, 0, 0, 0, 0, 0, 0, 0, '', '', 'product', 'en_US' ), (3991, '168', '861', 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, '', '{\"_sku\":1}', 'product', 'en_US' ), (3991, 'default', 'tluafed', 3, 0, 0, 0, 0, 0, 0, 0, 0, 3, '', '{\"site-sidebar-layout\":1,\"site-content-layout\":1,\"theme-transparent-header-meta\":1}', 'product', 'en_US' ), (3991, 'asian', 'naisa', 2, 0, 0, 0, 0, 0, 0, 0, 2, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'grocery', 'yrecorg', 3, 0, 0, 0, 0, 0, 0, 0, 3, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'pantry', 'yrtnap', 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'australia', 'ailartsua', 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'cheapest', 'tsepaehc', 2, 0, 0, 0, 0, 0, 0, 0, 2, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'community', 'ytinummoc', 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'free', 'eerf', 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'delivery', 'yreviled', 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'indomelb', 'blemodni', 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'makan', 'nakam', 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'melbourne', 'enruoblem', 1, 0, 0, 0, 0, 0, 0, 0, 1, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'online', 'enilno', 2, 0, 0, 0, 0, 0, 0, 0, 2, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'grocer', 'recorg', 2, 0, 0, 0, 0, 0, 0, 0, 2, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'pty', 'ytp', 2, 0, 0, 0, 0, 0, 0, 0, 2, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'ltd', 'dtl', 2, 0, 0, 0, 0, 0, 0, 0, 2, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ), (3991, 'ozgrocer', 'recorgzo', 2, 0, 0, 0, 0, 0, 0, 0, 2, 0, '{\"product_tag\":1}', '', 'product', 'en_US' ),
-
Hi there,
thanks for the prompt reply.WordPress version : 5.8.2
PHP Version : 7.4.13
MYSQL Version : 8.0.22
Astra theme version : 3.7.6Below is the content of “debug.log” post the search test I did.
====================25-Dec-2021 12:46:57 UTC] **************************** Trace start ****************************
[0]file: /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/add-search-to-menu/includes/class-is-debug.php; line: 98; function: debug_trace; class: IS_Debug
[1]function: process_error_backtrace; class: IS_Debug
[2]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/wp-db.php; line: 2056; function: mysqli_query
[3]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/wp-db.php; line: 1945; function: _do_query; class: wpdb
[4]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/wp-db.php; line: 2657; function: query; class: wpdb
[5]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-query.php; line: 3024; function: get_col; class: wpdb
[6]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-query.php; line: 3465; function: get_posts; class: WP_Query
[7]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-query.php; line: 3576; function: query; class: WP_Query
[8]file: /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/add-search-to-menu/public/partials/is-ajax-results.php; line: 57; function: __construct; class: WP_Query
[9]file: /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/add-search-to-menu/public/class-is-ajax.php; line: 99; function: require_once
[10]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php; line: 303; function: ajax_load_posts; class: IS_Ajax
[11]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php; line: 327; function: apply_filters; class: WP_Hook
[12]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/plugin.php; line: 470; function: do_action; class: WP_Hook
[13]file: /opt/bitnami/apps/wordpress/htdocs/wp-admin/admin-ajax.php; line: 187; function: do_action
[25-Dec-2021 12:46:57 UTC] WordPress database error Illegal argument to a regular expression. for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts WHER
E 1=1 AND ( ((wp_posts.post_title REGEXP ‘([[:<:]])sat|sat([[:>:]])’) OR (wp_posts.post_content REGEXP ‘([[:<:]])sat|sat([[:>:]])’) OR (wp_posts.post_excerpt REGEXP ‘([[
:<:]])sat|sat([[:>:]])’))) AND wp_posts.post_type = ‘product’ AND ((wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘inherit’)) ORDER BY wp_posts.post_title LI
KE ‘%sat%’ DESC, wp_posts.post_date DESC LIMIT 0, 10 made by do_action(‘wp_ajax_is_ajax_load_posts’), WP_Hook->do_action, WP_Hook->apply_filters, IS_Ajax->ajax_load_posts,
require_once(‘/plugins/add-search-to-menu/public/partials/is-ajax-results.php’), WP_Query->__construct, WP_Query->query, WP_Query->get_posts
[25-Dec-2021 12:47:00 UTC] [warning]: ‘mysqli_query(): (HY000/3685): Illegal argument to a regular expression.’ file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/wp-db.
php, line: 2056
[25-Dec-2021 12:47:00 UTC] **************************** Trace start ****************************
[0]file: /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/add-search-to-menu/includes/class-is-debug.php; line: 98; function: debug_trace; class: IS_Debug
[1]function: process_error_backtrace; class: IS_Debug
[2]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/wp-db.php; line: 2056; function: mysqli_query
[3]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/wp-db.php; line: 1945; function: _do_query; class: wpdb
[4]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/wp-db.php; line: 2657; function: query; class: wpdb
[5]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-query.php; line: 3024; function: get_col; class: wpdb
[6]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-query.php; line: 3465; function: get_posts; class: WP_Query
[7]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-query.php; line: 3576; function: query; class: WP_Query
[8]file: /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/add-search-to-menu/public/partials/is-ajax-results.php; line: 57; function: __construct; class: WP_Query
[9]file: /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/add-search-to-menu/public/class-is-ajax.php; line: 99; function: require_once
[10]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php; line: 303; function: ajax_load_posts; class: IS_Ajax
[11]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/class-wp-hook.php; line: 327; function: apply_filters; class: WP_Hook
[12]file: /opt/bitnami/apps/wordpress/htdocs/wp-includes/plugin.php; line: 470; function: do_action; class: WP_Hook
[13]file: /opt/bitnami/apps/wordpress/htdocs/wp-admin/admin-ajax.php; line: 187; function: do_action
[25-Dec-2021 12:47:00 UTC] WordPress database error Illegal argument to a regular expression. for query SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID FROM wp_posts WHER
E 1=1 AND ( ((wp_posts.post_title REGEXP ‘([[:<:]])sate|sate([[:>:]])’) OR (wp_posts.post_content REGEXP ‘([[:<:]])sate|sate([[:>:]])’) OR (wp_posts.post_excerpt REGEXP
‘([[:<:]])sate|sate([[:>:]])’))) AND wp_posts.post_type = ‘product’ AND ((wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘inherit’)) ORDER BY wp_posts.post_ti
tle LIKE ‘%sate%’ DESC, wp_posts.post_date DESC LIMIT 0, 10 made by do_action(‘wp_ajax_is_ajax_load_posts’), WP_Hook->do_action, WP_Hook->apply_filters, IS_Ajax->ajax_load
_posts, require_once(‘/plugins/add-search-to-menu/public/partials/is-ajax-results.php’), WP_Query->__construct, WP_Query->query, WP_Query->get_posts`
- The topic ‘Index building error – Ivory search 5.2’ is closed to new replies.
