APIIDA API Gateway Manager
SQL Error - SQLSTATE[22001]
- Michael Stroh (Deactivated)
- Mirco Hoffmann (Unlicensed)
Owned by Michael Stroh (Deactivated), created
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
Connect to the MySQL database AAGM is using
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