Menu Content

Podpora

> Diskusní fóra, FAQs & placená podpora
Welcome, Guest
Username Password: Remember me

MYSQL Errors during installation
(1 viewing) (1) Guest
Universal booking and reservations component for Joomla!.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: MYSQL Errors during installation

MYSQL Errors during installation 12 years, 9 months ago #23551

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;


Shared Environment Info:
Apache: 2.2.19
CentOS: CentOS release 5.6 (Final)
cPanel: 11.30.2 (build 1)
Curl: 7.12.1
MySQL: 5.1.52
phpMyAdmin: 3.4.3.2
Python: 2.4.3
Perl: 5.8.8
PHP: 5.2.17
ionCube Loader: 3.3.20
Zend Optimizer: 3.3.9
Ruby: 1.8.7
Rails: 2.3.5
OpenSSL: 0.9.8e-fips-rhel5


Thanks!
The topic has been locked.

Re: MYSQL Errors during installation 12 years, 9 months ago #23559

Similar problem here.... PLEASE HELP
The topic has been locked.

Re: MYSQL Errors during installation 12 years, 9 months ago #23587

JInstaller::install: Erro de 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;

Componente Instalar: Erro de SQL - o ficheiro sql não existe ou não é legível. 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;
The topic has been locked.

Re: MYSQL Errors during installation 12 years, 9 months ago #23590

Had it in Joomla 1.6.6, Joomla 1.7, Joomla 1.5

PLEASE DO SOMETHING, the funny thing is the free one works.

CAN SOMEONE HELP?


JInstaller::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 `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;
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 `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;
The topic has been locked.

Re: MYSQL Errors during installation 12 years, 9 months ago #23647

  • jitr
  • OFFLINE
  • ARTIO Support
  • Posts: 1432
It's problem in v 1.2.6. Download latest 1.2.7.
ARTIO Support Team
The topic has been locked.

Re: MYSQL Errors during installation 12 years, 9 months ago #23724

OK, I already uninstalled and used joomla 1.5 but i am having calender issues - square buttons wont respond. Also will your component be compatible with J1.7
The topic has been locked.
  • Page:
  • 1
Přihlášení uživatele Prázdný