[micheal332001]

Originally Posted by Lomak

got another mail from paypal - you had any luck?

Hello Lomak,

Please check your server that handles PayPal Instant Payment Notifications (IPN). IPNs sent to the following URL(s) are failing:

http://mysite.com/cart_gateway.php?method=paypal

If you do not recognize this URL, you may be using a service provider that is using IPN on your behalf. Please contact your service provider with the above information. If this problem continues, IPNs may be disabled for your account. 

Thank you for your prompt attention to this issue.


Thanks,

PayPal

and this SQL error still persist.. (as I updated to the latest version to test)

Invalid SQL:
UPDATE microcart_usercoupon SET valid=0 WHERE userid=;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number  : 1064
Request Date  : Wednesday, January 14th 2011 @ 10:28:43 AM
Error Date    : Wednesday, January 14th 2011 @ 10:28:44 AM
Script        : http://mysite.com/cart_gateway.php?method=paypal
Referrer      : 
IP Address    : 66.211.170.66
Username      : 
Classname     : vB_Database
MySQL Version :

I also cannot now View invoices in AdminCP (But Can edit)

Just to be clear..

all people must be registered and logged in to access the store.
required Customer data is turned on.
We do not have any active coupons.

All help is very much appreciated.

Regards

Originally Posted by Lomak

Tried it. I uploaded the one file: cart_gateway.php

I now do not get the SQL error. But the invoices are still not getting updated.. it says 'Unpaid'

I also cannot go in to the invoices (Via AdminCP) to see what 'options' the customer chose. Therefore I cannot ship any goods.

Thanks in advance

Hi there m8

Im trying to sort out your problem but will need your help to do this.

open the cart_gateway.php file and find this.

PHP Code:

$tax = doubleval($_REQUEST['tax']);

    $query[] = 'cmd=_notify-validate';
    foreach($_POST AS $key => $val) {
        if(!empty($val))
            $query[] = $key . '=' . urlencode ($val);
    }
    $query = implode('&', $query); 


Replace it with this.

PHP Code:

$tax = doubleval($_REQUEST['tax']);
      $text = '['.date('m/d/Y g:i A').'] - '; 

      $text .= "IPN POST Vars from Paypal:\n";
    $query[] = 'cmd=_notify-validate';
    foreach($_POST AS $key => $val) {
        $text .= "$key=$val, \n";
        if(!empty($val))
            $query[] = $key . '=' . urlencode ($val);
    }
      $text .= "\nIPN Response from Paypal Server:\n ";
    $fp=fopen('microcart_paypal_ipn_log.txt','a');
      fwrite($fp, strtolower($text) . "\n\n"); 

      fclose($fp);  // close file
      
    $query = implode('&', $query); 


Then put it back to the way it was i just need you to do this so that i can see the reply from paypal once an order has been passed back.

PM me with the results as this will show info you dont want to be seen by enyone.

Also remove the file microcart_paypal_ipn_log.txt when done.

Thanks m8