Skip to content

Unable to open notification log, sql error

Issue Description

The application is unable to open the notification log. At startup, running from CLI, I get this error:

$ /usr/lib64/xfce4/notifyd/xfce4-notifyd

(xfce4-notifyd:715400): xfce4-notifyd-WARNING **: 19:11:59.089: Unable to open notification log: Failed to prepare SQL statement: near "STRICT": syntax error (CREATE TABLE IF NOT EXISTS notifications (id TEXT PRIMARY KEY NOT NULL,timestamp INTEGER NOT NULL,tz_identifier TEXT NOT NULL,app_id TEXT,app_name TEXT,icon_id TEXT,summary TEXT,body TEXT,actions BLOB,expire_timeout INTEGER,is_read INTEGER NOT NULL DEFAULT FALSE) STRICT)

Steps to Reproduce Issue

  1. Start the app
  2. Enjoy

Expected Behavior

The application logs notifications.

Additional Information

Couldn't find any other occurrence on the web.

Versions

  • OS distribution and version: Almalinux 9.5, up to date
  • Overall Xfce version: 4.18
  • xfce4-notifyd version (git hash if not a release): Xfce Notify Daemon 0.8.2
  • Windowing system (X11/Wayland): X11