Post by jasong » Tue Jun 17, 2014 4:30 am

I am having all my orders through PayPal blocked and not appearing in admin. I have contacted PayPal and they ahve said this:
I've investigated this issue and your not the only Opencart user experiencing this issue, there are many reports of Opencart users being affected by this issue.

I've tested IPN separately and it's working fine, so that's not the issue here.

Testing your URL in a browser results in a blank page, which seems ok.

When I attempt to test your URL using our IPN simulator, I'm receiving back the following response "Error reading from remote server" -- Remember, we are attempting to POST to this URL and your .htaccess file could be only allowing GET requests.

There is no issue with the IPN service here, it's isolated to Opencart only.
What code should be used to allow PayPal access to my .htaccess file? I have to keep going into my missing orders and I am sure this isn't reducing my stock levels either.

Many thanks
Jason

New member

Posts

Joined
Wed Mar 24, 2010 5:09 am

Post by jasong » Tue Jun 17, 2014 4:33 am

I am using 1.5.6.4 and here is a copy of my .htaccess file:

Code: Select all

# 1.To use URL Alias you need to be running apache with mod_rewrite enabled. 

# 2. In your opencart directory rename htaccess.txt to .htaccess.

# For any support issues please visit: http://www.opencart.com

#Options +FollowSymlinks

# Prevent Directoy listing 
#Options -Indexes

# Prevent Direct Access to files
<FilesMatch "\.(tpl|ini|log)">
 Order deny,allow
 Deny from all
</FilesMatch>

# SEO URL Settings
RewriteEngine On


# If your opencart installation does not run on the main web folder make sure you folder it does run in ie. / becomes /shop/ 

RewriteBase /
RewriteRule ^sitemap.xml$ index.php?route=feed/google_sitemap [L]
RewriteRule ^googlebase.xml$ index.php?route=feed/google_base [L]
RewriteRule ^download/(.*) /index.php?route=error/not_found [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} !.*\.(ico|gif|jpg|jpeg|png|js|css)
RewriteRule ^([^?]*) index.php?_route_=$1 [L,QSA]

### Additional Settings that may need to be enabled for some servers 
### Uncomment the commands by removing the # sign in front of it.
### If you get an "Internal Server Error 500" after enabling any of the following settings, restore the # as this means your host doesn't allow that.

# 1. If your cart only allows you to add one item at a time, it is possible register_globals is on. This may work to disable it:
# php_flag register_globals off

# 2. If your cart has magic quotes enabled, This may work to disable it:
# php_flag magic_quotes_gpc Off

# 3. Set max upload file size. Most hosts will limit this and not allow it to be overridden but you can try
# php_value upload_max_filesize 999M

# 4. set max post size. uncomment this line if you have a lot of product options or are getting errors where forms are not saving all fields
# php_value post_max_size 999M

# 5. set max time script can take. uncomment this line if you have a lot of product options or are getting errors where forms are not saving all fields
# php_value max_execution_time 200

# 6. set max time for input to be recieved. Uncomment this line if you have a lot of product options or are getting errors where forms are not saving all fields
# php_value max_input_time 200

# 7. disable open_basedir limitations
# php_admin_value open_basedir none

New member

Posts

Joined
Wed Mar 24, 2010 5:09 am

Post by jasong » Wed Jun 18, 2014 12:25 am

Anyone know? I've been told theres loads of reports of this, someone must know a fix?

Thanks
Jason

New member

Posts

Joined
Wed Mar 24, 2010 5:09 am

Post by rph » Wed Jun 18, 2014 12:38 am

