[wpsolr]

1 year, 11 months ago #29671

Can you check for errors in debug.log?
You can also monitor the Elasticsearch/Solr/Algolia query, to find the problem by executing it manually.

• This reply was modified 1 year, 11 months ago by wpsolr.

[giannissak]

1 year, 11 months ago #29674

in query monitor i’m getting this:

(removed)

• This reply was modified 1 year, 11 months ago by wpsolr.
• This reply was modified 1 year, 3 months ago by wpsolr.

[giannissak]

1 year, 11 months ago #29675

In Debug im getting :
[09-May-2022 07:37:18 UTC] Error Multiple primary key defined in Data base WordPress για αίτηση ALTER TABLE wp_wpsolr_index_history CHANGE COLUMN id id bigint unsigned auto_increment primary key από do_action(‘toplevel_page_solr_settings’), WP_Hook->do_action, WP_Hook->apply_filters, fun_set_solr_options, include(‘/plugins/wpsolr-pro/wpsolr/core/dashboard/dashboard_settings.inc.php’), wpsolr\core\classes\models\WPSOLR_Model_Meta_Type_Abstract->upgrade_database_if_model_has_no_modified_date, wpsolr\core\classes\database\WPSOLR_Database::check_db_version, wpsolr\core\classes\database\WPSOLR_Database::_create_tables, dbDelta, QM_DB->query

[wpsolr]

1 year, 11 months ago #29679

Do you have some custom code that could have modified this query?

[wpsolr]

1 year, 11 months ago #29680

Drop your table wp_wpsolr_index_history first, to get rid of this error. The table should be recreated on full reindexing.

Which version of WPSOLR do you currently use?

[giannissak]

1 year, 11 months ago #29681

i have drop the wp_wpsolr_index_history many times and keep getting the same error

i’m using the WPSOLR PRO 22.2

[wpsolr]

1 year, 11 months ago #29682

Can you copy here your current table definition?

In your database manager:
DESCRIBE wp_wpsolr_index_history;

[giannissak]

1 year, 11 months ago #29683

DESCRIBE wp_wpsolr_index_history;
id bigint(20) unsigned NO PRI NULL auto_increment
model_id varchar(100) NO NULL
model_meta_type varchar(100) NO MUL NULL
modified datetime NO MUL 0000-00-00 00:00:00
action varchar(1) NO NULL

[wpsolr]

1 year, 11 months ago #29684

Check the option ‘wdm_db’ in your database with:
SELECT * FROM wp_options where option_name = 'wdm_db'

If not already, change it to:
a:1:{s:15:"current_version";s:4:"21.5";}

This should prevent the debug.log error.

• This reply was modified 1 year, 11 months ago by wpsolr.

[giannissak]

1 year, 11 months ago #29686

no i am getting this:
Duplicate column name ‘action’ …. ALTER TABLE wp_wpsolr_index_history ADD COLUMN action varchar(1) not null από do_action(‘toplevel_page_solr_settings’), WP_Hook->do_action, WP_Hook->apply_filters, fun_set_solr_options, include(‘/plugins/wpsolr-pro/wpsolr/core/dashboard/dashboard_settings.inc.php’), wpsolr\core\classes\models\WPSOLR_Model_Meta_Type_Abstract->upgrade_database_if_model_has_no_modified_date, wpsolr\core\classes\database\WPSOLR_Database::check_db_version, wpsolr\core\classes\database\WPSOLR_Database::_create_tables, dbDelta, QM_DB->query

[wpsolr]

1 year, 11 months ago #29687

What is the results of SELECT * FROM wp_options where option_name = 'wdm_db' ?

[giannissak]

1 year, 11 months ago #29688

now it’s a:1:{s:15:”current_version”;s:4:”21.5″;}

[wpsolr]

1 year, 11 months ago #29689

1. In wpsolr-pro/wpsolr/core/classes/database/class-wpsolr-database.php, line 18, comment all content of function function check_db_version(). Replace it with one line WPSOLR_Service_Container::getOption()->set_db_current_version( $db_version );

2. Reload your screen 2.2 to set the correct version in database

3. Undo step 1.

[wpsolr]

1 year, 11 months ago #29690

I forgot:

step 1b. in wpsolr-pro/wpsolr/core/classes/models/class-wpsolr-model-meta-type-abstract.php, line 312, comment line if ( ! static::$is_checked_db_version && ( is_null( $this->column_last_updated ) ) ) { and replace it with if (true) {

[giannissak]

1 year, 11 months ago #29691

Done, still no products inside categories