ORDER BY (false)

[Pierre-Louis-Boutruche]

Environment

• OS: Windows

• API version: 6.8.5

• Deployment: Docke

• Database: Postgres

• Server config:
  Auth enabled? No

• web UI version: 7.0

Expected behavior
On the tabs "Users", "groups", "downtime management", "permissions", "api keys" I have the following error:

This error prevents me from using all the features correctly.

Sending alerts and displaying alerts works properly without any bugs.

Screenshots

Config docker file

version: '3.1'

services:
  web:
    image: alerta/alerta-web
    ports:
      - "8080:8080"
    depends_on:
      - db
    environment:
      - DEBUG=1  # remove this line to turn DEBUG off
      - DATABASE_URL=postgres://postgres:postgres@db:5432/monitoring
      - PLUGINS=reject,blackout,normalise,enhance
    restart: always
  db:
    image: postgres
    ports:
      - 5432
    environment:
      POSTGRES_DB: monitoring
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: postgres
    restart: always

[orjanj]

Same error here, as the one in the JSON console you've posted.
Have the similar compose-file, though with a few more env variables.

Environment info:

• DB: psql (PostgreSQL) 15.1 (Debian 15.1-1.pgdg110+1)

This issue is similar as this one.

[sbensaoud]

Hi @orjanj ,

did you figure-out a workaround for this ?

[Pierre-Louis-Boutruche]

My problem comes from the version of PostgresSQL, version 15+ is not supported by Alerta. So I switched to version 14.

[satterly]

Alerta now supports Postgres 15.