Illuminate\Database\QueryException : SQLSTATE[HY000]: General error: 1813 Tablespace for table [duplicate]

Question

Am using Laravel 5.6

I Tried to migrate purchases table for my project
When i tried to migrate and it's showing Table Space error.

General error: 1813 Tablespace for table 'jshop.purchases' exists. Please DISCARD the tablespace before IMPORT.

Migrate Code Below :

Schema::create('purchases', function (Blueprint $table) { $table->increments('id'); $table->integer("product_price"); $table->integer("product_qty"); $table->unsignedInteger('invoice_id'); $table->unsignedInteger('product_id'); $table->unsignedInteger('weight_id'); $table->timestamps(); $table->foreign("invoice_id")->references('id')->on('invoices'); $table->foreign("product_id")->references('id')->on('products'); $table->foreign("weight_id")->references('id')->on('weights'); });

invoice,products,weights table are valid in my database.

Error Message Image Below : Migration Error image Link How to solve this ?

Full Migration Code Image

Refer this question stackoverflow.com/questions/15694168/… — Gihan Lakshan
– Gihan Lakshan, Commented Oct 2, 2018 at 6:24
@sanduniYW sir when am trying to put all code its warning me about length of code. That's why i shared image link below i.sstatic.net/yeH83.jpg please open this. — Ripon Uddin
– Ripon Uddin, Commented Oct 2, 2018 at 6:31
please put the relevant code in the question as text and not an image. this question becomes less useful if the image link goes down... — bunbun
– bunbun, Commented Oct 2, 2018 at 6:40

Sajjad Aljileezi · Accepted Answer · 2019-04-12 00:49:58Z

11

Drop the database and create a new one.

answered Apr 12, 2019 at 0:49

Sajjad Aljileezi

7948 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

bettersayhello Over a year ago

Although this suggestion is not the most elegant solution to the problem, in some cases, it will work.

frops Over a year ago

It sounds like: "Just reinstall Windows" ))

sanduniYW · Accepted Answer · 2018-10-02 07:03:49Z

8

try this:

php artisan migrate:refresh

if it is not solve this error try this:

Go to mysql/data/database_name /tablename.ibd file and delete it manually. after this try your command php artisan migrate

edited Oct 2, 2018 at 7:03

answered Oct 2, 2018 at 6:22

sanduniYW

7332 gold badges11 silver badges19 bronze badges

6 Comments

Ripon Uddin Over a year ago

sir... still facing this problem . :(

sanduniYW Over a year ago

you use xampp or wamp?

Ripon Uddin Over a year ago

xampp at windows 10 Operating system

sanduniYW Over a year ago

try above solution

Ripon Uddin Over a year ago

sir it's not work ... when i create new database with different name and migrate this . And its work now. Thank you so much for your help sir... your suggestion really good

|

MUHINDO · Accepted Answer · 2022-06-13 17:31:27Z

Your database is corrupted, do the followinf steps to fix it.

SETP 1. Drop the database and create a new one.

SETP 1. run the following command

php artisan migrate:refresh

Tamale Collins · Accepted Answer · 2021-03-04 15:48:53Z

Locate where your database is and delete the table. Then run PHP artisan migrate This worked for me

Collectives™ on Stack Overflow

Illuminate\Database\QueryException : SQLSTATE[HY000]: General error: 1813 Tablespace for table [duplicate]

Am using Laravel 5.6

invoice,products,weights table are valid in my database.

4 Answers 4

2 Comments

6 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Am using Laravel 5.6

invoice,products,weights table are valid in my database.

4 Answers 4

2 Comments

6 Comments

Comments

Comments

Linked

Related