menu
  • Register

Want to solve programming problems and get paid for it? If that sounds interesting to you then contact us.

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

0 votes
53 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

0 votes
1 answer 316 views
316 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
0 votes
1 answer 370 views
370 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, 2020 mphil 2.3k points
0 votes
1 answer 30 views
30 views
Connection failed: sqlstate[hy000] [1040] too many connections.
Problem: If I open my error log file then sometimes I see the below error: 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/products/ ... 'root', '**somePassword**'); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
asked Aug 8, 2020 Raphael Pacheco 4.9k points
0 votes
1 answer 188 views
188 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 2.4K views
2.4K 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, 2020 jwilliam 3.9k points
0 votes
2 answers 339 views
339 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
0 votes
1 answer 697 views
697 views
There was an error while executing `vboxmanage`, a cli used by vagrant
Problem : I am new to laravel. I recently installed laravel homestead and it was running using the powershell. But now it has stopped working completely. I had suspended the vagrant and turned off my box. Now it is only showing me below error: ... (extended info not available) VBoxManage.exe: error: Context: "LockMachine(a->session, LockType_Write)" at line 493 of file VBoxManageModifyVM.cpp
asked Feb 24, 2020 mphil 2.3k points
0 votes
1 answer 31 views
31 views
Createprocess error=206, the filename or extension is too long.
Problem: I am facing below error in my eclipse helios: "Exception occurred executing command line. Cannot run program "C:\Program Files (x86)\Java\jre6\bin\javaw.exe" (in directory "C:\Users\motiver\helios_workspace\TimeTracker"): CreateProcess error=206, The filename or ... database for the testing purposes. Everything worked fine on my Tomcat 7 but now it stopped working as I moved to JBoss 6.
asked Aug 5, 2020 Raphael Pacheco 4.9k points
0 votes
0 answers 53 views
53 views
malformed utf-8 characters, possibly incorrectly encoded
I'm applying Laravel to write a service for mobile. I am trying to figure the solution. Can someone give me the hint?
asked Sep 14, 2020 Daniel Anderson 4k points
Dark theme