Level 102
Do you have other migration?
Oct 19, 2022
13
Level 6
PDOException::("SQLSTATE[HY000]: General error: 1005 Can't create table `borujerd_amintamir`.`blogs` (errno: 121 "Duplicate key on write or u pdate")")
How to solve it?
public function up()
{
Schema::create('blogs', function (Blueprint $table) {
$table->id();
$table->foreignId('user_id')->nullable()->constrained()->cascadeOnDelete();
$table->string('title');
$table->string('slug');
$table->string('link');
$table->string('image')->nullable();
$table->text('body');
$table->string('keywords');
$table->string('meta_description');
$table->timestamps();
});
}
Level 6
@Sinnbeck No, I don't see blogs in my database.
Level 6
@mozew Can't create table `borujerd_amintami you show Schema::create('blogs', function (Blueprint $table) {
Level 6
@mozew maybe you should first borujerd_amintami table then blogs or upside down
Level 102
@LoverCode The error is most likely caused by a duplicate FK :)
1 like
Level 6
@LoverCode The problem is fromuser_id.
SQLSTATE[HY000]: General error: 1005 Can't create table
borujerd_amintamir.blogs(errno: 121 "Duplicate key on write or update") (SQL: alter tableblogsadd constraintblogs_user_id_foreignforeign key (user_id) referencesusers(id) on delete cascade)
Level 6
Level 102
@mozew Can you run php artisan migrate --pretend and post the output?
Level 6
Level 75
@mozew Last screen.... WOW!
1 like
Level 102
@mozew oh hi oxbir. 🤦♂️
1 like
Level 20
Try using this table migration code add these two lines in your migration table file remove this code
$table->foreignId('user_id')->nullable()->constrained()->cascadeOnDelete();
and add this and try to migrate it then
$table->foreignId('user_id')->unsigned()->index()->nullable();
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
Or take this down code and replace it from your migration file code
public function up()
{
Schema::create('blogs', function (Blueprint $table) {
$table->id();
$table->foreignId('user_id')->unsigned()->index()->nullable();
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
$table->string('title');
$table->string('slug');
$table->string('link');
$table->string('image')->nullable();
$table->text('body');
$table->string('keywords');
$table->string('meta_description');
$table->timestamps();
});
}
Level 1
did you try specifying what table does the foreign key being referenced to ?
$table->foreignId('user_id')->nullable()->constrained('relatedTable')->cascadeOnDelete();
Please or to participate in this conversation.