Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter clintonf

    (@clintonf)

    Godaddy are recording the following error now:

    [13-Feb-2018 21:13:01 UTC] PHP Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given in /home/vijayandclinton/public_html/wp-content/plugins/gift-registry/php/paypal_response.php on line 25

    Below is the current code in paypal_response.php: Any thoughts on how to add the second parameter?

    function gr_handle_paypal_response() {
    global $wpdb;

    wp_enqueue_script(‘paypal_response.js’, plugins_url(‘gift-registry/js/paypal_response.js’), array( ‘jquery’ ));
    $customId = mysqli_real_escape_string($_GET[‘customId’]);

    $q = “update {$wpdb->prefix}registry_order set
    status = ‘RECEIVED’
    where id = ‘$customId’ and status != ‘COMPLETED'”;
    $wpdb->query($q);

    Thread Starter clintonf

    (@clintonf)

    My hosting provider is GoDaddy

    Thread Starter clintonf

    (@clintonf)

    I have dug deeper and not that the following is on line of paypal_response.php:25

    wp_enqueue_script(‘paypal_response.js’, plugins_url(‘gift-registry/js/paypal_response.js’), array( ‘jquery’ ));
    $customId = mysql_real_escape_string($_GET[‘customId’]);

    One blog I read suggested changing:
    mysql_real_escape_string($_GET[‘customId’]);
    to
    mysqli_real_escape_string($_GET[‘customId’]);

    Which I did and then the PayPal error in ipn was queued however then changed to retrying again….

    Any thoughts?

Viewing 3 replies - 1 through 3 (of 3 total)