Post by gsc1ugs » Tue Feb 21, 2023 8:51 pm

Since beginning of FEBRUARY 2023 my cart is not saving the orders but the paypal payment is, what has changed please? Version 2.0.2.0 im using and i dont want to update everything will break
Last edited by gsc1ugs on Tue Feb 28, 2023 2:29 am, edited 1 time in total.

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by SohBH » Tue Feb 21, 2023 9:09 pm

You should replace Paypal with latest version:
https://www.opencart.com/index.php?rout ... n_id=38358

View all extensions | Request custom work | Pricing | Contact Me


User avatar
Active Member

Posts

Joined
Mon Nov 02, 2020 12:01 am
Location - Malaysia

Post by gsc1ugs » Tue Feb 21, 2023 9:37 pm

Is that done in the admin section of my site because its always worked using paypal standard its only this month its gone off?

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by gsc1ugs » Wed Feb 22, 2023 12:22 am

I assume the return string is nit coming back with results for the order

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by IP_CAM » Wed Feb 22, 2023 12:24 am

They just changed it a little, if might work now: ;)
https://github.com/Dreamvention/paypal

My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by ADD Creative » Wed Feb 22, 2023 1:30 am

Check your PayPal IPN history. Maybe the messages from PayPal are not getting through to your server.
https://developer.paypal.com/api/nvp-so ... perations/

Also check both the OpenCart and PHP error log.

www.add-creative.co.uk


Guru Member

Posts

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

Post by paulfeakins » Wed Feb 22, 2023 8:29 pm

gsc1ugs wrote:
Tue Feb 21, 2023 8:51 pm
Since beginning of FEBRUARY 2023 my cart is not saving the orders but the paypal payment is, what has changed please? Version 2.0.2.0 im using and i dont want to update everything will break
Are they in Missing Orders?

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Legendary Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by gsc1ugs » Wed Feb 22, 2023 9:59 pm

Are they in Missing Orders?
Nothing is being saved in db just paypal payment is taken so thats the only email i get the orders email i dont get

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by gsc1ugs » Wed Feb 22, 2023 10:13 pm

SohBH wrote:
Tue Feb 21, 2023 9:09 pm
You should replace Paypal with latest version:
https://www.opencart.com/index.php?rout ... n_id=38358
That version is year, 2020 nothing has changed, its been two or weeks since the orders where not being saved or logged not even given an ID or emails just the paypal confirmation of payment

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by ADD Creative » Wed Feb 22, 2023 10:36 pm

gsc1ugs wrote:
Wed Feb 22, 2023 9:59 pm
Are they in Missing Orders?
Nothing is being saved in db just paypal payment is taken so thats the only email i get the orders email i dont get
Check both your OpenCart and PHP error logs. OpenCart will save the order to the database before getting to the confirm/payment section of the checkout. So if you are not seeing it in the database there might be a related error message.

It would also be helpful to post what theme and extensions you are using.

www.add-creative.co.uk


Guru Member

Posts

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

Post by paulfeakins » Thu Feb 23, 2023 12:15 am

gsc1ugs wrote:
Wed Feb 22, 2023 9:59 pm
Are they in Missing Orders?
Nothing is being saved in db just paypal payment is taken so thats the only email i get the orders email i dont get
How do you know? Are you out of disk space?

UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk


User avatar
Legendary Member
Online

Posts

Joined
Mon Aug 22, 2011 11:01 pm
Location - London Gatwick, United Kingdom

Post by gsc1ugs » Thu Feb 23, 2023 1:10 am

Just launch PHPMYADMIN IN cpanel and i can see the orders in the database but its not listed in the admin section of opencart? ive just looked at error log and got this lot? obviously trying to load but wont show - its strange because i have made no changes for over a year - errors seem to have started 1/2/2023

2023-02-21 21:56:45 - PHP Notice: Undefined index: enquiry in /home/garyjacobjack/public_html/catalog/controller/information/contact.php on line 219
2023-02-22 5:49:40 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1<br />Error No: 1064<br />SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND () in /home/garyjacobjack/public_html/system/library/db/mysqli.php on line 41
2023-02-22 5:49:40 - PHP Notice: Trying to get property of non-object in /home/garyjacobjack/public_html/catalog/model/catalog/product.php on line 494
2023-02-22 5:49:40 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,30' at line 1<br />Error No: 1064<br />SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND () GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,30 in /home/garyjacobjack/public_html/system/library/db/mysqli.php on line 41
2023-02-22 5:49:40 - PHP Notice: Trying to get property of non-object in /home/garyjacobjack/public_html/catalog/model/catalog/product.php on line 194
2023-02-22 5:49:40 - PHP Warning: Invalid argument supplied for foreach() in /home/garyjacobjack/public_html/catalog/model/catalog/product.php on line 194
2023-02-22 5:57:13 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1<br />Error No: 1064<br />SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND () in /home/garyjacobjack/public_html/system/library/db/mysqli.php on line 41
2023-02-22 5:57:13 - PHP Notice: Trying to get property of non-object in /home/garyjacobjack/public_html/catalog/model/catalog/product.php on line 494
2023-02-22 5:57:13 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,30' at line 1<br />Error No: 1064<br />SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND () GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,30 in /home/garyjacobjack/public_html/system/library/db/mysqli.php on line 41
2023-02-22 5:57:13 - PHP Notice: Trying to get property of non-object in /home/garyjacobjack/public_html/catalog/model/catalog/product.php on line 194
2023-02-22 5:57:13 - PHP Warning: Invalid argument supplied for foreach() in /home/garyjacobjack/public_html/catalog/model/catalog/product.php on line 194
2023-02-22 7:13:48 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1<br />Error No: 1064<br />SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND () in /home/garyjacobjack/public_html/system/library/db/mysqli.php on line 41
2023-02-22 7:13:48 - PHP Notice: Trying to get property of non-object in /home/garyjacobjack/public_html/catalog/model/catalog/product.php on line 494
2023-02-22 7:13:48 - PHP Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,30' at line 1<br />Error No: 1064<br />SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND () GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,30 in /home/garyjacobjack/public_html/system/library/db/mysqli.php on line 41
2023-02-22 7:13:48 - PHP Notice: Trying to get property of non-object in /home/garyjacobjack/public_html/catalog/model/catalog/product.php on line 194
2023-02-22 7:13:48 - PHP Warning: Invalid argument supplied for foreach() in /home/garyjacobjack/public_html/catalog/model/catalog/product.php on line 194

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by ADD Creative » Thu Feb 23, 2023 2:40 am

