Post by loy111 » Tue Aug 16, 2022 2:02 am

Opencart3 Alipay, the payment is completed, but there are missing orders. This bug almost makes Asian Opencart users have some difficulties. Can Opencart official repair it? Or publish a repair method!



Your loyal supporters!

Newbie

Posts

Joined
Tue Aug 16, 2022 1:51 am

Post by ADD Creative » Tue Aug 16, 2022 3:38 am

You need to give more information. Which Alipay extension are you using. Which PHP version? What theme and extensions are you using? Any errors in both the OpenCart and PHP error logs.

Do all orders go to missing orders? Do other payment extensions work? When did it start happening?

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by loy111 » Tue Aug 16, 2022 10:34 am

I'm really glad to get a reply,
The following is the relevant information!
php7.2
apache 2.2
The payment plug-in is Alipay
It's just an opencart3.0.2.0 without any other plug-ins installed
Default theme
Other payment methods are normal, and there is no error in the order!
Only Alipay extended payment is completed, and all orders are missing orders!
The error of Alipay plug-in always exists!

We know it's hard to verify!Therefore, we can provide the public key and appid of Alipay and the private key of the merchant, so that the official can verify the error of Alipay!

Posted help on GitHub, but the official asked me to come to the forum for help!

You only need to install opencart3.0.2.0 or other versions. As long as there is a Alipay plug-in, you can use the Alipay merchant information provided by me to check. This is a bug that can be easily fixed!


Love you, loyal users for many years

I wish you a happy and happy day!

Newbie

Posts

Joined
Tue Aug 16, 2022 1:51 am

Post by loy111 » Tue Aug 16, 2022 2:49 pm

https://doc.opencart.cn/docs/alipay/1.0/home

This is the setting method of Alipay plug-in, please check!

Newbie

Posts

Joined
Tue Aug 16, 2022 1:51 am

Post by ADD Creative » Tue Aug 16, 2022 5:08 pm

Do you have the correct rewrite in your htaccess file for the Alipay callback notification?

See.
https://github.com/opencart/opencart/issues/5777

www.add-creative.co.uk


Expert Member

Posts

Joined
Sat Jan 14, 2012 1:02 am
Location - United Kingdom

Post by loy111 » Tue Aug 16, 2022 5:12 pm

.htaccess

# 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 "(?i)((\.tpl|.twig|\.ini|\.log|(?<!robots)\.txt))">

Order deny,allow
Deny from all

## For apache 2.2 and older, replace "Require all denied" with these two lines :
# 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=extension/feed/google_sitemap

RewriteRule ^payment_callback/(.*) index.php?route=extension/payment/$1/callback [QSA]







RewriteRule ^googlebase.xml$ index.php?route=extension/feed/google_base [L]
RewriteRule ^system/storage/(.*) 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


The file has been rewritten, but the order cannot be generated. The order status is still missing orders!

Newbie

Posts

Joined
Tue Aug 16, 2022 1:51 am

Post by JNeuhoff » Tue Aug 16, 2022 5:54 pm

Is it only some, or all orders, being affected by this issue?

If only some are affected by this, then it could be possible that the payment gateway simply didn't make the callbacks to your OpenCart site. This would cause some OC orders to stay with the order_status_id=0 (missing order status). This can happen with other payment gateways, too, such as Paypal. The only way to know for sure is to check the server's access log to see whether the payment gateway has made the callbacks to your server at all.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by loy111 » Tue Aug 16, 2022 6:55 pm

Thank you for your warm response and support, but the problem still exists. Alipay pays orders, payment is completed, and the order status is missing orders. All orders paid by Alipay are in this order status!
We hope you can test it. We will provide the official account information of Alipay,

You can find the problem!

thank you!

Newbie

Posts

Joined
Tue Aug 16, 2022 1:51 am

Post by loy111 » Tue Aug 16, 2022 11:02 pm

Thanks for your help and support, the problem has been solved. The reason is that the live mode is set, not the sandbox mode!



Enable static rewriting!

thank

Newbie

Posts

Joined
Tue Aug 16, 2022 1:51 am
Who is online

Users browsing this forum: No registered users and 83 guests