Post by bigjohnnc » Sun Oct 21, 2018 10:59 pm

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.

New member

Posts

Joined
Mon Mar 13, 2017 5:36 am

Post by straightlight » Sun Oct 21, 2018 11:47 pm

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.
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#p730051

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


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by bigjohnnc » Mon Oct 22, 2018 2:26 am

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

New member

Posts

Joined
Mon Mar 13, 2017 5:36 am

Post by straightlight » Mon Oct 22, 2018 3:08 am

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


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by ADD Creative » Mon Oct 22, 2018 3:55 am

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.

www.add-creative.co.uk


Expert Member

Posts

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

Post by bigjohnnc » Mon Oct 22, 2018 4:29 am

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

New member

Posts

Joined
Mon Mar 13, 2017 5:36 am

Post by bigjohnnc » Mon Oct 22, 2018 4:31 am

My last order submitted to Paypal but isn't showing up in my dashboard. Still not sure what else to try there

New member

Posts

Joined
Mon Mar 13, 2017 5:36 am

Post by bigjohnnc » Mon Oct 22, 2018 4:47 am

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.
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?

New member

Posts

Joined
Mon Mar 13, 2017 5:36 am

Post by ADD Creative » Mon Oct 22, 2018 5:21 am

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.

www.add-creative.co.uk


Expert Member

Posts

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

Post by bigjohnnc » Fri Oct 26, 2018 9:59 am

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.

New member

Posts

Joined
Mon Mar 13, 2017 5:36 am

Post by straightlight » Fri Oct 26, 2018 6:07 pm

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


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by ADD Creative » Sat Oct 27, 2018 6:40 am

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".

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);
?>
Remember to delete the file afterwards.

www.add-creative.co.uk


Expert Member

Posts

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

Post by bigjohnnc » Sun Oct 28, 2018 5:39 am

ADD Creative wrote:
Sat Oct 27, 2018 6:40 am
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".
This is the output from that test: PayPal_Connection_OKbool(true) string(0) ""

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&notify_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.!

New member

Posts

Joined
Mon Mar 13, 2017 5:36 am

Post by ADD Creative » Mon Oct 29, 2018 1:06 am

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.

www.add-creative.co.uk


Expert Member

Posts

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

Post by bigjohnnc » Tue Oct 30, 2018 5:34 am

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

New member

Posts

Joined
Mon Mar 13, 2017 5:36 am

Post by bigjohnnc » Tue Oct 30, 2018 5:35 am

And can not get Paypal to contact me back to see if it's something on their end. Live chat support tells me to email or call. Email hasn't responded (48 hours) and call I get put on hold.

New member

Posts

Joined
Mon Mar 13, 2017 5:36 am

Post by ADD Creative » Tue Oct 30, 2018 7:31 pm

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?

www.add-creative.co.uk


Expert Member

Posts

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

Post by straightlight » Wed Oct 31, 2018 5:36 am

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


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by bigjohnnc » Wed Oct 31, 2018 7:29 am

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.

New member

Posts

Joined
Mon Mar 13, 2017 5:36 am
Who is online

Users browsing this forum: No registered users and 266 guests