PHP Laravel SQL setup problem

I'm so junior and i started to setup these techniques but it give me an error

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (Connection: mysql, 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 vendor\laravel\framework\src\Illuminate\Database\Connection.php:825
    821▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    822▕                 );
    823▕             }
    824▕
  ➜ 825▕             throw new QueryException(
    826▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    827▕             );
    828▕         }
    829▕     }

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

  2   vendor\laravel\framework\src\Illuminate\Database\Connection.php:571
      PDOStatement::execute()

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists (Connection: mysql, 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 vendor\laravel\framework\src\Illuminate\Database\Connection.php:825
    821▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    822▕                 );
    823▕             }
    824▕
  ➜ 825▕             throw new QueryException(
    826▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    827▕             );
    828▕         }
    829▕     }

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

  2   vendor\laravel\framework\src\Illuminate\Database\Connection.php:571
      PDOStatement::execute()

15 Replies

محمدOP•3mo ago

why

محمدOP•3mo ago

ἔρως•3mo ago

delete the table or rename it, if you're worried then run that again or just create a new database

محمدOP•3mo ago

how do i do any of that

ἔρως•3mo ago

do you have phpmyadmin?

محمدOP•3mo ago

yes

ἔρως•3mo ago

then you can easily do it there

محمدOP•3mo ago

how i don't know

ἔρως•3mo ago

are you using the root user?

محمدOP•3mo ago

i don't know i just downloaded xampp and installed database client extension sir how do i rename the table

ἔρως•3mo ago

how did you configure thw database to work?

sebin•3mo ago

You can try opening your folder of database -> migrations-> file name of your database rename it or just delete the other user table. You cant have 2 same database name in your database

sebin•3mo ago

محمدOP•3mo ago

thanks so much it worked

Gaming

Programming

PHP Laravel SQL setup problem

Did you find this page helpful?