Problem installing Jigoshop

  • Geggsy

    (@geggsy)


    11 years ago

    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://ww.wp.xz.cn/plugins/jigoshop/

Viewing 1 replies (of 1 total)
  • Plugin Author Jigoshop Support – Krzysztof

    (@krzysztofk-1)

    11 years ago

    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.