-
jitr
- OFFLINE
-
ARTIO Support
- Posts: 1432
-
-
|
Hello, this is different. Control if you have database table #__booking_payment. If have and it's empty then run following command through PHPMyAdmin. First replace mark #__ with your database prefix (ussually jos_).
INSERT INTO `#__booking_payment` (`id`, `title`, `alias`, `state`, `params`, `checked_out`, `checked_out_time`) VALUES
(1, 'PayPal', 'paypal', 0, '', 0, '0000-00-00 00:00:00') ON DUPLICATE KEY UPDATE `id` = 1;
INSERT INTO `#__booking_payment` (`id`, `title`, `alias`, `state`, `params`, `checked_out`, `checked_out_time`) VALUES
(2, 'MoneyBookers', 'moneybookers', 0, '', 0, '0000-00-00 00:00:00') ON DUPLICATE KEY UPDATE `id` = 2;
INSERT INTO `#__booking_payment` (`id`, `title`, `alias`, `state`, `params`, `checked_out`, `checked_out_time`) VALUES
(3, 'BancTransfer', 'banctransfer', 0, '', 0, '0000-00-00 00:00:00') ON DUPLICATE KEY UPDATE `id` = 3;
INSERT INTO `#__booking_payment` (`id`, `title`, `alias`, `state`, `params`, `checked_out`, `checked_out_time`) VALUES
(4, 'CreditCard', 'creditcard', 0, '', 0, '0000-00-00 00:00:00') ON DUPLICATE KEY UPDATE `id` = 4;
INSERT INTO `#__booking_payment` (`id`, `title`, `alias`, `state`, `params`, `checked_out`, `checked_out_time`) VALUES
(5, 'DeltaPay', 'deltapay', 0, '', 0, '0000-00-00 00:00:00') ON DUPLICATE KEY UPDATE `id` = 5;
INSERT INTO `#__booking_payment` (`id`, `title`, `alias`, `state`, `params`, `checked_out`, `checked_out_time`) VALUES
(6, 'cciDEAL Platform', 'ccideal', 0, '', 0, '0000-00-00 00:00:00') ON DUPLICATE KEY UPDATE `id` = 6;
INSERT INTO `#__booking_payment` (`id`, `title`, `alias`, `state`, `params`, `checked_out`, `checked_out_time`) VALUES
(7, 'SoFort', 'sofort', 0, '', 0, '0000-00-00 00:00:00') ON DUPLICATE KEY UPDATE `id` = 7;
You can create table with:
CREATE TABLE IF NOT EXISTS `#__booking_payment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL,
`state` tinyint(4) NOT NULL DEFAULT '0',
`params` text NOT NULL,
`checked_out` int(11) NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `state` (`state`,`checked_out`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
