Error adding collection type

strapi5     | [2024-10-16 23:22:00.475] error: update `themes` set `id` = 1, `document_id` = 'px40op5cy4ayebrt78wffbhm', `colors` = '#ff0000', `video_urls` = NULL, `fonts` = NULL, `font_fallbacks` = NULL, `created_at` = '2024-10-16 23:21:20.982', `updated_at` = '2024-10-16 23:21:20.982', `published_at` = NULL, `created_by_id` = 1, `updated_by_id` = 1, `locale` = NULL where (`id` = 1) - Invalid JSON text: "Invalid value." at position 0 in value for column 'themes.colors'.
strapi5     | Error: update `themes` set `id` = 1, `document_id` = 'px40op5cy4ayebrt78wffbhm', `colors` = '#ff0000', `video_urls` = NULL, `fonts` = NULL, `font_fallbacks` = NULL, `created_at` = '2024-10-16 23:21:20.982', `updated_at` = '2024-10-16 23:21:20.982', `published_at` = NULL, `created_by_id` = 1, `updated_by_id` = 1, `locale` = NULL where (`id` = 1) - Invalid JSON text: "Invalid value." at position 0 in value for column 'themes.colors'.
strapi5     |     at Packet.asError (/opt/node_modules/mysql2/lib/packets/packet.js:728:17)
strapi5     |     at Query.execute (/opt/node_modules/mysql2/lib/commands/command.js:29:26)
strapi5     |     at Connection.handlePacket (/opt/node_modules/mysql2/lib/connection.js:481:34)
strapi5     |     at PacketParser.onPacket (/opt/node_modules/mysql2/lib/connection.js:97:12)
strapi5     |     at PacketParser.executeStart (/opt/node_modules/mysql2/lib/packet_parser.js:75:16)
strapi5     |     at Socket.<anonymous> (/opt/node_modules/mysql2/lib/connection.js:104:25)
strapi5     |     at Socket.emit (node:events:517:28)
strapi5     |     at Socket.emit (node:domain:489:12)
strapi5     |     at addChunk (node:internal/streams/readable:368:12)
strapi5     |     at readableAddChunk (node:internal/streams/readable:341:9)

i get this trying to add json to a collection type

This topic has been created from a Discord post (1296253162407202938) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord