Roberto

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)

  • Thank you so much keesiemeijer it solved !! No more appearing this error !
    I will definetely contact the vendor about it !

    have a nice day
    best regards,
    Snu

    hi, i have the same error a little different but is here:

    Warning: Missing argument 2 for wpdb::prepare(), called in /home/xxxxxx/public_html/wp/wp-content/themes/xxxxxxxx/includes/admin/admin-options.php on line 843 and defined in /home/xxxxxxx/public_html/wp/wp-includes/wp-db.php on line 990

    —————–

    $ad_rev_total = $wpdb->get_var( $wpdb->prepare( "SELECT sum(mc_gross) FROM $wpdb->cp_order_info" ) );
		$customers_today = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(ID) FROM $wpdb->users INNER JOIN $wpdb->usermeta ON $wpdb->users.ID = $wpdb->usermeta.user_id WHERE $wpdb->usermeta.meta_key = %s AND ($wpdb->usermeta.meta_value NOT LIKE %s) AND $wpdb->users.user_registered >= %s", $capabilities_meta, '%administrator%', $date_today ) );
		$customers_yesterday = $wpdb->get_var( $wpdb->prepare( "SELECT COUNT(ID) FROM $wpdb->users INNER JOIN $wpdb->usermeta ON $wpdb->users.ID = $wpdb->usermeta.user_id WHERE $wpdb->usermeta.meta_key = %s AND ($wpdb->usermeta.meta_value NOT LIKE %s) AND $wpdb->users.user_registered BETWEEN %s AND %s", $capabilities_meta, '%administrator%', $date_yesterday, $date_today ) );
		$countusers = count_users();
?>

    anyone knows how to fix it ?

Viewing 2 replies - 1 through 2 (of 2 total)