Conversation
supportI get this when I install on latest version of WordPress + BBPress + Buddypress: Warning: Missing argument 2 for wpdb::prepare(), called in /home/website/public_html/wp-content/plugins/bbpress-post-ratings/plugin.php on line 147 and defined in /home/website/public_html/v2/wp-includes/wp-db.php on line 992 http://wordpress.org/plugins/bbpress-post-ratings/
Everyone should be getting this error if they’ve upgraded. I just installed it. A quick search brought me to the site below… PHP Warning: Missing argument 2 for wpdb::prepare()
Could someone reply with exactly how we should edit the plugin? I’m not savvy enough to do it myself :-S
Quick and dirty fix : in wp-content/plugins/bbpress-post-ratings/plugin.php at line 147 change prepare to query.
@mediart thanks for the reply but that means nothing to me! Could you let me know exactly how line 147 should read? (I don’t code btw, just tinker.)
Andy – Jimaroonie, did either of you get a fix for this in the end?? Have the same problem and just want to know what line 147 should read. $authorIDs = $wpdb->get_col($wpdb->prepare(“SELECT post_author FROM ” . $wpdb->posts . ” WHERE ID = ” . intval($postID) . ” LIMIT 1″));
@deswardo nope! Still a desirable feature though…
Rats I am now getting this error Missing argument 2 for wpdb::prepare(), called in /home/*******/public_html/forum/wp-content/plugins/bbpress-post-ratings/plugin.php on line 147 and defined in /home/******/public_html/forum/wp-includes/wp-db.php Any solution?
I replaced “prepare” with “query” and suggested but everyone’s Forum posting votes goes to zero and the voting buttons don’t work now. But the error message is gone.
No solution? This plugin is broken and needs fixing
Had the same problem. Guess I’ll have to find another plugin, I think there is no support for this one.
Warning: Missing argument 2 for wpdb::prepare(), called in C:\xampp\htdocs\wordpress\wp-content\plugins\bbpress-post-ratings\plugin.php on line 147 and defined in C:\xampp\htdocs\wordpress\wp-includes\wp-db.php on line 1147
Hi guys, I fixed it as follows: =================================================================== --- wp-content/plugins/bbpress-post-ratings/plugin.php (revision ) +++ wp-content/plugins/bbpress-post-ratings/plugin.php (revision ) @@ -144,7 +144,7 @@ function bbpress_post_ratings_GetPostAuthorID($postID){ global $wpdb; - $authorIDs = $wpdb->get_col($wpdb->prepare("SELECT post_author FROM " . $wpdb->posts . " WHERE ID = " . intval($postID) . " LIMIT 1")); + $authorIDs = $wpdb->get_col($wpdb->prepare("SELECT post_author FROM {$wpdb->posts} WHERE ID = %d LIMIT 1", $postID)); return $authorIDs[0]; }
Tadas – thank you! That worked 😀
Hi there, I have buddypress and bbpress on my site and with this plugin I can rate the post on the forums bbpress but the karma don’t appear in the buddypress profuile. What an hell, anyone can help me? Thank you. Marco
Everyone should be getting this error if they’ve upgraded. I just installed it. A quick search brought me to the site below… PHP Warning: Missing argument 2 for wpdb::prepare()
Could someone reply with exactly how we should edit the plugin? I’m not savvy enough to do it myself :-S
Quick and dirty fix : in wp-content/plugins/bbpress-post-ratings/plugin.php at line 147 change prepare to query.
@mediart thanks for the reply but that means nothing to me! Could you let me know exactly how line 147 should read? (I don’t code btw, just tinker.)
Andy – Jimaroonie, did either of you get a fix for this in the end?? Have the same problem and just want to know what line 147 should read. $authorIDs = $wpdb->get_col($wpdb->prepare(“SELECT post_author FROM ” . $wpdb->posts . ” WHERE ID = ” . intval($postID) . ” LIMIT 1″));
@deswardo nope! Still a desirable feature though…
Rats I am now getting this error Missing argument 2 for wpdb::prepare(), called in /home/*******/public_html/forum/wp-content/plugins/bbpress-post-ratings/plugin.php on line 147 and defined in /home/******/public_html/forum/wp-includes/wp-db.php Any solution?
I replaced “prepare” with “query” and suggested but everyone’s Forum posting votes goes to zero and the voting buttons don’t work now. But the error message is gone.
No solution? This plugin is broken and needs fixing
Had the same problem. Guess I’ll have to find another plugin, I think there is no support for this one.
Warning: Missing argument 2 for wpdb::prepare(), called in C:\xampp\htdocs\wordpress\wp-content\plugins\bbpress-post-ratings\plugin.php on line 147 and defined in C:\xampp\htdocs\wordpress\wp-includes\wp-db.php on line 1147
Hi guys, I fixed it as follows: =================================================================== --- wp-content/plugins/bbpress-post-ratings/plugin.php (revision ) +++ wp-content/plugins/bbpress-post-ratings/plugin.php (revision ) @@ -144,7 +144,7 @@ function bbpress_post_ratings_GetPostAuthorID($postID){ global $wpdb; - $authorIDs = $wpdb->get_col($wpdb->prepare("SELECT post_author FROM " . $wpdb->posts . " WHERE ID = " . intval($postID) . " LIMIT 1")); + $authorIDs = $wpdb->get_col($wpdb->prepare("SELECT post_author FROM {$wpdb->posts} WHERE ID = %d LIMIT 1", $postID)); return $authorIDs[0]; }
Tadas – thank you! That worked 😀
Hi there, I have buddypress and bbpress on my site and with this plugin I can rate the post on the forums bbpress but the karma don’t appear in the buddypress profuile. What an hell, anyone can help me? Thank you. Marco