eror juga php artisan migrate:fresh --seed

Ditanyakan pada tanggal 31 July 2020 oleh Abdur Rozak Edit  Hapus  Tandai Selesai  Tandai 
db seed sudah eror, saya tetap lanjut dg melakukan php artisan dump-autoload setelah ini sesuai tutorial saya melakukan perintah php artisan migrate:fresh --seed tetap saja eror kak seperti dibawah ini. mohon petunjuknya kak biar saya bisa lanjut belajar. seperti dibah ini erornya.

PS C:\xampp\htdocs\perpus_applaravel> composer dump-autoload
Generating optimized autoload files
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
> @php artisan package:discover --ansi
Discovered Package: ?[32mbarryvdh/laravel-debugbar?[39m
Discovered Package: ?[32mfacade/ignition?[39m
Discovered Package: ?[32mfideloper/proxy?[39m
Discovered Package: ?[32mfruitcake/laravel-cors?[39m
Discovered Package: ?[32mlaravel/tinker?[39m
Discovered Package: ?[32mlaravel/ui?[39m
Discovered Package: ?[32mnesbot/carbon?[39m
Discovered Package: ?[32mnunomaduro/collision?[39m
Discovered Package: ?[32mspatie/laravel-permission?[39m
?[32mPackage manifest generated successfully.?[39m
Generated optimized autoload files containing 4545 classes
PS C:\xampp\htdocs\perpus_applaravel> php artisan migrate:fresh --seed
Dropped all tables successfully.
Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table
Migrated:  2014_10_12_000000_create_users_table (0.59 seconds)
Migrating: 2014_10_12_100000_create_password_resets_table
Migrated:  2014_10_12_100000_create_password_resets_table (0.41 seconds)
Migrating: 2020_06_26_154814_create-authors-table
Migrated:  2020_06_26_154814_create-authors-table (0.3 seconds)
Migrating: 2020_06_26_160133_create-books-table
Migrated:  2020_06_26_160133_create-books-table (1.1 seconds)
Migrating: 2020_06_26_161819_create_borrow_history_table
Migrated:  2020_06_26_161819_create_borrow_history_table (2.3 seconds)
Migrating: 2020_06_26_172036_create_permission_tables
Migrated:  2020_06_26_172036_create_permission_tables (8.38 seconds)
Migrating: 2020_07_28_155510_add-qty-on-books-table
Migrated:  2020_07_28_155510_add-qty-on-books-table (0.09 seconds)
Seeding: RolesTableSeeder
Seeded:  RolesTableSeeder (0.11 seconds)
Seeding: AdminUserSeeder

   Illuminate\Database\QueryException

  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email_verivied_at' in 'field list' (SQL: insert into `users` (`name`, `email`, `password`, `email_verivied_at`, `updated_at`, `created_at`) values (Admin Perpus, [email protected], $2y$10$Lm/fM8h53JF6OJCRElnVTO85vz7qtpYVauSI1yvymUKvX9f1kWhaS, 2020-07-30 17:53:02, 2020-07-30 17:53:02, 2020-07-30 17:53:02))

  at C:\xampp\htdocs\perpus_applaravel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:671
    667|         // If an exception occurs when attempting to run a query, we'll format the error
    668|         // message to include the bindings with SQL, which will make this exception a
    669|         // lot more helpful to the developer instead of just the database's errors.
    670|         catch (Exception $e) {
  > 671|             throw new QueryException(
    672|                 $query, $this->prepareBindings($bindings), $e
    673|             );
    674|         }
    675|

  • A column was not found: You might have forgotten to run your migrations. You can run your migrations using `php artisan migrate`.
    https://laravel.com/docs/master/migrations#running-migrations

  1   C:\xampp\htdocs\perpus_applaravel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458
      PDOException::("SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email_verivied_at' in 'field list'")

  2   C:\xampp\htdocs\perpus_applaravel\vendor\laravel\framework\src\Illuminate\Database\Connection.php:458
      PDO::prepare("insert into `users` (`name`, `email`, `password`, `email_verivied_at`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?)")
PS C:\xampp\htdocs\perpus_applaravel>
BUAT KOMENTAR

1 JAWABAN / 2 KOMENTAR

User avatar
Muhammad Amirul Ihsan menjawab pada tanggal 31 July 2020 Jadikan Jawaban Terbaik  Edit  Hapus  Ubah ke Komentar 
Dari errornya sudah jelas kolom email_verivied_at not found, harusnya verified 
Comment ..

alhamdulillah sudah bisa kak. terima kasih kak

Dikomentari pada tanggal 1 August 2020 oleh Abdur Rozak Edit  Remove 
BUAT KOMENTAR