- Posts: 1
We only provide official support for Solidres's subscribers, all subscribers can request support by using forum or support ticket system. For more information please check our Support Policy at www.solidres.com/support-policy
Error installing component
- nosyparker10
- Topic Author
- Offline
Less
More
10 years 3 weeks ago #8071
by nosyparker10
Error installing component was created by nosyparker10
Warning
JInstaller: :Install: Error SQL Specified key was too long; max key length is 767 bytes SQL=CREATE TABLE IF NOT EXISTS `#__sr_reservations` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `state` TINYINT(3) NOT NULL DEFAULT 0 , `customer_id` INT(11) UNSIGNED NULL DEFAULT NULL , `created_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , `modified_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , `modified_by` INT(11) UNSIGNED NOT NULL DEFAULT 0 , `created_by` INT(11) UNSIGNED NOT NULL DEFAULT 0 , `payment_method_id` VARCHAR(255) NOT NULL DEFAULT 0 , `payment_method_txn_id` VARCHAR(255) NULL DEFAULT NULL , `payment_status` TINYINT(2) NULL DEFAULT 0 COMMENT '0 is Unpaid, 1 is Completed, 2 is Cancelled, 3 is Pending' , `payment_data` TEXT NULL , `code` VARCHAR(255) NOT NULL , `coupon_id` INT(11) UNSIGNED NULL , `coupon_code` VARCHAR(15) NULL DEFAULT NULL , `customer_title` VARCHAR(45) NULL , `customer_firstname` VARCHAR(255) NULL , `customer_middlename` VARCHAR(255) NULL , `customer_lastname` VARCHAR(255) NULL , `customer_email` VARCHAR(255) NULL , `customer_phonenumber` VARCHAR(45) NULL , `customer_mobilephone` VARCHAR(45) NULL , `customer_company` VARCHAR(45) NULL , `customer_address1` VARCHAR(45) NULL , `customer_address2` VARCHAR(45) NULL , `customer_city` VARCHAR(45) NULL , `customer_zipcode` VARCHAR(45) NULL , `customer_country_id` INT(11) NULL , `customer_geo_state_id` INT(11) NULL , `customer_vat_number` VARCHAR(255) NULL DEFAULT NULL, `customer_ip` VARCHAR(50) NULL DEFAULT NULL, `checkin` DATE NOT NULL DEFAULT '0000-00-00' , `checkout` DATE NOT NULL DEFAULT '0000-00-00' , `invoice_number` VARCHAR(255) NULL , `currency_id` INT(11) UNSIGNED NULL , `currency_code` VARCHAR(10) NULL , `total_price` DECIMAL(12,2) UNSIGNED NULL , `total_price_tax_incl` DECIMAL(12,2) UNSIGNED NULL , `total_price_tax_excl` DECIMAL(12,2) UNSIGNED NULL , `total_extra_price` DECIMAL(12,2) UNSIGNED NULL , `total_extra_price_tax_incl` DECIMAL(12,2) UNSIGNED NULL , `total_extra_price_tax_excl` DECIMAL(12,2) UNSIGNED NULL , `total_discount` DECIMAL(12,2) UNSIGNED NULL , `note` TEXT NULL DEFAULT NULL , `reservation_asset_id` INT(11) UNSIGNED NULL DEFAULT NULL , `reservation_asset_name` VARCHAR(255) NULL DEFAULT NULL , `deposit_amount` DECIMAL(12,2) UNSIGNED NULL DEFAULT NULL , `total_paid` DECIMAL(12,2) UNSIGNED NULL, `discount_pre_tax` TINYINT( 3 ) UNSIGNED NULL DEFAULT NULL , `tax_amount` DECIMAL( 12, 2 ) UNSIGNED NULL , `booking_type` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0', `total_single_supplement` DECIMAL(12,2) UNSIGNED NULL , `token` VARCHAR(40) NULL DEFAULT NULL , `origin` VARCHAR(255) NULL DEFAULT NULL , `accessed_date` DATETIME NULL DEFAULT NULL , `target` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' , `cm_id` VARCHAR(45) NULL , `cm_creation_date` DATETIME NULL , `cm_modification_date` DATETIME NULL , `cm_channel_order_id` VARCHAR(45) NULL , PRIMARY KEY (`id`), UNIQUE INDEX `code_UNIQUE` (`code` ASC), INDEX `fk_sr_reservations_sr_coupons1_idx` (`coupon_id` ASC), INDEX `fk_sr_reservations_sr_reservation_assets1_idx` (`reservation_asset_id` ASC), CONSTRAINT `fk_sr_reservations_sr_coupons1` FOREIGN KEY (`coupon_id` ) REFERENCES `#__sr_coupons` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_sr_reservations_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `#__sr_reservation_assets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;
Extension Install: SQL error processing query: DB function failed with error number 1071
Specified key was too long; max key length is 767 bytes SQL=CREATE TABLE IF NOT EXISTS `#__sr_reservations` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `state` TINYINT(3) NOT NULL DEFAULT 0 , `customer_id` INT(11) UNSIGNED NULL DEFAULT NULL , `created_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , `modified_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , `modified_by` INT(11) UNSIGNED NOT NULL DEFAULT 0 , `created_by` INT(11) UNSIGNED NOT NULL DEFAULT 0 , `payment_method_id` VARCHAR(255) NOT NULL DEFAULT 0 , `payment_method_txn_id` VARCHAR(255) NULL DEFAULT NULL , `payment_status` TINYINT(2) NULL DEFAULT 0 COMMENT '0 is Unpaid, 1 is Completed, 2 is Cancelled, 3 is Pending' , `payment_data` TEXT NULL , `code` VARCHAR(255) NOT NULL , `coupon_id` INT(11) UNSIGNED NULL , `coupon_code` VARCHAR(15) NULL DEFAULT NULL , `customer_title` VARCHAR(45) NULL , `customer_firstname` VARCHAR(255) NULL , `customer_middlename` VARCHAR(255) NULL , `customer_lastname` VARCHAR(255) NULL , `customer_email` VARCHAR(255) NULL , `customer_phonenumber` VARCHAR(45) NULL , `customer_mobilephone` VARCHAR(45) NULL , `customer_company` VARCHAR(45) NULL , `customer_address1` VARCHAR(45) NULL , `customer_address2` VARCHAR(45) NULL , `customer_city` VARCHAR(45) NULL , `customer_zipcode` VARCHAR(45) NULL , `customer_country_id` INT(11) NULL , `customer_geo_state_id` INT(11) NULL , `customer_vat_number` VARCHAR(255) NULL DEFAULT NULL, `customer_ip` VARCHAR(50) NULL DEFAULT NULL, `checkin` DATE NOT NULL DEFAULT '0000-00-00' , `checkout` DATE NOT NULL DEFAULT '0000-00-00' , `invoice_number` VARCHAR(255) NULL , `currency_id` INT(11) UNSIGNED NULL , `currency_code` VARCHAR(10) NULL , `total_price` DECIMAL(12,2) UNSIGNED NULL , `total_price_tax_incl` DECIMAL(12,2) UNSIGNED NULL , `total_price_tax_excl` DECIMAL(12,2) UNSIGNED NULL , `total_extra_price` DECIMAL(12,2) UNSIGNED NULL , `total_extra_price_tax_incl` DECIMAL(12,2) UNSIGNED NULL , `total_extra_price_tax_excl` DECIMAL(12,2) UNSIGNED NULL , `total_discount` DECIMAL(12,2) UNSIGNED NULL , `note` TEXT NULL DEFAULT NULL , `reservation_asset_id` INT(11) UNSIGNED NULL DEFAULT NULL , `reservation_asset_name` VARCHAR(255) NULL DEFAULT NULL , `deposit_amount` DECIMAL(12,2) UNSIGNED NULL DEFAULT NULL , `total_paid` DECIMAL(12,2) UNSIGNED NULL, `discount_pre_tax` TINYINT( 3 ) UNSIGNED NULL DEFAULT NULL , `tax_amount` DECIMAL( 12, 2 ) UNSIGNED NULL , `booking_type` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0', `total_single_supplement` DECIMAL(12,2) UNSIGNED NULL , `token` VARCHAR(40) NULL DEFAULT NULL , `origin` VARCHAR(255) NULL DEFAULT NULL , `accessed_date` DATETIME NULL DEFAULT NULL , `target` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' , `cm_id` VARCHAR(45) NULL , `cm_creation_date` DATETIME NULL , `cm_modification_date` DATETIME NULL , `cm_channel_order_id` VARCHAR(45) NULL , PRIMARY KEY (`id`), UNIQUE INDEX `code_UNIQUE` (`code` ASC), INDEX `fk_sr_reservations_sr_coupons1_idx` (`coupon_id` ASC), INDEX `fk_sr_reservations_sr_reservation_assets1_idx` (`reservation_asset_id` ASC), CONSTRAINT `fk_sr_reservations_sr_coupons1` FOREIGN KEY (`coupon_id` ) REFERENCES `#__sr_coupons` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_sr_reservations_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `#__sr_reservation_assets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;
SQL =
CREATE TABLE IF NOT EXISTS `#__sr_reservations` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
`state` TINYINT(3) NOT NULL DEFAULT 0 ,
`customer_id` INT(11) UNSIGNED NULL DEFAULT NULL ,
`created_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`modified_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`modified_by` INT(11) UNSIGNED NOT NULL DEFAULT 0 ,
`created_by` INT(11) UNSIGNED NOT NULL DEFAULT 0 ,
`payment_method_id` VARCHAR(255) NOT NULL DEFAULT 0 ,
`payment_method_txn_id` VARCHAR(255) NULL DEFAULT NULL ,
`payment_status` TINYINT(2) NULL DEFAULT 0 COMMENT '0 is Unpaid, 1 is Completed, 2 is Cancelled, 3 is Pending' ,
`payment_data` TEXT NULL ,
`code` VARCHAR(255) NOT NULL ,
`coupon_id` INT(11) UNSIGNED NULL ,
`coupon_code` VARCHAR(15) NULL DEFAULT NULL ,
`customer_title` VARCHAR(45) NULL ,
`customer_firstname` VARCHAR(255) NULL ,
`customer_middlename` VARCHAR(255) NULL ,
`customer_lastname` VARCHAR(255) NULL ,
`customer_email` VARCHAR(255) NULL ,
`customer_phonenumber` VARCHAR(45) NULL ,
`customer_mobilephone` VARCHAR(45) NULL ,
`customer_company` VARCHAR(45) NULL ,
`customer_address1` VARCHAR(45) NULL ,
`customer_address2` VARCHAR(45) NULL ,
`customer_city` VARCHAR(45) NULL ,
`customer_zipcode` VARCHAR(45) NULL ,
`customer_country_id` INT(11) NULL ,
`customer_geo_state_id` INT(11) NULL ,
`customer_vat_number` VARCHAR(255) NULL DEFAULT NULL,
`customer_ip` VARCHAR(50) NULL DEFAULT NULL,
`checkin` DATE NOT NULL DEFAULT '0000-00-00' ,
`checkout` DATE NOT NULL DEFAULT '0000-00-00' ,
`invoice_number` VARCHAR(255) NULL ,
`currency_id` INT(11) UNSIGNED NULL ,
`currency_code` VARCHAR(10) NULL ,
`total_price` DECIMAL(12,2) UNSIGNED NULL ,
`total_price_tax_incl` DECIMAL(12,2) UNSIGNED NULL ,
`total_price_tax_excl` DECIMAL(12,2) UNSIGNED NULL ,
`total_extra_price` DECIMAL(12,2) UNSIGNED NULL ,
`total_extra_price_tax_incl` DECIMAL(12,2) UNSIGNED NULL ,
`total_extra_price_tax_excl` DECIMAL(12,2) UNSIGNED NULL ,
`total_discount` DECIMAL(12,2) UNSIGNED NULL ,
`note` TEXT NULL DEFAULT NULL ,
`reservation_asset_id` INT(11) UNSIGNED NULL DEFAULT NULL ,
`reservation_asset_name` VARCHAR(255) NULL DEFAULT NULL ,
`deposit_amount` DECIMAL(12,2) UNSIGNED NULL DEFAULT NULL ,
`total_paid` DECIMAL(12,2) UNSIGNED NULL,
`discount_pre_tax` TINYINT( 3 ) UNSIGNED NULL DEFAULT NULL ,
`tax_amount` DECIMAL( 12, 2 ) UNSIGNED NULL ,
`booking_type` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0',
`total_single_supplement` DECIMAL(12,2) UNSIGNED NULL ,
`token` VARCHAR(40) NULL DEFAULT NULL ,
`origin` VARCHAR(255) NULL DEFAULT NULL ,
`accessed_date` DATETIME NULL DEFAULT NULL ,
`target` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' ,
`cm_id` VARCHAR(45) NULL ,
`cm_creation_date` DATETIME NULL ,
`cm_modification_date` DATETIME NULL ,
`cm_channel_order_id` VARCHAR(45) NULL ,
PRIMARY KEY (`id`),
UNIQUE INDEX `code_UNIQUE` (`code` ASC),
INDEX `fk_sr_reservations_sr_coupons1_idx` (`coupon_id` ASC),
INDEX `fk_sr_reservations_sr_reservation_assets1_idx` (`reservation_asset_id` ASC),
CONSTRAINT `fk_sr_reservations_sr_coupons1`
FOREIGN KEY (`coupon_id` )
REFERENCES `#__sr_coupons` (`id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_sr_reservations_sr_reservation_assets1`
FOREIGN KEY (`reservation_asset_id`)
REFERENCES `#__sr_reservation_assets` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
×
Error
Error installing component
JInstaller: :Install: Error SQL Specified key was too long; max key length is 767 bytes SQL=CREATE TABLE IF NOT EXISTS `#__sr_reservations` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `state` TINYINT(3) NOT NULL DEFAULT 0 , `customer_id` INT(11) UNSIGNED NULL DEFAULT NULL , `created_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , `modified_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , `modified_by` INT(11) UNSIGNED NOT NULL DEFAULT 0 , `created_by` INT(11) UNSIGNED NOT NULL DEFAULT 0 , `payment_method_id` VARCHAR(255) NOT NULL DEFAULT 0 , `payment_method_txn_id` VARCHAR(255) NULL DEFAULT NULL , `payment_status` TINYINT(2) NULL DEFAULT 0 COMMENT '0 is Unpaid, 1 is Completed, 2 is Cancelled, 3 is Pending' , `payment_data` TEXT NULL , `code` VARCHAR(255) NOT NULL , `coupon_id` INT(11) UNSIGNED NULL , `coupon_code` VARCHAR(15) NULL DEFAULT NULL , `customer_title` VARCHAR(45) NULL , `customer_firstname` VARCHAR(255) NULL , `customer_middlename` VARCHAR(255) NULL , `customer_lastname` VARCHAR(255) NULL , `customer_email` VARCHAR(255) NULL , `customer_phonenumber` VARCHAR(45) NULL , `customer_mobilephone` VARCHAR(45) NULL , `customer_company` VARCHAR(45) NULL , `customer_address1` VARCHAR(45) NULL , `customer_address2` VARCHAR(45) NULL , `customer_city` VARCHAR(45) NULL , `customer_zipcode` VARCHAR(45) NULL , `customer_country_id` INT(11) NULL , `customer_geo_state_id` INT(11) NULL , `customer_vat_number` VARCHAR(255) NULL DEFAULT NULL, `customer_ip` VARCHAR(50) NULL DEFAULT NULL, `checkin` DATE NOT NULL DEFAULT '0000-00-00' , `checkout` DATE NOT NULL DEFAULT '0000-00-00' , `invoice_number` VARCHAR(255) NULL , `currency_id` INT(11) UNSIGNED NULL , `currency_code` VARCHAR(10) NULL , `total_price` DECIMAL(12,2) UNSIGNED NULL , `total_price_tax_incl` DECIMAL(12,2) UNSIGNED NULL , `total_price_tax_excl` DECIMAL(12,2) UNSIGNED NULL , `total_extra_price` DECIMAL(12,2) UNSIGNED NULL , `total_extra_price_tax_incl` DECIMAL(12,2) UNSIGNED NULL , `total_extra_price_tax_excl` DECIMAL(12,2) UNSIGNED NULL , `total_discount` DECIMAL(12,2) UNSIGNED NULL , `note` TEXT NULL DEFAULT NULL , `reservation_asset_id` INT(11) UNSIGNED NULL DEFAULT NULL , `reservation_asset_name` VARCHAR(255) NULL DEFAULT NULL , `deposit_amount` DECIMAL(12,2) UNSIGNED NULL DEFAULT NULL , `total_paid` DECIMAL(12,2) UNSIGNED NULL, `discount_pre_tax` TINYINT( 3 ) UNSIGNED NULL DEFAULT NULL , `tax_amount` DECIMAL( 12, 2 ) UNSIGNED NULL , `booking_type` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0', `total_single_supplement` DECIMAL(12,2) UNSIGNED NULL , `token` VARCHAR(40) NULL DEFAULT NULL , `origin` VARCHAR(255) NULL DEFAULT NULL , `accessed_date` DATETIME NULL DEFAULT NULL , `target` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' , `cm_id` VARCHAR(45) NULL , `cm_creation_date` DATETIME NULL , `cm_modification_date` DATETIME NULL , `cm_channel_order_id` VARCHAR(45) NULL , PRIMARY KEY (`id`), UNIQUE INDEX `code_UNIQUE` (`code` ASC), INDEX `fk_sr_reservations_sr_coupons1_idx` (`coupon_id` ASC), INDEX `fk_sr_reservations_sr_reservation_assets1_idx` (`reservation_asset_id` ASC), CONSTRAINT `fk_sr_reservations_sr_coupons1` FOREIGN KEY (`coupon_id` ) REFERENCES `#__sr_coupons` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_sr_reservations_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `#__sr_reservation_assets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;
Extension Install: SQL error processing query: DB function failed with error number 1071
Specified key was too long; max key length is 767 bytes SQL=CREATE TABLE IF NOT EXISTS `#__sr_reservations` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT , `state` TINYINT(3) NOT NULL DEFAULT 0 , `customer_id` INT(11) UNSIGNED NULL DEFAULT NULL , `created_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , `modified_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' , `modified_by` INT(11) UNSIGNED NOT NULL DEFAULT 0 , `created_by` INT(11) UNSIGNED NOT NULL DEFAULT 0 , `payment_method_id` VARCHAR(255) NOT NULL DEFAULT 0 , `payment_method_txn_id` VARCHAR(255) NULL DEFAULT NULL , `payment_status` TINYINT(2) NULL DEFAULT 0 COMMENT '0 is Unpaid, 1 is Completed, 2 is Cancelled, 3 is Pending' , `payment_data` TEXT NULL , `code` VARCHAR(255) NOT NULL , `coupon_id` INT(11) UNSIGNED NULL , `coupon_code` VARCHAR(15) NULL DEFAULT NULL , `customer_title` VARCHAR(45) NULL , `customer_firstname` VARCHAR(255) NULL , `customer_middlename` VARCHAR(255) NULL , `customer_lastname` VARCHAR(255) NULL , `customer_email` VARCHAR(255) NULL , `customer_phonenumber` VARCHAR(45) NULL , `customer_mobilephone` VARCHAR(45) NULL , `customer_company` VARCHAR(45) NULL , `customer_address1` VARCHAR(45) NULL , `customer_address2` VARCHAR(45) NULL , `customer_city` VARCHAR(45) NULL , `customer_zipcode` VARCHAR(45) NULL , `customer_country_id` INT(11) NULL , `customer_geo_state_id` INT(11) NULL , `customer_vat_number` VARCHAR(255) NULL DEFAULT NULL, `customer_ip` VARCHAR(50) NULL DEFAULT NULL, `checkin` DATE NOT NULL DEFAULT '0000-00-00' , `checkout` DATE NOT NULL DEFAULT '0000-00-00' , `invoice_number` VARCHAR(255) NULL , `currency_id` INT(11) UNSIGNED NULL , `currency_code` VARCHAR(10) NULL , `total_price` DECIMAL(12,2) UNSIGNED NULL , `total_price_tax_incl` DECIMAL(12,2) UNSIGNED NULL , `total_price_tax_excl` DECIMAL(12,2) UNSIGNED NULL , `total_extra_price` DECIMAL(12,2) UNSIGNED NULL , `total_extra_price_tax_incl` DECIMAL(12,2) UNSIGNED NULL , `total_extra_price_tax_excl` DECIMAL(12,2) UNSIGNED NULL , `total_discount` DECIMAL(12,2) UNSIGNED NULL , `note` TEXT NULL DEFAULT NULL , `reservation_asset_id` INT(11) UNSIGNED NULL DEFAULT NULL , `reservation_asset_name` VARCHAR(255) NULL DEFAULT NULL , `deposit_amount` DECIMAL(12,2) UNSIGNED NULL DEFAULT NULL , `total_paid` DECIMAL(12,2) UNSIGNED NULL, `discount_pre_tax` TINYINT( 3 ) UNSIGNED NULL DEFAULT NULL , `tax_amount` DECIMAL( 12, 2 ) UNSIGNED NULL , `booking_type` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0', `total_single_supplement` DECIMAL(12,2) UNSIGNED NULL , `token` VARCHAR(40) NULL DEFAULT NULL , `origin` VARCHAR(255) NULL DEFAULT NULL , `accessed_date` DATETIME NULL DEFAULT NULL , `target` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' , `cm_id` VARCHAR(45) NULL , `cm_creation_date` DATETIME NULL , `cm_modification_date` DATETIME NULL , `cm_channel_order_id` VARCHAR(45) NULL , PRIMARY KEY (`id`), UNIQUE INDEX `code_UNIQUE` (`code` ASC), INDEX `fk_sr_reservations_sr_coupons1_idx` (`coupon_id` ASC), INDEX `fk_sr_reservations_sr_reservation_assets1_idx` (`reservation_asset_id` ASC), CONSTRAINT `fk_sr_reservations_sr_coupons1` FOREIGN KEY (`coupon_id` ) REFERENCES `#__sr_coupons` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_sr_reservations_sr_reservation_assets1` FOREIGN KEY (`reservation_asset_id`) REFERENCES `#__sr_reservation_assets` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB;
SQL =
CREATE TABLE IF NOT EXISTS `#__sr_reservations` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
`state` TINYINT(3) NOT NULL DEFAULT 0 ,
`customer_id` INT(11) UNSIGNED NULL DEFAULT NULL ,
`created_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`modified_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ,
`modified_by` INT(11) UNSIGNED NOT NULL DEFAULT 0 ,
`created_by` INT(11) UNSIGNED NOT NULL DEFAULT 0 ,
`payment_method_id` VARCHAR(255) NOT NULL DEFAULT 0 ,
`payment_method_txn_id` VARCHAR(255) NULL DEFAULT NULL ,
`payment_status` TINYINT(2) NULL DEFAULT 0 COMMENT '0 is Unpaid, 1 is Completed, 2 is Cancelled, 3 is Pending' ,
`payment_data` TEXT NULL ,
`code` VARCHAR(255) NOT NULL ,
`coupon_id` INT(11) UNSIGNED NULL ,
`coupon_code` VARCHAR(15) NULL DEFAULT NULL ,
`customer_title` VARCHAR(45) NULL ,
`customer_firstname` VARCHAR(255) NULL ,
`customer_middlename` VARCHAR(255) NULL ,
`customer_lastname` VARCHAR(255) NULL ,
`customer_email` VARCHAR(255) NULL ,
`customer_phonenumber` VARCHAR(45) NULL ,
`customer_mobilephone` VARCHAR(45) NULL ,
`customer_company` VARCHAR(45) NULL ,
`customer_address1` VARCHAR(45) NULL ,
`customer_address2` VARCHAR(45) NULL ,
`customer_city` VARCHAR(45) NULL ,
`customer_zipcode` VARCHAR(45) NULL ,
`customer_country_id` INT(11) NULL ,
`customer_geo_state_id` INT(11) NULL ,
`customer_vat_number` VARCHAR(255) NULL DEFAULT NULL,
`customer_ip` VARCHAR(50) NULL DEFAULT NULL,
`checkin` DATE NOT NULL DEFAULT '0000-00-00' ,
`checkout` DATE NOT NULL DEFAULT '0000-00-00' ,
`invoice_number` VARCHAR(255) NULL ,
`currency_id` INT(11) UNSIGNED NULL ,
`currency_code` VARCHAR(10) NULL ,
`total_price` DECIMAL(12,2) UNSIGNED NULL ,
`total_price_tax_incl` DECIMAL(12,2) UNSIGNED NULL ,
`total_price_tax_excl` DECIMAL(12,2) UNSIGNED NULL ,
`total_extra_price` DECIMAL(12,2) UNSIGNED NULL ,
`total_extra_price_tax_incl` DECIMAL(12,2) UNSIGNED NULL ,
`total_extra_price_tax_excl` DECIMAL(12,2) UNSIGNED NULL ,
`total_discount` DECIMAL(12,2) UNSIGNED NULL ,
`note` TEXT NULL DEFAULT NULL ,
`reservation_asset_id` INT(11) UNSIGNED NULL DEFAULT NULL ,
`reservation_asset_name` VARCHAR(255) NULL DEFAULT NULL ,
`deposit_amount` DECIMAL(12,2) UNSIGNED NULL DEFAULT NULL ,
`total_paid` DECIMAL(12,2) UNSIGNED NULL,
`discount_pre_tax` TINYINT( 3 ) UNSIGNED NULL DEFAULT NULL ,
`tax_amount` DECIMAL( 12, 2 ) UNSIGNED NULL ,
`booking_type` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0',
`total_single_supplement` DECIMAL(12,2) UNSIGNED NULL ,
`token` VARCHAR(40) NULL DEFAULT NULL ,
`origin` VARCHAR(255) NULL DEFAULT NULL ,
`accessed_date` DATETIME NULL DEFAULT NULL ,
`target` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0' ,
`cm_id` VARCHAR(45) NULL ,
`cm_creation_date` DATETIME NULL ,
`cm_modification_date` DATETIME NULL ,
`cm_channel_order_id` VARCHAR(45) NULL ,
PRIMARY KEY (`id`),
UNIQUE INDEX `code_UNIQUE` (`code` ASC),
INDEX `fk_sr_reservations_sr_coupons1_idx` (`coupon_id` ASC),
INDEX `fk_sr_reservations_sr_reservation_assets1_idx` (`reservation_asset_id` ASC),
CONSTRAINT `fk_sr_reservations_sr_coupons1`
FOREIGN KEY (`coupon_id` )
REFERENCES `#__sr_coupons` (`id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_sr_reservations_sr_reservation_assets1`
FOREIGN KEY (`reservation_asset_id`)
REFERENCES `#__sr_reservation_assets` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
×
Error
Error installing component
Please Log in or Create an account to join the conversation.
- solidres
-
- Offline
Less
More
- Posts: 3066
10 years 3 weeks ago #8072
by solidres
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Replied by solidres on topic Error installing component
Hi,
You should change your database collation to utf8_unicode_ci and try again.
Cheers,
You should change your database collation to utf8_unicode_ci and try again.
Cheers,
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Please Log in or Create an account to join the conversation.
Moderators: solidres