APIIDA API Gateway Manager

SQL Error - SQLSTATE[22001]

Owned by Michael Stroh (Deactivated), created
Last updated: Sept 22, 2023 by Mirco Hoffmann

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

https://apiida.atlassian.net/wiki/spaces/AAGM/pages/7775256597