Re-index table issue

Resolved patriciapg93
(@patriciapg93)

3 years, 6 months ago
Hi,

I have just installed the plugin. I went to settings and clicked the “Re-index table” button. It seems that the process was successful. Console logs:
```
{"offset": 0,"start": true,"found_posts": 515}
.
.
.
{"offset": 500,"start": false,"found_posts": "515"}
{"offset": "515","start": false,"found_posts": "515"}
{"offset": 0,"start": false,"found_posts": "515"}
Reindex finished!
```
Once it has finished, in the settings page it shows 515 indexed products, but when I update de page, it shows 0.

I have also tried to use the widget (on the widget page and also with shortcode) but it always shows the following text: “Please go to plugins settings page and click on “Reindex table” button.”.

Can someone help me please?

BTW, I’m using WordPress v6.0 and PHP v7.3.33.

Thank you in advance.
- This topic was modified 3 years, 6 months ago by patriciapg93.

Viewing 5 replies - 1 through 5 (of 5 total)

Plugin Author ILLID
(@mihail-barinov)

3 years, 6 months ago

Hi,

Please try the following – enable debug mode by following this article and then try to re-index one more time. After this check your debug.log file for any error messages and let me know about them.

Regards

Thread Starter patriciapg93
(@patriciapg93)

3 years, 6 months ago

Hi,

I have enabled debug mode and checked the logs. Here you have the first 55 lines of logs. The file has almost 600 but it seems to repeat this. If you need the full debug.log, how can I send it to you?

Thanks for your help!

