Syntax error or access | Pixel V2

kamel-nahdi

Apr 23rd, 2017 04:43 PM

Please help me on this error i buy it this script two week ago i cant install in my domain

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `categories` add unique `categories_slug_unique`(`slug`))

my ftp details are already sent to your : https://codecanyon.net/user/devdojo

Thank you

devdojo

Apr 24th, 2017 02:16 PM

Ok, thanks. I'll be checking out the FTP info and help you with the setup.

Just FYI, for anyone else who has the issue. The problem is that you have an older version of MySQL. You can fix this by following this article: https://laravel-news.com/laravel-5-4-key-too-long-error

Thanks :)

kamel-nahdi

Apr 24th, 2017 04:01 PM

thank you for your reply

after add code

use Illuminate\Support\Facades\Schema;

public function boot() { Schema::defaultStringLength(191);

}

i have this message "Whoops, looks like something went wrong."