-
Notifications
You must be signed in to change notification settings - Fork 9.4k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
2.1.0rc - Paypal Website Payments Standard module doesn't work #4785
Comments
Loaded sample data and carried the same frontend steps > same error and trace. Cache emptied > reindexed > stats refreshed > Redis-cli flushall/flushdb, everything I could do to set this back to a ootb stance. Let me know if you need me to do anything else (I'll archive this VM in a meantime) |
Thanks for looking into this Alena. YOU have to make this PP work ;) Any workaround that you know of (temp fix) please let me know as I plan on putting RC1 in prod in a week (i know i know, not for prod etc) We just can't delay too much longer here so we'll make use of it. Everything else works flawlessly (for us anyway). We'll upgrade to a stable version in Aug or Sept. Ubuntu 16.04 |
Hi @commcad Please provide us with debug.log that contains response from PayPal (debug can be enabled in Advanced Settings section for PayPal Website Payments Standard), this should help to identify the cause of the issue. |
Hello @alena-marchenko Sure. Attaching the entire sys i/o from 2.07 composer-project install > update to 2.1.0rc using Web Setup. TestBuy/sandboxed performed with the paypal debug mode On as requested. See line no. 1435 |
MariaDB [storedB]> show columns from sales_invoice_grid; |
Hi @commcad Please provide us with debug.log file that is located in var/log directory under magento root folder. Please als ensure that "Debug: option is set to Yes Under PayPal Payments Standard configuration. |
Sure, see attached debug.txt below. All looking very good on the paypal side of things having success ack and all. I also have the payment registered and issued to the seller. Can't be a paypal bug...been using Paypal for the last 12 years with litle over $500,000 in sales and never came across a payment failure. See above post no 6 where I highlighted the bug. The mage's database column aren't named properly. Easy fix is to rename the column to what it should be but I am unaware of other possible crashes that could occur while doing/renaming this table column. Same bug on Magento 2.1.0rc2 by the way. Can't run a shop using the Paypal payment option :/ |
Hi @commcad We've created MAGETWO-54787 internal ticket regarding this issue. |
I used fresh installed magento2.1 and still having unable to place order issue. column base_grand_total is there in sales_invoice_grid table. |
Do we have visibility on these MAGETWO-54787 tickets? They keep being mentioned, so I assume they can be viewed somewhere? |
@maderlock MAGETWO-54787 internal ticket. Let's hope for this to be included in the upcoming release. In a meantime the ALTER table fix works like a charm. I haven't had any complications amending the column name (both dev & prod). |
Thanks @commcad. Not happy with having to adjust the schema, but without any idea of timescales I've used your fix. |
What commcad said. I placed the column in a different place based on the insert query that errored, but I imagine both would work. Here's the query i ran to fix the issue. ALTER TABLE |
I still have the same issue with message in system.log |
Thanks @commcad for posting the fix, works for us too with Magento 2.1.0 |
Sounds like we need a patch release asap. |
Can someone please clarify if I use the ALTER statement here to patch my 2.1.0 install... will that cause any issues when the next prod ver of mage is released/when I upgrade mage? The same issue occurs on PayPal Express if you have it set to not skip the review page... which is necessary if you need to add carrier fetched shipping method/cost... |
The issue has been fixed in 2.1.1 |
Upgraded to 2.1.1 and still getting this issue. The upgrade did not solved this issue for me. |
Hi @usertwelve , |
It's a new installation 2.1.0 and just updated to 2.1.1. Not sure what you mean by Invoice "grid" page but no I don't see errors in the sales/invoice page. Maybe it is because I don't have any invoices yet? Each time I try to make a purchase I end up with this "We can't place order" message. I've tried a few different set-up with Paypal and I get this message each single time. |
If you switch to Authorize Only instead of Authorize and Capture, does it work? Are the payments actually going through on the PayPal side? With the bug in 2.1.0 that was the case... but if setting it to just Authorize only still doesn't work then you've definitely got another issue |
I am assuming you are referring to Authorize.net configuration (since there is no such authorize options with Paypal) but I am only accepting payments with Paypal. I am trying to configure either Paypal Website Payments Standard or Paypal Express Checkout as the only option for payments. (I am already using this setup with 2 other older Magento site with no problems.) Both Paypal options seems to work as supposed but when I clic "Pay now" in Paypal it redirect me to the order review page with the alert "We can't place the order". Even when I select yes to "Skip Order Review Step". No invoice is created and no payments. |
No, he is not referring to that. Look again and pay attention where in PayPal config you see a drop down menu with "Authorize" and "Authorize and Capture". ---- On Mon, 12 Sep 2016 19:07:31 +0200 [email protected] wrote ---- I am assuming you are referring to Authorize.net configuration (since there is no such authorize options with Paypal) but I am only accepting payments with Paypal. I am trying to configure either Paypal Website Payments Standard or Paypal Express Checkout as the only option for payments. (I am already using this setup with 2 other older Magento site with no problems.) Both Paypal options seems to work as supposed but when I clic "Pay now" in Paypal it redirect me to the order review page with the alert "We can't place the order". Even when I select yes to "Skip Order Review Step". No invoice is created and no payments. — |
You're right this config is available in Paypal also but only with Paypal Payflow. Can't find it in Paypal Website Payments Standard nor in the Paypal Express checkout. |
Basic setting -> advanced settings -> billing agreement Check then double check again ---- On Mon, 12 Sep 2016 20:16:26 +0200 [email protected] wrote ---- You're right this config is available in Paypal also but only with Paypal Payflow. Can't find it in Paypal Website Payments Standard nor in the Paypal Express checkout. — |
I have set the Billing Agreement Signup to "Never" and the Paypal Billing Agreement Setting is disabled. |
Sorry Guys looks like my problem is not related to this issues. I have tried again with an other very basic test product and it worked this time. It was related to the product itself.. Maybe because of the customizable option. Thanks for your help. |
Still doesn't work with configurable products; especially those having both swatches + custom options. You will get that same Cannot place order error. However, it works fine if you use a configurable product having either one. Can't have both unfortunately ;) in 2.1.0 and 2.1.1 @usertwelve |
Hey Neil Change pwd and database name (magentodB) with yours From the Command Line Terminal: $ sudo mysql -u root -p |
The problem is stil in Magento 2.1.1 if the product have a Custom Option fields. Im getting an error like this:
|
Hi @plauge , |
Have same issue in Magento 2.1.2 for Some Orders |
Have the same issues in Magento 2.1.3 with certain customers. "We can't place the order" |
THERE IS AN ERROR WITH CONFIGURABLE PRODUCTS OR PRODUCTS WITH OPTIONS. |
Still having same issue on Magento 2.1.4 after payment with Paypal Express Checkout returned to the review page although "Skip review Step" is on with the following error message "We can't place the order". In order to reproduce the problem, take into account that only happens when Paypal is configured with live credentials. |
As LucScu pointed out - Have you guys tried to open the configurable product and save it again. It might give the error- SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1922-1.......... |
Looks like this issue is not fixed with magento 2.1.7 either. Amazing, this issue is still there and not fixed for over a year now. Its being carried over with every new upgrade |
Any solution for this bug? Magento 2.1.7 > Order Variable product with custom option Date > Pay with Paypal Transaction in successful, but after redirecting from paypal there is a red statement We can't place the order. |
[TSG-CSL3] For 2.3 (pr32)
Steps to reproduce
Expected result
Actual result
Trace in TXT format
trace for pp bug.txt
The text was updated successfully, but these errors were encountered: