I have my cart running for 5 years, since 2 month ago I had issue with order missing missing (listed in the missing column). opencart could not get the paypal notification to complete the order, hence order did not have any status assigned.
After speaking with Siteground, they suggested I move whole site to SSL, which I did. However this didn't solve the problem.
Checking paypal IPN history:
- all my orders have delivery status of retrying,
- order are flagged HTTP response code: 500
- my Notification URL looks okay to me : https://www.supergameasset.com/index.ph ... d/callback
- I did not use the notification URL from Paypal admin settings, never need to used that before.
HOWEVER IF I delete the order on opencart admin, then I can see a successfull IPN been sent with HTTP 200. But since the order is gone it doesn't exist, it can't be updated. But this seems a little strange, could it be server related issue?
I did also make changes to .htaccess to make whole site SSL
My .htaccess
Code: Select all
#deny from 80.82.79.231
# 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
# 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]
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]
RewriteCond %{HTTP:X-Forwarded-Proto} !https
RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]
### 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
# To speed up opencart
# compress text, html, javascript, css, xml:
AddOutputFilterByType DEFLATE text/plain
AddOutputFilterByType DEFLATE text/html
AddOutputFilterByType DEFLATE text/xml
AddOutputFilterByType DEFLATE text/css
AddOutputFilterByType DEFLATE application/xml
AddOutputFilterByType DEFLATE application/xhtml+xml
AddOutputFilterByType DEFLATE application/rss+xml
AddOutputFilterByType DEFLATE application/javascript
AddOutputFilterByType DEFLATE application/x-javascript
# Turn on Expires and set default to 0
ExpiresActive On
ExpiresDefault A0
# Set up caching on media files for 1 week
<FilesMatch "\.(gif|jpg|jpeg|png)$">
ExpiresDefault A604800
Header append Cache-Control "public"
</FilesMatch>
# Set up 1 week caching on javascript and CSS
<FilesMatch "\.(js|css)$">
ExpiresDefault A604800
Header append Cache-Control "proxy-revalidate"
SetOutputFilter DEFLATE
</FilesMatch>
# Force no caching for dynamic files
<FilesMatch "\.(php)$">
ExpiresActive Off
Header set Cache-Control "private, no-cache, no-store, proxy-revalidate, no-transform"
Header set Pragma "no-cache"
</FilesMatch>
# Enable Gzip for css and js
<IfModule mod_deflate.c>
<FilesMatch "\.(js|css)$">
SetOutputFilter DEFLATE
</FilesMatch>
</IfModule>
# keep alive
<ifModule mod_headers.c>
Header set Connection keep-alive
</ifModule>
AddHandler application/x-httpd-php52 .php .php5 .php4 .php3
theme: journal 1.6.2
server: on siteground shared hosting
siteground has cloudflare , and specific SSL setting I put on full strict for SSL. but I also put on developer mode to disable could flare for the time been. I also flushed their dynamic cache.
site ground also has HTTPS SSL enforce, which makes all pages SSL. I have I enabled that as well.
What could be the issue? Please any help would be appreciated. I have search many post and google on this, but did not get an answer..
I did not make any changes to the site before this happened, so could it be paypal updates to SSL, because site was not all SSL before? or siteground related changes?