error
www.artio.net/components/com_kunena/temp...s/topic-question.png
JInstaller::install: Σφάλμα SQL. DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `jos_booking_payment` (`id`, `title`, `alias`, `state`, `params`, `c' at line 15 SQL=CREATE TABLE `jos_booking_creditcards` ( `id` int(11) NOT NULL auto_increment, `reservation_id` int(11) NOT NULL, `card_type` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `card_number` varchar(255) NOT NULL, `sec_code` varchar(255) NOT NULL, `exp_month` int(2) NOT NULL, `exp_year` int(2) NOT NULL, `pay_type` int(2) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 INSERT INTO `jos_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;
SQL =
CREATE TABLE `jos_booking_creditcards` (
`id` int(11) NOT NULL auto_increment,
`reservation_id` int(11) NOT NULL,
`card_type` varchar(255) NOT NULL,
`username` varchar(255) NOT NULL,
`card_number` varchar(255) NOT NULL,
`sec_code` varchar(255) NOT NULL,
`exp_month` int(2) NOT NULL,
`exp_year` int(2) NOT NULL,
`pay_type` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
INSERT INTO `jos_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;
Εφαρμογή Εγκατάσταση: Σφάλμα SQL ή ανύπαρκτο ή μη αναγνώσιμο αρχείο SQL. DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `jos_booking_payment` (`id`, `title`, `alias`, `state`, `params`, `c' at line 15 SQL=CREATE TABLE `jos_booking_creditcards` ( `id` int(11) NOT NULL auto_increment, `reservation_id` int(11) NOT NULL, `card_type` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `card_number` varchar(255) NOT NULL, `sec_code` varchar(255) NOT NULL, `exp_month` int(2) NOT NULL, `exp_year` int(2) NOT NULL, `pay_type` int(2) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 INSERT INTO `jos_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;
SQL =
CREATE TABLE `jos_booking_creditcards` (
`id` int(11) NOT NULL auto_increment,
`reservation_id` int(11) NOT NULL,
`card_type` varchar(255) NOT NULL,
`username` varchar(255) NOT NULL,
`card_number` varchar(255) NOT NULL,
`sec_code` varchar(255) NOT NULL,
`exp_month` int(2) NOT NULL,
`exp_year` int(2) NOT NULL,
`pay_type` int(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
INSERT INTO `jos_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;
please tell me how install again
thanks
