sqlite3.OperationalError: table video_info has no column named caption

[zeyuzhou20-debug]

下载单个链接，返回错误：
Traceback (most recent call last):
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\runpy.py", line 196, in _run_module_as_main
return _run_code(code, main_globals, None,
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\runpy.py", line 86, in run_code
exec(code, run_globals)
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\Scripts\f2.exe_main.py", line 6, in
sys.exit(main())
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\site-packages\click\core.py", line 1157, in call
return self.main(*args, **kwargs)
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\site-packages\click\core.py", line 1078, in main
rv = self.invoke(ctx)
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\site-packages\click\core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\site-packages\click\core.py", line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\site-packages\click\core.py", line 783, in invoke
return __callback(*args, **kwargs)
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\site-packages\click\decorators.py", line 33, in new_func
return f(get_current_context(), *args, **kwargs)
File "C:\Users\zhouzeyu\f2\f2\apps\douyin\cli.py", line 443, in douyin
ctx.invoke(set_cli_config, **kwargs)
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\site-packages\click\core.py", line 783, in invoke
return __callback(*args, **kwargs)
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\site-packages\click\decorators.py", line 33, in new_func
return f(get_current_context(), *args, **kwargs)
File "C:\Users\zhouzeyu\f2\f2\cli\cli_commands.py", line 199, in set_cli_config
asyncio.run(run_app(kwargs))
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\asyncio\runners.py", line 44, in run
return loop.run_until_complete(main)
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\asyncio\base_events.py", line 649, in run_until_complete
return future.result()
File "C:\Users\zhouzeyu\f2\f2\cli\cli_commands.py", line 205, in run_app
await app_module.main(kwargs)
File "C:\Users\zhouzeyu\f2\f2\apps\douyin\handler.py", line 2455, in main
await mode_function_mapmode
File "C:\Users\zhouzeyu\f2\f2\apps\douyin\handler.py", line 261, in handle_one_video
await self.get_or_add_video_data(
File "C:\Users\zhouzeyu\f2\f2\apps\douyin\handler.py", line 235, in get_or_add_video_data
await db.add_video_info(ignore_fields=ignore_fields, **aweme_data)
File "C:\Users\zhouzeyu\f2\f2\apps\douyin\db.py", line 251, in add_video_info
await self.execute(
File "C:\Users\zhouzeyu\f2\f2\db\base_db.py", line 126, in execute
await cursor.execute(query, parameters)
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\site-packages\aiosqlite\cursor.py", line 48, in execute
await self._execute(self._cursor.execute, sql, parameters)
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\site-packages\aiosqlite\cursor.py", line 40, in _execute
return await self._conn._execute(fn, *args, **kwargs)
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\site-packages\aiosqlite\core.py", line 132, in _execute
return await future
File "C:\Users\zhouzeyu\AppData\Local\Programs\Python\Python310\lib\site-packages\aiosqlite\core.py", line 115, in run
result = function()
sqlite3.OperationalError: table video_info has no column named caption

[github-actions]

Similarity Issues

1. 84% sqlite3.OperationalError: table user_info_web has no column named nickname_raw #334
2. 74% [QUESTION]抖音下载单个视频报table video_info has no column named caption #303
3. 74% [BUG] table user_info_web has no column named nickname_raw #86
4. 57% [QUESTION] 下载提示有个字段不在数据库内 sqlite3.OperationalError:table user_info_web has no column named nickname_raw #80
5. 50% [BUG] 命令行执行f2 dy下载报错：sqlite3.OperationalError: table user_info_web has no column named nickname_raw #151

[dosubot]

Hi @zeyuzhou20-debug! I'm Dosu and I’m helping the f2 team.

这个报错是因为 f2 最近一次重大更新中，Douyin 的视频信息表从 video_info 重命名为 video_info_web，并且新增了 caption 字段等内容。如果你本地还在用旧的 .db 数据库文件，表结构就会和新代码不匹配，导致插入 caption 字段时报错。参考

解决方法有两个：

1. 如果不需要保留原有下载记录，直接删除下载目录下的旧 .db 文件，程序会自动重建新表结构（含 caption 字段），问题即可解决。
2. 如果需要保留原有数据，可以用如下 SQL 命令手动为 video_info 表添加 caption 字段：

   ALTER TABLE video_info ADD COLUMN caption TEXT;

   但注意，官方推荐的做法是迁移到 video_info_web 表，或者直接让程序自动生成新表。

删除数据库文件会导致原有下载记录丢失，建议提前备份。如果需要更详细的迁移方法或有其他数据库结构报错，可以继续问我。

To reply, just mention @dosu.

---

Docs are dead. Just use Dosu.