Promo Member Baru 40%! Program Full Stack Membership! Hanya 3 Hari! Klaim Promo

Error dalam php artisan migrate

Ditanyakan 1 bulan yang lalu oleh Abednego Sihombing

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

BUAT KOMENTAR

1 JAWABAN / 1 KOMENTAR

User avatar
Muhammad Amirul Ihsan menjawab 1 bulan yang lalu

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

Cek ini

Comment ..

sudah saya coba. tetapi belum bisa juga kak. saya sudah update gambar dalam bentuk link kak.

Dikomentari 1 bulan yang lalu oleh Abednego Sihombing
BUAT KOMENTAR