I am following all the steps for adding new column votes to the user table from laravel, still there isn't in the database? Please tell me where is my mistake? Firstly php artisan make:migration add_votes_to_users_table --table=users
public function up()
{
Schema::table('users', function (Blueprint $table) {
$table->integer('votes');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('users', function (Blueprint $table) {
$table->dropColumn('votes');
});
}
php artisan migrate
Error from cmd- In Connection.php line 647:
SQLSTATE[42S01] And In Connection.php line 449:
SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'users' already exists
I am suspecting that the reason you are getting this errors can come from 2 sides.
1) you created users table yourself without run any migration
2) a migration was interrupted.
If the above does not work try:
php artisan migrate:reset
to rollback all your changes or if you want to move back 1 step at a time you can try:
php artisan migrate:rollback --step=1
Last if you are sure you can start over and you are ok with that you can run:
php artisan migrate:fresh
This will drop all the tables (check the database just to be sure as well and drop yourself any remaining even though i don't think anything will be left, never happened to me) and then run
php artisan migrate
all over again
Check your data base. the users table already exit or not. if you create manually. you get this type of error. if users table ther you can remove manually from data base.
Thanks all of you for your suggestions, Sasa Blagojevic you are right about one thing my database was created in wrong way. Actually main problem arise when I created the database first time that time SQLSTATE[42000] appeared for user table. That why when updating the table previous error was still showing. After solving it there wasn't error now.
DFDFAD
alert();