Filament•2mo ago

Array to String Conversion Problem

I'm building form that include Repeater, but when I'm trying to save the form, Array to String Conversion error always appears. I have ensured that the column in the database has JSON type. Is theres any solution?

12 Replies

awcodes•2mo ago

You need to cast it in the model as ‘array’

kisut•2mo ago

I do, but the error keeps coming.

protected $casts = [
        'primary_artist' => 'array', 'featuring_artist' => 'array', 'metadata_track' => 'array',
    ];

protected $casts = [
        'primary_artist' => 'array', 'featuring_artist' => 'array', 'metadata_track' => 'array',
    ];

error

Array to string conversion (Connection: pgsql, SQL: insert into "releases" ("user_id", "status_project", "release_link", "release_title", "cover_art", "genre_project", "format_project", "original_date", "release_date", "p_line", "c_line", "production_year", "upc_project", "content_id_exclude", "track_link", "metadata_track", "updated_at", "created_at") values (2, Pending, ?, Surga, ?, 4, 1, 2024-06-22, 2024-06-25, Exercitation velit , Ut sit et amet quo , 2024, 12312312, ?, Optio corrupti neq, [{"trackTitle":"surga","genre_track":"0","preview_track":"22:55","isrc_track":"13sadasdas","language_track":"AL","excplicit_track":["true"],"writer_track":["sadasdas"]}], 2024-06-05 19:17:05, 2024-06-05 19:17:05) returning "id")

Array to string conversion (Connection: pgsql, SQL: insert into "releases" ("user_id", "status_project", "release_link", "release_title", "cover_art", "genre_project", "format_project", "original_date", "release_date", "p_line", "c_line", "production_year", "upc_project", "content_id_exclude", "track_link", "metadata_track", "updated_at", "created_at") values (2, Pending, ?, Surga, ?, 4, 1, 2024-06-22, 2024-06-25, Exercitation velit , Ut sit et amet quo , 2024, 12312312, ?, Optio corrupti neq, [{"trackTitle":"surga","genre_track":"0","preview_track":"22:55","isrc_track":"13sadasdas","language_track":"AL","excplicit_track":["true"],"writer_track":["sadasdas"]}], 2024-06-05 19:17:05, 2024-06-05 19:17:05) returning "id")

awcodes•2mo ago

Never worked with Postgres but I wonder if it has something to do with the nested arrays.

kisut•2mo ago

I still don't understand, do you have an example?

Dennis Koch•2mo ago

I don't think there should be anything special to Postgres

awcodes•2mo ago

I don’t either. But the data looks ok to me.

slamx_•2mo ago

You set the casts right, we use also Postgres without problems. How do you setup the database field type?

toeknee•2mo ago

Did you add the casts to the releases model

kisut•2mo ago

I do setup the

primary_artist

primary_artist

featuring_artist

featuring_artist

and

metadata_track

metadata_track

with json columns. So that's why I'm also confused why the result is actually an error. Yes, I do add the cast into releases model. Can you help me about this? I can give you access to see the code if that need.

toeknee•5w ago

Provide the schema of the table

kisut•5w ago

Here is the database table and the model.

kisut•4w ago

Until now, no solution has been found...

Gaming

Programming

Array to String Conversion Problem