无效的文本表示：7错误：类型bigint的输入语法无效

Question

收到以下错误：

SQLState[22P02]:无效文本表示：7错误：类型bigint的输入语法无效：“ebbdac9d-3633-43d6-9faf-0d3847fb83d0”（SQL：插入到“objects”（“parent_id”,“team_id”,“objectable_id”,“objectable_type”,“id”,“updated_at”,“created_at”）值（？,4,ebbdac9d-3633-43d6-9faf-0d3847fb83d0,folder,d7eb0ce9-27d1-4960-9322-169f8fda1417,

我把我的代码贴在下面，请大家帮忙：

数据库迁移

class CreateObjectsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('objects', function (Blueprint $table) {
            $table->uuid('id')->primary();
            $table->morphs('objectable');
            $table->foreignId('parent_id')->nullable()->contrained('objects');
            $table->foreignId('team_id')->contrained('teams');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('objects');
    }
}

Obj模型

<?php

namespace App\Models;

use App\Traits\Uuids;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Obj extends Model
{
    use HasFactory;
    use Uuids;

    public $table = 'objects';

    protected $fillable = [
        'parent_id',
    ];

    public function objectable()
    {
        return $this->morphTo();
    }
}

应用程序服务提供商

/**
 * Bootstrap any application services.
 *
 * @return void
 */
public function boot()
{
    Relation::morphMap([
        'folder' => Folder::class,
        'file' => File::class,
    ]);
}

团队模式

public static function booted()
{
    static::created(function ($team) {
        $folder = $team->folders()->create(['name' => $team->name]);
        $object = $team->objects()->make(['parent_id' => null]);

        $object->objectable()->associate($folder);
        $object->save();
    });
}

Answer 1

我用下面的解决方案修复了上面的问题：

$table->uuidmorphs('objectable')；

以前我使用的是：

$table->morphs（“objectable”）；