jacksmithy

Please check this database error caused by Yoast SEO plugin.

the error_log file size is 175MB all error from Yoast SEO.

Thanks

[24-Jun-2022] WordPress database error Table ‘ains8_/wp_yoast_indexable_hierarchy’ is marked as crashed and should be repaired for query SELECT ancestor_id FROM wp__yoast_indexable_hierarchy WHERE indexable_id = ‘46768’ ORDER BY depth DESC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/rehub-theme/single.php’), get_header, locate_template, load_template, require_once(‘/themes/rehub-theme/header.php’), wp_head, do_action(‘wp_head’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->call_wpseo_head, do_action(‘wpseo_head’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->present_head, Yoast\WP\SEO\Presenters\Schema_Presenter->present, Yoast\WP\SEO\Presenters\Schema_Presenter->get, Yoast\WP\SEO\Presentations\Abstract_Presentation->__get, Yoast\WP\SEO\Presentations\Indexable_Presentation->generate_schema, Yoast\WP\SEO\Generators\Schema_Generator->generate, Yoast\WP\SEO\Generators\Schema_Generator->generate_graph, Yoast\WP\SEO\Generators\Schema\Breadcrumb->generate, Yoast\WP\SEO\Presentations\Abstract_Presentation->__get, Yoast\WP\SEO\Presentations\Indexable_Presentation->generate_breadcrumbs, Yoast\WP\SEO\Generators\Breadcrumbs_Generator->generate, Yoast\WP\SEO\Repositories\Indexable_Repository->get_ancestors, Yoast\WP\SEO\Repositories\Indexable_Hierarchy_Repository->find_ancestors, Yoast\WP\Lib\ORM->find_array, Yoast\WP\Lib\ORM->run, Yoast\WP\Lib\ORM::execute

Hi

Thanks for the reply. Nothing has changed with the site in question. All plugins and Yoast SEO were fine for over a year or so, however, the only plugin that is causing the site to slow down is unfortunately Yoast SEO. Perhaps this plugin is okay for smaller websites 1000 – 10000 but bigger ones, it seems to struggle by making the admin end extremely slow.

I am deactivating it for now until fix pushed through an update. In the mean time I will be giving Rank Math a try.

Kind regards

Hi there,

Thanks for getting back.

Since the the major 4.2 update everything seems to be slower. Perhaps it’s okay on smaller sites but with 300K posts sites it has gone very slow, front and back end. I would say about 4 seconds slower than it used to be.

Perhaps it is something to do with database etc. I had to disable it for now until things improve. Everything was fine prior to the 4.2 and 4.3 updates.

Kind regards

Thanks David,

I think I’ll wait until the fix is available to avoid any further issues.

Do you know when will the fix be available?

Thanks

Just quick update. Actually, you can’t edit a post or page, or create a new post or page via WordPress (not Elementor) when Elementor v3.0.0 is enabled.

• This reply was modified 4 years, 3 months ago by jacksmithy.

Thanks for getting back so promptly.

When you try to edit a post via WordPress (not Elementor) you get this error: https://pasteboard.co/JnZvxb2.jpg

Also you can’t switch between Visual and Text in WordPress’s text editor – see screenshot: https://pasteboard.co/JnZz6c1.jpg

Everything works fine when Elementor v3.0.0 disabled.

Disabled all plugins apart from Elementor v3.0.0 and the issue remained.

When reverting back to Elementor v2.9.14 some of the design backgrounds are missing.

I hope that helps.

Kind regards

Thanks David,

I think you really should check your future updates thoroughly before releasing them to the public to avoid creating any extra work for your users as well as yourself.

v2.8.5 Seems to be stable enough.

Kind regards

v2.7.1: high CPU usage (database sql) and stuck updater

v2.7.2: will bring the whole site down

Well done Elementor!

Don’t update to v2.7.2 it is even worst than v2.7.1

It will bring the whole site down this time not just high CPU usage and stuck updater.

Well done Elementor!

Further details about the errors in this topic

• This reply was modified 5 years, 2 months ago by jacksmithy.

The same is here. Disappointing

Quick update:

Elementor has just released a new update to fix the [updater stuck and high CPU] issue in today’s 2.7.2 update. Let’s hope this update won’t fire any CPUs or cause any further issues!

Elementor, Why did you release an update with major bug without back-end testing?

Testing……

——————

2.7.2 – 2019-09-16

Fix: Data updater stuck in site with large database (Topic, Topic)
Fix: Added backward compatibility for deprecated hooks in page settings (#9060, #9080)
Fix: Added support for custom document in autosave (#9070)
Fix: Changed the default slidesPerGroup from 2 to 1 in Image Carousel widget

• This reply was modified 5 years, 2 months ago by jacksmithy.

Thanks @kingneb

Very disappointing that the guys from Elementor are not interested in supporting the free users of their buggy plugin! Even though this bug is caused by them.

Disabling and enabling the plugin didn’t work for me.

Here’s what I did to get it working, just in case someone has the same issue and the Elementor staff won’t help:

1- Delete the Elementor plugin (your settings should be save – you are only deleting the files from your server – not from your database – you can backup your database to be on the safe side)

2- Disable all plugins (enable maintenance mode if you have a plugin for that – no one likes a messy site)

3- Re-install Elementor

4- Rolled back Elementor to version 2.7.0 (go to Elementor >>Tools >> Version Control >>> select 2.7.0 and hit Reinstall v2.7.0).

5- You will see update notification for Elementor v2.7.1- click update.

6- You will see this notice: Elementor Data Updater – Database update process is running in the background. Taking a while? Click here to run it now

7- Click run it now and it should work ??

8- Enable your plugins and monitor your server to be on the safe side!

Done!

I hope that helps and thanks again @kingneb for your help!

Image WebP Replacement: ON

Thanks for that.

I can’t see any errors like the once you’ve mentioned above and I can see the the Webp images sitting in the server directory.

the Webp enabled.

Can I have a full screenshot of your media settings. Just in case mine is different which is highly unlikely.

Good feature if it works

Thanks

One question

I have the website set to only accept jpg, png, gif files when uploaded by users to the server. Would that make any difference?

Despite the above, I can still see the Webp images in server’s folders.

Thanks