Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

install after unistall
(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: install after unistall

install after unistall 12 years, 11 months ago #23603

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
The topic has been locked.

Re: install after unistall 12 years, 11 months ago #23642

the uninstalling function dosn't also delete the database. You should delete all tables jos_booking_* by hand from your database befor you reinstall the booking.

Regards
Ralph
The topic has been locked.
  • Page:
  • 1
User Login Empty