"Database query failed: Data truncated for column ''column_name'' at row 1

This error message is indicating that a database query has failed due to data being too large to fit into a specific column in the database table. The error message specifies that the column in question is column_name and that the error occurred at row 1. The error message also indicates that the language being used is PHP. This typically happens when you are trying to insert data that exceeds the maximum length of a VARCHAR or other string type field in your database table (common in MySQL or MariaDB).

To resolve this, you can either increase the column size or trim the input data before insertion.

Option 1: Increase column size

ALTER TABLE your_table MODIFY COLUMN column_name VARCHAR(255);

Option 2: Trim input data in PHP

$trimmedData = mb_substr($inputData, 0, 255);
// Proceed with query using $trimmedData