Fout: 1054 Unknown column 'profile_id' in 'field list' #65157

Hello Nico,

Did you update from an old version? That field is required in the jdidealgateway_logs table. You could uninstall the RO Payments, remove the jdidealgateway_logs table and install RO Payments again. That should recreate the table again. You could also manually remove the table and execute the query yourself. Make sure to replace the #_ with your own prefix.

CREATE TABLE IF NOT EXISTS `#__jdidealgateway_logs`
(
    `id`               INT(10)        NOT NULL AUTO_INCREMENT
        COMMENT 'Auto increment ID',
    `profile_id`       INT(10)        NOT NULL
        COMMENT 'The payment provider',
    `trans`            VARCHAR(50)    NOT NULL
        COMMENT 'Transaction number',
    `order_id`         VARCHAR(10)    NOT NULL
        COMMENT 'Order ID',
    `order_number`     VARCHAR(50)    NOT NULL
        COMMENT 'Order Number',
    `quantity`         INT(4)         NOT NULL DEFAULT '0'
        COMMENT 'The quantity purchased',
    `currency`         CHAR(15)       NOT NULL DEFAULT 'EUR'
        COMMENT 'The currency the order is in',
    `amount`           DECIMAL(12, 5) NOT NULL
        COMMENT 'Amount to be paid',
    `origin`           VARCHAR(50)    NOT NULL
        COMMENT 'Origin of call',
    `card`             VARCHAR(50)    NOT NULL
        COMMENT 'The payment card used',
    `processed`        TINYINT(1)     NOT NULL DEFAULT '0'
        COMMENT 'Set a transaction if it has been checked',
    `history`          TEXT           NOT NULL
        COMMENT 'History of payment request',
    `date_added`       TIMESTAMP      NOT NULL DEFAULT CURRENT_TIMESTAMP
        COMMENT 'Date and time of payment',
    `result`           VARCHAR(25)    NULL     DEFAULT NULL
        COMMENT 'Result of the payment request',
    `notify_url`       VARCHAR(255)   NOT NULL
        COMMENT 'Notification URL',
    `return_url`       VARCHAR(255)   NOT NULL
        COMMENT 'Return URL',
    `cancel_url`       VARCHAR(255)   NOT NULL
        COMMENT 'Cancellation URL',
    `paymentReference` VARCHAR(255)   NULL     DEFAULT NULL
        COMMENT 'Overboeking reference',
    `paymentId`        VARCHAR(255)   NULL     DEFAULT NULL
        COMMENT 'Payment ID for checking transaction',
    `language`         CHAR(7)        NOT NULL
        COMMENT 'The user language',
    `pid`              VARCHAR(50)    NOT NULL
        COMMENT 'A unique identifier for the transaction',
    PRIMARY KEY (`id`)
)
    CHARSET = utf8
    COMMENT = 'Stores all iDEAL transactions';