SQL - Error with PostGreSQL Server

Created on 19 February 2018, over 6 years ago
Updated 10 November 2023, about 1 year ago

When I put in the Block and configure it, there ist an unexpected error:
SQLSTATE[42601]: Syntax error: 7 FEHLER: Syntaxfehler bei ยป86400ยซ LINE 1: SELECT MIN(timestamp) DIV 86400 * 86400 AS timestamp, COUNT(... ^: SELECT MIN(timestamp) DIV 86400 * 86400 AS timestamp, COUNT(*) AS records_count FROM {watchdog} watchdog WHERE severity = :db_condition_placeholder_0 GROUP BY timestamp DIV 86400 LIMIT 10 OFFSET 0; Array ( [:db_condition_placeholder_0] => 3 )

I have a PostGreSQL Server and Drupal 8.4.4

greetz,
Kal

๐Ÿ› Bug report
Status

Closed: outdated

Version

1.5

Component

Code

Created by

๐Ÿ‡ฉ๐Ÿ‡ชGermany Kal_El

Live updates comments and jobs are added and updated live.
  • PostgreSQL

    Particularly affects sites running on the PostgreSQL database.

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024