Postingan lainnya
Error migrate
[Illuminate\Database\QueryException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key wa
s too long; max key length is 767 bytes (SQL: alter table `users` add un
ique `users_email_unique`(`email`))
[PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key wa
s too long; max key length is 767 bytes
tanya error migrate larevel
0
2 Jawaban:
Jawaban Terpilih
tambahkan script pada AppServiceProvider.php
<?php
namespace App\Providers;
use Illuminate\Support\Facades\Schema; // tambahkan script ini
use Illuminate\Support\ServiceProvider;
class AppServiceProvider extends ServiceProvider
{
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
Schema::defaultStringLength(191); // dan script ini
}
/**
* Register any application services.
*
* @return void
*/
public function register()
{
//
}
}
Semoga membantu
0