Forum Replies Created

Viewing 5 replies - 1 through 5 (of 5 total)
  • Looks like a pretty generic error. It has been described well here
    You need to modify your code
    $results = $wpdb->get_results( $wpdb->prepare("SELECT * FROM ".$wpdb->prefix."wpdeals_permissions WHERE user_id = $this->user_id AND order_key = '$this->order_key' AND deal_id = $item_id" ));
    to
    $results = $wpdb->get_results( $wpdb->prepare("SELECT * FROM ".$wpdb->prefix."wpdeals_permissions WHERE user_id = $this->user_id AND order_key = '$this->order_key' AND deal_id = $item_id",0));
    or
    $results = $wpdb->get_results( $wpdb->prepare("SELECT * FROM ".$wpdb->prefix."wpdeals_permissions WHERE user_id = %d AND order_key = %s AND deal_id = %d",$this->user_id,$this->order_key,$item_id));

    Do take care of %d and %s while using the above one…

    And do drop a link of your production site.

    Any one having the problem can download the js files from:
    Edited JS (ZIP)

    I am also involved in active development of WPDeals (Part time, ofcourse)
    so don’t hesitate to drop me a mail…

    It’s something to do with the REGEX

    if(/1\.(0|1|2)\.(0|1|2)/.test($.fn.jquery)||/^1.1/.test($.fn.jquery))

    which is checking the version of JQuery

    You are free to resolve it or comment out the

    if(/1\.(0|1|2)\.(0|1|2)/.test($.fn.jquery)||/^1.1/.test($.fn.jquery)){alert('blockUI requires jQuery v1.2.3 or later!  You are using v'+$.fn.jquery);return;

    in wpdeals_admin.js
    and

    if (/1\.(0|1|2)\.(0|1|2)/.test($.fn.jquery) || /^1.1/.test($.fn.jquery)) {
    	alert('blockUI requires jQuery v1.2.3 or later!  You are using v' + $.fn.jquery);
    	return;

    in wpdeals_plugins.js

    I have already informed the developer

    MichaelOzb, you solution “Works Great”!
    Could someone please also post how to include an image as a currency symbol?

    If you know what you are doing then you may:

    comment the if that checks the jQuery version using /*…*/
    The following needs to be commented in:

    wpdeals_plugins.js and wpdeals_admin.js

    if (/1\.(0|1|2)\.(0|1|2)/.test($.fn.jquery) || /^1.1/.test($.fn.jquery)) {
    	alert('blockUI requires jQuery v1.2.3 or later!  You are using v' + $.fn.jquery);
    	return;
    }
Viewing 5 replies - 1 through 5 (of 5 total)