He's just making a wild guess. There's nothing in the default OpenCart .htaccess (which is what you're using) limiting posting. Check your error log. If there's nothing it's possible there's a server level issue interfering with the callback.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by jasong » Wed Jun 18, 2014 1:28 am

My error log is clean, no errors recorded (I do also have PayPal debug active)

When you say server issue do you mean with my host? I did contact them and they said no to any blocking etc. Its been driving me nuts for ages.

New member

Posts

Joined
Wed Mar 24, 2010 5:09 am

Post by jasong » Wed Jun 18, 2014 1:34 am

I've been looking in the extensions store but I am unsure if any will work if my website isn't allowing PayPal to connect then maybe others wont work. I was going to get sagepay set up next week to accept cards and wondering will sagepay even work :(

New member

Posts

Joined
Wed Mar 24, 2010 5:09 am

Post by rph » Wed Jun 18, 2014 2:27 am

You can look through threads with similar issues:

https://www.google.com/search?q=paypal+ ... gws_rd=ssl

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by jasong » Wed Jun 18, 2014 4:39 am

I've had a look through that link, the issue looks to have been an issue with the encryption file from 1.5.4 needing updating to ver. 1.5.4.1

I'm running the latest version 1.5.6.4 and it looks to be a PayPal standard only bug ( I hope ). So maybe leaving PayPal standard for express or something may fix it?

New member

Posts

Joined
Wed Mar 24, 2010 5:09 am

Post by jasong » Wed Jun 18, 2014 5:03 am

I think I have fixed it. I downloaded 1.5.6.4 and re installed the paypal standard payments.
I resent all the failed paypal transactions from my PayPal account and its all showing as sent now.
Will test some orders soon!

Thanks for your help

New member

Posts

Joined
Wed Mar 24, 2010 5:09 am

Post by jasong » Wed Jun 18, 2014 5:21 am

Wishful thinking, they all changed from sent to retrying and test order didn't show any orders in admin, didn't show the order in the test accounts order history or deduct any stock :(

New member

Posts

Joined
Wed Mar 24, 2010 5:09 am

Post by jasong » Wed Jun 18, 2014 7:49 pm

I am wondering if this could be a host issue. I have just disabled SEO, theme, SSL and still the same.

I found it strange that when I added a new PP_standard file all my PayPal IPN's when to sent but changed back to retrying - does this bit help in any way?

New member

Posts

Joined
Wed Mar 24, 2010 5:09 am

Post by rph » Thu Jun 19, 2014 1:19 am

Which Paypal payment method are you using? Did you go over all your settings in both the store and on paypal.com to confirm you've set everything up correctly?

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by jasong » Thu Jun 19, 2014 5:09 am

im using PayPal standard, all settings are set up correctly and PayPal have said its all working fine but failing to send me the information. What files within Opencart would block PayPal from sending me orders?

Thank you

New member

Posts

Joined
Wed Mar 24, 2010 5:09 am

Post by jasong » Fri Jun 20, 2014 5:07 am

Had all my modules checked over and the issue isn't with them, anyone out there have this issue?

New member

Posts

Joined
Wed Mar 24, 2010 5:09 am

Post by rph » Fri Jun 20, 2014 1:41 pm

Try adding more details. It's not entirely clear what your issue is from the limited description. You can also look at hiring a developer to assist you at Partner's Page or Commercial Support subforum.

-Ryan


rph
Expert Member

Posts

Joined
Fri Jan 08, 2010 5:05 am
Location - Lincoln, Nebraska

Post by qahar » Fri Jun 20, 2014 6:24 pm

Try this, first check the Paypal IPN History, specifically "HTTP Response Code" part as a cross check.
It's a response status of HTTP POST message from paypal to your server. Successfull callback return 200 code.

Second, open controller/payment/pp_standard.php and find function callback().
Use $this->log->write('message'); to create debug step.

Example:

Code: Select all

public function callback() {
    $this->log->write('PP_DEBUG: 1st line');

    if (isset($this->request->post['custom'])) {
        $order_id = $this->request->post['custom'];
    } else {
        $order_id = 0;
    }       
    
    $this->log->write('PP_DEBUG: Order ID ' . $order_id);
    
    $this->load->model('checkout/order');
            
    $order_info = $this->model_checkout_order->getOrder($order_id);
    
    if ($order_info) {
        $this->log->write('PP_DEBUG: Order total ' . $order_info['total']);

        ... ...
    }
}
When I access index.php?route=payment/pp_standard/callback my log file show:

Code: Select all

2014-06-20 17:19:55 - PP_DEBUG: 1st line
2014-06-20 17:19:55 - PP_DEBUG: Order ID 0
Try to buy with Paypal and check the IPN History then the Log.
Hope you will know at what step the callbak is break

User avatar
Expert Member

Posts

Joined
Tue Jun 29, 2010 10:24 pm
Location - Indonesia

Post by jasong » Sat Jun 21, 2014 7:40 pm

Thank you for your help, that code word by word seems to already be in there appart from

Code: Select all

$this->log->write('message')
which I am not sure where abouts it would be placed.
I have started another store now on another cart so this may be goodbye after 4yrs or see you soon! But I do want to thank you for taking your item to look at this issue.

New member

Posts

Joined
Wed Mar 24, 2010 5:09 am
Who is online

Users browsing this forum: No registered users and 21 guests