- Posts: 4
- Home
- Forum
- Community Forum
- Questions
- Tariffs
- weekly tariff instead of day by day
SolidRes wil not install
- geertf
- Topic Author
- Offline
Less
More
8 years 8 months ago - 8 years 8 months ago #7824
by geertf
SolidRes wil not install was created by geertf
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!
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!
Last edit: 8 years 8 months ago by geertf. Reason: exta info
Please Log in or Create an account to join the conversation.
- solidres
-
- Offline
Less
More
- Posts: 2952
8 years 8 months ago #7828
by solidres
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Replied by solidres on topic SolidRes wil not install
Hi,
Nice week to you.
Please create a new support ticket and provide your website address + super user account + phpMyAdmin account, we will check it for you.
Regards,
Nice week to you.
Please create a new support ticket and provide your website address + super user account + phpMyAdmin account, we will check it for you.
Regards,
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.
- kav971
- Offline
Less
More
- Posts: 1
8 years 8 months ago #7832
by kav971
Replied by kav971 on topic SolidRes wil not install
I have the same problem. There are already solutions?
Please Log in or Create an account to join the conversation.
- solidres
-
- Offline
Less
More
- Posts: 2952
8 years 8 months ago #7834
by solidres
FAQ: www.solidres.com/support/frequently-asked-questions
Support Policy: www.solidres.com/support-policy
Replied by solidres on topic SolidRes wil not install
Hi,
If you are using default database collation = utf8mb4_general_ci, try to change it to utf8_general_ci and install again.
If you need further assistance, please raise a new support ticket, we will check it for you.
Regards,
If you are using default database collation = utf8mb4_general_ci, try to change it to utf8_general_ci and install again.
If you need further assistance, please raise a new support ticket, we will check it for you.
Regards,
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