v1.0.8.1 Questions / Comments / Concerns

[artfulweb]

Hi Matt,
Having updated from Phoenix 1.0.8.0 to 1.0.8.1 using the update file I now have a problem with Paypal on the checkout confirmation page, the "Finalize and Pay" button no longer shows (nor the columns on either side) whereas it worked fine in 1.0.8.1 and all the other payments work correctly. The details of the order show up to where the button should appear. Any idea what would have caused it?

Thanks in advance.

[ecartz]

Usually there would be an error message in the log that would give some hints. Two guesses without that:

1. There's a problem with the CSS, such that the HTML is still there but not visible. View page source to check.
2. There's a problem with a module, such that everything after that module is not showing. This should show in the logs.

[artfulweb]

Hi Matt, thete is nothing in the logs, no addons in the cart and the page surce stops just above the finalize button... a real mystery whereas the other payment modules go all the way.

[artfulweb]

Rolled back to 1.0.8.0 and it works, so something in 1.0.8.1 interferes but I can not see what...

[artfulweb]

Hello Matt,
I started from scratch and installed 1.0.8.1 and finally get an error in the log to explain why the checkout_confirmation page with Paypal will not show the "finalize order" button :

PHP Notice: Undefined variable: db in /xx/xx/xx/xx/catalog/includes/system/segments/checkout/insert_order.php on line 117

PHP Fatal error: Uncaught Error: Call to a member function query() on null in /xx/xx/xx/xx/catalog/includes/system/segments/checkout/insert_order.php:117
Stack trace:
#0 /xx/xx/xx/xx/catalog/includes/modules/payment/paypal_standard.php(184): require()
#1 /xx/xx/xx/xx/catalog/includes/system/versioned/1.0.7.3/payment.php(166): paypal_standard->confirmation()
#2 /xx/xx/xx/xx/catalog/templates/default/includes/pages/checkout_confirmation.php(123): payment->confirmation()
#3 /xx/xx/xx/xx/catalog/checkout_confirmation.php(25): require('/xx/xx/x...')
#4 {main}
thrown in /xx/xx/xx/xx/catalog/includes/system/segments/checkout/insert_order.php on line 117

[artfulweb]

Hello Matt,
I started from scratch and installed 1.0.8.1 and finally get an error in the log to explain why the checkout_confirmation page with Paypal will not show the "finalize order" button :

PHP Notice: Undefined variable: db in /xx/xx/xx/xx/catalog/includes/system/segments/checkout/insert_order.php on line 117

PHP Fatal error: Uncaught Error: Call to a member function query() on null in /xx/xx/xx/xx/catalog/includes/system/segments/checkout/insert_order.php:117
Stack trace:
#0 /xx/xx/xx/xx/catalog/includes/modules/payment/paypal_standard.php(184): require()
#1 /xx/xx/xx/xx/catalog/includes/system/versioned/1.0.7.3/payment.php(166): paypal_standard->confirmation()
#2 /xx/xx/xx/xx/catalog/templates/default/includes/pages/checkout_confirmation.php(123): payment->confirmation()
#3 /xx/xx/xx/xx/catalog/checkout_confirmation.php(25): require('/xx/xx/x...')
#4 {main}
thrown in /xx/xx/xx/xx/catalog/includes/system/segments/checkout/insert_order.php on line 117

Just noticed it only happens if a product has attributes. If no attributes it works normally.

[ecartz]

PHP Notice: Undefined variable: db in /xx/xx/xx/xx/catalog/includes/system/segments/checkout/insert_order.php on line 117

PHP Fatal error: Uncaught Error: Call to a member function query() on null in /xx/xx/xx/xx/catalog/includes/system/segments/checkout/insert_order.php:117

TY. https://github.com/CE-PhoenixCart/Phoen ... 7cd9991b25

[artfulweb]

Thank you! You are the best!

[gsmiley007]

Mysql: Server version: 5.6.32-78.1 - Percona Server (GPL), Release 78.1, Revision 8bb53b6

So I tried to a new install of 1.0.8.4 and i was having database issues, so I tried 1.0.8.1 since it's working on 1.0.8.0.

This is the error i'm getting:

Specified key was too long; max key length is 767 bytes

collation: utf8mb4_unicode_ci

[zipurman]

Mysql: Server version: 5.6.32-78.1 - Percona Server (GPL), Release 78.1, Revision 8bb53b6

So I tried to a new install of 1.0.8.4 and i was having database issues, so I tried 1.0.8.1 since it's working on 1.0.8.0.

This is the error i'm getting:

Specified key was too long; max key length is 767 bytes

collation: utf8mb4_unicode_ci

See viewtopic.php?p=3853#p3853