Error Activating Jigoshop 2

  • Resolved astrasuite

    (@astrasuite)


    8 years, 1 month ago

    I am getting this error while Activating Jigoshop 2:

    “Plugin could not be activated because it triggered a fatal error.

    We haven’t been able to change the engine of the table “posts” to InnoDB. This is a required option. Ask your server provider if this is possible.”

    Any help please ? Thanks

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter astrasuite

    (@astrasuite)

    Well, I found the answer. MySQL version in my Bluehost hosting is 5.5.51, not yet 5.6.

    5.6 will solve the problem, but I am not sure if it is that easy to ask Bluehost to upgrade MySQL.

    Just spoke to Bluehost, they cannot just upgrade to 5.6 since I am on a Shared server. So I guess I can’t use Jigoshop 2 unless I upgrade to a private server (not likely), change hosting services, or change Jigoshop to Woo Commerce.

    Any other workaround ?

    • This reply was modified 8 years, 1 month ago by astrasuite.
    Plugin Author Jigoshop Support – Marcin

    (@azrielnefezen)

    Um, well – the issue is not with the version – it’s with the engine.
    Are you able to login to your database manager (like phpMyAdmin) and change the WP database tables engines to “InnoDB”? The plugin reported that it cannot do it automatically (maybe due to insufficient permissions?)
    The 5.6 version requirement is for PHP, not MySQL ??

    Thread Starter astrasuite

    (@astrasuite)

    No, I cannot change it using phpMyAdmin. If I change the table’s engine to InnoDB, it comes out with this error :

    #1214- The used table type doesn’t support FULLTEXT indexes

    After googling it out, many articles suggest that it is because MySQL has to be 5.6, where InnoDB can support FULLTEXT indexes. If not, only MYISAM can do it.

    The plugin I guess can’t change it because of this error, not insufficient permissions. Other tables seem ok, it’s only the table “posts”

    Thread Starter astrasuite

    (@astrasuite)

    Well, what do you suggest ? Any other Jigoshop user has the same issue yet or is it just me ?

    Plugin Author Jigoshop Support – Marcin

    (@azrielnefezen)

    Well, it seems that it’s only you – since nobody else reported this.
    And this is required – myISAM databases do not enable relating tables in the way we need them to be related.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Error Activating Jigoshop 2’ is closed to new replies.