InnoDB

I notice that my current phpmyadmin doesn't have the option to use InnoDB as it is currently disabled. Is there anyway for me (or you) to enable it? I wouldn't be asking but as my database tables contain foreign keys I need to use InnoDB. As of right now I can't carry on with my website until this issue has been fixed.

Any help would be much appreciated

midnightmobsters:

you should activate innodb support in your AlterVista control panel before.

Quote:

---

Originally Posted by Gianluca

midnightmobsters:

you should activate innodb support in your AlterVista control panel before.

---

Is this MySQL error related to the use of ENGINE=MyISAM instead of ENGINE=InnoDB ? :confused:

#1071 - Specified key was too long; max key length is 1000 bytes

This is the faulty SQL generated with php artisan migrate --pretend

Code:

---

alter table `users` add unique `users_email_unique`(`email`)

---

Did you activate innoDB from here?

Bye!

Quote:

---

Originally Posted by alemoppo

Did you activate innoDB from here?

Bye!

---

Could I activate it for free?

No, I'm sorry, but you should have enough AlterCents to activate that service in a new account.

Bye!