#1766 mod_storage_Archive summary API does not work with Postgres

Reporter Zash
Owner Zash
Stars ★ (1)
  • Status-Fixed
  • Type-Defect
  • Milestone-0.12
  • Priority-Medium
  1. Zash on

    What steps will reproduce the problem? 0. Configure Prosody to use Postgres for storage 1. Use the archive:summary() (e.g. via the community mod_map) What is the expected output? The API returns a table with summary data What do you see instead? Error preparing statement handle: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list LINE 5: ORDER BY "sort_id" ASC; ^ What version of the product are you using? On what operating system? Prosody 0.12.1, also reproduced on trunk 494577d883ff Debian testing (for LuaDBI compatible with Lua 5.4) Postgres from the Docker image postgres:14-alpine Please provide any additional information below. Reported by Jack in the chat

  2. Zash on

    Fixed in https://hg.prosody.im/trunk/rev/5aafcf6a0730

    • tags Status-Fixed
    • owner Zash

New comment

Not published. Used for spam prevention and optional update notifications.