Error with WP 3.5: wpdb::prepare()

Hi 501dash,

here’s what you need to change in the theme-refine.php file:
FROM:
$results = $wpdb->get_results( $sql = $wpdb->prepare( "SELECT ID, form_cats FROM ". $wpdb->prefix . "cp_ad_forms WHERE form_status = 'active'" ) );
TO:
$results = $wpdb->get_results( $sql = $wpdb->prepare( "SELECT ID, form_cats FROM %s cp_ad_forms WHERE form_status = 'active'", $wpdb->prefix ) );

Regards,
Alex

AlexRayan,

I tried changing it but it didn’t work.
Can I email it to you? Maybe I am doing something totally wrong…

Thanks!

sure, email me the php files in a zip (so they don’t get blocked my mail) – alex (at) alexiz.com.

Hi

Can somebody help me. I get the following error message:

Warning: Missing argument 2 for wpdb::prepare(), called in ……plugins/secure-wordpress/inc/swUtil.php on line 137 and defined in …..wp-includes/wp-db.php on line 992

These are the lines:

Line 137 in swUtil.php
$obj->data = $wpdb->prepare($out);

Line 992 in wp-db.php
function prepare( $query, $args ) {

Thank you

Christian

Hi Christian,

Could you please post the code that is in variable $out since this is the one you would need to change. It should be defined before line 137.

Best regards,
Alex

Hi Alex

I can’t find it. I send you the file by e-mail. The answer then we can post in the forum.

Christian

@alex

Did you get my email with the file?

Christian

Hi Christian,

Yes, I did and replied to you yesterday to your email.
Just in case you didn’t get it, here’s my reply:

I looked through the file and you can actually just remove prepare() from here since the data in $out in being validated when the posts are being saved from the back end.

So, please change this line 137 from:

$obj->data = $wpdb->prepare($out);

to

$obj->data = $out;

Please let me know if it works for you.

Best regards,
Alex

Hi Alex

Thank you very much!

The error message is gone. It looks like it’s working.

Best regards

Christian

Hi

I’ve again an error in one of the php files.

Error message:
Too few arguments in…
….wp-content/themes/CherryFramework/title.php on line 29

Below the lines 21 up to 31. Line 29 are in bold.

——————————

<?php } elseif ( is_category() ) { ?>

<?php printf( theme_locals(“category_archives”).”: %s”, ‘<small>’ . single_cat_title( ”, false ) . ‘</small>’ ); ?>

<?php echo category_description(); /* displays the category’s description from the WordPress admin */ ?>

<?php } elseif ( is_tax(‘portfolio_category’) ) { ?>

<?php echo theme_locals(“portfolio_category”).”: “; ?>

——————————

Best regards

Christian

Hello Alex

I have this problem appearing when accessing my website.

`Warning: Missing argument 2 for wpdb::prepare(), called in /home/a12261/public_html/wp-content/plugins/groups/lib/core/class-groups-user.php on line 151
and defined in/home/a12261/public_html/wp-includes/wp-db.php on line 992

Please asvise
Vukistar

I made a few changes on line 151 and now it saya……………
Parse error: syntax error, unexpected T_STRING in /home……../class-groups-user.php on line 157
This is line 157
“SELECT group_id FROM $user_group_table WHERE user_id = %d”,
Please can someone advise me here.

Hi –

I am having the same problem – my warning is:

Warning: Missing argument 2 for wpdb::prepare(), called in /home/columbin/public_html/wp-content/themes/revelation-theme/lib/theme-sidebars.php on line 51 and defined in /home/columbin/public_html/wp-includes/wp-db.php on line 992

Line 51 is:
$widgetized_pages = $wpdb->get_col( $wpdb->prepare(“SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key = ‘celta_sidebar'” ) );

From a previous forum reply, I changed Line 51 to:
$widgetized_pages = $wpdb->get_col(“SELECT DISTINCT meta_value FROM $wpdb->postmeta WHERE meta_key = ‘celta_sidebar'” );

The error message no longer appears on the site, however my admin login page is completely blank, ie I can’t log in…

Can you help? Thank you!

I’m sorry to add more to the list. Ive read the info and tried to make it right but I just seem to make more errors.
My error message is;
Warning: Missing argument 2 for wpdb::prepare(), called in/wp-content/themes/dt-nimble/functions/core/core-filters.php on line 8 and defined in wp-includes/wp-db.php on line 992

core-filters file reads;
<?php

function dt_core_parents_where_filter( $where ) {
if( function_exists(‘dt_storage’) ) {
global $wpdb;
$param = dt_storage(‘where_filter_param’);
if( $param ) {
$where .= sprintf( ” AND $wpdb->posts.post_parent IN(%s)”, $wpdb->prepare($param) );
}else {
$where .= ‘ AND 1=0’;
}
}
return $where;
}

function dt_core_join_left_filter( $parts ) {
if( isset($parts[‘join’]) && !empty($parts[‘join’]) ) {
$parts[‘join’] = str_replace( ‘INNER’, ‘LEFT’, $parts[‘join’]);
}
return $parts;
}

function dt_core_media_item_remove_insert_button( $args = array() ) {
if( isset($args[‘send’]) )
$args[‘send’] = false;
return $args;
}

function dt_inset_into_post_filter ( $html, $id, $caption, $title, $align, $url ) {
if ( isset( $url ) ) {
$html = str_replace( ‘href=’, ‘class=”highslide” onclick=”return hs.expand(this)” href=’, $html );
}
return $html;
}
//add_filter( ‘image_send_to_editor’, ‘dt_inset_into_post_filter’, 10, 6 );
?>

Is it possible one of you nice people could help me out. I have contacted the theme provider but theyre person is away until th e30th Sep and I dont think I want the message for the world to see for that long.

Many Thanks in advance
Mike B

Guys I don’t want to steal topic or anything, I have same issue, can somebody help me I get warrning as well, this is code:

global $wpdb;
$sql = $wpdb->prepare( "SELECT id, name, description, options FROM ".$wpdb->prefix."_bk_loupe_settings WHERE is_active='true';");
$loupes = $wpdb->get_results( $sql );