[22-Sep-2022 16:36:16 UTC] Error Table 'xcn_e_events' already exists de la base de datos de WordPress para la consulta CREATE TABLEXcN_e_events` (
id bigint(20) unsigned auto_increment primary key,
event_data text null,
created_at datetime not null
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; realizada por require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Plugin->init, Elementor\Plugin->init_components, Elementor\Core\Admin\Admin->__construct, Elementor\Plugin->init_common, Elementor\Core\Common\App->init_components, Elementor\Core\Common\Modules\EventTracker\Module->__construct, Elementor\Core\Common\Modules\EventTracker\DB->__construct, Elementor\Core\Common\Modules\EventTracker\DB->create_table
[22-Sep-2022 16:36:16 UTC] Error Duplicate key name ‘created_at_index’ de la base de datos de WordPress para la consulta ALTER TABLE XcN_e_events
ADD INDEX created_at_index (created_at)
realizada por require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Plugin->init, Elementor\Plugin->init_components, Elementor\Core\Admin\Admin->__construct, Elementor\Plugin->init_common, Elementor\Core\Common\App->init_components, Elementor\Core\Common\Modules\EventTracker\Module->__construct, Elementor\Core\Common\Modules\EventTracker\DB->__construct, Elementor\Core\Common\Modules\EventTracker\DB->add_indexes
[22-Sep-2022 16:36:17 UTC] Error Table ‘xcn_wc_reserved_stock’ already exists de la base de datos de WordPress para la consulta
CREATE TABLE XcN_wc_reserved_stock (
order_id bigint(20) NOT NULL,
product_id bigint(20) NOT NULL,
stock_quantity double NOT NULL DEFAULT 0,
timestamp datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
expires datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
PRIMARY KEY (order_id, product_id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
realizada por require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Installer->install, Automattic\WooCommerce\Blocks\Installer->maybe_create_tables, Automattic\WooCommerce\Blocks\Installer->maybe_create_table
[22-Sep-2022 16:36:19 UTC] Error Table ‘xcn_e_events’ already exists de la base de datos de WordPress para la consulta CREATE TABLE XcN_e_events (
id bigint(20) unsigned auto_increment primary key,
event_data text null,
created_at datetime not null
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; realizada por require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Plugin->init, Elementor\Plugin->init_components, Elementor\Core\Admin\Admin->__construct, Elementor\Plugin->init_common, Elementor\Core\Common\App->init_components, Elementor\Core\Common\Modules\EventTracker\Module->__construct, Elementor\Core\Common\Modules\EventTracker\DB->__construct, Elementor\Core\Common\Modules\EventTracker\DB->create_table
[22-Sep-2022 16:36:19 UTC] Error Duplicate key name ‘created_at_index’ de la base de datos de WordPress para la consulta ALTER TABLE XcN_e_events
ADD INDEX created_at_index (created_at)
realizada por require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Plugin->init, Elementor\Plugin->init_components, Elementor\Core\Admin\Admin->__construct, Elementor\Plugin->init_common, Elementor\Core\Common\App->init_components, Elementor\Core\Common\Modules\EventTracker\Module->__construct, Elementor\Core\Common\Modules\EventTracker\DB->__construct, Elementor\Core\Common\Modules\EventTracker\DB->add_indexes
[22-Sep-2022 16:36:19 UTC] Error Table ‘xcn_wc_reserved_stock’ already exists de la base de datos de WordPress para la consulta
CREATE TABLE XcN_wc_reserved_stock (
order_id bigint(20) NOT NULL,
product_id bigint(20) NOT NULL,
stock_quantity double NOT NULL DEFAULT 0,
timestamp datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
expires datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
PRIMARY KEY (order_id, product_id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
realizada por require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Installer->install, Automattic\WooCommerce\Blocks\Installer->maybe_create_tables, Automattic\WooCommerce\Blocks\Installer->maybe_create_table
[22-Sep-2022 16:36:32 UTC] Error Table ‘xcn_e_events’ already exists de la base de datos de WordPress para la consulta CREATE TABLE XcN_e_events (
id bigint(20) unsigned auto_increment primary key,
event_data text null,
created_at datetime not null
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci; realizada por require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Plugin->init, Elementor\Plugin->init_components, Elementor\Core\Admin\Admin->__construct, Elementor\Plugin->init_common, Elementor\Core\Common\App->init_components, Elementor\Core\Common\Modules\EventTracker\Module->__construct, Elementor\Core\Common\Modules\EventTracker\DB->__construct, Elementor\Core\Common\Modules\EventTracker\DB->create_table
[22-Sep-2022 16:36:32 UTC] Error Duplicate key name ‘created_at_index’ de la base de datos de WordPress para la consulta ALTER TABLE XcN_e_events
ADD INDEX created_at_index (created_at)
realizada por require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook->apply_filters, Elementor\Plugin->init, Elementor\Plugin->init_components, Elementor\Core\Admin\Admin->__construct, Elementor\Plugin->init_common, Elementor\Core\Common\App->init_components, Elementor\Core\Common\Modules\EventTracker\Module->__construct, Elementor\Core\Common\Modules\EventTracker\DB->__construct, Elementor\Core\Common\Modules\EventTracker\DB->add_indexes
[22-Sep-2022 16:36:32 UTC] Error Table ‘xcn_wc_reserved_stock’ already exists de la base de datos de WordPress para la consulta
CREATE TABLE XcN_wc_reserved_stock (
order_id bigint(20) NOT NULL,
product_id bigint(20) NOT NULL,
stock_quantity double NOT NULL DEFAULT 0,
timestamp datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
expires datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
PRIMARY KEY (order_id, product_id)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci;
realizada por require_once(‘wp-admin/admin.php’), do_action(‘admin_init’), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Installer->install, Automattic\WooCommerce\Blocks\Installer->maybe_create_tables, Automattic\WooCommerce\Blocks\Installer->maybe_create_table`

Plugin Author ILLID
(@mihail-barinov)

3 years, 6 months ago

Thanks, but from this part of debug.log file I don’t see any info regarding search plugin issue. Can you please send full debug.log file to support@advanced-woo-search.com ?

Regards

Thread Starter patriciapg93
(@patriciapg93)

3 years, 6 months ago

Hi,

I have just send the file to you via emai.

I look forward to receiving your response.

Thank you very much.

Thread Starter patriciapg93
(@patriciapg93)

3 years, 5 months ago

Hi,

I finally solved the issue! It was something related with the tables on my database. It seems the prefix was wrong and it was causing an error because it is case sensitive.

This is the error that was appearing in the logs.

Thank you very much for your support!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Re-index table issue’ is closed to new replies.