abusefilter.tables.sqlite.sql and abusefilter.tables.pg.sql are missing columns that are present at abusefilter.tables.sql
possible missing appropriate db patches too.
Description
Description
Details
Details
- Reference
- bz60639
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Fix database schema for PostgreSQL | mediawiki/extensions/AbuseFilter | master | +83 -32 |
| Status | Subtype | Assigned | Task | |
|---|---|---|---|---|
| · · · | ||||
| Invalid | None | T2384 [REPLACED BY TAG] PostgreSQL/pgsql support (tracking) | ||
| Resolved | Daimona | T199544 Make AbuseFilter work on PostgreSQL and SQLite (epic) | ||
| Resolved | matej_suchanek | T62639 Database: SQLite and PG are missing columns | ||
| · · · |
Event Timeline
Comment Actions
abusefilter.tables.sqlite.sql and abusefilter.tables.pg.sql are missing columns that are present at abusefilter.tables.sql
Since rEABF61be1e914913e2c229dbb1f4e252637a97df8fad and rEABF61be1e914913e2c229dbb1f4e252637a97df8fad, the schema should be up-to-date.
EDIT: It wasn't and I made a mistake in this comment as well.
Comment Actions
Change 454810 had a related patch set uploaded (by Matěj Suchánek; owner: Matěj Suchánek):
[mediawiki/extensions/AbuseFilter@master] Fix keys on abuse_filter_log in PostgreSQL
Comment Actions
Change 454810 merged by jenkins-bot:
[mediawiki/extensions/AbuseFilter@master] Fix database schema for PostgreSQL
Comment Actions
Unless I missed something, the files should be up-to-date. Another thing is migration paths (ie. extension updates) between all schemas. T199507 is evidence for one particular problem.
Comment Actions
Nice. I guess we're done with this specific task (which also was quite vague). For other MySQLite- and Postgres-related problems, we have the task linked above, and T199544 as tracking.