truncated - w3toppers.com

Trouble with GROUP_CONCAT and Longtext in MySQL

According to the MySQL manual, the maximum length of GROUP_CONCAT is defined by the group_concat_max_len system variable, which defaults to 1024. This value can be increased, by using the following command: SET group_concat_max_len = <int> It should be noted, however, that the value of group_concat_max_len is itself limited by the value of another system variable, … Read more

Error Code 1292 – Truncated incorrect DOUBLE value – Mysql

This message means you’re trying to compare a number and a string in a WHERE or ON clause. In your query, the only potential place where that could be occurring is ON ac.company_code = ta.company_code; either make sure they have similar declarations, or use an explicit CAST to convert the number to a string. If … Read more