tecvoid

is anyone using the beta tester plugin successfully as a fix?
is there other issues that then need addressed by using the plugin?

general question, looking for user feedback. ill try it in the next few days and let people know.

Here is the code that finally deletes my users.

<?php
// Remove users and meta data.
function fix_wpsc_clear_customer_meta() {
global $wpdb;
require_once( ABSPATH . ‘wp-admin/includes/user.php’ );
$purge_count = 200;
$sql = “
SELECT user_id
FROM {$wpdb->usermeta}
WHERE
meta_key = ‘_wpsc_last_active’
LIMIT {$purge_count}
“;
// Do this in batches of 200 to avoid memory issues when there are too many
// anonymous users.
@set_time_limit( 0 ); // no time limit
do {
$ids = $wpdb->get_col( $sql );
$included_ids = array();
foreach ( $ids as $id ) {
$included_ids[$id] = $id;
}
$in = implode(‘,’, $included_ids);
$wpdb->query( “DELETE FROM $wpdb->users WHERE ID IN ($in)” );
$wpdb->query(“DELETE FROM $wpdb->usermeta WHERE user_id IN ($in)”);
} while ( count( $ids ) == $purge_count );
// Update number of users.
update_option( ‘user_count’, count_users() );
}

// Modify action hook for WP e-Commerce automated task.
function fix_reset_wpsc_cron() {
remove_action( ‘wpsc_hourly_cron_task’, ‘_wpsc_clear_customer_meta’ );
add_action( ‘wpsc_hourly_cron_task’, ‘fix_wpsc_clear_customer_meta’ );
}

// Do reset.
add_action( ‘wpsc_init’, ‘fix_reset_wpsc_cron’ );
fix_wpsc_clear_customer_meta();
?>

i actually have to remove

AND meta_value < NOW() – ” . WPSC_CUSTOMER_DATA_EXPIRATION . “

if i dont remove that line, i dont think that it returns any values to delete.

im sorry if i kinda took over for a minute here, ill quiet down now that i have code i can run for just a couple seconds it seems to delete my anon users.

if anyone can point out why i should not let it run without that customer expiration line please let me know.

here is the code that doesnt seem to have any errors, but it doesnt seem to be removing any anon users, im not sure what to try next, i used the NOW () command also, im just loading pages on my site hoping this is supposed to be activating the deletion, im getting a better idea of whats going on i guess i just need the right code.

<?php
// Remove users and meta data.
function fix_wpsc_clear_customer_meta() {
global $wpdb;
require_once( ABSPATH . ‘wp-admin/includes/user.php’ );
$purge_count = 200;
$sql = “
SELECT user_id
FROM {$wpdb->usermeta}
WHERE
meta_key = ‘_wpsc_last_active’
AND meta_value < UNIX_TIMESTAMP() – ” . WPSC_CUSTOMER_DATA_EXPIRATION . “
LIMIT {$purge_count}
“;
// Do this in batches of 200 to avoid memory issues when there are too many
// anonymous users.
@set_time_limit( 0 ); // no time limit
do {
$ids = $wpdb->get_col( $sql );
$included_ids = array();
foreach ( $ids as $id ) {
$included_ids[$id] = $id;
}
$in = implode(‘,’, $included_ids);
$wpdb->query( “DELETE FROM $wpdb->users WHERE ID IN ($in)” );
$wpdb->query(“DELETE FROM $wpdb->usermeta WHERE user_id IN ($in)”);
} while ( count( $ids ) == $purge_count );
// Update number of users.
update_option( ‘user_count’, count_users() );
}

// Modify action hook for WP e-Commerce automated task.
function fix_reset_wpsc_cron() {
remove_action( ‘wpsc_hourly_cron_task’, ‘_wpsc_clear_customer_meta’ );
add_action( ‘wpsc_hourly_cron_task’, ‘fix_wpsc_clear_customer_meta’ );
}

// Do reset.
add_action( ‘wpsc_init’, ‘fix_reset_wpsc_cron’ );
?>

i tried adding the code to my functions.php and keep breaking the site.

ive tried changing the time code to now, ive tried including it inside the ending }
including it outside
including it outside with a closing }

im ok at inserting code but this is a headache considering that the same code doesnt work on different production servers.

// Remove users and meta data.
function fix_wpsc_clear_customer_meta() {
	global $wpdb;
	require_once( ABSPATH . 'wp-admin/includes/user.php' );
	$purge_count = 200;
	$sql = "
		SELECT user_id
		FROM {$wpdb->usermeta}
		WHERE
		meta_key = '_wpsc_last_active'
		AND meta_value < UNIX_TIMESTAMP() - " . WPSC_CUSTOMER_DATA_EXPIRATION . "
		LIMIT {$purge_count}
	";
	// Do this in batches of 200 to avoid memory issues when there are too many
	// anonymous users.
	@set_time_limit( 0 ); // no time limit
	do {
		$ids = $wpdb->get_col( $sql );
		$included_ids = array();
		foreach ( $ids as $id ) {
			$included_ids[$id] = $id;
		}
		$in = implode(',', $included_ids);
		$wpdb->query( "DELETE FROM $wpdb->users WHERE ID IN ($in)" );
		$wpdb->query("DELETE FROM $wpdb->usermeta WHERE user_id IN ($in)");
	} while ( count( $ids ) == $purge_count );
	// Update number of users.
	update_option( 'user_count', count_users()['total_users'] );
}

// Modify action hook for WP e-Commerce automated task.
function fix_reset_wpsc_cron() {
	remove_action( 'wpsc_hourly_cron_task', '_wpsc_clear_customer_meta' );
	add_action( 'wpsc_hourly_cron_task', 'fix_wpsc_clear_customer_meta' );
}

// Do reset.
add_action( 'wpsc_init', 'fix_reset_wpsc_cron' );

@ddt i hate to beg, but could you post once more the final code for a medium skill person you used? and touch on how you trigger the call/fix event?

one last question, im avoiding upgrading to version 3.8.13.3 from version 3.8.13.1, will i need to have the latest broken version to fix?

god what an awful mess

i read 3 pages and im still not sure what the best fix is.
hostgator is pressuring me to do something for some reason, and im not sure if i should roll back wpec, and if so, how far.

or if i should upgrade to newest and put the line in the functions.php

what are you guys doing in the meantime?

i am googling around right now trying to find out if this is fixable.

like above, you can like but it doesnt give you an option to comment and it doesnt show on facebook as a like.