• Resolved swudev

    (@swudev)


    I am receiving this error in the log:
    Index wp_searchable_posts does not exist

    When I look in my Algolia dashboard I see wp_searchable_posts_tmp so it does look like wp_searchable_posts is not available in my indices.

    Also what is searchable_posts vs posts in the plugin settings which one should I choose?

    What would cause the creation of wp_searchable_posts_tmp instead of wp_searchable_posts

    Hosted at WPengine.

    Thanks in advance.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Contributor rayrutjes

    (@rayrutjes)

    Hi @swudev,

    The error you are describing has popped up for several users.

    Could you try deleting the wp-content/advanced-object-cache.php file and try to re-index again?

    For some reason your WordPress stops at the last setp of the process and doesn’t detect that the indexing has finished and thus doesn’t move the index to its final name.

    I’m looking forward to fix this if possible, I’ve not been able to re-produce it yet, any more info would be appreciated.

    Hi Ray,

    I’ve been getting this as well. We are not using any WordPress caching plugin, though are doing basic nginx fastcgi cache. Cleared that cache, still getting this.

    Any luck tracking it down?

    Plugin Contributor rayrutjes

    (@rayrutjes)

    Thanks for jumping in @paulisloud,

    Can you test the plugin without nginx fastcgi cache and let me know if it works?
    Also, do you use the latest version of the plugin? 1.3.0?

    Looking forward to fix this,

    I’d of been happy to but I just logged in to Algolia again to grab my API keys for some tests with the node client, and noticed that the _tmp on the index has done away, and now only the primary wp_searchable_posts index exists.

    On a side note, we want to give certain post types priority in our ranking, and unfortunately it doesn’t happen to be the case that alphabetical ranking (either asc or desc) would be the sort order we want, so we have to look for alternatives to this approach.

    We’re thinking of using the node client to basically:

    * pull the records in the index
    * add an attribute to each record (i.e. post_type_priority)
    * establish a priority for each post type (i.e. ‘photos’ would be priority 1, ‘videos’ priority 2)
    * add this attribute as an attributeToIndex, and to customRanking, sorting either asc or desc

    It’s a lot of reading and writing, and we’d have to rerun the whole thing every time we publish a post, to get the additional meta data added to the new posts’ index record in algolia.

    Seems to me a better option would be a type of sort like so

    customRanking: [
    { ‘literal(post_type)’: [‘photos’, ‘videos’]}
    ]

    or something similar – I think you get the idea. Basically, give me more than just asc and desc, so I can provide a defined sort order for a non-numerical field.

    Would be super helpful, and save me a lot of code and your servers a lot of reading / writing.

    Plugin Contributor rayrutjes

    (@rayrutjes)

    Hi there,

    Indexing issues should be resolved in the newest version of the plugin v2.0.0.

    Feel free to re-open a new issue if you experience something similar.

    Thanks for your support.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Index wp_searchable_posts does not exist’ is closed to new replies.