If you go to the orders in admin and filter by Order Status - Missing Orders do you see them?

Do the date and time of the errors in the log match the date and time of the orders in the database?

Did you also check the PHP error log?

www.add-creative.co.uk


Guru Member

Posts

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

Post by gsc1ugs » Thu Feb 23, 2023 2:48 am

ADD Creative wrote:
Thu Feb 23, 2023 2:40 am
If you go to the orders in admin and filter by Order Status - Missing Orders do you see them?

Do the date and time of the errors in the log match the date and time of the orders in the database?

Did you also check the PHP error log?
Yes selecting missing orders they are listed!

Dates are correct when purchased..

Where is php error log?

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by gsc1ugs » Thu Feb 23, 2023 2:51 am

Also trying to edit one of the orders with status “missing orders” i get this error

The page you requested cannot be found!

I get this same error looking at a completed order from January? Which i got emails and it showing in admin?

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by ADD Creative » Thu Feb 23, 2023 4:04 am

If they are in missing orders and you are using the PayPal Standard payment extension. Check IPNs are switched on in your PayPal account the check the IPN history as suggested here. viewtopic.php?p=854129#p854069

For the PHP error log. Ask your host or use phpinfo() to find it.

www.add-creative.co.uk


Guru Member

Posts

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

Post by SohBH » Thu Feb 23, 2023 6:56 pm

Hi,
Could you replace this with original file:
public_html/catalog/model/catalog/product.php

View all extensions | Request custom work | Pricing | Contact Me


User avatar
Active Member

Posts

Joined
Mon Nov 02, 2020 12:01 am
Location - Malaysia

Post by gsc1ugs » Thu Feb 23, 2023 8:55 pm

SohBH wrote:
Thu Feb 23, 2023 6:56 pm
Hi,
Could you replace this with original file:
public_html/catalog/model/catalog/product.php
Why would it have changed?

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by gsc1ugs » Thu Feb 23, 2023 8:58 pm

ADD Creative wrote:
Wed Feb 22, 2023 1:30 am
Check your PayPal IPN history. Maybe the messages from PayPal are not getting through to your server.
https://developer.paypal.com/api/nvp-so ... perations/

Also check both the OpenCart and PHP error log.
My IPN is disabled i believe it always has been, what would be the URL i put in please if my website is
www.clearvape.com

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm

Post by gsc1ugs » Thu Feb 23, 2023 9:08 pm

Ok, ive enabled IPN
Ive used

https://www.paypal.com/cgi-bin/webscr?c ... ns-history
for the URL, on viewiing IPN history i see this

23/02/2023, 13:02 8WL523117U377790C Retrying 8UC03412Y18778148

When i click the ID i get the order i made clicking message id i get this

mc_gross=2.05&invoice=4765+-+GARY+CORCORAN&protection_eligibility=Eligible&item_number1=EGO-LANYARD-H3&item_number2=&payer_id=T8TASHJDNP5LC&payment_date=05%3A02%3A07+Feb+23%2C+2023+PST&option_selection1_1=Black&payment_status=Completed&charset=windows-1252&first_name=Gary&mc_fee=0.36&notify_version=3.9&custom=4765&payer_status=unverified&business=payments%40clearvape.com&num_cart_items=2&verify_sign=AopY798sPSqXL8-lfEYKNeDLDOkWA8SV3lw2y2jiMh-KKi6GChqrO6qV&payer_email=gsc1ugs%40gmail.com&option_name1_1=Colour&txn_id=8UC03412Y18778148&payment_type=instant&last_name=Corcoran&item_name1=EGO+Necklace+Lanyard+for+eGo-t%2CeGo-w%2CeGo-c+eGo-F&receiver_email=payments%40clearvape.com&item_name2=Shipping%2C+Handling%2C+Discounts+%26+Taxes&payment_fee=&shipping_discount=0.00&quantity1=1&insurance_amount=0.00&quantity2=1&receiver_id=TXDX4BCYB244J&txn_type=cart&discount=0.00&mc_gross_1=1.00&mc_currency=GBP&mc_gross_2=1.05&residence_country=GB&shipping_method=Default&transaction_subject=&payment_gross=&ipn_track_id=f6353893b10ac

The payment process through paypal doesn't tell you there is an error and redirects the the account saying successful and clicking view order history NOTHING

Order History
You have not made any previous orders!

BAFFLED

Active Member

Posts

Joined
Mon Sep 09, 2013 3:32 pm
Who is online

Users browsing this forum: Bing [Bot] and 15 guests