01/24/2021 03:54:48 PM INFO raw data from request is b'{"marketingGoal":"2","customCrowd":"1","scheduleType":"SCHEDULE_START_END","scheduleTimes":"SpecifiedTImePeriod","strategyBudget":"","bidType":10,"ocpxActionType":2,"campaignName":"222","groupName":"22","gender":0,"platformOs":0,"clickTrackUrl":"https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=1&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5=__IDFA2__&oaid=__OAID__&callbackUrl=__CALLBACK__&groupId=__AID__&csite=__CSITE__&androidIdMd5=__ANDROIDID2__×tamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=Huichuang.wz","impressionUrl":"https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=1&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5=__IDFA2__&oaid=__OAID__&callbackUrl=__CALLBACK__&groupId=__AID__&csite=__CSITE__&androidIdMd5=__ANDROIDID2__×tamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=Huichuang.wz","actionbarClickUrl":"https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=2&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5=__IDFA2__&oaid=__OAID__&callbackUrl=__CALLBACK__&groupId=__AID__&csite=__CSITE__&androidIdMd5=__ANDROIDID2__×tamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=NewHuichuang.wz","creativeCategory":null,"actionBarText":"22","imageCnt":10,"description":"22","useAppMarket":"1","appIds":[622955],"sceneId":[6,7,3],"scheduleTime":"111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110","siteId":[{"appId":622955,"siteId":""}],"beginTime":"2021-01-23","endTime":"2021-02-02","agesRange":[24,18,31,41,50],"region":[],"convertId":"","excludePopulation":[],"population":[10099095],"strategyState":"1","appStore":["huawei","oppo","vivo","xiaomi","meizu","smartisan"],"accountId":23212,"strategyName":"55"}' 01/24/2021 03:54:48 PM INFO *************************************** NEW REQUEST *************************************** 01/24/2021 03:54:48 PM INFO raw data from request is {'marketingGoal': '2', 'customCrowd': '1', 'scheduleType': 'SCHEDULE_START_END', 'scheduleTimes': 'SpecifiedTImePeriod', 'strategyBudget': '', 'bidType': 10, 'ocpxActionType': 2, 'campaignName': '222', 'groupName': '22', 'gender': 0, 'platformOs': 0, 'clickTrackUrl': 'https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=1&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5=__IDFA2__&oaid=__OAID__&callbackUrl=__CALLBACK__&groupId=__AID__&csite=__CSITE__&androidIdMd5=__ANDROIDID2__×tamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=Huichuang.wz', 'impressionUrl': 'https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=1&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5=__IDFA2__&oaid=__OAID__&callbackUrl=__CALLBACK__&groupId=__AID__&csite=__CSITE__&androidIdMd5=__ANDROIDID2__×tamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=Huichuang.wz', 'actionbarClickUrl': 'https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=2&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5=__IDFA2__&oaid=__OAID__&callbackUrl=__CALLBACK__&groupId=__AID__&csite=__CSITE__&androidIdMd5=__ANDROIDID2__×tamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=NewHuichuang.wz', 'creativeCategory': None, 'actionBarText': '22', 'imageCnt': 10, 'description': '22', 'useAppMarket': '1', 'appIds': [622955], 'sceneId': [6, 7, 3], 'scheduleTime': '111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110', 'siteId': [{'appId': 622955, 'siteId': ''}], 'beginTime': '2021-01-23', 'endTime': '2021-02-02', 'agesRange': [24, 18, 31, 41, 50], 'region': [], 'convertId': '', 'excludePopulation': [], 'population': [10099095], 'strategyState': '1', 'appStore': ['huawei', 'oppo', 'vivo', 'xiaomi', 'meizu', 'smartisan'], 'accountId': 23212, 'strategyName': '55'} 01/24/2021 03:54:49 PM ERROR Traceback (most recent call last): File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context cursor, statement, parameters, context File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute cursor.execute(statement, parameters) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute result = self._query(query) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query conn.query(q) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result result.read() File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) pymysql.err.OperationalError: (1054, "Unknown column 'schedule_type' in 'field list'") The above exception was the direct cause of the following exception: Traceback (most recent call last): File "E:\ai_ads\advertiser_strategy_operate.py", line 68, in post df.to_sql(name="ctop_ai_kuaishou_advertiser_strategy", con=engine, if_exists='append', index=False) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql method=method, File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql method=method, File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql raise err File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql table.insert(chunksize, method=method) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert exec_insert(conn, keys, chunk_iter) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert conn.execute(self.table.insert(), data) File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute return meth(self, multiparams, params) File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement distilled_params, File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context cursor, statement, parameters, context File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute cursor.execute(statement, parameters) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute result = self._query(query) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query conn.query(q) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query self._affected_rows = self._read_query_result(unbuffered=unbuffered) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result result.read() File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read first_packet = self.connection._read_packet() File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet packet.raise_for_error() File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error err.raise_mysql_exception(self._data) File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception raise errorclass(errno, errval) sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column 'schedule_type' in 'field list'") [SQL: INSERT INTO ctop_ai_kuaishou_advertiser_strategy (schedule_type, schedule_times, strategy_budget, bid_type, ocpx_action_type, campaign_name, group_name, gender, platform_os, click_track_url, impression_url, actionbar_click_url, creative_category, action_bar_text, image_cnt, description, use_app_market, app_ids, scene_id, schedule_time, site_id, begin_time, end_time, ages_range, region, convert_id, exclude_population, population, strategy_state, app_store, account_id, strategy_name, campaign_type) VALUES (%(schedule_type)s, %(schedule_times)s, %(strategy_budget)s, %(bid_type)s, %(ocpx_action_type)s, %(campaign_name)s, %(group_name)s, %(gender)s, %(platform_os)s, %(click_track_url)s, %(impression_url)s, %(actionbar_click_url)s, %(creative_category)s, %(action_bar_text)s, %(image_cnt)s, %(description)s, %(use_app_market)s, %(app_ids)s, %(scene_id)s, %(schedule_time)s, %(site_id)s, %(begin_time)s, %(end_time)s, %(ages_range)s, %(region)s, %(convert_id)s, %(exclude_population)s, %(population)s, %(strategy_state)s, %(app_store)s, %(account_id)s, %(strategy_name)s, %(campaign_type)s)] [parameters: {'schedule_type': 'SCHEDULE_START_END', 'schedule_times': 'SpecifiedTImePeriod', 'strategy_budget': '', 'bid_type': 10, 'ocpx_action_type': 2, 'campaign_name': '222', 'group_name': '22', 'gender': 0, 'platform_os': 0, 'click_track_url': 'https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=1&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5 ... (70 characters truncated) ... e=__CSITE__&androidIdMd5=__ANDROIDID2__×tamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=Huichuang.wz', 'impression_url': 'https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=1&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5 ... (70 characters truncated) ... e=__CSITE__&androidIdMd5=__ANDROIDID2__×tamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=Huichuang.wz', 'actionbar_click_url': 'https://adtracker.surge.alibaba.com/monitor.htm?channel=3&taskId=4&app=7&action=2&adid=__DID__&adName=__DNAME__&cid=__CID__&imeiMd5=__IMEI2__&idfaMd5 ... (73 characters truncated) ... _CSITE__&androidIdMd5=__ANDROIDID2__×tamp=__TS__&mac1Md5=__MAC2__&macMd5=__MAC3__&ip=__IP__&translationTag=1&serviceProviderName=NewHuichuang.wz', 'creative_category': None, 'action_bar_text': '22', 'image_cnt': 10, 'description': '22', 'use_app_market': '1', 'app_ids': '[622955]', 'scene_id': '[6, 7, 3]', 'schedule_time': '111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110111111111111111111111110', 'site_id': "[{'appId': 622955, 'siteId': ''}]", 'begin_time': '2021-01-23', 'end_time': '2021-02-02', 'ages_range': '[24, 18, 31, 41, 50]', 'region': '[]', 'convert_id': '', 'exclude_population': '[]', 'population': '[10099095]', 'strategy_state': '1', 'app_store': "['huawei', 'oppo', 'vivo', 'xiaomi', 'meizu', 'smartisan']", 'account_id': 23212, 'strategy_name': '55', 'campaign_type': '2'}] (Background on this error at: http://sqlalche.me/e/13/e3q8)