报错的语句 看着数据也不大 。应该不是真的数据过长的问题 。 试过 longtext 也不行 。
INSERT INTO Synads_Tt_Qc_Creative (creative_id, ad_id, advertiser_id, status, opt_status, image_mode, creative_create_time, creative_modify_time, video_material, image_material, title_material, promotion_card_material, Synch_Create_Date, Synch_Create_Hour, lab_ad_type, Synch_Time, creative_material_mode, marketing_goal) VALUES (?, ?, ?, ?, ?, ?, ?, ?, IFNULL(?, ?), IFNULL(?, ?), IFNULL(?, ?), ?, ?, ?, ?, NOW(), ?, ?) ON DUPLICATE KEY UPDATE status = ?, opt_status = ?, image_mode = ?, video_material = ?, creative_modify_time = ?, video_material = IFNULL(?, ?), image_material = IFNULL(?, ?), title_material = IFNULL(?, ?), promotion_card_material = ?, Synch_Create_Hour = ?, lab_ad_type = ?, Synch_Time = NOW(), creative_material_mode = ?, marketing_goal = ?
[arguments: (1733190621, 173318500, 171040419, "DELETE", "DISABLE", "VIDEO_LARGE", "2022-05-19 02:43:05", "2022-11-17 16:09:48", "[{\"aweme_item_id\":0,\"image_mode\":null,\"is_auto_generate\":0,\"video_cover_id\":\"tos-cn-v-c9e10a/537d35a58d2f41ecab2ac2\",\"video_id\":\"v02c8eg10000c9sjpq3c77\"}]", "{\"aweme_item_id\":0,\"is_auto_generate\":0,\"video_cover_id\":\"tos-cn-v-c9e10a/537d35a58d2f41e、\",\"video_id\":\"v02c8eg10000c9sjpq3c7\"}", NULL, NULL, "[{\"dynamic_words\":[],\"title\":\"飞科情人节礼盒已上线，抓紧来直播间抢！ #送男朋友礼物 #男士必备 #飞科 #剃须 #剃须刀\"}]", "{\"dynamic_words\":[],\"title\":\"飞科情人节礼盒已上线，抓紧来直播间抢！ #送男朋友礼物 #男士必备 #飞科 #剃须 #剃须刀\"}", NULL, "2022-05-19", "02", "NOT_LAB_AD", "PROGRAMMATIC_CREATIVE", "LIVE_PROM_GOODS", "DELETE", "DISABLE", "VIDEO_LARGE", "{\"aweme_item_id\":0,\"is_auto_generate\":0,\"video_cover_id\":\"tos-cn-v-c9e10a/537d35a58d2f41ecab2ac\",\"video_id\":\"v02c8eg10000c9sjpq3c77\"}", "2022-11-17 16:09:48", "[{\"aweme_item_id\":0,\"image_mode\":null,\"is_auto_generate\":0,\"video_cover_id\":\"tos-cn-v-c9e10a/537d35a58d2f\",\"video_id\":\"v02c8eg1000、\"}]", "{\"aweme_item_id\":0,\"is_auto_generate\":0,\"video_cover_id\":\"tos-cn-v-c9e10a/537d35a58d2f41eca\",\"video_id\":\"v02c8eg100\"}", NULL, NULL, "[{\"dynamic_words\":[],\"title\":\"飞科情人节礼盒已上线，抓紧来直播间抢！ #送男朋友礼物 #男士必备 #飞科 #剃须 #剃须刀\"}]", "{\"dynamic_words\":[],\"title\":\"飞科情人节礼盒已上线，抓紧来直播间抢！ #送男朋友礼物 #男士必备 #飞科 #剃须 #剃须刀\"}", NULL, "02", "NOT_LAB_AD", "PROGRAMMATIC_CREATIVE", "LIVE_PROM_GOODS")]