PHP Warning: Missing argument 2 for wpdb::prepare()

yes i’ve got the same error

I think you need to change

$commentdata = $wpdb->get_row($wpdb->prepare( "SELECT comment_ID, comment_parent FROM $wpdb->comments WHERE comment_agent = 'Disqus/1.0:{$comment->id}' LIMIT 1"), ARRAY_A);

to like this

$commentdata = $wpdb->get_row($wpdb->prepare( "SELECT comment_ID, comment_parent FROM $wpdb->comments WHERE comment_agent = 'Disqus/1.0:{%d}' LIMIT 1"), $comment->id, ARRAY_A);

So change the bottom line only — Disqua/1.0:{CHANGETHISHEREASDASHAHASDHA} and move $comment->id to just before ARRAY_A

I am testing it now on my site

Nice job! Thanks!

How is it working for you so far?

I placed the variable incorrectly in my previous post.

You can copy and paste this — replace line 285 as follows:

$commentdata = $wpdb->get_row($wpdb->prepare( “SELECT comment_ID, comment_parent FROM $wpdb->comments WHERE comment_agent = ‘Disqus/1.0:{%d}’ LIMIT 1”, $comment->id), ARRAY_A);

I just changed this on my own site, so we will see how it works.

Shouldn’t it be:

$commentdata = $wpdb->get_row($wpdb->prepare( "SELECT comment_ID, comment_parent FROM $wpdb->comments WHERE comment_agent = 'Disqus/1.0:%d' LIMIT 1", $comment->id), ARRAY_A);

The { and } character were there to get the right PHP variable.

You’re probably right, but I haven’t seen any issues with it the way I put it though.

Can you help me? Please

if (!function_exists('cp_get_ad_details')) {
    function cp_get_ad_details($postid, $catid, $locationOption = 'list') {
        global $wpdb;
        //$all_custom_fields = get_post_custom($post->ID);
        // see if there's a custom form first based on catid.
        $fid = cp_get_form_id($catid);

        // if there's no form id it must mean the default form is being used
        if(!($fid)) {

			// get all the custom field labels so we can match the field_name up against the post_meta keys
			$sql = $wpdb->prepare("SELECT field_label, field_name, field_type FROM ". $wpdb->prefix . "cp_ad_fields");

        } else {

            // now we should have the formid so show the form layout based on the category selected
            $sql = $wpdb->prepare("SELECT f.field_label, f.field_name, f.field_type, m.field_pos "
                     . "FROM ". $wpdb->prefix . "cp_ad_fields f "
                     . "INNER JOIN ". $wpdb->prefix . "cp_ad_meta m "
                     . "ON f.field_id = m.field_id "
                     . "WHERE m.form_id = '$fid' "
                     . "ORDER BY m.field_pos asc");

        }

As per the Forum Welcome, please post your own topic.