WebsiteBaker Community Forum

WebsiteBaker Support (2.8.x) => Bakery Shop => Topic started by: dazz on August 23, 2012, 10:14:02 AM

Title: Order missing
Post by: dazz on August 23, 2012, 10:14:02 AM

My client has just gone live with their site and a number of orders have go through successfully. But one order the paypal notification was received but no order showed up.

I have looked in the data and the records are in wb_mod_bakery_order but there is no matching record in wb_mod_bakery_custo mer.   

Anyone got any ideas what can cause this and how to stop it happening again?

thanks in advance
Darren

Title: Re: Order missing
Post by: freeSbee on August 23, 2012, 02:38:54 PM

Hi Darren

Communication between Bakery and the PayPal Server depends largely upon PayPal Instant Payment Notification (IPN).

• Please make sure you have set the Instant Payment Notification Preferences correctly:
  http://www.bakery-shop.ch/#paypal
  
• PayPal Instant Payment Notification uses the PHP function fsockopen() on port 80.

Due to security reasons some ISP deactivate fsockopen() or use another port than 80.

You can use the code below to the test fsockopen(). Copy it to an empty file, name it eg. test.php, upload it to the same webspace as your WB installation and direct your browser to the test.php file.

Code: [Select]

<?php
$url = 'www.paypal.com';
$output = '';

$fp = fsockopen($url, 80, $errno, $errstr, 30);
if (!$fp) {
    echo "<h1>Fehler</h1>$errstr ($errno)<br />\n";
} else {
    $out = "GET / HTTP/1.1\r\n";
    $out .= "Host: $url\r\n";
    $out .= "Connection: Close\r\n\r\n";
    fwrite($fp, $out);
    while (!feof($fp)) {
        $output .= fgets($fp, 128);
    }
    fclose($fp);
}
echo '<pre>' . $output . '</pre>';
?>

The request should give back a server answer similar like this:

HTTP/1.1 301 Moved Permanently
Date: Tue, 23 Aug 2012 13:04:13 GMT
Server: Apache
X-Frame-Options: SAMEORIGIN
Set-Cookie: cwrClyrK4LoCV1fydGb AxiNL6iG=%7cP2hrfPKbkawEjYLthP25yKDJzFjiTzaGF9cX9phzb0C7-5aHFryR4uELdnEtXwKiWfyJKW%7c9Sog9BzzdqfIJ0HJYggVoarqezv97LZc_Fe6LyEyxYvj0vXlOJeeLaIn1Jj3NHTzlxqSuW%7c; domain=.paypal.com; path=/; HttpOnly
Set-Cookie: cookie_check=yes; expires=Fri, 03-Dec-2021 13:04:13 GMT; domain=.paypal.com; path=/; HttpOnly
Location: https://www.paypal.com/
Vary: Accept-Encoding
Connection: close
Transfer-Encoding: chunked
Content-Type: text/html

0

If you get a server answer like the one on the bottom, a connection using fsockopen() is not possible. Please ask your Internet Service Provider ISP (Hosting) to activate fsockopen() on port 80.

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, info@example.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.
Apache Server at www.example.com Port 80


Regards Christoph

Title: Re: Order missing
Post by: dazz on November 03, 2012, 11:02:58 AM

Thanks Christoph,

its all working fine and problem has not been able to be replicated.

Darren