Post by yinako » Fri Mar 05, 2021 9:09 am

Hello,

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
opencart version 1.5.4
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?

Newbie

Posts

Joined
Sat May 11, 2013 10:57 am

Post by Cue4cheap » Fri Mar 05, 2021 10:49 am

For 500 errors look in your server logs.
1.5.4 is pretty old. Did they change your PHP version? I see AddHandler application/x-httpd-php52 .php .php5 .php4 .php3
but that doesn't mean php is still available. Is php 5 still available? If they updated php and made so you actually can't use php 5 then that could be the cause. MOST hosts are going away from running php 5.
Mike

cue4cheap not cheap quality


Expert Member

Posts

Joined
Fri Sep 20, 2013 4:45 am

Post by yinako » Fri Mar 05, 2021 1:49 pm

Cue4cheap wrote:
Fri Mar 05, 2021 10:49 am
For 500 errors look in your server logs.
1.5.4 is pretty old. Did they change your PHP version? I see AddHandler application/x-httpd-php52 .php .php5 .php4 .php3
but that doesn't mean php is still available. Is php 5 still available? If they updated php and made so you actually can't use php 5 then that could be the cause. MOST hosts are going away from running php 5.
Mike
Thanks for the quick response Cue4cheap!! :)

I'm happy to report its is now fixed!! ;D PHP5.2 could of been the issue.

- so I have upgrade over to php7, update the .htaccess with

Code: Select all

AddHandler application/x-httpd-php7 .php .php5 .php4 .php3
- updated mysqli from this thread, it was bring the site down. viewtopic.php?t=217182
- installed latest VQmod to move over all my extension provided some broke, no big issue there.

And after all that paypal IPN went smoothly. I think overall it could of been the way cURL was handled in the paypal standard moduel, and PHP7 may have something to do with it. because siteground recently moved over to PHP7 although they still supported PHP5.6 but my .htacess was pointing to PHP5.2

so now i'm running
- opencart 1.5.4 (I'm scared of updated to 1.5.6 or anything higher as it would break so much custom stuff that in the site for over 6 years)
- PHP7
- VQMod 2.6.4

Newbie

Posts

Joined
Sat May 11, 2013 10:57 am
Who is online

Users browsing this forum: Amazon [Bot] and 128 guests