3

I'm trying to install an old CiviCRM version on Drupal 6, the purpose is to migrate an old database data to the latest CiviCRM version, but I'm getting this error when I try to install CiviCRM in a clean Drupal install:

Unable to create InnoDB tables. MySQL InnoDB support is required for CiviCRM but is either not available or not enabled in this MySQL database server.

Everything else seems to be ok, I'm gettinig this error in a windows environment. First I tried with wamp, now I'm trying with Laragon. I tried also with vagrant and homestead which is a linux environment I think, same results.

I tried setting innoDB as the default engine and a lot stuff that is there on internet, but anything seems to work. Any idea?

Error

This is what "SHOW ENGINES" return:

SHOW ENGINES

4
  • What does 'show engines' produce? dev.mysql.com/doc/refman/5.7/en/innodb-check-availability.html
    – Aidan
    Oct 23, 2018 at 8:57
  • @Aidan I've added a new picture, as you can see, InnoDB is enabled and is the default engine Oct 23, 2018 at 15:16
  • I'm having the same issue on a unix system running AMPPS. I'm trying to install an old version of CiviCRM (3.3.6 on Drupal 6) for the purpose of upgrading to the latest version of CiviCRM and Drupal 7 to ensure PHP 7.1 compatibility. I also show InnoB as the default. @CésarEscudero, did you figure this out?
    – Christia
    Dec 6, 2018 at 11:39
  • Check here. Sounds like we need a lower mysql version and need to check file permissions: civicrm.stackexchange.com/questions/9448/…
    – Christia
    Dec 6, 2018 at 11:47

1 Answer 1

1

Just go to civicrm/install/index.php and change the line with code if ( $dbName != 'Drupal' ) and either exclude the entire if statement (comment it out) or change it to if(true).

4
  • This doesn't work and needs to be edited for clarity and more detail.
    – Christia
    Dec 10, 2018 at 2:52
  • are you installing a stand alone civic crm or with in drupal/jumula framework?
    – joash
    Dec 10, 2018 at 5:49
  • It is part of Drupal and I was able to get it to work after I figured out what you mean. I commented out the entire if argument.
    – Christia
    Dec 10, 2018 at 6:17
  • sweet you can kindly flag the answer as useful with a few more details you find needful
    – joash
    Dec 10, 2018 at 8:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.