MYSQL Errors during installation

Welcome, Guest

TOPIC: MYSQL Errors during installation

MYSQL Errors during installation 13 years, 4 months ago #23551

invnobody
OFFLINE
Posts: 1

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

daimondd OFFLINE Posts: 7	Similar problem here.... PLEASE HELP
	The topic has been locked.

Re: MYSQL Errors during installation 13 years, 4 months ago #23587

tutorium
OFFLINE
Posts: 3

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

daimondd
OFFLINE
Posts: 7

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

daimondd OFFLINE Posts: 7	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

Podpora

TOPIC: MYSQL Errors during installation