Tag Archives: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘vod_content’.

[Solved] SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘vod_content’.

ALTER TABLE `mac_vod` CHANGE `vod_content` `vod_content` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;

The above line of code solves the error when collecting Apple cms v10 custom interface. The reason is that the vod_content of the database is wrong, you can try;

The following is the error content:

1 SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘vod_content’ ……

ALTER TABLE `mac_vod` CHANGE `vod_content` `vod_content` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL;