Urgent: Site not returning from Paypal

I have a site that successfully goes from the cart page to the Paypal website and allows you to enter the relevant details. However, pressing continue on Paypal brings up a blank page rather than re-directing back the customers site to confirm the order. The URL displayed on the blank page is:

pp_confirm.php?token=EC-41203608VT257821J&PayerID=XHBN2ZG76K6XN

Can anyone tell me what is wrong? This is urgent as no-one can currently complete a purchase online.

Regards,

Laura

Hi Laura,

To try and find a problem you would need to paste the code of your page rather than just the link, as posting the link just shows the front end of the site and not the underlying problematic code.

It might also be worth looking to make sure there is no whitespace in the pp_confirm.php page, between PHP tags as this is sometimes a cause of the dreaded white screen.

Cheers
Ian

a blank php page means that a php error is occurring but error reporting is turned off.

add the following code at line 1 to turn error reporting on:

<?php

error_reporting(E_ALL);

ini_set('display_errors','on');

?>

once we know the error, we will be able to determine where to look for the cause.

Thanks Jason - getting the following error


Fatal error: Call to undefined function getsqlvaluestring() in /home/sites/ecotale.co.uk/public_html/pp_confirm.php on line 24

I sent that last reply too early. Code on line 24 is

$query_rsDetail = sprintf("SELECT stock - (SELECT coalesce(sum(DetailQuantity),0) as soldStock from orders INNER JOIN orderdetails ON OrderID = DetailOrderID WHERE DetailProductID = ProductID AND OrderDate > stock_update) as newStock FROM products WHERE productID = %s", GetSQLValueString($colname_rsDetail, "int"));

This was added when I was entering an inventory control section to the site and was done in conjunction with one of the Webassist tech guys. As I needed help to implement it, I don't know how to work out what's going wrong.

add the following code block at line 1 of the pp_confirm.php page

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 

{

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }



  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);



  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;    

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

}

}

?>

Thank you Jason - all working fine now.