WordPress database error on step 2.2
I’m currently evaluating v21.5 on localhost to determine if it’s right for my clients. I’m really impressed with the functionality, but I’m finding the documentation very confusing, and the underlying code very hard to debug. I’m encountering a several issues:
Firstly, I’m seeing the following database errors on step 2.2:
WordPress database error: [Multiple primary key defined] ALTER TABLE wp_wpsolr_index_history CHANGE COLUMN id id bigint unsigned auto_increment primary key
WordPress database error: [Duplicate column name 'action'] ALTER TABLE wp_wpsolr_index_history ADD COLUMN action varchar(1) not null
I’ve checked the database tables, in the first instance there is a single primary key on
id, in the second instance there is already a varchar(1) not null column named
Secondly, is it possible to return search result posts that match taxonomies in the search page? All taxonomies are selected in ‘Select data to search in’ beside my post-types, however searching for a taxonomy term returns no results. For example, searching for ‘Attractions’ yields zero results, despite there being hundreds of matching posts.
Thirdly, I’m getting an “Unknown error:60” code trying to delete the “Test index from Elastic Cloud”, and a deletion failure.
Thank you in advance.
I’ll answer here to the first question. Can you create 2 other topics for the other questions?
I’ve checked the database tables, in the first instance there is a single primary key on id, in the second instance there is already a varchar(1) not null column named action.
Try to drop the table, and deactivate/reactivate the plugin.
Ok, I’ve dropped the table again and checked only post types to index, and no more errors (the table wasn’t created in the database).
So I’ve checked Products to index – no errors.
But when I’ve checked products category to index, that’s when the errors reappeared.
What can be wrong with product categories? Currently there are 1624 categories in the store.
Ok, I’ve checked Products category in tab 2.2, the table wp_wpsolr_index_history was created, wen to tab 3 ‘send your data’, tried with option ‘Re-index all the data in place.’ after the reindex the table was still empty.
Then I’ve deleted selected post types from index, then index selected post types. The table was still empty.
It doesn’t look like it’s working.
You must be logged in to reply to this topic.