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.
You must be logged in to reply to this topic.