0

i am try to install drupal distribution campaigion on my local WAMP server. But during installation it always give AJAX HTTP error.

enter image description here

I contact support team of campaigion but no reponse.How to cope this one.

gill
  • 83
  • 1
  • 9
  • 1
    I don't know drupal, but the errors details is at the bottom of you post: `Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes`. I did a quick google: https://www.drupal.org/node/982980 – Phil Cross Sep 17 '14 at 08:11

1 Answers1

1

I had the same problem.

If you see MySql docs:

Prefix support and lengths of prefixes (where supported) are storage engine dependent. For example, a prefix can be up to 1000 bytes long for MyISAM tables, and 767 bytes for InnoDB tables.

I turned off InnoDB:

You could find my.ini in WAMP server in this answer:

c:\wamp\bin\mysql\mysqlx.y.z\my.ini
Community
  • 1
  • 1
Avara
  • 1,753
  • 2
  • 17
  • 24
  • in my.ini file of mysql where i edit the value.there is no value that match 767 bytes – gill Sep 17 '14 at 09:45
  • You can´t change the 767 bytes. You must turn off InnoDB because InnoDB use 767bytes. The easiest way that i have founded is in this question: http://stackoverflow.com/questions/11772611/how-to-disable-innodb-in-mysql. Search [mysqld] in your my.ini and add: skip-innodb default-storage-engine = myisam – Avara Sep 17 '14 at 09:50