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