Just purchased the paid version of Book-it (Receipt No: 2662-0999-8738-5504) and unfortunately the install failed. I browsed the forums and checked the documentation, but I didn't find any help. Please see errors and environment below.
Installer::install: SQL Error. 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 `damus_booking_payment` (`id`, `title`, `alias`, `state`, `params`, ' 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 `damus_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 `damus_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;
Component Install: SQL error OR missing OR unreadable SQL file. 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 `damus_booking_payment` (`id`, `title`, `alias`, `state`, `params`, ' 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 `damus_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 `damus_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;
