Skip to content

[Error] MindSpider # 只获取今日热点和关键词 python main.py --broad-topic 报错 #149

@Looong01

Description

@Looong01
> python main.py --broad-topic
2025-11-05 22:15:17.698 | INFO     | __main__:__init__:43 - MindSpider AI爬虫项目
2025-11-05 22:15:17.698 | INFO     | __main__:__init__:44 - 项目路径: C:\Users\lizel\OneDrive - UvA\Desktop\Codes\Github\BettaFish\MindSpider
2025-11-05 22:15:17.698 | INFO     | __main__:run_broad_topic_extraction:197 - 运行BroadTopicExtraction模块...
2025-11-05 22:15:17.698 | INFO     | __main__:run_broad_topic_extraction:208 - 执行命令: C:\Users\lizel\miniconda3\envs\Yuqing\python.exe main.py --keywords 100
2025-11-05 22:15:19.167 | INFO     | BroadTopicExtraction.database_manager:connect:45 - 成功连接到数据库: mindspider
2025-11-05 22:15:19.436 | INFO     | BroadTopicExtraction.database_manager:connect:45 - 成功连接到数据库: mindspider
2025-11-05 22:15:19.436 | INFO     | __main__:__init__:38 - BroadTopicExtraction 初始化完成
2025-11-05 22:15:19.436 | INFO     | __main__:run_daily_extraction:87 - 
MindSpider AI爬虫 - 每日话题提取
执行时间: 2025-11-05 22:15:19
目标日期: 2025-11-05
爬取平台: 全部 12 个平台
关键词数: 最多 100 个

2025-11-05 22:15:19.436 | INFO     | __main__:run_daily_extraction:101 - 【步骤1】收集热点新闻...
2025-11-05 22:15:19.436 | INFO     | BroadTopicExtraction.get_today_news:collect_and_save_news:178 - 
开始收集每日热点新闻...
时间: 2025-11-05 22:15:19
将从 12 个新闻源收集数据:
  - 微博热搜
  - 知乎热榜
  - B站热搜
  - 今日头条
  - 抖音热榜
  - GitHub趋势
  - 酷安热榜
  - 百度贴吧
  - 华尔街见闻
  - 澎湃新闻
  - 财联社
  - 雪球热榜

2025-11-05 22:15:19.436 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:127 - 正在获取 12 个新闻源的最新内容...
2025-11-05 22:15:19.436 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:128 - ================================================================================
2025-11-05 22:15:19.436 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:133 - 正在获取 微博热搜 的新闻...
2025-11-05 22:15:20.319 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:141 - ✓ 微博热搜: 获取成功,共 30 条新闻
2025-11-05 22:15:20.827 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:133 - 正在获取 知乎热榜 的新闻...
2025-11-05 22:15:21.606 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:141 - ✓ 知乎热榜: 获取成功,共 20 条新闻
2025-11-05 22:15:22.121 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:133 - 正在获取 B站热搜 的新闻...
2025-11-05 22:15:22.830 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:141 - ✓ B站热搜: 获取成功,共 30 条新闻
2025-11-05 22:15:23.330 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:133 - 正在获取 今日头条 的新闻...
2025-11-05 22:15:24.170 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:141 - ✓ 今日头条: 获取成功,共 30 条新闻
2025-11-05 22:15:24.678 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:133 - 正在获取 抖音热榜 的新闻...
2025-11-05 22:15:25.415 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:141 - ✓ 抖音热榜: 获取成功,共 30 条新闻
2025-11-05 22:15:25.917 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:133 - 正在获取 GitHub趋势 的新闻...
2025-11-05 22:15:26.699 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:141 - ✓ GitHub趋势: 获取成功,共 18 条新闻
2025-11-05 22:15:27.200 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:133 - 正在获取 酷安热榜 的新闻...
2025-11-05 22:15:27.922 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:141 - ✓ 酷安热榜: 获取成功,共 18 条新闻
2025-11-05 22:15:28.424 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:133 - 正在获取 百度贴吧 的新闻...
2025-11-05 22:15:29.135 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:141 - ✓ 百度贴吧: 获取成功,共 30 条新闻
2025-11-05 22:15:29.645 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:133 - 正在获取 华尔街见闻 的新闻...
2025-11-05 22:15:30.501 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:141 - ✓ 华尔街见闻: 获取成功,共 30 条新闻
2025-11-05 22:15:31.008 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:133 - 正在获取 澎湃新闻 的新闻...
2025-11-05 22:15:31.785 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:141 - ✓ 澎湃新闻: 获取成功,共 20 条新闻
2025-11-05 22:15:32.286 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:133 - 正在获取 财联社 的新闻...
2025-11-05 22:15:33.090 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:141 - ✓ 财联社: 获取成功,共 13 条新闻
2025-11-05 22:15:33.600 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:133 - 正在获取 雪球热榜 的新闻...
2025-11-05 22:15:34.332 | INFO     | BroadTopicExtraction.get_today_news:get_popular_news:141 - ✓ 雪球热榜: 获取成功,共 30 条新闻
2025-11-05 22:15:34.858 | INFO     | BroadTopicExtraction.database_manager:save_daily_news:95 - 覆盖模式:删除了当天已有的 299 条新闻记录
2025-11-05 22:15:36.024 | INFO     | BroadTopicExtraction.database_manager:save_daily_news:129 - 成功保存 299 条新闻记录
2025-11-05 22:15:36.035 | INFO     | BroadTopicExtraction.get_today_news:_print_collection_summary:282 - 
总新闻源: 12
成功源数: 12
总新闻数: 299
已保存数: 299

