FLASH SALE Promo Gajian! Potongan harga hingga Rp 400.000. KLAIM PROMO

Error dalam php artisan migrate

Ditanyakan pada tanggal 17 January 2020 oleh Abednego Sihombing Edit  Hapus  Buka Kembali  Tandai 

Minta tolong kak, ini kenapa error dalam melakukan migrate ya kak?

Migrating: 2014_10_12_000000_create_users_table

Illuminate\Database\QueryException : SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (SQL: create table users (id bigint unsigned not null auto_increment primary key, name varchar(255) not null, email varchar(255) not null, email_verified_at timestamp null, password varchar(255) not null, remember_token varchar(100) null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

at C:\Users\Abednego\perpus\vendor\laravel\framework\src\Illuminate\Database\Connection.php:669 665| // If an exception occurs when attempting to run a query, we'll format the error 666| // message to include the bindings with SQL, which will make this exception a 667| // lot more helpful to the developer instead of just the database's errors. 668| catch (Exception $e) {

669| throw new QueryException( 670| $query, $this->prepareBindings($bindings), $e 671| ); 672| } 673|

     Exception trace:

1 PDOException::("SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists") C:\Users\Abednego\perpus\vendor\laravel\framework\src\Illuminate\Database\Connection.php:463

2 PDOStatement::execute() C:\Users\Abednego\perpus\vendor\laravel\framework\src\Illuminate\Database\Connection.php:463

https://imgur.com/bOY6Kj6 https://imgur.com/zIcqDVG https://imgur.com/btAaqvo

1 JAWABAN / 1 KOMENTAR

User avatar
Muhammad Amirul Ihsan menjawab pada tanggal 17 January 2020 Batalkan Jawaban Terbaik  Edit  Hapus  Ubah ke Komentar 

bisa di lampirkan sourcecodenya. itu masalah di tipe data antara foreign key dan primary key referencesnya sepertinya

Cek ini