Error when installing Easyshop Ver 1.14

  • Gerald Thomas
  • Topic Author
  • Offline
  • New Member
  • New Member
More
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

Please Log in or Create an account to join the conversation.

More
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.

Please Log in or Create an account to join the conversation.

Moderators: Rainy

wWw.joomtech.net. All rights reserved.

CONTACT US
  • This email address is being protected from spambots. You need JavaScript enabled to view it.
HIRE US to develop your store.

© 2015 - 2020 wWw.joomtech.net. All rights reserved. JoomTech.net is not affiliated with or endorsed by the Joomla! Project or Open Source Matters. The Joomla!® name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.