Failed to seed sample data

[perotom]

Fix

Describe your request

npm run seed finished with

error: [ERROR] insert into "public"."articles" ("content", "created_at", "description", "document_id", "locale", "published_at", "slug", "title", "updated_at") values ($1, $2, $3, $4, $5, $6, $7, $8, $9) returning "id" - value too long for type character varying(255)

and

error: [ERROR] insert into "public"."components_shared_seos" ("canonical_url", "keywords", "meta_description", "meta_robots", "meta_title", "meta_viewport", "structured_data") values ($1, $2, $3, $4, $5, $6, $7) returning "id" - value too long for type character varying(255)

Steps to reproduce the behavior

1. Follow read me instructions for setup.

Expected behavior

Import should work

Additional context

After manually changing all column length to more than 255, started to work. Tested with Postgresql 16.

[ekalaya2021]

@perotom would you like to describe your walkthrough to fix the problem? I have same problem when I tried to seed into PostgreSQL

[SevakAyvazyan-BM]

same problem with PostgreSQL

[cognitiaclaeves]

In case anyone else hits this. I took a guess and looks like I got lucky; I only had to modify one field in two tables. They were both description-type fields. The error includes "value too long for type character varying(255)", so I guessed at the varying(255) fields, and guessed "description" first. For postgres, I used these commands:

strapi_launchpad=# \d public.articles;
strapi_launchpad=# alter table public.articles alter column description type text;
strapi_launchpad=# \d public.components_shared_seos;
strapi_launchpad=# alter table public.articles alter column meta_description type text;