Level 60
Would be nice if you will describe your errors, show your logs too
1 like
Sep 6, 2018
5
Level 1
Unable to upload the data to the database (localhost)
Basically , i have 3 models or migrations or tables in my laravel , named as users ,companies , password resets and when i run the php artisan migrate command in cmd it only created the users table in database , didn't created the other two tables and now when i run the php artisan migrate command again it throws an error says user table already exist, users table is working perfectly fine, i am not able to store data in the others table, please help. Thank you
Level 2
The migrate:refresh command will roll back all of your migrations and then execute the migrate command. This command effectively re-creates your entire database:
php artisan migrate:refresh
// Refresh the database and run all database seeds...
php artisan migrate:refresh --seed
The migrate:fresh command will drop all tables from the database and then execute the migrate command:
php artisan migrate:fresh
or
Delete tables from database and then runphp artisan migrate command
Level 1
@Sergiu17 in my terminal php artisan migrate
Illuminate\Database\QueryException : SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (SQL: create table users (id int unsigned not null auto_increment primary key, name varchar(255) not null, email varchar(255) not 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 /opt/lampp/htdocs/Laravel-Vue-First-CRUD-master/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
Level 1
@pardeepkumar when my cmd is : php artisan migrate:refresh
Nothing to rollback.
Illuminate\Database\QueryException : SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (SQL: create table users (id int unsigned not null auto_increment primary key, name varchar(255) not null, email varchar(255) not 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 /opt/lampp/htdocs/Laravel-Vue-First-CRUD-master/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664....
same with the --seed
and
when my command id :- php artisan migrate:fresh
Dropped all tables successfully.
Migration table created successfully.
Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table users add unique users_email_unique(email))
at /opt/lampp/htdocs/Laravel-Vue-First-CRUD-master/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664 660| // If an exception occurs when attempting to run a query, we'll format the error 661| // message to include the bindings with SQL, which will make this exception a 662| // lot more helpful to the developer instead of just the database's errors. 663| catch (Exception $e) {
664| throw new QueryException( 665| $query, $this->prepareBindings($bindings), $e 666| ); 667| } 668|
Exception trace:
1 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes") /opt/lampp/htdocs/Laravel-Vue-First-CRUD-master/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458
2 PDOStatement::execute() /opt/lampp/htdocs/Laravel-Vue-First-CRUD-master/vendor/laravel/framework/src/Illuminate/Database/Connection.php:458
Please use the argument -v to see more details.
Level 1
@Sergiu17 how do i remove your answer from top?? im newbie here so i didnt know that..that was the by mistake
Please or to participate in this conversation.