Title: Error by activating jigoshop plugin Last modified: August 24, 2016 --- # Error by activating jigoshop plugin * Resolved [gerardbeek](https://wordpress.org/support/users/gerardbeek/) * (@gerardbeek) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/) * I get the following error by activating jigoshop: ====== WordPress database error: [Specified key was too long; max key length is 767 bytes] CREATE TABLE IF NOT EXISTS wp_jigoshop_downloadable_product_permissions ( `product_id` mediumint( 9) NOT NULL, `user_email` varchar(200) NOT NULL, `user_id` mediumint(9) NULL,` order_key` varchar(200) NOT NULL, `downloads_remaining` varchar(9) NULL, PRIMARY KEY id (`product_id`, `order_key`)) DEFAULT CHARACTER SET utf8mb4; * We were not able to create a Jigoshop database table during installation! (jigoshop_downloadable_product_permissions) ===== Can you help? Thanks * [https://wordpress.org/plugins/jigoshop/](https://wordpress.org/plugins/jigoshop/) Viewing 15 replies - 1 through 15 (of 19 total) 1 [2](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/page/2/?output_format=md) [→](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/page/2/?output_format=md) * Plugin Author [Jigoshop Support – Krzysztof](https://wordpress.org/support/users/krzysztofk-1/) * (@krzysztofk-1) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086352) * Hi gerardbeek, * Do you have access to your database control panel? * Thread Starter [gerardbeek](https://wordpress.org/support/users/gerardbeek/) * (@gerardbeek) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086357) * Hello, Yes I have, no problem. Regards, Gerard * Plugin Author [Jigoshop Support – Krzysztof](https://wordpress.org/support/users/krzysztofk-1/) * (@krzysztofk-1) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086358) * Can you tell me which charset are you using as default? * Thread Starter [gerardbeek](https://wordpress.org/support/users/gerardbeek/) * (@gerardbeek) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086372) * I have just installed WordPress and this is the first plugin I install. Nothing have been changed as I am new to wordpress. So it should be the standard fonts. I have been looking into the CSS and all is standard. * Plugin Author [Jigoshop Support – Krzysztof](https://wordpress.org/support/users/krzysztofk-1/) * (@krzysztofk-1) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086424) * I was talking about your database default charset, which you can find in database control panel. * Thread Starter [gerardbeek](https://wordpress.org/support/users/gerardbeek/) * (@gerardbeek) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086425) * Ok. This is what I am using: * •Server: 127.0.0.1 via TCP/IP •Software: MySQL •Softwareversie: 5.5.27 – MySQL Community Server (GPL) •Protocolversie: 10 •Gebruiker: root@localhost • Karakterset van server: UTF-8 Unicode (utf8) * Plugin Author [Jigoshop Support – Krzysztof](https://wordpress.org/support/users/krzysztofk-1/) * (@krzysztofk-1) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086429) * Hmm ok, so please open wp-config.php (website main directory), and tell me which value is set as “DB_CHARSET” it should looks like: * ``` define('DB_CHARSET', 'VALUE_WHAT_I_WANT_TO_KNOW'); ``` * Also you can change it to: * ``` define('DB_CHARSET', 'utf8'); ``` * and after that jigoshop should install without any problems. * [alanf-wp](https://wordpress.org/support/users/alanf-wp/) * (@alanf-wp) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086472) * Hi – I’m not the original poster, but I am having the same error x 2 on activation. I have checked wp-config and I changed the default charset to utf8, deleted the database, recreated it, and still got the same error on activation. * [Duuk](https://wordpress.org/support/users/duuk/) * (@duuk) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086473) * I’m a superadmin on a multisite installation. I tried to activate the plugin on one of the sites and got `We were not able to create a Jigoshop database table during installation! (jigoshop_downloadable_product_permissions)` * I have full permissions so I don’t understand the problem. Sounds like it is the same as the others. * [alanf-wp](https://wordpress.org/support/users/alanf-wp/) * (@alanf-wp) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086474) * My error is (and it says it twice, for some reason) * WordPress database error: [Specified key was too long; max key length is 767 bytes] CREATE TABLE IF NOT EXISTS wp_jigoshop_downloadable_product_permissions * Which is ironic, as we don’t need it. We don’t have any downloadable products! * Plugin Author [Jigoshop Support – Krzysztof](https://wordpress.org/support/users/krzysztofk-1/) * (@krzysztofk-1) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086475) * Hi guys. * Try to change charset to “latin1”. * ``` define('DB_CHARSET', 'latin1'); ``` * [alanf-wp](https://wordpress.org/support/users/alanf-wp/) * (@alanf-wp) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086476) * Worked a treat, Krzysztof – thanks! * [Aurumdao](https://wordpress.org/support/users/aurumdao/) * (@aurumdao) * [11 years, 3 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086488) * Unfortunately, ‘latin1’ – is not solution. Need encoding utf8, namely: utf8mb4. The problem is not solved. In WooCommerce not have this problem. * Plugin Author [Jigoshop Support – Krzysztof](https://wordpress.org/support/users/krzysztofk-1/) * (@krzysztofk-1) * [11 years, 2 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086498) * And this is a problem, becouse utf8mb4 uses 4 bytes per character. * Go to jigoshop/admin/jigoshop-install.php in line 345 change `varchar(200)` to` varchar(175)` * [Aurumdao](https://wordpress.org/support/users/aurumdao/) * (@aurumdao) * [11 years, 2 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/#post-6086500) * Great! Installation was successful. Thanks! Viewing 15 replies - 1 through 15 (of 19 total) 1 [2](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/page/2/?output_format=md) [→](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/page/2/?output_format=md) The topic ‘Error by activating jigoshop plugin’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/jigoshop_655549.svg) * [Jigoshop](https://wordpress.org/plugins/jigoshop/) * [Frequently Asked Questions](https://wordpress.org/plugins/jigoshop/#faq) * [Support Threads](https://wordpress.org/support/plugin/jigoshop/) * [Active Topics](https://wordpress.org/support/plugin/jigoshop/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/jigoshop/unresolved/) * [Reviews](https://wordpress.org/support/plugin/jigoshop/reviews/) * 19 replies * 9 participants * Last reply from: [Jigoshop Support – Marcin](https://wordpress.org/support/users/azrielnefezen/) * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/error-by-activating-jigoshop-plugin/page/2/#post-6086549) * Status: resolved