help getting global site search working

Hi, i need help getting global site search working.
I know it needs site indexer so installed it, but it did not create the necessary tables on the database (network prefix ones).

Disabling/reinstalling the plugin will not create the tables. The theme is just twenty fourteen with cosmetic changes.

So i am not good at this (coding/mysql). So i granted access to the site i need someone to get both plugins working properly.

Let me know if you need something else.

Thanks.

  • Adam Czajczyk

    Hello Michael,

    I hope you're well today and thank you for your question!

    The Post Indexer will not by default index any post from before it was installed, only those that were posted afterwards. To index older posts - thus make Global Site Search work - you will want to use "Re-build index" option that will force "Post Indexer" to run through entire database.

    This however may take a bit of time since posts are indexed in batches triggered by WP Cron calls (so the better traffic your site is getting, the more accurate results). Would you please give it a try and let me know if it helped?

    Best regards,
    Adam

  • Michael

    I'm aware of this. It can't happen because the tables don't exist on the database for some reason. I don't know how to fix the database.

    [09-Jan-2016 19:09:27 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress > 0 ORDER BY rebuild_updatedate ASC LIMIT 5 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_secondpass, postindexermodel->get_rebuilding_blogs
    [09-Jan-2016 19:09:27 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress = 0 ORDER BY rebuild_updatedate ASC LIMIT 25 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_firstpass, postindexermodel->get_justqueued_blogs
    [09-Jan-2016 19:09:32 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress > 0 ORDER BY rebuild_updatedate ASC LIMIT 5 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_secondpass, postindexermodel->get_rebuilding_blogs
    [09-Jan-2016 19:09:32 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress = 0 ORDER BY rebuild_updatedate ASC LIMIT 25 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_firstpass, postindexermodel->get_justqueued_blogs
    [09-Jan-2016 19:09:41 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress > 0 ORDER BY rebuild_updatedate ASC LIMIT 5 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_secondpass, postindexermodel->get_rebuilding_blogs
    [09-Jan-2016 19:09:41 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress = 0 ORDER BY rebuild_updatedate ASC LIMIT 25 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_firstpass, postindexermodel->get_justqueued_blogs
    [09-Jan-2016 19:10:21 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress > 0 ORDER BY rebuild_updatedate ASC LIMIT 5 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_secondpass, postindexermodel->get_rebuilding_blogs
    [09-Jan-2016 19:10:21 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress = 0 ORDER BY rebuild_updatedate ASC LIMIT 25 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_firstpass, postindexermodel->get_justqueued_blogs
    [09-Jan-2016 19:10:32 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress > 0 ORDER BY rebuild_updatedate ASC LIMIT 5 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_secondpass, postindexermodel->get_rebuilding_blogs
    [09-Jan-2016 19:10:32 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress = 0 ORDER BY rebuild_updatedate ASC LIMIT 25 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_firstpass, postindexermodel->get_justqueued_blogs
    [09-Jan-2016 19:10:57 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress > 0 ORDER BY rebuild_updatedate ASC LIMIT 5 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_secondpass, postindexermodel->get_rebuilding_blogs
    [09-Jan-2016 19:10:57 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress = 0 ORDER BY rebuild_updatedate ASC LIMIT 25 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_firstpass, postindexermodel->get_justqueued_blogs
    [09-Jan-2016 19:10:58 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress > 0 ORDER BY rebuild_updatedate ASC LIMIT 5 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_secondpass, postindexermodel->get_rebuilding_blogs
    [09-Jan-2016 19:10:58 UTC] WordPress database error Table 'nicoorg_wp.wp_network_rebuildqueue' doesn't exist for query SELECT * FROM wp_network_rebuildqueue WHERE rebuild_progress = 0 ORDER BY rebuild_updatedate ASC LIMIT 25 made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_firstpass, postindexermodel->get_justqueued_blogs
  • Adam Czajczyk

    Hello Michael,

    Thank you for your replay!

    I apologize for misunderstanding. I assumed that too quickly that you're referring to the fact that no data is gathered by Post Indexer itself, so the tables are simply empty. You're of course right that in case there's no Post Indexer related tables at all, it cannot work.

    I admit that I'm not sure why the tables weren't created. Would I be right guessing that you've already tried to re-install Post Indexer and it didn't help? If so, please follow these steps:

    1. login to your database via phpMyAdmin
    2. go to "Import" tab
    3.extract an attached .zip file to your local storage
    3. select "post-indexer.sql" file from your local storage in "Import" page of phpMyAdmin and hit "Execute"

    Please make a backup of your site first and let me know if it worked for you!

    Best regards,
    Adam

  • Michael

    So yeah there's a column "meta_robots" used by YOAST'S "WORDPRESS SEO" Plugin.
    https://yoast.com/wordpress/plugins/meta-robots-wordpress-plugin/

    I think it is used for when you a set a post "no index" on Wordpress Seo plugin.
    I can't delete this, i need it.

    Any work around so the indexer ignore this additional field?

    PS: I'm kinda in a hurry getting this thing working and so far all day Monday and Tuesday no replies here. I was told support was 24/7. It isn't.

  • Adam Czajczyk

    Hello Michael!

    It seems that the "meta_robots" field was added by "Meta Robots" plugin which is no longer developed and has been replaced with well known Yoast SEO. There's even no old package to be downloaded from WP repository in order to check its code.

    I have however installed Yoast SEO on my Multisite and it seems it's neither adding "meta_robots" column nor making use of it. I suppose the "original" column is inside "wp_posts" table, is that right?

    If so, I'm pretty sure you may safely remove this column as Yoast SEO now stores that data as a "post meta" value. Not having access to the deprecated "Meta Robots" plugin though I'm not able to 100% confirm that so you may either want to ask Yoast's support team or just give it a try. In case of latter one: please make a backup of your db so you could restore it in case anything went wrong.

    Alternatively, if you still have the "Meta Robots" plugin (which was either a predecessor of Yoast SEO or its extension in the past) you may want to share it with me (privately) so I could test and confirm this on my own setup.

    Best regards,
    Adam

  • Michael

    Hi, i have dropped those columns and indexing started. Results started appearing. I a have a few errors on the log:
    1)
    WordPress database error Duplicate entry 'jpn' for key 'slug' for query INSERT INTO 'wp_network_terms' ('name', 'slug', 'term_group') VALUES ('JPN', 'jpn', 0) made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_secondpass, postindexermodel->index_tax, postindexermodel->insert_or_get_term
    2)
    WordPress database error Duplicate entry 'action-adventure' for key 'slug' for query INSERT INTO 'wp_network_terms' ('name', 'slug', 'term_group') VALUES ('action adventure', 'action-adventure', 0) made by do_action_ref_array, call_user_func_array, postindexercron->process_rebuild_secondpass, postindexermodel->index_tax, postindexermodel->insert_or_get_term

    Any idea how to solve these?

  • Adam Czajczyk

    Hello Michael,

    Thank you for letting me know that Post Indexer started to index posts, I'm really happy we finally managed to get it working :slight_smile:

    As for these new errors. From what I can see, it's warning abut duplicate terms (and terms may only be unique) which I think may happen a lot in case of Multisite. Tags could be good example here.

    That said, I think this could be safely ignored but let me make sure of it, if you don't mind. I've already asked one of our developers to lend me a hand here and hopefully he'll be able to shed some light on this. Please note though that his response time may be a bit longer than mine here on support forum as he deals with a lot of complex questions on daily basis.

    Please keep an eye on the thread and I'll keep you informed!

    Best regards,
    Adam

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.