我的PayPal IPN脚本突然不再起作用。在PayPal IPN历史记录中,IPN现在正在失败,HTTP响应代码保持空为空。什么可能导致此问题以及如何修复它?我没有更改任何代码,它只是停止工作。
这是我的php代码:
<?php
//Change these with your information
$paypalmode = ''; //Sandbox for testing or empty ''
$dbusername = 'xxx'; //db username
$dbpassword = 'xxx'; //db password
$dbhost = 'xxx.com'; //db host
$dbname = 'xxx'; //db name
if($_POST)
{
if($paypalmode=='sandbox')
{
$paypalmode = '.sandbox';
}
$req = 'cmd=' . urlencode('_notify-validate');
foreach ($_POST as $key => $value) {
$value = urlencode(stripslashes($value));
$req .= "&$key=$value";
}
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'https://www'.$paypalmode.'.paypal.com/cgi-bin/webscr');
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $req);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Host: www'.$paypalmode.'.sandbox.paypal.com'));
$res = curl_exec($ch);
curl_close($ch);
if (strcmp ($res, "VERIFIED") == 0)
{
$transaction_id = $_POST['txn_id'];
$ebaytxnid = $_POST['ebay_txn_id1'];
$payerid = $_POST['payer_id'];
$firstname = $_POST['first_name'];
$lastname = $_POST['last_name'];
$ebayname = $_POST['auction_buyer_id'];
$email = $_POST['payer_email'];
$shippingname = $_POST['address_name'];
$shippingstreet = $_POST['address_street'];
$shippingcity = $_POST['address_city'];
$shippingstate = $_POST['address_state'];
$shippingzip = $_POST['address_zip'];
$shippingcountry = $_POST['address_country'];
$shippingcountrycode = $_POST['address_country_code'];
$currency = $_POST['mc_currency'];
$paymentfee = $_POST['payment_fee'];
$total = $_POST['payment_gross'];
$mcfee = $_POST['mc_fee'];
$mcgross = $_POST['mc_gross'];
$ebayitemno = $_POST['item_number'];
$ebayitemname = $_POST['item_name'];
$quantity = $_POST['quantity1'];
$paymentdate = $_POST['payment_date'];
$mdate= date('Y-m-d h:i:s',strtotime($paymentdate));
$paymentstatus = $_POST['payment_status'];
$payerstatus = $_POST['payer_status'];
$paymenttype = $_POST['payment_type'];
$addressstatus = $_POST['address_status'];
$forauction = $_POST['for_auction'];
$protectioneligibility = $_POST['protection_eligibility'];
$otherstuff = json_encode($_POST);
$conn = mysql_connect($dbhost,$dbusername,$dbpassword);
if (!$conn)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($dbname, $conn);
// insert in our IPN record table
$query = "INSERT INTO ibn_table
(itransaction_id,iebaytxnid,ipayerid,ifirstname,ilastname,iebayname,iemail,ishippingname,ishippingstreet,ishippingcity,ishippingstate,ishippingzip,ishippingcountry,ishippingcountrycode,icurrency,ipaymentfee,itotal,imcfee,imcgross,iebayitemno,iebayitemname,iquantity,itransaction_date,ipaymentstatus,ipayerstatus,ipaymenttype,iaddressstatus,iforauction,iprotectioneligibility,ieverything_else)
VALUES
('$transaction_id','$ebaytxnid','$payerid','$firstname','$lastname','$ebayname','$email','$shippingname','$shippingstreet','$shippingcity','$shippingstate','$shippingzip','$shippingcountry','$shippingcountrycode','$currency','$paymentfee','$total','$mcfee','$mcgross','$ebayitemno','$ebayitemname','$quantity','$mdate','$paymentstatus','$payerstatus','$paymenttype','$addressstatus','$forauction','$protectioneligibility','$otherstuff')";
if(!mysql_query($query))
{
//mysql error..!
}
mysql_close($conn);
}
}
?>
更新:截至2017年3月15日上午11:47突然工作
我也有一些关于Godaddy的托管帐户的问题。截至2017年3月13日,后端停止从PAYPAL接收IPN。
对不起,如果事情没有意义,我是一个自学成才的白痴。我尝试过的事情:删除SSL证书添加SSL证书手动检查IPN URL(工作)白名单PayPal IP将所有内容重命名为HTTPS将所有内容重命名为HTTP检查了四个检查以确保:IPN未禁用,IPN URL是正确的
我发现的有趣的东西:在所有托管帐户上,一切都很好3年了。PayPal Sandbox帐户还会寄回IPN的完美效果。在交易中的IPN历史记录中,没有HTTP状态代码。PayPal根本没有IPN访问权限,我的末端没有错误或访问日志。问题是跨多个托管帐户在上个月只有一个变化。
让我知道您的想法和事物,希望PayPal可以做出回应或修复,因为所有迹象都指向他们。厌倦了他们的复制糊反应。