dewzone

@donncha regarding the debug how do i check debugged files and update the site?
I am thinking to remove cloudflare.
Need to check errors that arises in the debug file? how do i check tha?

how do i update the curl version as i have terminal access in my cpanel

WordPress database error Table ‘corporat_db.nn_yoast_indexable’ doesn’t exist for query UPDATE nn_yoast_indexable SET has_public_posts = ‘0’, permalink = ‘https://www.corporatenepal.com/author/corporate-nepal/’, permalink_hash = ’54:f83d8688b374ae2e3139ac815928f658′, updated_at = ‘2020-05-11 18:01:24’ WHERE id = ‘0’ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Yoast\WP\SEO\Routes\Indexable_Indexation_Route->index_posts, Yoast\WP\SEO\Routes\Indexable_Indexation_Route->run_indexation_action, Yoast\WP\SEO\Actions\Indexation\Indexable_Post_Indexation_Action->index, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_id_and_type, Yoast\WP\SEO\Builders\Indexable_Builder->save_indexable, do_action(‘wpseo_save_indexable’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Watcher->updated_indexable, Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Watcher->update_has_public_posts, Yoast\WP\SEO\Models\Indexable->save, Yoast\WP\Lib\Model->save, Yoast\WP\Lib\ORM->save, Yoast\WP\Lib\ORM::_execute
[11-May-2020 18:01:24 UTC] WordPress database error Table ‘corporat_db.nn_yoast_indexable’ doesn’t exist for query UPDATE nn_yoast_indexable SET has_public_posts = ” WHERE object_type = ‘post’ AND object_sub_type = ‘attachment’ AND post_status = ‘inherit’ AND post_parent = ‘18392’ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Yoast\WP\SEO\Routes\Indexable_Indexation_Route->index_posts, Yoast\WP\SEO\Routes\Indexable_Indexation_Route->run_indexation_action, Yoast\WP\SEO\Actions\Indexation\Indexable_Post_Indexation_Action->index, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_id_and_type, Yoast\WP\SEO\Builders\Indexable_Builder->save_indexable, do_action(‘wpseo_save_indexable’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Watcher->updated_indexable, Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Watcher->update_has_public_posts, Yoast\WP\SEO\Helpers\Post_Helper->update_has_public_posts_on_attachments, Yoast\WP\Lib\ORM::raw_execute, Yoast\WP\Lib\ORM::_execute
[11-May-2020 18:01:24 UTC] WordPress database error Table ‘corporat_db.nn_yoast_indexable’ doesn’t exist for query INSERT INTO nn_yoast_indexable (object_id, object_type, object_sub_type, permalink, primary_focus_keyword_score, readability_score, is_cornerstone, is_robots_noindex, is_robots_nofollow, is_robots_noimageindex, is_robots_noarchive, is_robots_nosnippet, open_graph_image, open_graph_image_id, open_graph_image_source, open_graph_image_meta, twitter_image, twitter_image_id, twitter_image_source, primary_focus_keyword, canonical, title, description, breadcrumb_title, open_graph_title, open_graph_description, twitter_title, twitter_description, author_id, post_parent, number_of_pages, post_status, is_protected, is_public, has_public_posts, blog_id, permalink_hash, created_at, updated_at) VALUES (‘18392’, ‘post’, ‘attachment’, ‘https://www.corporatenepal.com/1433041031_imager/’, NULL, ‘0’, ‘0’, NULL, ‘0’, NULL, NULL, NULL, ‘https://www.corporatenepal.com/wp-content/uploads/2015/05/1433041031_imager.jpg’, ‘18392’, ‘attachment-image’, ‘{\”width\”:600,\”height\”:450,\”url\”:\”https:\\/\\/www.corporatenepal.com\\/wp-content\\/uploads\\/2015\\/05\\/1433041031_imager.jpg\”,\”path\”:\”\\/home\\/corporat\\/public_html\\/wp-content\\/uploads\\/2015\\/05\\/1433041031_imager.jpg\”,\”size\”:\”full\”,\”id\”:18392,\”alt\”:\”\”,\”pixels\”:270000,\”type\”:\”image\\/jpeg\”}’, ‘https://www.corporatenepal.com/wp-content/uploads/2015/05/1433041031_imager.jpg’, ‘18392’, ‘attachment-image’, NULL, NULL, NULL, NULL, ‘1433041031_imager’, NULL, NULL, NULL, NULL, ’18’, ‘0’, NULL, ‘inherit’, ‘0’, ‘0’, ‘0’, ‘1’, ’49:78da7e57d1453fb6640d372defa13513′, ‘2020-05-11 18:01:24’, ‘2020-05-11 18:01:24’) made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Yoast\WP\SEO\Routes\Indexable_Indexation_Route->index_posts, Yoast\WP\SEO\Routes\Indexable_Indexation_Route->run_indexation_action, Yoast\WP\SEO\Actions\Indexation\Indexable_Post_Indexation_Action->index, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_id_and_type, Yoast\WP\SEO\Builders\Indexable_Builder->save_indexable, Yoast\WP\SEO\Models\Indexable->save, Yoast\WP\Lib\Model->save, Yoast\WP\Lib\ORM->save, Yoast\WP\Lib\ORM::_execute
[11-May-2020 18:01:24 UTC] WordPress database error Table ‘corporat_db.nn_yoast_indexable_hierarchy’ doesn’t exist for query DELETE FROM nn_yoast_indexable_hierarchy WHERE indexable_id = ‘0’ made by require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, Yoast\WP\SEO\Routes\Indexable_Indexation_Route->index_posts, Yoast\WP\SEO\Routes\Indexable_Indexation_Route->run_indexation_action, Yoast\WP\SEO\Actions\Indexation\Indexable_Post_Indexation_Action->index, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_id_and_type, Yoast\WP\SEO\Builders\Indexable_Hierarchy_Builder->build, Yoast\WP\SEO\Repositories\Indexable_Hierarchy_Repository->clear_ancestors, Yoast\WP\Lib\ORM->delete_many, Yoast\WP\Lib\ORM::_execute
[11-May-2020 18:12:51 UTC]

This was the last error from yoast after this there are no any from yoast. But my website is loading way too slow..
where as the https://english.corporatenepal.com with same yoast n settins run way faster loads within a second
and the main https://corporatenepal.com loads way slower according my hosting provider the above yoast error was the slowest query in the website. And i dont know how to fix this.

Kindly assist.

@pcosta88 @mazedulislamkhan @marcanor

@mazedulislamkhan @marcanor @pcosta88

for 4. number ques.
any more solutions?

• This reply was modified 6 years ago by Marius L. J.. Reason: Removed screenshot with confidential information in it

i completed the 87000* objects processing and after the indexing again on tools there was speed up site button appeared. And it shows 8500* objects.
i tried running it and it showed something went wrong.
Trying again.

@marcanor Hello,

no i am not using any multilingual plugin. As one language is corporatenepal.com and another language is of english.corporatenepal.com

i have made them seperate and also recently updated to the latest yoast 14.1.

also can you let me know how to run cli from terminal i.e if i have to be in the wordpress-seo directory from terminal and then run php wp-cli.phar yoast index?

or where is the location to run?

after the update i had running the indexing from few hours its currently 37000/87000*
lets see if it gets completed manually or not.
Also kindly let me know to use wp-cli.. I have seen that only wp yoast index is needed to run but i need on which directory it needs to be executed.