Hi,

This morning I had a strange behavior:

• A customer tried to pay with Stripe, his card was declined by Stripe
• Few seconds later, he paid with Paypal (module from 202) and succeed
• Stripe sent a webhook just after and order status changed to "Payment Error"

Does webhook check transaction ID or another related thing ?

Thank you !

EDIT: Prestashop 1.7.4 and Stripe Module 2.3.5

Seems the module is not compatible with 1.6.1.x.

In errorlog_php i've many errors like:

[10-May-2021 10:17:58 Europe/Rome] PHP Fatal error: Uncaught exception 'Stripe\Exception\InvalidArgumentException' with message 'api_key cannot contain whitespace' in /home/www/public_html/modules/stripe_official/vendor/stripe/stripe-php/lib/BaseStripeClient.php:227 Stack trace: #0 /home/www/public_html/modules/stripe_official/vendor/stripe/stripe-php/lib/BaseStripeClient.php(59): Stripe\BaseStripeClient->validateConfig(Array) #1 /home/www/public_html/modules/stripe_official/classes/StripeDispute.php(44): Stripe\BaseStripeClient->__construct('\t sk_live_b3BTw...') #2 /home/www/public_html/modules/stripe_official/classes/StripeDispute.php(51): StripeDispute->getAllDisputes() #3 /home/www/public_html/modules/stripe_official/stripe_official.php(1359): StripeDispute->orderHasDispute(NULL) #4 /home/www/public_html/classes/Hook.php(587): Stripe_official->hookDisplayAdminOrderContentOrder(Array) #5 /home/www/public_html/classes/Hook.php(542): HookCore::coreCallHook(Object(Stripe_official), 'hookdisplayAdmi...', Array) #6 /home/xyz in /home/www/public_html/modules/stripe_official/vendor/stripe/stripe-php/lib/BaseStripeClient.php on line 227

this error is created when in BO you can try to edit an order.

Plus if you try to configure the module there are many JS errors that not allow to see the interface:

We run on php 5.6 version but even switching to 7.0 there is the same problem

After a successful charge, the Stripe Dashboard indicates in the Receipt history section for each Payment:

No receipts sent
No email address for this payment

While I see that you are sending the Billing Details > email in the charge payload, according the the Stripe API docs, for an email to be sent to the customer the field receipt_email must be provided in the Payment Intent.

https://stripe.com/docs/api/payment_intents/create#create_payment_intent-receipt_email

Is this an enhancement that can be included in a future version?

Setup to reproduce:

• Install Prestashop in multishop mode.
• Disable stripe in shop 1 and install another payment solution (it should not matter which)
• Enable and configure stripe in shop 2

Provoke the error

• In BO choose shop 1
• Search an order
• Display the details of the order => Error 500

Stacktrace

/vendor/stripe/stripe-php/lib/BaseStripeClient.php in __construct at line 55
/modules/stripe_official/classes/StripeDispute.php in getAllDisputes at line 43
/modules/stripe_official/classes/StripeDispute.php in orderHasDispute at line 51
/modules/stripe_official/stripe_official.php in hookDisplayAdminOrderContentOrder at line 1286

