Error with WP 3.5: wpdb::prepare()
-
Seems like this is a pretty common error with the new wp 3.5 release, but getting a “Missing argument 2 for wpdb::prepare() on line 75” error in the Posts page for the plugin after upgrade. It still seems to function ok for already selected posts on the front-end, but the error prevents selecting of any new posts.
Assuming we wont be getting an upgrade since it hasn’t been updated in over 2 years but though someone here might have a fix?
-
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,
AlexAlexRayan,
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,
AlexHi Alex
I can’t find it. I send you the file by e-mail. The answer then we can post in the forum.
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,
AlexHi 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 29Below 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 992Please asvise
VukistarI 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 992core-filters file reads;
<?phpfunction 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 BGuys 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 );
The topic ‘Error with WP 3.5: wpdb::prepare()’ is closed to new replies.