Level 5
@yaelahrep Please share your migration file, there is many things could cause this error. Let's make sure it's not in the migration
Oct 24, 2022
9
Level 3
Illuminate\Database\QueryException
I'm trying to migrate a table in database and this table isn't exists there but getting this error:
SQLSTATE[HY000]: General error: 1813 Tablespace for table '`betterhorizon`.`subscriptions`' exists. Please DISCARD the tablespace before IMPORT (SQL: create table `subscriptions` (`id` bigint unsigned not null auto_increment primary key, `month` int not null, `price` double(8, 2) not null, `status` tinyint not null default '1', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
Level 3
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
return new class extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('subscriptions', function (Blueprint $table) {
$table->id();
$table->integer('month');
$table->float('price');
$table->tinyInteger('status')->default(1);
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('subscriptions');
}
};
Level 102
@mahsanr44 And you have no table named "subscriptions" if you open your database editor? Be sure to not just assume. Actually check it
Level 3
@Sinnbeck yes I have chekced there's no table. I deleted it actually
Level 5
@mahsanr44 Looks fine. I don't know excatly what's the problem with your database, you may have a look on this question on stackoverflow
1 like
Level 102
This sounds like an environment specific error. Like a left over file from earlier or similar. What are you running this on ? Xampp?
Level 3
Level 102
@mahsanr44 Sounds like it was only deleted in the editor, but not on disk. https://stackoverflow.com/a/24107982/1305117
1 like
Level 3
@Sinnbeck yeah I got it
Please or to participate in this conversation.