WordPress database error on step 2.2

  • ukdesignservices
    Participant
    # 2 months, 3 weeks ago

    Good afternoon.

    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 action.

    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.

    Ben

    wpsolr
    Keymaster
    # 2 months, 3 weeks ago

    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.

    ukdesignservices
    Participant
    # 2 months, 3 weeks ago

    Thank you, that has solved the first issue. I’ll create individual topics for the others.

    Thanks also for the quick reply.

    Ben

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.