Im trying to create a foreign keys using artisan
, but this error show up.
[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL: alter table `comments` add constraint `comments_comment_lot_id_foreign` foreign key (`comment_lot_id`) references `lots` (`lot_id`
) on delete cascade)
This is my migration:
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateCommentsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('comments', function (Blueprint $table) {
$table->increments('id');
$table->text('comment');
$table->integer('comment_lot_id')->unsigned();
$table->timestamps();
});
Schema::table('comments', function ($table) {
$table->foreign('comment_lot_id')->references('lot_id')->on('lots')->onDelete('cascade');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropForeign(['comment_lot_id']);
Schema::dropIfExists('comments');
}
}
in the lots table i use lot_id
as id
it model Lot.php i add:
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Lot extends Model {
protected $primaryKey = 'lot_id';
}
Any idea how can i resolve this error?
via Chebli Mohamed
The most effective method to Solve MySQL Error 1215 through MySQL Technical Support
RépondreSupprimerThe blunder 1215 signifies "Can't Add Foreign Key Constraints" on the off chance that you are confronting this issue then here we give you three stages to include an outside key. To start with, ensure there is no less than one file on parent segment and furthermore there is one record on tyke section. At that point include outside key requirements tyke table. Be that as it may, in the event that you don't know how to do this procedure at that point admirably contact to MySQL Remote Support and MySQL Remote Service to comprehend this mistake message.
For More Info: https://cognegicsystems.com/
Contact Number: 1-800-450-8670
Email Address- info@cognegicsystems.com
Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801