public function hookDisplayAdminOrderContentOrder($params)
{
    $stripePayment = new StripePayment();
    $stripePayment->getStripePaymentByCart($params['order']->id_cart);

    $stripeCapture = new StripeCapture();
    $stripeCapture->getByIdPaymentIntent($stripePayment->getIdPaymentIntent());

    $stripeDispute = new StripeDispute();
    $dispute = $stripeDispute->orderHasDispute($stripePayment->getIdStripe()); <<<<

The reason is stripe is disabled in this shop, thus it is impossible to instantiate the BaseStripeClient.

Solution

hookDisplayAdminOrderContentOrder must not search for disputes, if the module stripe is not activated in the current shop, or if there is no payment:

    if(!empty($stripePayment->getIdStripe())) {
        $stripeDispute = new StripeDispute();
        $dispute = $stripeDispute->orderHasDispute($stripePayment->getIdStripe());
    } else {
        $dispute = null;
    }

Hi,

We started on version 2.3.1, and had occasional issues with orders not being created after payments had been accepted.

We attempted to upgrade to 2.3.2 and only had more issues. At first, it didn't create the webhook automatically. We managed to eventually get the module to do so after entirely removing it and removing the STRIPE_* configuration keys in the database.

However, now it doesn't capture payments either as the Webhook returns a 'Fatal error' to stripe, this is logged in the stripe_official_processlogger table:

Invalid signature : Unable to extract timestamp and signatures from header

As far as I can see from the Stripe dashboard, the STRIPE_WEBHOOK_SIGNATURE is the correct value.

Unfortunately, even in this case, it still presents an order success page, even though the payment is left uncaptured and no order is created within PrestaShop.

Please advise, as we have had to disable taking Stripe payments at the moment until this is resolved, as we cannot be sure that payments will succeed or even fail in a transparent way to the user.

Hi I have now received multiple messages from my customers that the buy products button is not useable in some cases such as in this screenshot a customer send to me:

Every time I issue a partial refund, I mark the order as canceled and send the email to the customer as canceled. How can I solve the problem?

I have big issues with the stripe module in the current version 2.3.5 and your support from prestashop addons told me that it is not possible anymore with 2.3.5 to support multistore core feature of prestashop. Is this true?
My config is the following.

I have 3 domains

abcabc.at
abcabc.de
abcabc.ch

Each domain has it's own stripe account. As I have 3 different credentials I always chose the shop/domain in the backoffice and set the credentials for the shop.
Nice and easy, no worries until now....

It all started with the issue that payments from only from abcabc.at were captured. With another update the orders from the domains abcabc.de and abcabc.ch were also not captured and after placing an test order you get always redirected to your account with your order history, but no order confirmation. In the background the order still seems to be some kind of validated because I can see this in the stripe dashboard.

Any ideas or help??

Hi,

It should be nice if you could will the payment detail, description field with something like "{shopname} Order {order_id}
It would be easier for accounting department to match payment and order.

Regards,
Luc

Hi,

I've installed the module on my prestashop website. I've also connected the module to Stripe.
Payments are processed successfully but the webhook is not configured in my Stripe account and the status of some intend payments are not updated.
I have no idea of the URL of the endpoint that I should create as it is specified in the documentation that the webhook should be created automatically.

Thank you for your help.

There is a problem with 1.7.7.4 version of Prestashop, when we open an order into backoffice the template is not rendered.
After some investigation I see that we need to change at row 1350 of "stripe_official.php"

FROM:

        $stripePayment = new StripePayment();
        $stripePayment->getStripePaymentByCart($params['order']->id_cart);

TO

        $order = new Order($params["id_order"]);
        $stripePayment = new StripePayment();
        $stripePayment->getStripePaymentByCart($order->id_cart);

This permit to have valid smarty parameters assignment.
After that we cannot already see the correct tab:

This is because also into the hookDisplayAdminOrderTabOrder the $params does not contain "order" child, but only "id_order" and after whe have changed it to (at row 1334):

        $order = new Order($params["id_order"]);
        if ($order->module != 'stripe_official') {
            return;
        }

now all work fine.

Dear Support, after a payment the hook DisplayOrderConfirmation is not called.
Test on Prestashop 1.7.7.4 installed from scratch and test mode for Stripe.

This is a big issue as several modules need this hook to dispatch pixels and/or trigger somme conversion data.
Best regards

Hello,

we're running PrestaShop 1.7.6.7 and Stripe payment module v2.3.1.

A limited number of customers complain that they can't complete checkout on our website as the form simply freezes after entering card details and submitting.

The error on the Stripe dashboard seems to be:

parameter_missing - payment_method The payment_method parameter supplied pm_*********************** belongs to the Customer cus_***********************. Please include the Customer in the customer parameter on the PaymentIntent.

This seems to happen on multiple clients:

• Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.1.1 Safari/605.1.15

• Mozilla/5.0 (iPhone; CPU iPhone OS 14_7_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.1.2 Mobile/15E148 Safari/604.1

• Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/92.0.4515.131 Safari/537.36

It's also happening to existing customers who ordered in the past but now can't seem to place an order.

Any hints on what could be causing this? Thank you

I am trying to setup google pay and this button appears in test mode but it doesn't use the default google pay button branding because of which I am getting rejected from using google pay on my store :

Prestashop setup

• Setup prestashop in multishop node
• Configure shop 1 with stripe account 1
• Configure shop 2 with stripe account 2

Action that leads to error

• Connect to Prestshop BO
• Select All shops
• Search for an order of shop 2
• Display that order
• => The information in the payment detail will not show the disputes on the payment.

Explanation

In the function orderHasDispute (classes/StripeDispute.php, line 51), $disputes = $this->getAllDisputes();` should get the disputes of the stripe account connected to the shop of the current order, but, since no shop is selected, it will connect to the stripe account of shop 1 (Prestashop always loads the configuration of shop 1 if no shop is selected).

PS : 1.6.1.7
Stripe module : 2.3.1

Error received:

"The provided PaymentMethod has failed authentication. You can provide payment_method_data or a new PaymentMethod to attempt to fulfill this PaymentIntent again."

How to reproduce:

• Payment initiated with bancontact (belgian payment mean) then cancelled during the payment
• go back to the payment page and chose credit card
• fill the card information then pay
  => error received

In the logs, payment_method_types is still "bancontact" despite the fact that card has been chosen afterward:

  "payment_method_types": [
    "bancontact"
  ],

"expected_payment_method_type": "card",

More logs are available if needed.
Btw, same payment is used even bancontact try has been cancelled and I can't see any try to update the payment method in the payment initiated which is still noted as "bancontact"

Thanks

Hello,

I'd like to suggest a great feature for this Prestashop module.

I own multiple shops and I'd like to have a custom statement for each shop instead of the default one configured on my Stripe account.
For example, my company's name is Raphy Shops and the default statement descriptor is RAPHY SHOPS and the shortened descriptor is RS.
I own 2 shops : Awesome Shop and Dess Me. I'd like to set the descriptors AWESOME SHOP / AS and DRESS ME / DM for these shops :)

In the module configuration we can add a checkbox Override default statements and allow to override the statement descriptor and the shortened one.

I've never developed Prestashop modules but if I can, I will suggest à PR ;)

For quite some time now, the orders that are done with the module where customers used "SOFORT" as the payment option, seem to be stuck in the "payment pending / waiting for payment" state even if the payment is already received and displayed in the stripe backend.

There is a bug with the display of the card icons in multistore environment

How to reproduce:

• I have a Prestashop installation with multistore enabled.
• I installed stripe in more than one store.
• I checked in the options of the Stripe module Display the long version of the form with the card logos instead of the condensed version.

Expected behavior:

On the payment form of each store are displayed the icons of the current store

Actual behavior:

All the icons of all the stores display everywhere.

Example configuration:

• Store 1: enable Mastercard, Visa and Amex
• Store 2: enable CB, Mastercard and Visa
  Result: in both stores is displayed the following 1 CB icon, 2 Mastercard icons, 2 Visa icons and 1 Amex icons

Dear community,

I have a problem with my stripe v2.1.0 module on Prestashop v1.7.6.4 and PHP 7.3.18.
When I go to card options for payment, I see this and I can't go forward:

I think it's a resource loading problem, as stripe is configured correctly and this seems to be a fairly common problem.
Can you help me? Thanks in advance

Hello,

We are a Dutch webshop.
But we also have multistores in Saudi Arabia and Argentina.
So in the Prestashop backoffice at localisation these multistores have Saudi Arabia and Argentina as default country.
But when customers try to pay in these two multistores we get the following error:

(index):1 Uncaught (in promise) IntegrationError: Invalid value for paymentRequest(): country should be one of the following strings: AE, AT, AU, BE, BG, BR, CA, CH, CI, CR, CY, CZ, DE, DK, DO, EE, ES, FI, FR, GB, GI, GR, GT, HK, HU, ID, IE, IN, IT, JP, LI, LT, LU, LV, MT, MX, MY, NL, NO, NZ, PE, PH, PL, PT, RO, SE, SG, SI, SK, SN, TH, TT, US, UY. You specified: SA.

Is there a fix for this problem?

Thank you.

Best regards,
Niels Roest
BricksDirect

This issue tracks the status of the stripe_official module for PrestaShop 2.1.1 release

Information

Current status

• Specification
• Feature development
  • PrestaShop 1.7.7 compatibility
  • Pull request #3
  • Add a description on Stripe Dashboard about the payment #11
• Translations
• Stabilization
• Build (Beta)
• QA validation (Beta)
• Support team training // docs updates
• Release (Beta)
• Final release
• Available on PrestaShop addons

I got some signature issues when switching from TEST to PROD or PROD to TEST and playing with the keys.
I had to remove the keys from the database and reinstall them to get finally TEST working.
But now I got some signature issue on PROD.

As far as I see in the ps_configuration table, there is only one signature (STRIPE_WEBHOOK_SIGNATURE field).
How do you manage the signature for both TEST and PROD env ?

Hi,

I see you're committing changes regarding the Authorize and Capture functionnality.

Is it "safe" to use the developer branch to use this functionnality now?
If not, do you know when you should publish a stable version?

Many thanks!

This issue tracks the status of the stripe_official module for PrestaShop 2.3.0 release

Information

Current status

• Specification
• Feature development
  • Add OXXO payment method
  • Add Alipay payment method
  • Add dispute statut on order
  • Other
• Translations
• Stabilization
• Build (Beta)
• QA validation (Beta)
• Support team training // docs updates
• Release (Beta)
• Final release
• Available on PrestaShop addons

This issue tracks the status of the stripe_official module for PrestaShop 2.1.0 release

Information

Current status

• Specification
• Feature development
  • Save and re-use credit cards
  • Authorized and catch payments according to order steps
  • Webhook auto creating during the onboarding
  • Improve webhook call with Signature Key
• Translations
• Stabilization
• Build (Beta)
• QA validation (Beta)
• Support team training // docs updates
• Release (Beta)
• Final release
• Available on PrestaShop addons

button google pay not showing on Aandroid devices

Hi!

I'm trying to use credit card autosave feature, but doesn't work.

The selector input[data-module-name="stripe_official"] not present, so param card_form_payment is always false

Where it's supposed to be?

Thanks!

I've encountered an error affecting payments after upgrading to 2.1.0 on Prestashop 1.7.6.5

Payments were initially not being completed once the "Order with an obligation to pay" button was clicked and changed to "Processing...", as the process just hung at this stage.

In troubleshooting this issue, I have completely removed the module as well as renaming all the "ps_stripe..." tables in the database to try to start from scratch. After doing so, the first payment test using the test keys and card number work successfully. After this, all payments using the test or live keys fail with "A processing error occurred."

The relevant comments in the console are as follows:
Request URL: https://api.stripe.com/v1/payment_intents/pi_1GvgZJKxPxnnhXBEkiFQtqOc/confirm
Request Method: POST
Status Code: 400
"
{error: {code: "payment_intent_unexpected_state",…}}
error: {code: "payment_intent_unexpected_state",…}
code: "payment_intent_unexpected_state"
doc_url: "https://stripe.com/docs/error-codes/payment-intent-unexpected-state"
message: "You cannot confirm this PaymentIntent because it has already succeeded after being previously confirmed."
payment_intent: {id: "pi_1GvgZJKxPxnnhXBEkiFQtqOc", object: "payment_intent", amount: 740, canceled_at: null,…}
type: "invalid_request_error"
"
Then an event:
"
event: elements.confirm_payment_intent.server_error
event_count: 31
timestamp: 1592559663116
version: 8ce3d6c5
running_tests: false
frame_width: 1225
error-code: payment_intent_unexpected_state
error-doc_url: https://stripe.com/docs/error-codes/payment-intent-unexpected-state
error-message: You cannot confirm this PaymentIntent because it has already succeeded after being previously confirmed.
error-payment_intent-id: pi_1GvgZJKxPxnnhXBEkiFQtqOc
error-payment_intent-object: payment_intent
error-payment_intent-amount: 740
error-payment_intent-capture_method: automatic
error-payment_intent-client_secret: redacted
error-payment_intent-confirmation_method: automatic
error-payment_intent-created:
error-payment_intent-currency: gbp
error-payment_intent-livemode: false
error-payment_intent-payment_method_types: card
error-payment_intent-source: src_1GvgZvKxPxnnhXBEEJxO4n0w
error-payment_intent-status: succeeded
error-type: invalid_request_error
element: cardNumber
key: pk_test__redacted_
referrer: https://www.redacted.com/store/order
betas: payment_intent_beta_3
stripe_js_id: 5a4247e6-8b45-4c67-8364-95284faac0e4
wrapper: unknown
es_module: false
"

Unsure of how to proceed from here as I can't see any issue with the setup of the module, and this issue only started after upgrading from the previous version of the module. Happy to collect more info as needed! Will roll back to previous version to keep the site live though.

Stripe Module doesn't work behind a HTTP Proxy, the problem come from the cURL. I can't configure the stripe keys because cURL doesn't take environnement variables.

Stripe ne marche pas derrière un Proxy HTTP, je sais que le problème vient de cURL. Je ne peux pas valider les clés stripe car cURL ne prend pas l'option Proxy.

TL;DR When customer make a payment using non card method (Sofort, P24) and will not click back to shop there is no order on Prestashop side.

I had from time to time customers who paid me money.
I can see it on Stripe dashboard but there was no order on Prestashop side.
No order, no error, nothing.

Some customers are too fast and will not wait or click back to shop and there is problem that there will be no orders on Prestashop.

I think that this is important problem.

To reproduce the order

1. start any order (not using a card)
2. after successful order do not click back to shop or do not wait, just close the window
3. result: on stripe side you will get a money, but there will be no order on prestashop side

I had a many customers like that as I finally figure out that is the problem.

This issue tracks the status of the stripe_official module for PrestaShop 2.2.0 release

Information

Current status

• Specification
• Feature development
  • Upgrade Stripe-php SDK (:warning: = breaking changes)
  • Refactoring iDeal method with payment intents
  • Refactoring Bancontact method with payment intents
  • Refactoring Giropay method with payment intents
  • Create EPS payment method
  • Create FPX payment method
  • Create P24 payment method
  • Create Sepa debit payment method
• Translations
• Stabilization
• Build (Beta)
• QA validation (Beta)
• Support team training // docs updates
• Release (Beta)
• Final release
• Available on PrestaShop addons

Prestahsop version: 1.7.6.8

stripe_official version : v2.3.7

Payment made using this module is not visible in the backend of Prestashop.

Payments are visible in stripe dashbaord

This issue tracks the status of the stripe_official module for PrestaShop 2.x.x release

Information

Current status

• Specification
• Feature development
  • Refactoring SoFort method with payment intents
  • Add Multibanco debit payment method
  • Other
• Translations
• Stabilization
• Build (Beta)
• QA validation (Beta)
• Support team training // docs updates
• Release (Beta)
• Final release
• Available on PrestaShop addons

Hi,
I use the Stripe addon, and I have noticed that, when I go to my shopping cart, the Visa/Mastercard logo turns out gigantic (over half a webpage, too big for a screenshot).
Also, in its folder within the modules, the image is 100x324 in size.
Could you look into that, please?
Thanks.

Hi guys, I have encountered some incorrect charges, specifically in one case greater than the order amount and in another case lower. The version of the module used 2.3.1 instead PS v1.7.7.1
If you provide me with information on how to proceed to identify the cause of the bug we could investigate further.
Thanks

hi
I have the ps_stripe_official_processlogger table of several megabytes which slows down a client's site then I emptied it without making him lose important or sensitive data it takes more than 500 MB it is really huge due to spam attacks, I do not take care of spam just to lighten and clean the site
cordialy

Hi, I encounter this error whenever I install the module. I hope the image can provide more information about this.

MySQL version: 8.0.23
MySQL engine: InnoDB
PHP version: 7.2.34
PrestaShop version: 1.7.7.2

This has been broken for a couple of months.

https://www.prestashop.com/forums/topic/1046676-error-in-connecting-account-with-stripe-platform/

PS 1.6.1.7
Module Stripe: 2.3.2

TEST mode

Trying to make a payement with fake card 4242...
Payment is initiated but stays uncaptured in Stripe (as payment method is card and capture method is manual in your code)

Order is in payment accepted status in BO but payment has to be captured manually in Stripe...

Payment should be captured

nb: module is not configure with catch and authorize

Sometimes when a customer places and order I receive the payment, but the order in prestashop is not created. Customer receives error message that there was an error during payment, as if the payment was rejected. In the prestashop logs I found the following: Frontcontroller::init - Cart cannot be loaded or an order has already been placed using this cart

No logos are shown in my 1.7.6.2 Prestashop for the Stripe payment methods. I checked in stripe_official.php and the line "->setLogo(Media::getMediaPath(PS_MODULE_DIR.$this->name.'/views/img/'.$cc_img))" was commented out. Removing the comment mark does not solve it as cc_img is not defined.

Invalid Stripe API version: 2020-03-02;alipay_beta=v1. You do not have permission to pass this beta header: alipay_beta. If you have any questions, we can help at https://support.stripe.com/.

I updated both the module and the api to the latest version but the payment problem continues to persist.

Version module 2.2.2
Prestashop 1.7.6.8

Prestashop 1.7 makes heavy usage of composer. Many modules can be installed with composer adding them to PrestaShop's composer.json.

In order for this to work, the module's composer.json must adhere to some rules (see Prestashop doc). Especially, "type": "prestashop-module" is required (and more general fields like name, description, homepage and authors.

I can prepare a pull request that allows then to include stript_official in a Prestashop install with composer. by adding this to to Prestashop's composer.json:

"require": {
    "202-ecommerce/stripe_official": "dev-master#<commit>",
    ( ... Prestashop's requirements ... )
},
"repositories": [
    {
        "type": "vcs",
        "url": "[email protected]:202-ecommerce/stripe-official.git"
    },
    ( ... Prestashop's custom repositories ... )

I dont' know what other steps would be required to allow simple composer require 202-ecommerce/stripe_official.

Are you interested in this pull request? Or do you think the use cases would be too small? (I'm using it for our custom deployments of Prestashop).

Thanks for the great module.

A visibility issue:
The addon page exists but https://addons.prestashop.com/en/payment-card-wallet/24922-stripe-official-sca-ready.html is not possible to find on addons.prestashop.com by e.g. using the Search. I am not sure it's expected especially that Stripe is a partner to Prestashop. In particual I am unsure this can be the cause for the next issue as explained below.

More importantly in the Prestashop backoffice (1.7.7.2) the module is not listed in the module manager. The only way to access the configuration page is to visit the URL ..../index.php?controller=AdminModules&configure=stripe_official directly. Anyway, updating, uninstalling or disabling the module is not possible.

Attaching a screenshot for my all pretty standard payment modules.

Furthermore, the Design->Positions page lists the module hooks just fine; here's an excerpt:

That said, the stripe integration works for card payments, not for Digital Wallets like Google Pay (they're enabled in the config).

Best regards
Jarek

Hello,
if the charge.failed webhook is called, ValidationOrderAction will set the current state of the order to PS_OS_ERROR (payment fail) even if the command was already in PS_OS_PAYMENT (payment success).

Example :
A client have payment_intent( 1) "blocked" by a rule ("Block if :address_zip_check: = 'fail'").
So he retry a new payment_intent(2), => success, the order is created with statut (payment success). all is ok.
1h later, the webhook charge.failed from the payment_intent(1) is fired again. Captured by ValidationOrderAction and set the order state do payment failed.

How can we fix that ? Check if the order is not already in success ? The initial charge.failed shouldn't send back a http400 so there is no retry send ?

Hello, i'm trying to implement stripe on my prestashop, all the payment process is ok, but when i try to see the order from backoffice i get error 500, with debug enabled it gives me

Class 'Stripe\Service\CoreServiceFactory' not found

prestashop version is 1.7.6.8 and PHP 7.2.34

stacktrace:

Symfony\Component\Debug\Exception\ClassNotFoundException:
Attempted to load class "CoreServiceFactory" from namespace "Stripe\Service".
Did you forget a "use" statement for another namespace?

at modules/stripe_official/vendor/stripe/stripe-php/lib/StripeClient.php:72
at Stripe\StripeClient->__get('disputes')
(modules/stripe_official/classes/StripeDispute.php:46)
at StripeDispute->getAllDisputes()
(modules/stripe_official/classes/StripeDispute.php:51)
at StripeDispute->orderHasDispute('ch_1IdecPJi0qnrey3K9bLOqi6s')
(modules/stripe_official/stripe_official.php:1359)
at Stripe_official->hookDisplayAdminOrderContentOrder(array('order' => object(Order), 'products' => array(array('id_order_detail' => '11', 'id_order' => '8', 'id_order_invoice' => '2', 'id_warehouse' => '0', 'id_shop' => '1', 'product_id' => '20', 'product_attribute_id' => '45', 'id_customization' => '0', 'product_name' => 'stan smith - Numero : 38- Colore : rosso', 'product_quantity' => '1', 'product_quantity_in_stock' => '1', 'product_quantity_refunded' => '0', 'product_quantity_return' => '0', 'product_quantity_reinjected' => '0', 'product_price' => 110.0, 'reduction_percent' => '0.00', 'reduction_amount' => '0.000000', 'reduction_amount_tax_incl' => '0.000000', 'reduction_amount_tax_excl' => '0.000000', 'group_reduction' => '0.00', 'product_quantity_discount' => '0.000000', 'product_ean13' => '', 'product_isbn' => '', 'product_upc' => '', 'product_reference' => '', 'product_supplier_reference' => '', 'product_weight' => '0.000000', 'id_tax_rules_group' => '2', 'tax_computation_method' => '0', 'tax_name' => '', 'tax_rate' => 10.0, 'ecotax' => '0.000000', 'ecotax_tax_rate' => '0.000', 'discount_quantity_applied' => '0', 'download_hash' => '', 'download_nb' => '0', 'download_deadline' => '0000-00-00 00:00:00', 'total_price_tax_incl' => '121.000000', 'total_price_tax_excl' => '110.000000', 'unit_price_tax_incl' => '121.000000', 'unit_price_tax_excl' => '110.000000', 'total_shipping_price_tax_incl' => '0.000000', 'total_shipping_price_tax_excl' => '0.000000', 'purchase_supplier_price' => '0.000000', 'original_product_price' => '110.000000', 'original_wholesale_price' => '0.000000', 'id_product' => '20', 'id_supplier' => '0', 'id_manufacturer' => '3', 'id_category_default' => '12', 'id_shop_default' => '1', 'on_sale' => '0', 'online_only' => '0', 'ean13' => '', 'isbn' => '', 'upc' => '', 'quantity' => '0', 'minimal_quantity' => '1', 'low_stock_threshold' => null, 'low_stock_alert' => '0', 'price' => '110.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'reference' => '', 'supplier_reference' => '', 'location' => '', 'width' => '0.000000', 'height' => '0.000000', 'depth' => '0.000000', 'weight' => '0.000000', 'out_of_stock' => '2', 'additional_delivery_times' => '1', 'quantity_discount' => '0', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '301-category', 'id_type_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'show_condition' => '0', 'condition' => 'new', 'show_price' => '1', 'indexed' => '1', 'visibility' => 'both', 'cache_is_pack' => '0', 'cache_has_attachments' => '0', 'is_virtual' => '0', 'cache_default_attribute' => '45', 'date_add' => '2021-04-07 16:12:47', 'date_upd' => '2021-04-07 16:21:20', 'advanced_stock_management' => '0', 'pack_stock_type' => '3', 'state' => '1', 'image' => object(Image), 'image_size' => array(77, 45, 2, 'width="77" height="45"', 'bits' => 8, 'channels' => 3, 'mime' => 'image/jpeg'), 'current_stock' => 8, 'tax_calculator' => object(TaxCalculator), 'product_price_wt' => 121.0, 'product_price_wt_but_ecotax' => 121.0, 'total_wt' => '121.000000', 'total_price' => '110.000000', 'customizedDatas' => null, 'customizationQuantityTotal' => 0, 'id_address_delivery' => '6', 'image_tag' => '<img src="../img/tmp/product_mini_20_45.jpg?time=1617814461" alt="" class="imgm img-thumbnail" />', 'customized_product_quantity' => 0, 'quantity_refundable' => 1, 'amount_refundable' => 110.0, 'amount_refundable_tax_incl' => 121.0, 'amount_refund' => null, 'refund_history' => array(), 'return_history' => array(), 'warehouse_name' => '--', 'warehouse_location' => false, 'pack_items' => array())), 'customer' => object(Customer), 'cookie' => object(Cookie), 'cart' => object(Cart), 'altern' => 3))
(classes/Hook.php:970)
at HookCore::coreCallHook(object(Stripe_official), 'hookdisplayAdminOrderContentOrder', array('order' => object(Order), 'products' => array(array('id_order_detail' => '11', 'id_order' => '8', 'id_order_invoice' => '2', 'id_warehouse' => '0', 'id_shop' => '1', 'product_id' => '20', 'product_attribute_id' => '45', 'id_customization' => '0', 'product_name' => 'stan smith - Numero : 38- Colore : rosso', 'product_quantity' => '1', 'product_quantity_in_stock' => '1', 'product_quantity_refunded' => '0', 'product_quantity_return' => '0', 'product_quantity_reinjected' => '0', 'product_price' => 110.0, 'reduction_percent' => '0.00', 'reduction_amount' => '0.000000', 'reduction_amount_tax_incl' => '0.000000', 'reduction_amount_tax_excl' => '0.000000', 'group_reduction' => '0.00', 'product_quantity_discount' => '0.000000', 'product_ean13' => '', 'product_isbn' => '', 'product_upc' => '', 'product_reference' => '', 'product_supplier_reference' => '', 'product_weight' => '0.000000', 'id_tax_rules_group' => '2', 'tax_computation_method' => '0', 'tax_name' => '', 'tax_rate' => 10.0, 'ecotax' => '0.000000', 'ecotax_tax_rate' => '0.000', 'discount_quantity_applied' => '0', 'download_hash' => '', 'download_nb' => '0', 'download_deadline' => '0000-00-00 00:00:00', 'total_price_tax_incl' => '121.000000', 'total_price_tax_excl' => '110.000000', 'unit_price_tax_incl' => '121.000000', 'unit_price_tax_excl' => '110.000000', 'total_shipping_price_tax_incl' => '0.000000', 'total_shipping_price_tax_excl' => '0.000000', 'purchase_supplier_price' => '0.000000', 'original_product_price' => '110.000000', 'original_wholesale_price' => '0.000000', 'id_product' => '20', 'id_supplier' => '0', 'id_manufacturer' => '3', 'id_category_default' => '12', 'id_shop_default' => '1', 'on_sale' => '0', 'online_only' => '0', 'ean13' => '', 'isbn' => '', 'upc' => '', 'quantity' => '0', 'minimal_quantity' => '1', 'low_stock_threshold' => null, 'low_stock_alert' => '0', 'price' => '110.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'reference' => '', 'supplier_reference' => '', 'location' => '', 'width' => '0.000000', 'height' => '0.000000', 'depth' => '0.000000', 'weight' => '0.000000', 'out_of_stock' => '2', 'additional_delivery_times' => '1', 'quantity_discount' => '0', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '301-category', 'id_type_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'show_condition' => '0', 'condition' => 'new', 'show_price' => '1', 'indexed' => '1', 'visibility' => 'both', 'cache_is_pack' => '0', 'cache_has_attachments' => '0', 'is_virtual' => '0', 'cache_default_attribute' => '45', 'date_add' => '2021-04-07 16:12:47', 'date_upd' => '2021-04-07 16:21:20', 'advanced_stock_management' => '0', 'pack_stock_type' => '3', 'state' => '1', 'image' => object(Image), 'image_size' => array(77, 45, 2, 'width="77" height="45"', 'bits' => 8, 'channels' => 3, 'mime' => 'image/jpeg'), 'current_stock' => 8, 'tax_calculator' => object(TaxCalculator), 'product_price_wt' => 121.0, 'product_price_wt_but_ecotax' => 121.0, 'total_wt' => '121.000000', 'total_price' => '110.000000', 'customizedDatas' => null, 'customizationQuantityTotal' => 0, 'id_address_delivery' => '6', 'image_tag' => '<img src="../img/tmp/product_mini_20_45.jpg?time=1617814461" alt="" class="imgm img-thumbnail" />', 'customized_product_quantity' => 0, 'quantity_refundable' => 1, 'amount_refundable' => 110.0, 'amount_refundable_tax_incl' => 121.0, 'amount_refund' => null, 'refund_history' => array(), 'return_history' => array(), 'warehouse_name' => '--', 'warehouse_location' => false, 'pack_items' => array())), 'customer' => object(Customer), 'cookie' => object(Cookie), 'cart' => object(Cart), 'altern' => 3))
(classes/Hook.php:355)
at HookCore::callHookOn(object(Stripe_official), 'displayAdminOrderContentOrder', array('order' => object(Order), 'products' => array(array('id_order_detail' => '11', 'id_order' => '8', 'id_order_invoice' => '2', 'id_warehouse' => '0', 'id_shop' => '1', 'product_id' => '20', 'product_attribute_id' => '45', 'id_customization' => '0', 'product_name' => 'stan smith - Numero : 38- Colore : rosso', 'product_quantity' => '1', 'product_quantity_in_stock' => '1', 'product_quantity_refunded' => '0', 'product_quantity_return' => '0', 'product_quantity_reinjected' => '0', 'product_price' => 110.0, 'reduction_percent' => '0.00', 'reduction_amount' => '0.000000', 'reduction_amount_tax_incl' => '0.000000', 'reduction_amount_tax_excl' => '0.000000', 'group_reduction' => '0.00', 'product_quantity_discount' => '0.000000', 'product_ean13' => '', 'product_isbn' => '', 'product_upc' => '', 'product_reference' => '', 'product_supplier_reference' => '', 'product_weight' => '0.000000', 'id_tax_rules_group' => '2', 'tax_computation_method' => '0', 'tax_name' => '', 'tax_rate' => 10.0, 'ecotax' => '0.000000', 'ecotax_tax_rate' => '0.000', 'discount_quantity_applied' => '0', 'download_hash' => '', 'download_nb' => '0', 'download_deadline' => '0000-00-00 00:00:00', 'total_price_tax_incl' => '121.000000', 'total_price_tax_excl' => '110.000000', 'unit_price_tax_incl' => '121.000000', 'unit_price_tax_excl' => '110.000000', 'total_shipping_price_tax_incl' => '0.000000', 'total_shipping_price_tax_excl' => '0.000000', 'purchase_supplier_price' => '0.000000', 'original_product_price' => '110.000000', 'original_wholesale_price' => '0.000000', 'id_product' => '20', 'id_supplier' => '0', 'id_manufacturer' => '3', 'id_category_default' => '12', 'id_shop_default' => '1', 'on_sale' => '0', 'online_only' => '0', 'ean13' => '', 'isbn' => '', 'upc' => '', 'quantity' => '0', 'minimal_quantity' => '1', 'low_stock_threshold' => null, 'low_stock_alert' => '0', 'price' => '110.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'reference' => '', 'supplier_reference' => '', 'location' => '', 'width' => '0.000000', 'height' => '0.000000', 'depth' => '0.000000', 'weight' => '0.000000', 'out_of_stock' => '2', 'additional_delivery_times' => '1', 'quantity_discount' => '0', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '301-category', 'id_type_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'show_condition' => '0', 'condition' => 'new', 'show_price' => '1', 'indexed' => '1', 'visibility' => 'both', 'cache_is_pack' => '0', 'cache_has_attachments' => '0', 'is_virtual' => '0', 'cache_default_attribute' => '45', 'date_add' => '2021-04-07 16:12:47', 'date_upd' => '2021-04-07 16:21:20', 'advanced_stock_management' => '0', 'pack_stock_type' => '3', 'state' => '1', 'image' => object(Image), 'image_size' => array(77, 45, 2, 'width="77" height="45"', 'bits' => 8, 'channels' => 3, 'mime' => 'image/jpeg'), 'current_stock' => 8, 'tax_calculator' => object(TaxCalculator), 'product_price_wt' => 121.0, 'product_price_wt_but_ecotax' => 121.0, 'total_wt' => '121.000000', 'total_price' => '110.000000', 'customizedDatas' => null, 'customizationQuantityTotal' => 0, 'id_address_delivery' => '6', 'image_tag' => '<img src="../img/tmp/product_mini_20_45.jpg?time=1617814461" alt="" class="imgm img-thumbnail" />', 'customized_product_quantity' => 0, 'quantity_refundable' => 1, 'amount_refundable' => 110.0, 'amount_refundable_tax_incl' => 121.0, 'amount_refund' => null, 'refund_history' => array(), 'return_history' => array(), 'warehouse_name' => '--', 'warehouse_location' => false, 'pack_items' => array())), 'customer' => object(Customer), 'cookie' => object(Cookie), 'cart' => object(Cart), 'altern' => 3))
(classes/Hook.php:907)
at HookCore::exec('displayAdminOrderContentOrder', array('order' => object(Order), 'products' => array(array('id_order_detail' => '11', 'id_order' => '8', 'id_order_invoice' => '2', 'id_warehouse' => '0', 'id_shop' => '1', 'product_id' => '20', 'product_attribute_id' => '45', 'id_customization' => '0', 'product_name' => 'stan smith - Numero : 38- Colore : rosso', 'product_quantity' => '1', 'product_quantity_in_stock' => '1', 'product_quantity_refunded' => '0', 'product_quantity_return' => '0', 'product_quantity_reinjected' => '0', 'product_price' => 110.0, 'reduction_percent' => '0.00', 'reduction_amount' => '0.000000', 'reduction_amount_tax_incl' => '0.000000', 'reduction_amount_tax_excl' => '0.000000', 'group_reduction' => '0.00', 'product_quantity_discount' => '0.000000', 'product_ean13' => '', 'product_isbn' => '', 'product_upc' => '', 'product_reference' => '', 'product_supplier_reference' => '', 'product_weight' => '0.000000', 'id_tax_rules_group' => '2', 'tax_computation_method' => '0', 'tax_name' => '', 'tax_rate' => 10.0, 'ecotax' => '0.000000', 'ecotax_tax_rate' => '0.000', 'discount_quantity_applied' => '0', 'download_hash' => '', 'download_nb' => '0', 'download_deadline' => '0000-00-00 00:00:00', 'total_price_tax_incl' => '121.000000', 'total_price_tax_excl' => '110.000000', 'unit_price_tax_incl' => '121.000000', 'unit_price_tax_excl' => '110.000000', 'total_shipping_price_tax_incl' => '0.000000', 'total_shipping_price_tax_excl' => '0.000000', 'purchase_supplier_price' => '0.000000', 'original_product_price' => '110.000000', 'original_wholesale_price' => '0.000000', 'id_product' => '20', 'id_supplier' => '0', 'id_manufacturer' => '3', 'id_category_default' => '12', 'id_shop_default' => '1', 'on_sale' => '0', 'online_only' => '0', 'ean13' => '', 'isbn' => '', 'upc' => '', 'quantity' => '0', 'minimal_quantity' => '1', 'low_stock_threshold' => null, 'low_stock_alert' => '0', 'price' => '110.000000', 'wholesale_price' => '0.000000', 'unity' => '', 'unit_price_ratio' => '0.000000', 'additional_shipping_cost' => '0.00', 'reference' => '', 'supplier_reference' => '', 'location' => '', 'width' => '0.000000', 'height' => '0.000000', 'depth' => '0.000000', 'weight' => '0.000000', 'out_of_stock' => '2', 'additional_delivery_times' => '1', 'quantity_discount' => '0', 'customizable' => '0', 'uploadable_files' => '0', 'text_fields' => '0', 'active' => '1', 'redirect_type' => '301-category', 'id_type_redirected' => '0', 'available_for_order' => '1', 'available_date' => '0000-00-00', 'show_condition' => '0', 'condition' => 'new', 'show_price' => '1', 'indexed' => '1', 'visibility' => 'both', 'cache_is_pack' => '0', 'cache_has_attachments' => '0', 'is_virtual' => '0', 'cache_default_attribute' => '45', 'date_add' => '2021-04-07 16:12:47', 'date_upd' => '2021-04-07 16:21:20', 'advanced_stock_management' => '0', 'pack_stock_type' => '3', 'state' => '1', 'image' => object(Image), 'image_size' => array(77, 45, 2, 'width="77" height="45"', 'bits' => 8, 'channels' => 3, 'mime' => 'image/jpeg'), 'current_stock' => 8, 'tax_calculator' => object(TaxCalculator), 'product_price_wt' => 121.0, 'product_price_wt_but_ecotax' => 121.0, 'total_wt' => '121.000000', 'total_price' => '110.000000', 'customizedDatas' => null, 'customizationQuantityTotal' => 0, 'id_address_delivery' => '6', 'image_tag' => '<img src="../img/tmp/product_mini_20_45.jpg?time=1617814461" alt="" class="imgm img-thumbnail" />', 'customized_product_quantity' => 0, 'quantity_refundable' => 1, 'amount_refundable' => 110.0, 'amount_refundable_tax_incl' => 121.0, 'amount_refund' => null, 'refund_history' => array(), 'return_history' => array(), 'warehouse_name' => '--', 'warehouse_location' => false, 'pack_items' => array())), 'customer' => object(Customer), 'cookie' => object(Cookie), 'cart' => object(Cart), 'altern' => 3))
(controllers/admin/AdminOrdersController.php:1949)
at AdminOrdersControllerCore->renderView()
(classes/controller/AdminController.php:2121)
at AdminControllerCore->initContent()
(classes/controller/Controller.php:292)
at ControllerCore->run()
(classes/Dispatcher.php:515)
at DispatcherCore->dispatch()
(admin540xnc0wq/index.php:97)

thank you in advance for your help!

While trying to install the stripe plugin on prestashop v1.7.7.6 I got the following error.

PHP: 7.2.34-23
MySQL: 8.0.26

No database table are created.

`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 'DEFAULT' at line 1

CREATE TABLE IF NOT EXISTS ps_stripe_payment (id_payment INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, id_stripe VARCHAR(255) NOT NULL, id_payment_intent VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, id_cart INT(10) SIGNED NOT NULL, last4 INT(10) SIGNED NOT NULL, type VARCHAR(20) NOT NULL, amount DECIMAL(10,2) NOT NULL, refund DECIMAL(10,2) NOT NULL, currency VARCHAR(3) NOT NULL, result INT(10) SIGNED NOT NULL, state INT(10) SIGNED NOT NULL, voucher_url VARCHAR(255) NOT NULL, voucher_expire DATETIME NOT NULL, voucher_validate DATETIME NOT NULL, date_add DATETIME NOT NULL, PRIMARY KEY (id_payment)) ENGINE=InnoDB CHARSET=utf8 COLLATE=DEFAULT;`