2025-11-05 22:15:36.035 | INFO     | __main__:run_daily_extraction:117 - 【步骤2】提取关键词和生成总结...
成功提取 48 个关键词并生成新闻总结
2025-11-05 22:15:53.576 | INFO     | __main__:run_daily_extraction:134 - 【步骤3】保存分析结果到数据库...
2025-11-05 22:15:53.598 | ERROR    | BroadTopicExtraction.database_manager:save_daily_topics:200 - 保存话题分析失败: (pymysql.err.DataError) (1366, "Incorrect integer value: 'summary' for column 'topic_id' at row 1")
[SQL: INSERT INTO daily_topics (extract_date, topic_id, topic_name, keywords, topic_description, add_ts, last_modify_ts) VALUES (%(d)s, %(tid)s, %(tn)s, %(k)s, %(s)s, %(ts)s, %(lmt)s)]     
[parameters: {'d': datetime.date(2025, 11, 5), 'tid': 'summary', 'tn': '每日新闻分析', 'k': '["王传君", "东京电影节", "超级月亮", "全运会", "神二十", "空间碎片", "中美关税", "邵佳一", "国足", "白百何", "iPhone", "AI", "OpenAI", "山姆", "阿里", "星穹铁道", "昔涟", "Faker", "T1", "特朗普",  ... (42 characters truncated) ... "英伟达", "进博会", "台湾", "台独", "国台办", "张晗", "小米", "格力", "诺基亚", "崩坏", "黑神话悟空", "马斯克", "星巴克", "瑞幸", "抖音", "立冬", "穿搭", "GitHub", "酷安", "贴吧", "华尔街见闻", "澎湃新闻"]', 's': '今日热点新闻呈现多元化特征, 涵盖文娱、科技、国际关系等多个领域。王传君获东京电影节影帝成为文娱圈焦点,相关话题持续发酵;科技领域关注AI发展,OpenAI签署巨额合同,谷歌与苹果合作引发关注;国际关系方面,中美关税调整、美国 航母动向、台湾问题等成为重要议题;体育领域全运会赛事和邵佳一出任国足主帅备受瞩目。此外,神二十空间站遭遇碎片撞击推迟返回、超级月亮天文现象、进博会创新展示等也引发广泛讨论。这些热点反映了当 前社会对文化成就、科技创新、国际局势、体育发展的持续关注,同时显示社交媒体平台在热点传播中的重要作用。', 'ts': 1762377353, 'lmt': 1762377353}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)
Traceback (most recent call last):

  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
    │    │       └ <function DefaultDialect.do_execute at 0x0000019F5BE9A8E0>
    │    └ <sqlalchemy.dialects.mysql.pymysql.MySQLDialect_pymysql object at 0x0000019F5DBF8150>
    └ <sqlalchemy.engine.base.Connection object at 0x0000019F5E502290>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\sqlalchemy\engine\default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
    │      │       │          └ {'d': datetime.date(2025, 11, 5), 'tid': 'summary', 'tn': '每日新闻分析', 'k': '["王传君", "东京电影节", "超级月亮", "全运会", "神二十", "空间碎片", "中美关...
    │      │       └ 'INSERT INTO daily_topics (extract_date, topic_id, topic_name, keywords, topic_description, add_ts, last_modify_ts) VALUES (%...
    │      └ <function Cursor.execute at 0x0000019F5DB16F20>
    └ <pymysql.cursors.Cursor object at 0x0000019F5E514890>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\cursors.py", line 153, in execute
    result = self._query(query)
             │    │      └ 'INSERT INTO daily_topics (extract_date, topic_id, topic_name, keywords, topic_description, add_ts, last_modify_ts) VALUES (\...
             │    └ <function Cursor._query at 0x0000019F5DB17420>
             └ <pymysql.cursors.Cursor object at 0x0000019F5E514890>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\cursors.py", line 322, in _query
    conn.query(q)
    │    │     └ 'INSERT INTO daily_topics (extract_date, topic_id, topic_name, keywords, topic_description, add_ts, last_modify_ts) VALUES (\...
    │    └ <function Connection.query at 0x0000019F5DB36CA0>
    └ <pymysql.connections.Connection object at 0x0000019F5E5023D0>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\connections.py", line 558, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
    │    │                │    │                             └ False
    │    │                │    └ <function Connection._read_query_result at 0x0000019F5DB37420>
    │    │                └ <pymysql.connections.Connection object at 0x0000019F5E5023D0>
    │    └ 0
    └ <pymysql.connections.Connection object at 0x0000019F5E5023D0>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\connections.py", line 822, in _read_query_result
    result.read()
    │      └ <function MySQLResult.read at 0x0000019F5DB37CE0>
    └ <pymysql.connections.MySQLResult object at 0x0000019F5E50FF50>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\connections.py", line 1200, in read
    first_packet = self.connection._read_packet()
                   │    └ None
                   └ <pymysql.connections.MySQLResult object at 0x0000019F5E50FF50>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\connections.py", line 772, in _read_packet
    packet.raise_for_error()
    │      └ <function MysqlPacket.raise_for_error at 0x0000019F5DB356C0>
    └ <pymysql.protocol.MysqlPacket object at 0x0000019F5C4CED10>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
    │   │                     │    └ <member '_data' of 'MysqlPacket' objects>
    │   │                     └ <pymysql.protocol.MysqlPacket object at 0x0000019F5C4CED10>
    │   └ <function raise_mysql_exception at 0x0000019F5DA10540>
    └ <module 'pymysql.err' from 'C:\\Users\\lizel\\miniconda3\\envs\\Yuqing\\Lib\\site-packages\\pymysql\\err.py'>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
          │          │      └ "Incorrect integer value: 'summary' for column 'topic_id' at row 1"
          │          └ 1366
          └ <class 'pymysql.err.DataError'>

pymysql.err.DataError: (1366, "Incorrect integer value: 'summary' for column 'topic_id' at row 1")


The above exception was the direct cause of the following exception:


Traceback (most recent call last):

  File "C:\Users\lizel\OneDrive - UvA\Desktop\Codes\Github\BettaFish\MindSpider\BroadTopicExtraction\main.py", line 325, in <module>
    main()
    └ <function main at 0x0000019F5D964D60>

  File "C:\Users\lizel\OneDrive - UvA\Desktop\Codes\Github\BettaFish\MindSpider\BroadTopicExtraction\main.py", line 312, in main
    success = asyncio.run(run_extraction_command(
              │       │   └ <function run_extraction_command at 0x0000019F5A691620>
              │       └ <function run at 0x0000019F58AA3380>
              └ <module 'asyncio' from 'C:\\Users\\lizel\\miniconda3\\envs\\Yuqing\\Lib\\asyncio\\__init__.py'>

  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\asyncio\runners.py", line 190, in run
    return runner.run(main)
           │      │   └ <coroutine object run_extraction_command at 0x0000019F5C7A5D20>
           │      └ <function Runner.run at 0x0000019F5A4CEE80>
           └ <asyncio.runners.Runner object at 0x0000019F5D95F690>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\asyncio\runners.py", line 118, in run
    return self._loop.run_until_complete(task)
           │    │     │                  └ <Task pending name='Task-1' coro=<run_extraction_command() running at C:\Users\lizel\OneDrive - UvA\Desktop\Codes\Github\Bett...
           │    │     └ <function BaseEventLoop.run_until_complete at 0x0000019F5A4CCAE0>
           │    └ <ProactorEventLoop running=True closed=False debug=False>
           └ <asyncio.runners.Runner object at 0x0000019F5D95F690>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\asyncio\base_events.py", line 641, in run_until_complete
    self.run_forever()
    │    └ <function ProactorEventLoop.run_forever at 0x0000019F5A59C040>
    └ <ProactorEventLoop running=True closed=False debug=False>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\asyncio\windows_events.py", line 321, in run_forever
    super().run_forever()
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\asyncio\base_events.py", line 608, in run_forever
    self._run_once()
    │    └ <function BaseEventLoop._run_once at 0x0000019F5A4CE840>
    └ <ProactorEventLoop running=True closed=False debug=False>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\asyncio\base_events.py", line 1936, in _run_once
    handle._run()
    │      └ <function Handle._run at 0x0000019F58A58C20>
    └ <Handle Task.task_wakeup(<Future finished result=None>)>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\asyncio\events.py", line 84, in _run
    self._context.run(self._callback, *self._args)
    │    │            │    │           │    └ <member '_args' of 'Handle' objects>
    │    │            │    │           └ <Handle Task.task_wakeup(<Future finished result=None>)>
    │    │            │    └ <member '_callback' of 'Handle' objects>
    │    │            └ <Handle Task.task_wakeup(<Future finished result=None>)>
    │    └ <member '_context' of 'Handle' objects>
    └ <Handle Task.task_wakeup(<Future finished result=None>)>

  File "C:\Users\lizel\OneDrive - UvA\Desktop\Codes\Github\BettaFish\MindSpider\BroadTopicExtraction\main.py", line 242, in run_extraction_command
    result = await extractor.run_daily_extraction(
                   │         └ <function BroadTopicExtraction.run_daily_extraction at 0x0000019F5D964A40>
                   └ <__main__.BroadTopicExtraction object at 0x0000019F5D95FA10>

  File "C:\Users\lizel\OneDrive - UvA\Desktop\Codes\Github\BettaFish\MindSpider\BroadTopicExtraction\main.py", line 135, in run_daily_extraction
    save_success = self.db_manager.save_daily_topics(
                   │    │          └ <function DatabaseManager.save_daily_topics at 0x0000019F5C204CC0>
                   │    └ <BroadTopicExtraction.database_manager.DatabaseManager object at 0x0000019F5DB32650>
                   └ <__main__.BroadTopicExtraction object at 0x0000019F5D95FA10>

> File "C:\Users\lizel\OneDrive - UvA\Desktop\Codes\Github\BettaFish\MindSpider\BroadTopicExtraction\database_manager.py", line 191, in save_daily_topics
    conn.execute(
    │    └ <function Connection.execute at 0x0000019F5BDDACA0>
    └ <sqlalchemy.engine.base.Connection object at 0x0000019F5E502290>

  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\sqlalchemy\engine\base.py", line 1419, in execute
    return meth(
           └ <bound method ClauseElement._execute_on_connection of <sqlalchemy.sql.elements.TextClause object at 0x0000019F5E501910>>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\sqlalchemy\sql\elements.py", line 526, in _execute_on_connection
    return connection._execute_clauseelement(
           │          └ <function Connection._execute_clauseelement at 0x0000019F5BDDAFC0>
           └ <sqlalchemy.engine.base.Connection object at 0x0000019F5E502290>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\sqlalchemy\engine\base.py", line 1641, in _execute_clauseelement
    ret = self._execute_context(
          │    └ <function Connection._execute_context at 0x0000019F5BDDB1A0>
          └ <sqlalchemy.engine.base.Connection object at 0x0000019F5E502290>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\sqlalchemy\engine\base.py", line 1846, in _execute_context
    return self._exec_single_context(
           │    └ <function Connection._exec_single_context at 0x0000019F5BDDB240>
           └ <sqlalchemy.engine.base.Connection object at 0x0000019F5E502290>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\sqlalchemy\engine\base.py", line 1986, in _exec_single_context
    self._handle_dbapi_exception(
    │    └ <function Connection._handle_dbapi_exception at 0x0000019F5BDDB4C0>
    └ <sqlalchemy.engine.base.Connection object at 0x0000019F5E502290>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\sqlalchemy\engine\base.py", line 2355, in _handle_dbapi_exception
    raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
          │                    │              │                 └ DataError(1366, "Incorrect integer value: 'summary' for column 'topic_id' at row 1")
          │                    │              └ (<class 'pymysql.err.DataError'>, DataError(1366, "Incorrect integer value: 'summary' for column 'topic_id' at row 1"), <trac...
          │                    └ <method 'with_traceback' of 'BaseException' objects>
          └ DataError('(pymysql.err.DataError) (1366, "Incorrect integer value: \'summary\' for column \'topic_id\' at row 1")')
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\sqlalchemy\engine\base.py", line 1967, in _exec_single_context
    self.dialect.do_execute(
    │    │       └ <function DefaultDialect.do_execute at 0x0000019F5BE9A8E0>
    │    └ <sqlalchemy.dialects.mysql.pymysql.MySQLDialect_pymysql object at 0x0000019F5DBF8150>
    └ <sqlalchemy.engine.base.Connection object at 0x0000019F5E502290>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\sqlalchemy\engine\default.py", line 951, in do_execute
    cursor.execute(statement, parameters)
    │      │       │          └ {'d': datetime.date(2025, 11, 5), 'tid': 'summary', 'tn': '每日新闻分析', 'k': '["王传君", "东京电影节", "超级月亮", "全运会", "神二十", "空间碎片", "中美关...
    │      │       └ 'INSERT INTO daily_topics (extract_date, topic_id, topic_name, keywords, topic_description, add_ts, last_modify_ts) VALUES (%...
    │      └ <function Cursor.execute at 0x0000019F5DB16F20>
    └ <pymysql.cursors.Cursor object at 0x0000019F5E514890>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\cursors.py", line 153, in execute
    result = self._query(query)
             │    │      └ 'INSERT INTO daily_topics (extract_date, topic_id, topic_name, keywords, topic_description, add_ts, last_modify_ts) VALUES (\...
             │    └ <function Cursor._query at 0x0000019F5DB17420>
             └ <pymysql.cursors.Cursor object at 0x0000019F5E514890>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\cursors.py", line 322, in _query
    conn.query(q)
    │    │     └ 'INSERT INTO daily_topics (extract_date, topic_id, topic_name, keywords, topic_description, add_ts, last_modify_ts) VALUES (\...
    │    └ <function Connection.query at 0x0000019F5DB36CA0>
    └ <pymysql.connections.Connection object at 0x0000019F5E5023D0>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\connections.py", line 558, in query
    self._affected_rows = self._read_query_result(unbuffered=unbuffered)
    │    │                │    │                             └ False
    │    │                │    └ <function Connection._read_query_result at 0x0000019F5DB37420>
    │    │                └ <pymysql.connections.Connection object at 0x0000019F5E5023D0>
    │    └ 0
    └ <pymysql.connections.Connection object at 0x0000019F5E5023D0>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\connections.py", line 822, in _read_query_result
    result.read()
    │      └ <function MySQLResult.read at 0x0000019F5DB37CE0>
    └ <pymysql.connections.MySQLResult object at 0x0000019F5E50FF50>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\connections.py", line 1200, in read
    first_packet = self.connection._read_packet()
                   │    └ None
                   └ <pymysql.connections.MySQLResult object at 0x0000019F5E50FF50>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\connections.py", line 772, in _read_packet
    packet.raise_for_error()
    │      └ <function MysqlPacket.raise_for_error at 0x0000019F5DB356C0>
    └ <pymysql.protocol.MysqlPacket object at 0x0000019F5C4CED10>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
    err.raise_mysql_exception(self._data)
    │   │                     │    └ <member '_data' of 'MysqlPacket' objects>
    │   │                     └ <pymysql.protocol.MysqlPacket object at 0x0000019F5C4CED10>
    │   └ <function raise_mysql_exception at 0x0000019F5DA10540>
    └ <module 'pymysql.err' from 'C:\\Users\\lizel\\miniconda3\\envs\\Yuqing\\Lib\\site-packages\\pymysql\\err.py'>
  File "C:\Users\lizel\miniconda3\envs\Yuqing\Lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
    raise errorclass(errno, errval)
          │          │      └ "Incorrect integer value: 'summary' for column 'topic_id' at row 1"
          │          └ 1366
          └ <class 'pymysql.err.DataError'>

sqlalchemy.exc.DataError: (pymysql.err.DataError) (1366, "Incorrect integer value: 'summary' for column 'topic_id' at row 1")
[SQL: INSERT INTO daily_topics (extract_date, topic_id, topic_name, keywords, topic_description, add_ts, last_modify_ts) VALUES (%(d)s, %(tid)s, %(tn)s, %(k)s, %(s)s, %(ts)s, %(lmt)s)]     
[parameters: {'d': datetime.date(2025, 11, 5), 'tid': 'summary', 'tn': '每日新闻分析', 'k': '["王传君", "东京电影节", "超级月亮", "全运会", "神二十", "空间碎片", "中美关税", "邵佳一", "国足", "白百何", "iPhone", "AI", "OpenAI", "山姆", "阿里", "星穹铁道", "昔涟", "Faker", "T1", "特朗普",  ... (42 characters truncated) ... "英伟达", "进博会", "台湾", "台独", "国台办", "张晗", "小米", "格力", "诺基亚", "崩坏", "黑神话悟空", "马斯克", "星巴克", "瑞幸", "抖音", "立冬", "穿搭", "GitHub", "酷安", "贴吧", "华尔街见闻", "澎湃新闻"]', 's': '今日热点新闻呈现多元化特征, 涵盖文娱、科技、国际关系等多个领域。王传君获东京电影节影帝成为文娱圈焦点,相关话题持续发酵;科技领域关注AI发展,OpenAI签署巨额合同,谷歌与苹果合作引发关注;国际关系方面,中美关税调整、美国 航母动向、台湾问题等成为重要议题;体育领域全运会赛事和邵佳一出任国足主帅备受瞩目。此外,神二十空间站遭遇碎片撞击推迟返回、超级月亮天文现象、进博会创新展示等也引发广泛讨论。这些热点反映了当 前社会对文化成就、科技创新、国际局势、体育发展的持续关注,同时显示社交媒体平台在热点传播中的重要作用。', 'ts': 1762377353, 'lmt': 1762377353}]
(Background on this error at: https://sqlalche.me/e/20/9h9h)
2025-11-05 22:15:53.617 | INFO     | __main__:run_daily_extraction:146 - 每日话题提取流程完成!
2025-11-05 22:15:53.618 | INFO     | __main__:print_extraction_results:186 -
📰 新闻收集: 299 条新闻
   成功源数: 12/12

🔑 提取关键词: 48 个
   王传君, 东京电影节, 超级月亮, 全运会, 神二十
   空间碎片, 中美关税, 邵佳一, 国足, 白百何
   iPhone, AI, OpenAI, 山姆, 阿里
   星穹铁道, 昔涟, Faker, T1, 特朗普
   航母, 委内瑞拉, 金融强国, 茅台, 机器人
   特斯拉, 英伟达, 进博会, 台湾, 台独
   国台办, 张晗, 小米, 格力, 诺基亚
   崩坏, 黑神话悟空, 马斯克, 星巴克, 瑞幸
   抖音, 立冬, 穿搭, GitHub, 酷安
   贴吧, 华尔街见闻, 澎湃新闻

📝 新闻总结:
   今日热点新闻呈现多元化特征,涵盖文娱、科技、国际关系等多个领域。王传君获东京电影节影帝成为文娱圈焦点,相关话题持续发酵;科技领域关注AI发展,OpenAI签署巨额合同,谷歌与苹果合作引发关注;国际关系方面,中美关税调整、美国航母动向、台湾问题等成为重要议题;体育领域全运会赛事和邵佳一出任国足主帅备受瞩目。此外,神二十空间站遭遇碎片撞击推迟返回、超级月亮天文现象、进博会创新展示等也 引发广泛讨论。这些热点反映了当前社会对文化成就、科技创新、国际局势、体育发展的持续关注,同时显示社交媒体平台在热点传播中的重要作用。

💾 数据库保存: 失败

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions