Good afternoon,
Just bought SolidRes and tried to install. But unfortunately I got this DB warning:
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;
Already tried to repair the DB (with Joomla ánd Akeeba Admin Tools)
Using J3.6.2
Any help is much appreciated!
