The OAuth 2.0 access token has expired, and a refresh token is not available. Re

I just applied the patch to options.php from that ticket and the tracking is now working.

Thank you Alin!

I’ll just wait for an official fix (update) from you through the WP repository.

Awesome response time — you rock!!!

Alin,
which is better to do – apply the patch to options.php or use the fix you created?

Wait for the update, that fix won’t work either. As a general rule, never modify the core files, except for testings, of course.

@kenneth-feldman or @juggledad can you do a grep or in-file search (I believe cPanel file manager has that) under /wp-content/plugins/ and /wp-content/themes/ and search for transient_timeout.

Upload the results in a file or post them here.

FYI: GADWP 4.8.2 is ready for deploy, if it passes all tests it should be available within hours.

with the patched version of the plugin from above and the option.php patch removed, both sites were working, but now one has stopped.

I did find one plugin – Backupbuddy – with this code

function backupbuddy_transient_delete( $expired = true ) {
	global $_wp_using_ext_object_cache;
	if ( !$_wp_using_ext_object_cache ) {
		global $wpdb;
		$sql = "DELETE FROM <code>$wpdb->options</code> WHERE option_name LIKE '_transient_timeout%'";
		if ( $expired ) {
			$time = time();
			$sql .=  " AND option_value < $time";
		}
		$wpdb->query( $sql );
		$wpdb->query( "OPTIMIZE TABLE $wpdb->options" );
	}
}
add_action( 'wp_scheduled_delete', 'backupbuddy_clean_transients' );
add_action( 'after_db_upgrade', 'backupbuddy_clear_transients' );

and another – GravityForms – with this code

if (is_multisite()) {
            $sql = "
                 DELETE FROM $wpdb->sitemeta
                 WHERE meta_key LIKE '_site_transient_timeout_GFCache_%' OR
                 meta_key LIKE '_site_transient_GFCache_%'
                ";
        } else {
            $sql = "
                 DELETE FROM $wpdb->options
                 WHERE option_name LIKE '_transient_timeout_GFCache_%' OR
                 option_name LIKE '_transient_GFCache_%'
                ";

nothing found in the themes folder

Thanks, GravityForms is ok, they are deleting both timeouts and values, and they also delete it only for their plugin.

Backupbuddy is the culpirt, they are doing it wrong.

and to confirm, there was a backup at 8:56 PM last night

will the new version of the plugin deal with this or will it take the change to the WP core to fix it?

Yes, it will, no worries.

FYI: The above plugin (and I’m sure is not the only one) breaks all transients in your database! That’s going to have a negative impact on the overall performance and functionality of your site! So, the developers of that plugin and similar ones should fix the issue ASAP.

Hi Alin,

Thanks again for all of this.

Here’s what I found when searching the plugins folder of one of my affected sites:

(I’ve removed the results from your plugin.)

Is this enough for you? Do I need to include more from each of the files?

root@XXXXXXX [/home/xxxxxxx/public_html/wp-content/plugins]# grep -r -H “transient_timeout” *
backupbuddy/init_global.php: $sql = “DELETE FROM $wpdb->options WHERE option_name LIKE ‘_transient_timeout%'”;
gravityforms/common.php: WHERE meta_key LIKE ‘_site_transient_timeout_GFCache_%’ OR
gravityforms/common.php: WHERE option_name LIKE ‘_transient_timeout_GFCache_%’ OR
jetpack/modules/protect/transient-cleanup.php: SELECT REPLACE(option_name, ‘_transient_timeout_jpp_’, ”) AS transient_name
jetpack/modules/protect/transient-cleanup.php: $options_names[] = ‘_transient_timeout_jpp_’ . $transient;
rvg-optimize-database/rvg-optimize-db.php: option_name LIKE ‘_transient_timeout_%’
rvg-optimize-database/rvg-optimize-db.php: OR option_name LIKE ‘_site_transient_timeout_%’
rvg-optimize-database/rvg-optimize-db.php: option_name LIKE ‘_transient_timeout_%’
rvg-optimize-database/rvg-optimize-db.php: OR option_name LIKE ‘_site_transient_timeout_%’
rvg-optimize-database/rvg-optimize-db.php: option_name LIKE ‘_transient_timeout_%’
rvg-optimize-database/rvg-optimize-db.php: OR option_name LIKE ‘_site_transient_timeout_%’
rvg-optimize-database/rvg-optimize-db.php: option_name LIKE ‘_transient_timeout_%’
rvg-optimize-database/rvg-optimize-db.php: OR option_name LIKE ‘_site_transient_timeout_%’
wordpress-seo/inc/class-wpseo-utils.php: $query .= ” option_name LIKE ‘_transient_wpseo_sitemap_cache_” . $sitemap_type . “_%’ OR option_name LIKE ‘_transient_timeout_wpseo_sitemap_cache_” . $sitemap_type . “_%'”;
wordpress-seo/inc/class-wpseo-utils.php: $query .= ” option_name LIKE ‘_transient_wpseo_sitemap_%’ OR option_name LIKE ‘_transient_timeout_wpseo_sitemap_%'”;

I’m a longtime user of Backup Buddy. The iThemes developers are quite responsive.

Is there something that I can relay to them which might be helpful?

Just updated two sites to GADWP 4.8.2, and both seem to be working now. Not getting any errors.

Will monitor over the next few days.

Thank you so much Alin!!!

@kenneth-feldman backupbuddy & rvg-optimize-database are definitively doing it wrong ??

wordpress-seo and jetpack are ok, since they are handling their own transients.

Alin > Thank you for being so responsive. You certainly know your stuff!

Kenneth Feldman> did you log this with iThemes? If not I can, or maybe I should also do it so there is more than 1 voice. Also, you mentioned that you set up a GA account for each website. how come? I find that my one account makes it very easy to check up on all of my customers.

apologies for this being off topic.

Cheers,

John.