Reply To: Database updates not showing

@ SWS

Will, there’s not an easy solution for this…

Try this… open the class.output.php file. Do a search for Block(. In each instance that you see , $cached = TRUE ) { on the same line; change TRUE to FALSE. There should be only 8 instances. Save and upload overwriting the original. Now Connections will never use the cached data from the main table. Doing this will definitely cause much more db usage.

Deleting the cache columns will not have any effect other than nothing will be shown for that data.

You could also try force updating every single entry…

You need to be on 0.7.9+ for this to work:

add_action( 'cn-loaded', 'cnBulkUpdate' );

function cnBulkUpdate() {

	$results = $connections->retrieve->entries();

	foreach ( $results as $row ) {

		$entry = new cnEntry( $row );
		$entry->update();
	}
}

Dropping this in the theme’s functions.php file should do it.

A few words of caution…

I didn’t test the code, but there’s no reason it should not work.

IMPORTANT: Put your site in maint mode and sure no others are on the site before you add this code because it will run on every page load. That would be bad.

I would test with a single broken entry first to make sure it’s all good; like so:

add_action( 'cn-loaded', 'cnBulkUpdate' );

function cnBulkUpdate() {

	// X == the entry ID to update.
	$results = $connections->retrieve->entries( array( 'id' => X ) );

	foreach ( $results as $row ) {

		$entry = new cnEntry( $row );
		$entry->update();
	}
}

I would also suggest increasing the PHP memory and max exec time. What you have set now should be perfectly fine; but why chance it, right?

After you test on a couple and you’re satisfied that it worked. Go ahead and do them all. Don’t worry about excluding the ones you tested on.

Let me know how it goes.