Skip to content

PGSQL "message": "SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: #6811

Answered by phpmac
phpmac asked this question in Q&A
PGSQL "message": "SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: #6811
@phpmac phpmac
Mar 30, 2025 · 2 comments
Answered by phpmac Return to top
Discussion options

phpmac
Mar 30, 2025

You must be logged in to vote
Answered by phpmac Mar 30, 2025 
<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::table('action_events', function (Blueprint $table) {
            // 修改actionable_id、model_id和target_id字段为string类型
            $table->string('actionable_id', 36)->change();
            $table->string('model_id', 36)->change();
            $table->string('target_id', 36)->change();
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::table('action_events', fun…
View full answer

Replies: 2 comments

Comment options

phpmac
Mar 30, 2025
Author

You must be logged in to vote
0 replies
Comment options

phpmac
Mar 30, 2025
Author

You must be logged in to vote
0 replies
Answer selected by phpmac
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
1 participant
@phpmac
Converted from issue

This discussion was converted from issue #6804 on April 03, 2025 07:57.