Index: lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20220217.sql =================================================================== diff -u -r694dd2c529990a94c17576dce6c98e5b821532e0 -rb1cedb4154efd7a2a2abfa379abd3bcd4127e32f --- lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20220217.sql (.../patch20220217.sql) (revision 694dd2c529990a94c17576dce6c98e5b821532e0) +++ lams_tool_larsrc/src/java/org/lamsfoundation/lams/tool/rsrc/dbupdates/patch20220217.sql (.../patch20220217.sql) (revision b1cedb4154efd7a2a2abfa379abd3bcd4127e32f) @@ -6,6 +6,10 @@ -- LDEV-5287 Use a single instructions field instead of multiple ones ALTER TABLE tl_larsrc11_resource_item CHANGE COLUMN description instructions TEXT; +-- set concat max len to its max +-- https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_group_concat_max_len +SET SESSION group_concat_max_len=18446744073709551615; + UPDATE tl_larsrc11_resource_item AS r JOIN (SELECT item_uid, GROUP_CONCAT(description ORDER BY sequence_id SEPARATOR '

') AS merged_instructions FROM tl_larsrc11_item_instruction GROUP BY item_uid) AS i ON r.uid = i.item_uid