Good but has a bug with 3.6

Yes, my website also problem with below:

Warning: Missing argument 2 for wpdb::prepare(), called in /home/content/97/11433197/html/wp-content/plugins/category-icons/category_icons.php on line 1047 and defined in /home/content/97/11433197/html/wp-includes/wp-db.php on line 992

I think it will bug.

A nice heads up would have been nice …
Anyhow, for developers this is an interesting read:
http://make.wordpress.org/core/tag/3-5-field-guide/

It’s unfortunately not a WordPress bug … it’s a developers mistake like MCM confirms 🙂
If you’re not the developer of the plugin or theme causing this error message: contact the developer so he/she can update their code.

See also: this post, Prepare Missing Argument and the previous link I posted.

wp-includes/wp-db.php in line 992:

Replace this:

function prepare( $query, $args ) {
if ( is_null( $query ) )
return;

With:

function prepare( $query, $args = null ) {
if ( is_null( $query ) )
return;

It will fix wordpress 3.6 🙂

Open buddypress-featured-members\include\bfm-functions.php

Change Line 8:
$result = $wpdb->get_results($wpdb->prepare($query), ARRAY_A);

to:
$result = $wpdb->get_results($query, ARRAY_A);

There is no need for the ‘prepare’ because the query is hard-coded.

$query = "SELECT * FROM ".$wpdb->base_prefix."usermeta WHERE meta_key = 'bfm_is_featured' AND meta_value = 1";

Check here:

http://wordpress.org/support/topic/missing-argument-2-for-wpdbprepare-17/page/2?replies=27