Results 1 to 6 of 6
Like Tree1Likes
  • 1 Post By alemoppo

Thread: InnoDB

  1. #1
    Guest

    Exclamation 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

  2. #2
    Gianluca is offline Administrator
    Join Date
    Feb 2010
    Posts
    512

    Default

    midnightmobsters:

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

  3. #3
    laravista is offline Utente AlterBlog
    Join Date
    Dec 2019
    Posts
    45

    Default

    Quote Originally Posted by Gianluca View Post
    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 ?

    #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`)

  4. #4
    alemoppo is offline AlterVista Staff
    Join Date
    Feb 2010
    Location
    IT
    Posts
    734

    Default

    Did you activate innoDB from here?

    Bye!

  5. #5
    laravista is offline Utente AlterBlog
    Join Date
    Dec 2019
    Posts
    45

    Default

    Quote Originally Posted by alemoppo View Post
    Did you activate innoDB from here?

    Bye!
    Could I activate it for free?

  6. #6
    alemoppo is offline AlterVista Staff
    Join Date
    Feb 2010
    Location
    IT
    Posts
    734

    Default

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

    Bye!
    laravista likes this.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

SEO by vBSEO