Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me
Forgot your password? Forgot your username? Create an account
ARTIO Forums
Archive
Book it!
Customer Support

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 13 years, 4 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 13 years, 4 months ago #23559

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

Re: MYSQL Errors during installation 13 years, 4 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 13 years, 4 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 13 years, 4 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 13 years, 4 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
ARTIO Forums
Archive
Book it!
Customer Support
User Login Empty
Create an account Forgot your password?
Copyright © 2024 ARTIO