WordPress.org

Ready to get started?Download WordPress

Forums

Banner Garden Plugin for WordPress
Warning: Missing argument 2 for wpdb::prepare() (3 posts)

  1. siutouamy
    Member
    Posted 11 months ago #

    I'm aware Banner Garden has been inactive for quite sometime, but hadn't noticed if there was an issue with it (I don't think so) until the 3.6 update. I'm having this issue with this warning.

    Any kind soul wants to jumpstart this plugin? It's really the simplest random plugin out there.

    Warning: Missing argument 2 for wpdb::prepare(), ****/banner-garden/bannergarden.class.php on line 404 and defined in *wp-includes/wp-db.php on line 992

    $count_of_banners = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM ".$this->b_table." WHERE b_campaign = ".$camp->c_id));

    Warning: Missing argument 2 for wpdb::prepare(), called in /***/banner-garden/bannergarden.class.php on line 383 and defined in /***/wp-includes/wp-db.php on line 992

    $name = $wpdb->get_var($wpdb->prepare("SELECT c_name FROM ".$this->c_table." WHERE c_id = ".$c_id));

    Warning: Missing argument 2 for wpdb::prepare(), called in /***/banner-garden/bannergarden_frontend.class.php on line 141 and defined in /***/wp-includes/wp-db.php on line 992

    $count = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM ".$this->c_table." WHERE c_id = ".$c_id));

    I added ", $id, $name" (can you tell I'm null at this?) as this pointed, and it got rid of the warnings but the plugin isn't letting me add new banners or modify them.

    http://wordpress.org/plugins/banner-garden/

  2. jefspereira
    Member
    Posted 3 months ago #

    Hi there!

    I resolved, change this lines.

    in bannergarden.class.php

    383- $name = $wpdb->get_var($wpdb->prepare("SELECT c_name FROM ".$this->c_table." WHERE c_id = %d",$c_id));

    404 - $count_of_banners = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM ".$this->b_table." WHERE b_campaign = %d", $camp->c_id));

    and in bannergarden_frontend.class.php

    141- $count = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM ".$this->c_table." WHERE c_id = %d",$c_id));

    in the folder js I change bannergarden_banners.js.php

    /**************************************/
    /********* AJAX FORM CONTROL **********/
    /**************************************/

    39 $('#code, #flash, #pic').bind('click', function()
    to
    39 jQuery('#code, #flash, #pic').bind('click', function()

    and works then.

  3. jefspereira
    Member
    Posted 3 months ago #

Reply

You must log in to post.

About this Plugin

About this Topic