SQL Error - SQLSTATE[22001]

Problem

When doing a migration, you get the following error:

Query could not be executed: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'gr_data' at row 1insert into gatewayresources (gr_node, …) values (:gr_node, …)

Solution

1. Connect to the MySQL database AAGM is using
2. Change the type of the field gr_data in table gatewayresources from varchar to MEDIUMTEXT

This issue is fixed in Version 2022.1.3

---

Related articles

Release Notes 2022.1.3