menu
  • Register

syntax error or access violation: 1071 specified key was too long; max key length is 767 bytes

0 votes
61 views

Problem :

Facing migration error on Laravel 5.4 with php artisan make:auth command as follows:

syntax error or access violation: 1071 specified key was too long; max key length is 767 bytes

●6 ●5 ●3
6,930 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

I am giving two sollutions those work for me.

1:

  1. Open your database.php file insde your config dir/folder.

  2. Edit your 'engine' => null, to 'engine' => 'InnoDB',

    This worked for me.

2:

  1. Open your database.php file insde config dir/folder.
    2. Edit your
    'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci',
    to

    'charset' => 'utf8', 'collation' => 'utf8_unicode_ci',

This worked for me.
●9 ●7 ●4
38,600 points

Related questions

1 vote
1 answer 1 view
1 view
#1071 - specified key was too long; max key length is 767 bytes
Problem: I am getting this error on executing a command : # 1071 - Specified key was too long; max key length is 767 bytes Here’s the command I am trying to execute : ALTER TABLE `mytable` ADD UNIQUE ( `column1` , `column2` ); Any idea how can I solve this problem?
asked 10 hours ago Raj Tyagi 15.6k points
1 vote
1 answer 6 views
6 views
Mysql2::error: specified key was too long; max key length is 767 bytes
Problem: Please help me to solve it out : mysql2::error: specified key was too long; max key length is 767 bytes
asked Apr 7 MUHAMMAD MUNEEB 83k points
1 vote
1 answer 9 views
9 views
specified key was too long; max key length is 767 bytes
Problem: Please help me. How can I solve it? specified key was too long; max key length is 767 bytes
asked Mar 17 MUHAMMAD MUNEEB 83k points
0 votes
1 answer 9 views
9 views
Syntax error or access violation: 1064
Problem: it outputs the error: Syntax error or access violation: 1064 No idea how to fix this. any ideas?
asked Mar 22 ummesalma 29.2k points
1 vote
1 answer 44 views
44 views
Call to a member function store() on null - laravel 5.4
Problem : In Laravel 5.4, I'm trying to upload an image though everytime I submit it's returning that the store() on null error. I've set the form to enctype="multipart/form-data" which hasn't helped. Can anyone point me in the right direction?Thanks.
asked Mar 27 Sabbir Hossain 14.6k points
1 vote
1 answer 2 views
2 views
specified key was too long; max key length is 1000 bytes
Problem: Can someone please help fix this uncaught error: specified key was too long; max key length is 1000 bytes
asked Mar 17 MUHAMMAD MUNEEB 83k points
0 votes
1 answer 3 views
3 views
No application encryption key has been specified laravel.
Problem: Can anyone help me with this complication? >No application encryption key has been specified laravel.
asked 1 day ago Ashok Dileep 5.3k points
0 votes
1 answer 4 views
4 views
Runtimeexception no application encryption key has been specified.
Problem: I'm new to Laravel and I'm trying to use the Artisan command...php artisan serve.It displays...Laravel development server started: http://127.0.0.1:8000.However, it won't automatically launch and when I manually enter http://127.0.0.1:8000 it shows this error:RuntimeException No application encryption key has been specified.Any ideas?
asked May 3 Humaira ahmed 50.7k points
0 votes
1 answer 26 views
26 views
No application encryption key has been specified. laravel
Problem: no application encryption key has been specified. laravel.
asked Feb 24 Ethan ross 2.7k points
0 votes
1 answer 417 views
417 views
The response content must be a string or object implementing __tostring(), "boolean" given.
Problem : I am trying to learn the pSQL. I recently moved my Laravel App from the MySQL to pSQL. But now I keep on getting below error. “The Response content must be a string or object implementing __toString(), "boolean" given.” I have the API that was returning my promotion before but now it only returns the above error. Can anyone suggest me solution on above error ?
asked Feb 13, 2020 mphil 2.3k points
Dark theme