مشكلة في الmigrate

migration

migration





C:\\xampp\\htdocs\\blog>php artisan make:migration create_products_table --create=p
roducts
Created Migration: 2017_06_01_001200_create_products_table

C:\\xampp\\htdocs\\blog>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`))



C:\\xampp\\htdocs\\blog>php artisan migrate


  [Illuminate\\Database\\QueryException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table \'users\' alre
  ady exists (SQL: create table `users` (`id` int unsigned not null auto_incr
  ement primary key, `name` varchar(191) not null, `email` varchar(191) not n
  ull, `password` varchar(191) not null, `remember_token` varchar(100) null,
  `created_at` timestamp null, `updated_at` timestamp null) default character
   set utf8mb4 collate utf8mb4_unicode_ci)



  [PDOException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table \'users\' alre
  ady exists



C:\\xampp\\htdocs\\blog>composer dumpautoload
Generating optimized autoload files

C:\\xampp\\htdocs\\blog>php artisan migrate


  [Illuminate\\Database\\QueryException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table \'users\' alre
  ady exists (SQL: create table `users` (`id` int unsigned not null auto_incr
  ement primary key, `name` varchar(191) not null, `email` varchar(191) not n
  ull, `password` varchar(191) not null, `remember_token` varchar(100) null,
  `created_at` timestamp null, `updated_at` timestamp null) default character
   set utf8mb4 collate utf8mb4_unicode_ci)



  [PDOException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table \'users\' alre
  ady exists



C:\\xampp\\htdocs\\blog>php artisan migrate:refresh
Nothing to rollback.


  [Illuminate\\Database\\QueryException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table \'users\' alre
  ady exists (SQL: create table `users` (`id` int unsigned not null auto_incr
  ement primary key, `name` varchar(191) not null, `email` varchar(191) not n
  ull, `password` varchar(191) not null, `remember_token` varchar(100) null,
  `created_at` timestamp null, `updated_at` timestamp null) default character
   set utf8mb4 collate utf8mb4_unicode_ci)



  [PDOException]
  SQLSTATE[42S01]: Base table or view already exists: 1050 Table \'users\' alre
  ady exists




1 التعليقات


  • Abdel Aziz Hassan
    Abdel Aziz Hassan 2017-09-21 17:57:02

    الجدول usersموجود من قبل امسحة قبل ما تعمل migrate

    Base table or view already exists: 1050 Table \'users\' alre
    

اضف تعليق


يجب ان يكون لديك حساب في الموقع تسجيل الدخول او تسجيل عضوية جديدة

خدمات ويب الفريق