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?

awcodes•6/5/24, 12:13 PM

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

kisutOP•6/5/24, 12:18 PM

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•6/5/24, 12:28 PM

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

kisutOP•6/5/24, 12:40 PM

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

Aawcodes Never worked with Postgres but I wonder if it has something to do with the neste...

Dennis Koch•6/5/24, 12:41 PM

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

awcodes•6/5/24, 12:42 PM

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

slamx_•6/5/24, 12:58 PM

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

toeknee•6/5/24, 1:19 PM

Did you add the casts to the releases model

Sslamx_You set the casts right, we use also Postgres without problems. How do you setup...

kisutOP•6/6/24, 6:19 PM

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.

Ttoeknee Did you add the casts to the releases model

kisutOP•6/6/24, 6:21 PM

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•6/7/24, 6:34 AM

Provide the schema of the table

Ttoeknee Provide the schema of the table

kisutOP•6/7/24, 10:28 AM

Here is the database table and the model.

kisutOP•6/13/24, 11:29 PM

Until now, no solution has been found...

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")