采集数据入库,遇到类似报错:SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1
原因是插入的数据,超过xxx字段的限制长度。
解决办法:
1、进入对应网站的数据库管理,找到 mac_vod 数据表打开,并切换到“结构”选项
![苹果cms采集报错:SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1-萌芽采集插件 苹果cms采集报错:SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1](http://www.xuzou.com/wp-content/uploads/2024/09/20240927030244-66f6205438b10.png)
![苹果cms采集报错:SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1-萌芽采集插件 苹果cms采集报错:SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1](http://www.xuzou.com/wp-content/uploads/2024/09/20240927030244-66f620543e33c.png)
2、找到对应的报错提示的字段,如下图报错提示的字段是 vod_tag
![苹果cms采集报错:SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1-萌芽采集插件 苹果cms采集报错:SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1](http://www.xuzou.com/wp-content/uploads/2024/09/20240927030244-66f6205443caf.png)
![苹果cms采集报错:SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1-萌芽采集插件 苹果cms采集报错:SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1](http://www.xuzou.com/wp-content/uploads/2024/09/20240927030244-66f6205448d0d.png)
3、点击修改该字段长度值,建议255,然后保存
![苹果cms采集报错:SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1-萌芽采集插件 苹果cms采集报错:SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1](http://www.xuzou.com/wp-content/uploads/2024/09/20240927030244-66f620544e408.png)
4、保存完毕后,再去采集试试看,如果还是报相同错误,请尝试加大长度值再试。

