Postingan lainnya
Tentang migrations laravel {belajar laravel 5.3 dasar}
saya dapat error seperti dibawah ini
php artisan migrate Migration table created successfully.
[Illuminate\Database\QueryException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was t oo long; max key length is 767 bytes (SQL: alter table `users` add unique ` users_email_unique`(`email`))
[PDOException] SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was t oo long; max key length is 767 bytes
ada solusi ?
7 Jawaban:
masuk ke file AppServiceProvider.php yang berada di bawah folder app/Providers. terus setelah itu baru masukin script code berikut ini..
<?php
namespace App\Providers;
use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;//tambahin facads nya juga gan
class AppServiceProvider extends ServiceProvider
{
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
Schema::defaultStringLength(191);//tambahin script ini juga gan
}
abis itu coba lagi dah di migrate.. insya allah manjur hehehe
semoga membantu dan bermanfaat.
kode migartaionnya ditampilkan juga gan
Masih Juga mas @BadRabbit hasilnya error seperti dibawah ini
$ php artisan migrate PHP Fatal error: Class 'App\Providers\Schema' not found in C:\xampp\htdocs\Tina s\app\Providers\AppServiceProvider.php on line 16
[Symfony\Component\Debug\Exception\FatalErrorException] Class 'App\Providers\Schema' not found
ini code migrationnya gan @hilmanrdn class CreateForumsTable extends Migration { /\\ \* Run the migrations. \* \* @return void */ public function up() { Schema::create('forums', function (Blueprint $table) { $table->increments('id'); $table->string('title'); $table->text('description'); $table->timestamps(); }); }
/\\ \* Reverse the migrations. \* \* @return void */ public function down() { Schema::drop('forums'); }
script yang ini udah ditambahin belom gan di atas...
use Illuminate\Support\Facades\Schema;
sudah ada gan increments('id'); $table->string('title'); $table->text('description'); $table->timestamps(); }); }
/\\ \* Reverse the migrations. \* \* @return void */ public function down() { Schema::drop('forums'); } }
@AndrianusTinas kalau taro kode di antara tag kode gan (ada tombol yang udah disediakan), biar bagus highlightnya.
Maksudnya agan @BadRabbit
use Illuminate\Support\Facades\Schema;
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
Schema::defaultStringLength(191);
}
kode "schema" itu ditaro di AppServiceProvider bukan cuma di migrationnya Masalah ini bisa dilihat di sini https://github.com/laravel/docs/blob/5.4/migrations.md