[功能异常] 用户作品下载异常

[March-8U]

问题描述

使用 accounts_urls 参数的账号链接 下载多个作品时，在第十一个链接时出现BUG。未开启日志，且使用链接单独下载正常。

复现步骤

1. 使用多个主页分享短链
2. 超过十位账号链接
3. 使用链接“https://v.douyin.com/MchQrKcMJWU/”

错误代码

程序连续处理了 10 个数据，为了避免请求频率过高导致账号或 IP 被风控，程序已经暂停运行，将在 300 秒后恢复运行！
开始处理第 11 个账号
共获取到 52 个账号发布作品
开始提取作品数据
昵称/标题：口罩女王OvO；标识：口罩女王Ⅰ；ID：7527933293816628284
正在关闭程序
Traceback (most recent call last):
File "D:\Project\TikTokDownloader\src\storage\sqlite.py", line 76, in update_sheet
await self.cursor.execute(self.UPDATE_SQL, (old_sheet, new_sheet))
File "D:\Variable\Python\Lib\site-packages\aiosqlite\cursor.py", line 48, in execute
await self._execute(self._cursor.execute, sql, parameters)
File "D:\Variable\Python\Lib\site-packages\aiosqlite\cursor.py", line 40, in _execute
return await self._conn._execute(fn, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Variable\Python\Lib\site-packages\aiosqlite\core.py", line 132, in _execute
return await future
^^^^^^^^^^^^
File "D:\Variable\Python\Lib\site-packages\aiosqlite\core.py", line 115, in run
result = function()
^^^^^^^^^^
sqlite3.OperationalError: near "?": syntax error

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "D:\Project\TikTokDownloader\main.py", line 19, in
run(main())
File "D:\Variable\Python\Lib\asyncio\runners.py", line 194, in run
return runner.run(main)
^^^^^^^^^^^^^^^^
File "D:\Variable\Python\Lib\asyncio\runners.py", line 118, in run
return self._loop.run_until_complete(task)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Variable\Python\Lib\asyncio\base_events.py", line 664, in run_until_complete
return future.result()
^^^^^^^^^^^^^^^
File "D:\Project\TikTokDownloader\main.py", line 10, in main
await downloader.run()
File "D:\Project\TikTokDownloader\src\application\TikTokDownloader.py", line 415, in run
await self.main_menu(safe_pop(self.run_command))
File "D:\Project\TikTokDownloader\src\application\TikTokDownloader.py", line 288, in main_menu
await self.compatible(mode)
File "D:\Project\TikTokDownloader\src\application\TikTokDownloader.py", line 374, in compatible
await self.__function_menu[n]1
File "D:\Project\TikTokDownloader\src\application\TikTokDownloader.py", line 298, in complete
await example.run(self.run_command)
File "D:\Project\TikTokDownloader\src\application\main_terminal.py", line 2315, in run
await self.__function[n]1
File "D:\Project\TikTokDownloader\src\application\main_terminal.py", line 321, in account_acquisition_interactive
await self.__secondary_menu(
File "D:\Project\TikTokDownloader\src\application\main_terminal.py", line 349, in __secondary_menu
await function[n][1](
File "D:\Project\TikTokDownloader\src\application\main_terminal.py", line 358, in account_detail_batch
await self.__account_detail_batch(
File "D:\Project\TikTokDownloader\src\application\main_terminal.py", line 402, in __account_detail_batch
if not await self.deal_account_detail(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Project\TikTokDownloader\src\application\main_terminal.py", line 605, in deal_account_detail
return await self._batch_process_detail(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "D:\Project\TikTokDownloader\src\application\main_terminal.py", line 759, in _batch_process_detail
async with logger(
File "D:\Project\TikTokDownloader\src\storage\sqlite.py", line 45, in aenter
await self.update_sheet()
File "D:\Project\TikTokDownloader\src\storage\sqlite.py", line 80, in update_sheet
" ".join(
TypeError: sequence item 1: expected str instance, OperationalError found

[dosubot]

这是一个已知的 bug，根本原因是 SQLite DDL 语句中错误使用了参数占位符 ?。

在 src/storage/sql.py 中，UPDATE_SQL 使用了：

UPDATE_SQL = "ALTER TABLE ? RENAME TO ?;"

SQLite 不支持在表名位置使用 ? 占位符（只能用于数据值），所以执行时会报 near "?": syntax error。

解决方案： 请更新到最新版本，此问题已在 2026年1月30日的提交 中修复，改用了 .format() 字符串替换。

相关 issue：#630、#194、#506

To reply, just mention @dosu.

---

^{How did I do? Good | Irrelevant | Incorrect | Verbose | Hallucination | Report 🐛 | Other}