Support is offline. We are back Monday 16 November, 09:00.

No transcation data found #61005

Open 73Orange opened this topic Monday, 16 December 2019 · 1 reply
Author

After ordering through VirtueMart and clicking the payment button, I get redirected to the homepage with the following error message:
Geen transactie gegevens gevonden voor de betaalprovider Mollie met transactie ID 0

Any idea what could be wrong?

Support

Hello,

This error is generated when you start the payment but RO Payments cannot find any payment information. I do not know if this is a clean installation or a recent upgrade. If so, there might be a problem with the database structure.

A column named pid was recently added to the jdidealgateway_logs table. You can check if this column exists using PhpMyAdmin for example. If this does not exist you can run the following query to add it:

ALTER TABLE `#__jdidealgateway_logs`
    CHANGE COLUMN `language` `language` VARCHAR(5) NOT NULL COMMENT 'The user language' AFTER `paymentId`,
    ADD COLUMN `pid` VARCHAR(50) NOT NULL COMMENT 'A unique identifier for the transaction' AFTER `language`;

Replace #_ with your Joomla prefix as used on the site.

After that you can give it another try.

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Log in to reply to this topic.