苹果cms采集报错：SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1
采集数据入库，遇到类似报错：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-萌芽采集插件](https://static.mycj.cc/wp-content/uploads/2023/11/1706076485-78805a221a988e7.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-萌芽采集插件](https://static.mycj.cc/wp-content/uploads/2023/11/1706076517-78805a221a988e7.png "苹果cms采集报错：SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1-萌芽采集插件")
2、找到对应的报错提示的字段，如下图报错提示的字段是 vod_tag
![苹果cms采集报错：SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1-萌芽采集插件](https://static.mycj.cc/wp-content/uploads/2023/11/1706076381-78805a221a988e7.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-萌芽采集插件](https://static.mycj.cc/wp-content/uploads/2023/11/1706076636-78805a221a988e7.png "苹果cms采集报错：SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1-萌芽采集插件")
3、点击修改该字段长度值，建议255，然后保存
![苹果cms采集报错：SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1-萌芽采集插件](https://static.mycj.cc/wp-content/uploads/2023/11/1706076746-78805a221a988e7.png "苹果cms采集报错：SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘xxx‘ at row 1-萌芽采集插件")
4、保存完毕后，再去采集试试看，如果还是报相同错误，请尝试加大长度值再试。
