2.1.0rc - Paypal Website Payments Standard module doesn't work

[commcad]

Steps to reproduce

1. Install Magento from 2.0.7 > Upgrade to 2.1.0rc using Web Setup Wizard (no sample data)
2. Store > Configuration > Sales > Payment Method > Enable Website Payments Standard

3. Insert valid facilitator (merchant) email + API credentials > Save > Clear cache

4. Products > Category > Add New Category
5. Products > Catalog > Add New Product
6. Save everything, go get a coffee, let the cron do their thing every minutes
7. Go to frontend, register as a new customer, place an order, checkout using Paypal

Expected result

1. Succeed page/we have received your order confirmation, order created, qty adjustment, etc

Actual result

1. Error message "We can't place the order."
2. The PP sandbox works fine as I can see the payments in both buyer & facilitator paypal accounts.

Trace in TXT format
trace for pp bug.txt

[commcad]

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)

[commcad]

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
NGINX 1.10.0
MariaDB 10.0.24
PHP 7.0.4
PhpRedis Extension
REDIS 3.2.0 (for session & page cache)

[alena-marchenko]

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.

[commcad]

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.

system.txt

See line no. 1435
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'base_grand_total' in 'field list', query was: INSERT INTO sales_invoice_grid

[commcad]

MariaDB [storedB]> show columns from sales_invoice_grid;
+-----------------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+----------------------+------+-----+---------+-------+
| entity_id | int(10) unsigned | NO | PRI | NULL | |
| increment_id | varchar(50) | YES | MUL | NULL | |
| state | int(11) | YES | MUL | NULL | |
| store_id | smallint(5) unsigned | YES | MUL | NULL | |
| store_name | varchar(255) | YES | | NULL | |
| order_id | int(10) unsigned | NO | MUL | NULL | |
| order_increment_id | varchar(50) | YES | MUL | NULL | |
| order_created_at | timestamp | YES | MUL | NULL | |
| customer_name | varchar(255) | YES | | NULL | |
| customer_email | varchar(255) | YES | | NULL | |
| customer_group_id | smallint(6) | YES | | NULL | |
| payment_method | varchar(128) | YES | | NULL | |
| store_currency_code | varchar(3) | YES | | NULL | |
| order_currency_code | varchar(3) | YES | | NULL | |
| base_currency_code | varchar(3) | YES | | NULL | |
| global_currency_code | varchar(3) | YES | | NULL | |
| billing_name | varchar(255) | YES | MUL | NULL | |
| billing_address | varchar(255) | YES | | NULL | |
| shipping_address | varchar(255) | YES | | NULL | |
| shipping_information | varchar(255) | YES | | NULL | |
| subtotal | decimal(12,4) | YES | | NULL | |
| shipping_and_handling | decimal(12,4) | YES | | NULL | |
| grand_total | decimal(12,4) | YES | MUL | NULL | |
| created_at | timestamp | YES | MUL | NULL | |
| updated_at | timestamp | YES | MUL | NULL | |
+-----------------------+----------------------+------+-----+---------+-------+
25 rows in set (0.00 sec)

[commcad]

MariaDB [storedB]>
> ALTER TABLE sales_invoice_grid ADD base_grand_total decimal(12,4) AFTER grand_total;

;)

[alena-marchenko]

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.

[commcad]

@alena-marchenko

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 :/

debug.txt

[alena-marchenko]

Hi @commcad

We've created MAGETWO-54787 internal ticket regarding this issue.
Thank you.