Confirmation page after paiment

[Nux007]

Expected behavior

Display the order information after the payment was processed.

Actual behavior

As the screenshot below, no information is shown to the customer after succes redirection.

Steps to reproduce the behavior

Environment

• PrestaShop version: 1.7.8.5
• Mollie module version: 6.0.2
• PHP version: 7.4.28

[justelis22]

Hi there @Nux007,

Could you please clarify whether you see any errors in the Mollie/PrestaShop logs, browser console, or the network tab? The issue could not be recreated from our side, so we would need some additional information to understand where is it coming from.

Best Regards, Invertus Support team.

[Nux007]

There is no error message in dev console, but in the prestashop logs I can find this:

All other paiments methods was working (Stripe, MoneyTigo, ...).

[Nux007]

Hello, any news about this ?

[justelis22]

Hi @Nux007,

We have analyzed the issue, however, we could not recreate it from our side with the default PrestaShop environment. Most likely it is related to your theme or 3rd party modules. Perhaps you have a development environment where you could turn off some of the modules and change the theme to the default one to identify the root cause.

Best Regards, Invertus Support team.

[Nux007]

I can't do that I do not have all code on my hand. We never had this issue with all paiment methods we used before. My fix will be to go back to Stripe :(

[justelis22]

@Nux007,

In that case, would it be possible for you to share back office and FTP credentials with us via email - support@invertus.eu? Also if you could share the whole backup including the database, it would be even better, in that case, I could deploy your shop locally and debug from my side.

Best Regards, Invertus Support team.

[Nux007]

Hello @justelis22 I tested to reproduce this bug from an other client website and it sounds like I cannot reproduce it on this one... So, as you said, it's related to the shop theme. Unfortunately, I can't share the whole website for privacy reasons :(

[Nux007]

Invastigating a bit more to find out how to fix this, I can see the transaction_id is not registered into the mollie_payment table when thjis bug appens

But the paiment was made

[justelis22]

@Nux007 Hello there,

Perhaps it would be possible to share the theme files so that we could test with the theme only to identify the issue?

Best Regards, Invertus Support team.

[wzzly]

@justelis22 I have the exact same problem after updating PS to 1.7.8.10 Mollie 6.0.3 After an order is paid, I get a page with: Er bestaat geen bestelling met deze ID. "No order exists with this ID" The order does exist in BO and is PAID. This is a real problem as now no orders are being tracked by Google Ads, because this happens on the order confirmation page. Please investigate ASAP. It only happens when an order is paid with Mollie. All other payment methods redirect to confirmation page after payment. This is in PS log:

There are no server errors.

[ausrinekr]

Hi there @wzzly ,

Thank you for the sent copy of the website on a subdomain, however, if no errors persist in logs or browser console we cannot really check much.

Could you please share the whole backup including the database via email? We could deploy your shop locally and debug it from our side.

Best Regards, Invertus Support team.

[mandan2]

Hello @wzzly ,

We have just checked your sent shop. Issue seems to persist due to missing "mandate_id" column in mollie_payments table. Try to launch following SQL query for your test shop and try to do some test orders to verify if suggestion fixes your problem.

ALTER TABLE pr_mollie_payments ADD mandate_id VARCHAR(64);

Best Regards, Invertus Support team.

[mandan2]

Hello @Nux007 ,

Could you give us some more context. Is order being finished or cart is still full of products? If order is finished, is order status changed to anything than "Awaiting payment"? Furthermore, is Mollie payment reference being updated to PrestaShop order reference in Mollie dashboard? Lastly, is order from "mollie_payments" table being updated with order_id, bank_status, transaction_id?

If no order is created in PrestaShop, could you check if our message above covers your case as well with missing mandate_id?

Best Regards, Invertus Support team.

[Nux007]

Hello @mandan2 The order is completed and all payment information are stored into the prestashop payment but not into the mollie payment table. The payment status is correctly set to the correct one. In fact, ALL is good except that the payment is not registered into the mollie table as shown in my previous screenshot.

Here is a screen of my mollie_payment table:

[mandan2]

Hello @Nux007,

From your screenshot I see that column "mandate_id" is missing as well. Due to missing column SQL query might fail when inserting new payment. Would it be possible for you to try the fix above and alter table manually to add missing column? Adding example structure with the 10th column "mandate_id".

Best Regards, Invertus Support team.

[Nux007]

Hello @mandan2 I confirm that that's fixing the bug :-)

Thanks.

[justelis22]

Hello @Nux007, Glad to hear that!

Is everything fine now? Perhaps we can close this issue?

Best Regards, Invertus Support team.