Michael

The Second Post, Last Delete with Option_name has brought the site up. But there are hundreds of _created_at’s, that look orphined and undcared for in here as well.

This is NOT the way to use the Options table. Please fix this immediately, as this table has ALL its values loaded in memory on EVERY page load. And when you consider each post is 3 rows, AND that its not being maintained, AND that it contains Empty values and orphaned values… It’s not good. Atleast use Transiants. Or better yet, create a new table for them.

These are the lines that are bringing down our site. Essential Addons for Elementor-light\Traits\Generator.php

// update page data
update_option($this->uid . ‘_elements’, $this->loaded_elements);
update_option($this->uid . ‘_custom_js’, $this->custom_js_strings);
update_option($this->uid . ‘_updated_at’, get_option(‘eael_editor_updated_at’));

It appears the above script is not going to work.

Sorry, this script will work better.

DELETE wp_options FROM wp_options INNER JOIN (SELECT option_name FROM wp_options WHERE option_value = “a:0:{}” OR option_value IS NULL OR option_value = “”) AS opt2 ON opt2.option_name = wp_options.option_name

Got the same issue. 1.2 GiB of the wp_yoast_seo_links table. It is BY FAR the largest table on the db. I disabled the feature in yoast, but the table remains.

Link to disable:
https://yoast.com/help/enable-disable-link-count/

Related:
https://github.com/Yoast/wordpress-seo/issues/7519
https://www.ads-software.com/support/topic/overloaded-links-in-wp__yoast_seo_links-table-in-the-db/

*** correction: the code above needs “jQuery” instead of “jquery”

Very good chance this fixes the issue. I do not see any side effects, yet.
UPDATE wc_wpgmza SET lnglat = POINT( lng, lat )

mysqli_query(): (22023/3037): Invalid GIS data provided to function st_astext.

When visualizing the data in wc_wpgmza of row longlat with MyPHPAdmin

This is the same table and row causing the issue.

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

This also prevents us from using Automated migration tools.

I was able to get around this in other projects, and it can be used to fix the problem you face. It should work with almost any Lazy Loading. And with your project, the URL of the image’s are extremely easy to know.

https://idiallo.com/javascript/img-detect-loaded

Any way, goodluck on it. And do you mean the Premium version now has a fix?

Let me check it out. I will change my review if it works.

Thank you.

Heres a fix, but you want to delete it when they release the update.

/**
 * Delete the mad plugins files!
 */
function myprefix_custom_cron_schedule($schedules) {
	$schedules['every_six_hours'] = array(
		'interval' => 21600, // Every 6 hours
		'display'  => __('Every 6 hours'),
	);
	return $schedules;
}

add_filter('cron_schedules', 'myprefix_custom_cron_schedule');

//Schedule an action if it's not already scheduled
if(!wp_next_scheduled('myprefix_cron_hook')) {
	wp_schedule_event(time(), 'every_six_hours', 'myprefix_cron_hook');
}

///Hook into that action that'll fire every six hours
//add_action( 'myprefix_cron_hook', 'myprefix_cron_function' );

//create your function, that runs on cron
function myprefix_cron_function() {
	//your function...

	$files = glob( ABSPATH . '/wp-content/uploads/essential-addons-elementor/*'); // get all file names
	foreach($files as $file) { // iterate files
		if(is_file($file)) {
			unlink($file);
		} // delete file
	}
}

It deletes all the files every 6 hours.

• This reply was modified 4 years, 5 months ago by Michael.

@rafinkhan, we’ve got the same issue. Please resolve, immediately.

@oxydigital, you can delete them as they’re cache files. Another user has 20gb+ on the drive.