Title: Problem installing Jigoshop
Last modified: August 30, 2016

---

# Problem installing Jigoshop

 *  [Geggsy](https://wordpress.org/support/users/geggsy/)
 * (@geggsy)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/problem-installing-jigoshop/)
 * Hello again,
 * I am attempting to install Jigoshop on my localhost (iMac running Mavericks 10.9.5)
   in order to attempt to install the drag & Drop Cart on a Jigoshop approved theme.
 * However i am getting this error:
 * **Copied and Pasted from WP**
 * 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
   COLLATE utf8mb4_unicode_ci;
 * 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
   COLLATE utf8mb4_unicode_ci;
 * We were not able to create a Jigoshop database table during installation! (jigoshop_downloadable_product_permissions)
 * **End of Copy & Paste**
 * I am installing from a WP downloaded zip for version Jigoshop 1.17.6
 * Thanks
 * [https://wordpress.org/plugins/jigoshop/](https://wordpress.org/plugins/jigoshop/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Jigoshop Support – Krzysztof](https://wordpress.org/support/users/krzysztofk-1/)
 * (@krzysztofk-1)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/problem-installing-jigoshop/#post-6207346)
 * Hi Geggsy
 * It is becouse WordPress changed database charset, please edit wp-config.php and
   change
 *     ```
       define('DB_CHARSET', 'utf8mb4);
       ```
   
 * to
 *     ```
       define('DB_CHARSET', 'utf8);
       ```
   

Viewing 1 replies (of 1 total)

The topic ‘Problem installing Jigoshop’ 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/)

 * 1 reply
 * 2 participants
 * Last reply from: [Jigoshop Support – Krzysztof](https://wordpress.org/support/users/krzysztofk-1/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/problem-installing-jigoshop/#post-6207346)
 * Status: not resolved