Forum Login
Error when installing Easyshop Ver 1.14
- Gerald Thomas
- Topic Author
- Offline
- New Member
Less
More
- Posts: 3
- Thank you received: 0
5 years 11 months ago #86
by Gerald Thomas
Error when installing Easyshop Ver 1.14 was created by Gerald Thomas
HI, I am trying to install easyshop on a fresh install of Joomla 3.8.7 but I get a error saying ;
Notice
The alias product-category is already being used by Product category menu item in the EasyShop Menu menu (remember it may be a trashed item).
×
Warning
JInstaller: :Install: Error SQL Index column size too large. The maximum column size is 767 bytes.
Extension Install: SQL error processing query: DB function failed with error number 1709
Index column size too large. The maximum column size is 767 bytes.
SQL =
CREATE TABLE IF NOT EXISTS `#__easyshop_customfields` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`group_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(255) NOT NULL DEFAULT '',
`alias` VARCHAR(255) NOT NULL DEFAULT '',
`state` TINYINT(1) NOT NULL DEFAULT '1',
`type` CHAR(20) NOT NULL DEFAULT 'TEXT',
`default_value` TEXT,
`required` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`created_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`checked_out` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` INT(10) UNSIGNED NOT NULL DEFAULT '1',
`params` TEXT,
`reflector` TEXT,
`protected` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`rules` TEXT,
`showon` TINYINT(1) NOT NULL DEFAULT '-1',
`attributes` TEXT,
`categories` TEXT,
`checkout_field` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`field_name` VARCHAR(225) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `idx_state` (`state`),
KEY `idx_group_id` (`group_id`),
KEY `idx_protected` (`protected`),
KEY `idx_checkout_field` (`checkout_field`),
KEY `idx_field_name` (`field_name`)
)
ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
DEFAULT COLLATE = utf8mb4_unicode_ci;
It will not let me install it, never seen this problem before, any ideas on what ncan be happening?
Thanks
Gerald
Notice
The alias product-category is already being used by Product category menu item in the EasyShop Menu menu (remember it may be a trashed item).
×
Warning
JInstaller: :Install: Error SQL Index column size too large. The maximum column size is 767 bytes.
Extension Install: SQL error processing query: DB function failed with error number 1709
Index column size too large. The maximum column size is 767 bytes.
SQL =
CREATE TABLE IF NOT EXISTS `#__easyshop_customfields` (
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
`group_id` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`name` VARCHAR(255) NOT NULL DEFAULT '',
`alias` VARCHAR(255) NOT NULL DEFAULT '',
`state` TINYINT(1) NOT NULL DEFAULT '1',
`type` CHAR(20) NOT NULL DEFAULT 'TEXT',
`default_value` TEXT,
`required` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`created_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`checked_out` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` INT(10) UNSIGNED NOT NULL DEFAULT '1',
`params` TEXT,
`reflector` TEXT,
`protected` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`rules` TEXT,
`showon` TINYINT(1) NOT NULL DEFAULT '-1',
`attributes` TEXT,
`categories` TEXT,
`checkout_field` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`field_name` VARCHAR(225) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `idx_state` (`state`),
KEY `idx_group_id` (`group_id`),
KEY `idx_protected` (`protected`),
KEY `idx_checkout_field` (`checkout_field`),
KEY `idx_field_name` (`field_name`)
)
ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4
DEFAULT COLLATE = utf8mb4_unicode_ci;
It will not let me install it, never seen this problem before, any ideas on what ncan be happening?
Thanks
Gerald
Please Log in or Create an account to join the conversation.
- Rainy
- Offline
- Administrator
5 years 11 months ago #87
by Rainy
Replied by Rainy on topic Error when installing Easyshop Ver 1.14
Hi, look like your site has installed the old version of EasyShop.
1. Try to remove the exists EasyShop menu.
2. Make sure your host database support utf8mb4.
P/s I also replied your ticket.
1. Try to remove the exists EasyShop menu.
2. Make sure your host database support utf8mb4.
P/s I also replied your ticket.
Please Log in or Create an account to join the conversation.
Moderators: Rainy