Still testing out my site and getting frustrated.
Paypal Standard worked yesterday, then last night did not work-- kept getting "We're sorry, things don't seem to be working at the moment," when trying to use a card to purchase. I disabled it, then enabled it and it seems to be working now.
But when my new order went through, it is not showing up in the dashboard now. Version 3.0.2.0
Have had a lot of trouble with this store. I guess this is what I get for using the newer version. Set up a store previously with 2.0.something and had very few issues.
Can anyone point me in the right direction on this missing order? It's showing up as "pending" in my Paypal account, but not showing up on my OpenCart dashboard.
Paypal Standard worked yesterday, then last night did not work-- kept getting "We're sorry, things don't seem to be working at the moment," when trying to use a card to purchase. I disabled it, then enabled it and it seems to be working now.
But when my new order went through, it is not showing up in the dashboard now. Version 3.0.2.0
Have had a lot of trouble with this store. I guess this is what I get for using the newer version. Set up a store previously with 2.0.something and had very few issues.
Can anyone point me in the right direction on this missing order? It's showing up as "pending" in my Paypal account, but not showing up on my OpenCart dashboard.
That is because you may have not followed the FAQ steps in order to avoid situations like these to happen: viewtopic.php?f=176&p=737014#p730051Have had a lot of trouble with this store. I guess this is what I get for using the newer version. Set up a store previously with 2.0.something and had very few issues.
However, if this is a fresh install, you'd need to post the transaction logs without confidential information to see the reason code and its description.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
I was unclear-- I had previously used 2.0 for a completely different store, different domain.
Here is my error log (I'm also having issues with admin getting email notifications of orders)
2018-10-21 14:01:58 - PHP Warning: fsockopen(): Peer certificate CN=`*.bluehost.com' did not match expected CN=`smtp.gmail.com' in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-21 14:01:58 - PHP Warning: fsockopen(): Failed to enable crypto in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-21 14:01:58 - PHP Warning: fsockopen(): unable to connect to ssl://smtp.gmail.com:465 (Unknown error) in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-21 14:40:49 - PHP Warning: fsockopen(): Peer certificate CN=`*.bluehost.com' did not match expected CN=`smtp.gmail.com' in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-21 14:40:49 - PHP Warning: fsockopen(): Failed to enable crypto in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-21 14:40:49 - PHP Warning: fsockopen(): unable to connect to ssl://smtp.gmail.com:465 (Unknown error) in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
Here is my error log (I'm also having issues with admin getting email notifications of orders)
2018-10-21 14:01:58 - PHP Warning: fsockopen(): Peer certificate CN=`*.bluehost.com' did not match expected CN=`smtp.gmail.com' in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-21 14:01:58 - PHP Warning: fsockopen(): Failed to enable crypto in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-21 14:01:58 - PHP Warning: fsockopen(): unable to connect to ssl://smtp.gmail.com:465 (Unknown error) in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-21 14:40:49 - PHP Warning: fsockopen(): Peer certificate CN=`*.bluehost.com' did not match expected CN=`smtp.gmail.com' in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-21 14:40:49 - PHP Warning: fsockopen(): Failed to enable crypto in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-21 14:40:49 - PHP Warning: fsockopen(): unable to connect to ssl://smtp.gmail.com:465 (Unknown error) in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
Your admin - > systems - > settings - > edit settings - > mail tab is improperly configured with your mail settings.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
The error suggests that your host may have a restriction on outgoing SMTP connections. You could try tls://smtp.gmail.com and port 587. If that doesn't work you may have to contact your host.
For the PayPal problem you could check the IPN history. Login to PayPal and go to More > Sitemap > (Transactions) Instant Payment Notification (IPN) history. Look at your history to see if there are any messages and check the details, such as the URL and response code, which should be 200.
For the PayPal problem you could check the IPN history. Login to PayPal and go to More > Sitemap > (Transactions) Instant Payment Notification (IPN) history. Look at your history to see if there are any messages and check the details, such as the URL and response code, which should be 200.
ADD creative I tried those settings and this is the new error I get
Warning: stream_socket_enable_crypto(): Peer certificate CN=`*.bluehost.com' did not match expected CN=`smtp.gmail.com' in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 140
Warning: stream_socket_enable_crypto(): Peer certificate CN=`*.bluehost.com' did not match expected CN=`smtp.gmail.com' in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 140
This isn't activated so I am going to activate it. It is asking for a notification URL. I'm not sure what I should enter here?ADD Creative wrote: ↑Mon Oct 22, 2018 3:55 am
For the PayPal problem you could check the IPN history. Login to PayPal and go to More > Sitemap > (Transactions) Instant Payment Notification (IPN) history. Look at your history to see if there are any messages and check the details, such as the URL and response code, which should be 200.
The email error is telling you that it was trying to connect to smtp.gmail.com, but the connection was made to bluehost.com according to the certificate returned. It might be worth asking your host if they block or redirect outgoing SMTP connections.
The PayPal notification URL will be set by the OpenCart PayPal standard module each time it's used. So no need to set in PayPal.
The PayPal notification URL will be set by the OpenCart PayPal standard module each time it's used. So no need to set in PayPal.
Welp.
Bluehost says everything on their end is ok.
Had some guys trying to help me from the OpenCart end.
Wonder if I should try a new Paypal account, or different PayPal extension?
All of my orders are showing up as "Missing orders" so not showing directly on my Dashboard, not sending email notification to customer and not sending email notification to my email.
I'm stumped and don't know what my next step could be other than blow it up and start over.
Bluehost says everything on their end is ok.
Had some guys trying to help me from the OpenCart end.
Wonder if I should try a new Paypal account, or different PayPal extension?
All of my orders are showing up as "Missing orders" so not showing directly on my Dashboard, not sending email notification to customer and not sending email notification to my email.
I'm stumped and don't know what my next step could be other than blow it up and start over.
Follow these instructions and provide the output results without the certificate string: https://github.com/opencart/opencart/issues/6768
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
For the PayPal problem. Did you check the IPN history. Login to PayPal and go to More > Sitemap > (Transactions) Instant Payment Notification (IPN) history. Look at your history to see if there are any messages and check the details, such as the URL and response code, which should be 200.
Then try this PayPal test (put it in a paypaltest.php file on your server and then go to it in a web browser) it should give the output of "PayPal_Connection_OK".
Remember to delete the file afterwards.
Then try this PayPal test (put it in a paypaltest.php file on your server and then go to it in a web browser) it should give the output of "PayPal_Connection_OK".
Code: Select all
<?php
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "https://tlstest.paypal.com/");
var_dump(curl_exec($ch));
var_dump(curl_error($ch));
curl_close($ch);
?>
This is the output from that test: PayPal_Connection_OKbool(true) string(0) ""ADD Creative wrote: ↑Sat Oct 27, 2018 6:40 amFor the PayPal problem. Did you check the IPN history. Login to PayPal and go to More > Sitemap > (Transactions) Instant Payment Notification (IPN) history. Look at your history to see if there are any messages and check the details, such as the URL and response code, which should be 200.
Then try this PayPal test (put it in a paypaltest.php file on your server and then go to it in a web browser) it should give the output of "PayPal_Connection_OK".
Response code is 500. It has retried 15 times
Here is the message I got in the last transaction
mc_gross=10.82&invoice=29 - **masked**&protection_eligibility=Ineligible&item_number1=Diggs Fishing T-Shirt ts-11&item_number2=&payer_id=**masked**&tax=0.68&payment_date=17:35:47 Oct 24, 2018 PDT&payment_status=Completed&charset=windows-1252&first_name=**masked**&mc_fee=0.61¬ify_version=3.9&custom=29&payer_status=unverified&business=**masked**&num_cart_items=2&verify_sign=ApxVmElu0MhfXUD7Eb9oXyC-ahCAApiMCYLERQU9gUG629hnc5Q4O0nk&payer_email=**masked**&txn_id=**masked**&payment_type=instant&last_name=**masked**&item_name1=Diggs Fishing T-Shirt ts-11&receiver_email=**masked**&item_name2=Shipping, Handling, Discounts & Taxes&payment_fee=0.61&shipping_discount=0.00&quantity1=1&insurance_amount=0.00&quantity2=1&receiver_id=**masked**&txn_type=cart&discount=0.00&mc_gross_1=2.00&mc_currency=USD&mc_gross_2=8.14&residence_country=US&receipt_id=**masked**&shipping_method=Default&transaction_subject=&payment_gross=10.82&ipn_track_id=**masked**
Last edited by OSWorX on Mon Oct 29, 2018 2:55 am, edited 1 time in total.
Reason: Never post real names, email, etc.!
Reason: Never post real names, email, etc.!
I would edit your last post if they are actual names and emails.
The URL should of been something like your domain followed by /index.php?route=payment/pp_standard/callback. The 500 Internal Server Error means that your server could not respond to the IPN message due to an error. Finding the reason for the error can be tricky.
You could check your OpenCart error log for any errors and check for a file error_log in you OpenCart root folder (or wherever it's been set to on your server).
You could then switch on the debug messages in the payment module. Then check your logs for PP_STANDARD :: IPN REQUEST and PP_STANDARD :: IPN RESPONSE messages in your error log.
Maybe unrelated but the charset was not UTF-8 in the message. To check the in your PayPal account. Profile -> Profile and Settings -> My selling preferences -> PayPal button language encoding -> More Options. Check Encoding is set to UTF-8 and "Do you want to use the same encoding for data sent from PayPal to you (e.g. IPN, downloadable logs, emails)?" is yes.
The URL should of been something like your domain followed by /index.php?route=payment/pp_standard/callback. The 500 Internal Server Error means that your server could not respond to the IPN message due to an error. Finding the reason for the error can be tricky.
You could check your OpenCart error log for any errors and check for a file error_log in you OpenCart root folder (or wherever it's been set to on your server).
You could then switch on the debug messages in the payment module. Then check your logs for PP_STANDARD :: IPN REQUEST and PP_STANDARD :: IPN RESPONSE messages in your error log.
Maybe unrelated but the charset was not UTF-8 in the message. To check the in your PayPal account. Profile -> Profile and Settings -> My selling preferences -> PayPal button language encoding -> More Options. Check Encoding is set to UTF-8 and "Do you want to use the same encoding for data sent from PayPal to you (e.g. IPN, downloadable logs, emails)?" is yes.
These are the type of errors showing in my OpenCart error log:
2018-10-28 21:56:35 - PP_STANDARD :: IPN REQUEST: cmd=_notify-validate&mc_gross=10.82&invoice=28+-+***********&auth_exp=15%3A50%3A39+Nov+21%2C+2018+PST&protection_eligibility=Ineligible&item_number1=&item_number2=Diggs+Fishing+T-Shirt+ts-11&payer_id=GDUJLNWD82LQJ&tax=0.68&payment_date=17%3A24%3A43+Oct+24%2C+2018+PDT&payment_status=Completed&charset=windows-1252&mc_shipping=0.00&mc_handling=0.00&first_name=***********&transaction_entity=payment&mc_fee=0.61¬ify_version=3.9&custom=28&payer_status=unverified&business=***********&num_cart_items=2&verify_sign=Ao5nNRyX8B2kZoOZhM4y0lQF5O8RA9-Crng4PMA7aN6-R9pZTWpRJDy.&payer_email=***********&parent_txn_id=77C673460B5254907&txn_id=5NG168426T682794R&payment_type=instant&remaining_settle=0&auth_id=77C673460B5254907&last_name=***********&item_name1=Shipping%2C+Handling%2C+Discounts+%26+Taxes&receiver_email=***********&auth_amount=10.82&item_name2=Diggs+Fishing+T-Shirt+ts-11&payment_fee=0.61&shipping_discount=0.00&quantity1=1&insurance_amount=0.00&quantity2=1&receiver_id=MQ2FANLYHE9GE&txn_type=cart&discount=0.00&mc_gross_1=8.14&mc_currency=USD&mc_gross_2=2.00&residence_country=US&receipt_id=3121-0215-2007-7300&shipping_method=Default&transaction_subject=&payment_gross=10.82&auth_status=Completed&ipn_track_id=5f29d1fa18df4
2018-10-28 21:56:35 - PP_STANDARD :: IPN RESPONSE: VERIFIED
2018-10-28 21:56:35 - PP_STANDARD :: TOTAL PAID MISMATCH! 10.82
2018-10-28 21:56:35 - PHP Warning: fsockopen(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-28 21:56:35 - PHP Warning: fsockopen(): unable to connect to smtp.gmail.com :587 (php_network_getaddresses: getaddrinfo failed: Name or service not known) in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-28 22:07:03 - PP_STANDARD :: IPN REQUEST: cmd=_notify-validate&mc_gross=10.82&invoice=29+-+***********protection_eligibility=Ineligible&item_number1=Diggs+Fishing+T-Shirt+ts-11&item_number2=&payer_id=CKSRKWMH6SJZE&tax=0.68&payment_date=17%3A35%3A47+Oct+24%2C+2018+PDT&payment_status=Completed&charset=windows-1252&first_name=***********&mc_fee=0.61¬ify_version=3.9&custom=29&payer_status=unverified&business=************************&num_cart_items=2&verify_sign=ApxVmElu0MhfXUD7Eb9oXyC-ahCAApiMCYLERQU9gUG629hnc5Q4O0nk&payer_email=***********&txn_id=44X129824B452150C&payment_type=instant&last_name=***********&item_name1=Diggs+Fishing+T-Shirt+ts-11&receiver_email=************&item_name2=Shipping%2C+Handling%2C+Discounts+%26+Taxes&payment_fee=0.61&shipping_discount=0.00&quantity1=1&insurance_amount=0.00&quantity2=1&receiver_id=MQ2FANLYHE9GE&txn_type=cart&discount=0.00&mc_gross_1=2.00&mc_currency=USD&mc_gross_2=8.14&residence_country=US&receipt_id=0799-6958-1782-4354&shipping_method=Default&transaction_subject=&payment_gross=10.82&ipn_track_id=7ae256fc3ab3a
2018-10-28 22:07:03 - PP_STANDARD :: IPN RESPONSE: VERIFIED
2018-10-28 22:07:03 - PP_STANDARD :: TOTAL PAID MISMATCH! 10.82
2018-10-28 22:07:03 - PHP Warning: fsockopen(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-28 22:07:03 - PHP Warning: fsockopen(): unable to connect to smtp.gmail.com :587 (php_network_getaddresses: getaddrinfo failed: Name or service not known) in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-28 21:56:35 - PP_STANDARD :: IPN REQUEST: cmd=_notify-validate&mc_gross=10.82&invoice=28+-+***********&auth_exp=15%3A50%3A39+Nov+21%2C+2018+PST&protection_eligibility=Ineligible&item_number1=&item_number2=Diggs+Fishing+T-Shirt+ts-11&payer_id=GDUJLNWD82LQJ&tax=0.68&payment_date=17%3A24%3A43+Oct+24%2C+2018+PDT&payment_status=Completed&charset=windows-1252&mc_shipping=0.00&mc_handling=0.00&first_name=***********&transaction_entity=payment&mc_fee=0.61¬ify_version=3.9&custom=28&payer_status=unverified&business=***********&num_cart_items=2&verify_sign=Ao5nNRyX8B2kZoOZhM4y0lQF5O8RA9-Crng4PMA7aN6-R9pZTWpRJDy.&payer_email=***********&parent_txn_id=77C673460B5254907&txn_id=5NG168426T682794R&payment_type=instant&remaining_settle=0&auth_id=77C673460B5254907&last_name=***********&item_name1=Shipping%2C+Handling%2C+Discounts+%26+Taxes&receiver_email=***********&auth_amount=10.82&item_name2=Diggs+Fishing+T-Shirt+ts-11&payment_fee=0.61&shipping_discount=0.00&quantity1=1&insurance_amount=0.00&quantity2=1&receiver_id=MQ2FANLYHE9GE&txn_type=cart&discount=0.00&mc_gross_1=8.14&mc_currency=USD&mc_gross_2=2.00&residence_country=US&receipt_id=3121-0215-2007-7300&shipping_method=Default&transaction_subject=&payment_gross=10.82&auth_status=Completed&ipn_track_id=5f29d1fa18df4
2018-10-28 21:56:35 - PP_STANDARD :: IPN RESPONSE: VERIFIED
2018-10-28 21:56:35 - PP_STANDARD :: TOTAL PAID MISMATCH! 10.82
2018-10-28 21:56:35 - PHP Warning: fsockopen(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-28 21:56:35 - PHP Warning: fsockopen(): unable to connect to smtp.gmail.com :587 (php_network_getaddresses: getaddrinfo failed: Name or service not known) in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-28 22:07:03 - PP_STANDARD :: IPN REQUEST: cmd=_notify-validate&mc_gross=10.82&invoice=29+-+***********protection_eligibility=Ineligible&item_number1=Diggs+Fishing+T-Shirt+ts-11&item_number2=&payer_id=CKSRKWMH6SJZE&tax=0.68&payment_date=17%3A35%3A47+Oct+24%2C+2018+PDT&payment_status=Completed&charset=windows-1252&first_name=***********&mc_fee=0.61¬ify_version=3.9&custom=29&payer_status=unverified&business=************************&num_cart_items=2&verify_sign=ApxVmElu0MhfXUD7Eb9oXyC-ahCAApiMCYLERQU9gUG629hnc5Q4O0nk&payer_email=***********&txn_id=44X129824B452150C&payment_type=instant&last_name=***********&item_name1=Diggs+Fishing+T-Shirt+ts-11&receiver_email=************&item_name2=Shipping%2C+Handling%2C+Discounts+%26+Taxes&payment_fee=0.61&shipping_discount=0.00&quantity1=1&insurance_amount=0.00&quantity2=1&receiver_id=MQ2FANLYHE9GE&txn_type=cart&discount=0.00&mc_gross_1=2.00&mc_currency=USD&mc_gross_2=8.14&residence_country=US&receipt_id=0799-6958-1782-4354&shipping_method=Default&transaction_subject=&payment_gross=10.82&ipn_track_id=7ae256fc3ab3a
2018-10-28 22:07:03 - PP_STANDARD :: IPN RESPONSE: VERIFIED
2018-10-28 22:07:03 - PP_STANDARD :: TOTAL PAID MISMATCH! 10.82
2018-10-28 22:07:03 - PHP Warning: fsockopen(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-28 22:07:03 - PHP Warning: fsockopen(): unable to connect to smtp.gmail.com :587 (php_network_getaddresses: getaddrinfo failed: Name or service not known) in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
The message "PP_STANDARD :: TOTAL PAID MISMATCH! 10.82" is telling you that the amount received is not matching the total for the order in OpenCart. Check the OpenCart total for this order matches. It may be something to do with the "&tax=0.68" in the PayPal IPN message. OpenCart does not set the tax by default, so you either have a modification that is setting the tax or your PayPal account is set to add the tax.
However, the order status should still be getting set to the default, so the problem still may be with addOrderHistory. This could be caused by the email problem. Have you tried changing the Mail Protocol to Mail instead of SMTP in the OpenCart mail settings? Or even using your host's outgoing mail settings?
However, the order status should still be getting set to the default, so the problem still may be with addOrderHistory. This could be caused by the email problem. Have you tried changing the Mail Protocol to Mail instead of SMTP in the OpenCart mail settings? Or even using your host's outgoing mail settings?
Also an issue with these protocols / functions:
2018-10-28 21:56:35 - PHP Warning: fsockopen(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home2/santeero/public_html/diggsfishing/store/system/library/mail/smtp.php on line 87
2018-10-28 21:56:35 - PHP Warning: fsockopen(): unable to connect to smtp.gmail.com :587 (php_network_getaddresses: getaddrinfo failed: Name or service not known) in
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
OMG ADD you are the MAN!
Paypal was set to add sales tax. I changed that, then changed the mail settings to "Mail" instead of "SMTP" and it's working now. Strange, I originally had it set at "Mail" but since it didn't work had tried SMTP.
Anyway, thank you so much, and thanks to all others who helped. Whew. What a relief.
Paypal was set to add sales tax. I changed that, then changed the mail settings to "Mail" instead of "SMTP" and it's working now. Strange, I originally had it set at "Mail" but since it didn't work had tried SMTP.
Anyway, thank you so much, and thanks to all others who helped. Whew. What a relief.
Who is online
Users browsing this forum: No registered users and 266 guests