PlexMatch在MoviePilot2.15.3 postgresql18+上出错

[shadowce]

date	stream	content
2026/08/04 02:27:29	stderr	WHERE transferhistory.tmdbid IS NOT 0 AND transferhistory.status
2026/08/04 02:27:29	stderr	FROM transferhistory
2026/08/04 02:27:29	stderr	2026-08-03 18:27:29.838 UTC [2073] STATEMENT:  SELECT transferhistory.id AS transferhistory_id, transferhistory.src AS transferhistory_src, transferhistory.src_storage AS transferhistory_src_storage, transferhistory.src_fileitem AS transferhistory_src_fileitem, transferhistory.dest AS transferhistory_dest, transferhistory.dest_storage AS transferhistory_dest_storage, transferhistory.dest_fileitem AS transferhistory_dest_fileitem, transferhistory.mode AS transferhistory_mode, transferhistory.type AS transferhistory_type, transferhistory.category AS transferhistory_category, transferhistory.title AS transferhistory_title, transferhistory.year AS transferhistory_year, transferhistory.tmdbid AS transferhistory_tmdbid, transferhistory.imdbid AS transferhistory_imdbid, transferhistory.tvdbid AS transferhistory_tvdbid, transferhistory.doubanid AS transferhistory_doubanid, transferhistory.bangumiid AS transferhistory_bangumiid, transferhistory.anilistid AS transferhistory_anilistid, transferhistory.media_source AS transferhistory_media_source, transferhistory.media_id AS transferhistory_media_id, transferhistory.seasons AS transferhistory_seasons, transferhistory.episodes AS transferhistory_episodes, transferhistory.image AS transferhistory_image, transferhistory.downloader AS transferhistory_downloader, transferhistory.download_hash AS transferhistory_download_hash, transferhistory.status AS transferhistory_status, transferhistory.errmsg AS transferhistory_errmsg, transferhistory.date AS transferhistory_date, transferhistory.files AS transferhistory_files, transferhistory.episode_group AS transferhistory_episode_group
2026/08/04 02:27:29	stderr	2026-08-03 18:27:29.838 UTC [2073] ERROR:  syntax error at or near "0" at character 1652

[dosubot]

Hi @shadowce! I'm Dosu and I'm helping the InfinityPacer's Org team.

The error is caused by TransferHistory.tmdbid.is_not(0) in the PlexMatch plugin, which generates the invalid PostgreSQL syntax IS NOT 0 [1]. SQLAlchemy's is_not() is designed for NULL checks only — it's not valid for numeric comparisons in PostgreSQL.

The fix is to replace is_not(0) with != 0:

# Before (broken on PostgreSQL)
TransferHistory.tmdbid.is_not(0),

# After (correct)
TransferHistory.tmdbid != 0,

This affects three files:

1. plugins/plexmatch/__init__.py line 403
2. plugins.v2/plexmatch/__init__.py line 403
3. plugins/historycategory/__init__.py line 407 — the HistoryCategory plugin has the same issue

Note: this likely worked on SQLite (which is more lenient with IS NOT syntax) but fails on PostgreSQL which strictly requires IS NOT to only be used with NULL, TRUE, FALSE, etc.

To reply, just mention @dosu.

---

Docs are dead. Just use Dosu.

[InfinityPacer]

已确认问题存在：PlexMatch v2 在执行“补全 .plexmatch 文件”时，tmdbid.is_not(0) 会在 PostgreSQL 下生成非法的 IS NOT 0；普通入库事件不经过该查询。

现已修复并发布 PlexMatch v1.3：

• 查询改为 IS NOT NULL AND != 0，兼容 PostgreSQL 与 SQLite
• 历史 v1 插件未修改、未重新打包
• PR：fix(plexmatch): 修复 PostgreSQL 历史记录查询 #370
• Release：https://github.com/InfinityPacer/MoviePilot-Plugins/releases/tag/PlexMatch_v1.3

发布资产已回查，版本与修复源码一致。