menu
  • Register

Recent Badges

Popular Question peterlaw
Famous Question mphil
Notable Question peterlaw

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

0 votes
40 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.9k points

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.
36.1k points

Related questions

0 votes
1 answer 125 views
125 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 mphil 2.3k points
0 votes
1 answer 104 views
104 views
Cdbconnection failed to open the db connection: sqlstate[08004] [1040] too many connections
Problem : I am getting following error in my error log file [18-Nov-2019 19:09:55 UTC] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /home/root/products/db.php:2 Stack trace: /home/ ... ', 'root', '**somePassword**'); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
asked Nov 20, 2019 peterlaw 6.9k points
0 votes
1 answer 91 views
91 views
Sqlstate[hy000] [1045] access denied for user 'homestead'@'localhost' (using password: yes)
Problem : I am currently using the Mac OS Yosemite and Laravel 5.0. I am new to Laravel 5.0. In the local environment whenever I run the below command php artisan migrate I always encounter below error : “Access denied for user 'homestead'@'localhost' (using password: YES)” I am unable to fix above error. Any clue to fix the above error?
asked Feb 13 mphil 2.3k points
0 votes
1 answer 885 views
885 views
Expected response code 250 but got code "530", with message "530 5.7.1 authentication required "
Problem : I got stuck on below error I am trying to configure my SMTP mail on laravel “Expected response code 250 but got code "530", with message "530 5.7.1 authentication required "” Below is the configuration on .env MAIL_DRIVER=smtp MAIL_HOST=smtp.mailtrap.io ... I have tried to authenticate my SMTP on the env but I keep facing the above error so for now I am stuck on that error.
asked Feb 4 jwilliam 3.9k points
0 votes
2 answers 169 views
169 views
Symfony \ component \ httpkernel \ exception \ methodnotallowedhttpexception no message
Problem : I am facing following error while trying to login from the form: Symfony \ Component \ HttpKernel \ Exception \ MethodNotAllowedHttpException No message The following is my route: Route::get('/', ['as' => '/', 'uses' => 'LoginController@getLogin']); Route::get('/login', ... ']); }); The following is form tag: <form class="login-form" action="{{ route('login') }}" method="post">
asked Dec 3, 2019 alecxe 7.5k points
Dark theme