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';
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the
Joomla! Extension Directory
