v2 Beta - SQL Syntax error when saving Status Page #3749

New issue

Open

opened 2026-02-28 03:39:48 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-28 03:39:48 -05:00

Owner

Originally created by @drewstopherlee on GitHub (Nov 12, 2024).

Unable to find similar issues via search.

🛡️ Security Policy

I agree to have read this project Security Policy

Description

When running the v2 Beta (specifically the nightly2 image, sha256:87ad383f586f9251eb6b644c45f2af3480f205d349b8bfa54c755fce323ee1b0), I get an error when trying to save changes made to a status page.

👟 Reproduction steps

Fresh install of v2 Beta, add monitors, create status page, while in edit mode, make changes and click Save.

👀 Expected behavior

Changes should be applied to the status page and edit mode should close gracefully.

😓 Actual Behavior

Red error popup with text that reads:

DELETE FROM `group` WHERE id NOT IN () AND status_page_id = 2 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND status_page_id = 2' at line 1

🐻 Uptime-Kuma Version

2.0.0-beta.0-nightly-20241105100611

💻 Operating System and Arch

Ubuntu Server 22.04.5 LTS x64

🌐 Browser

Google Chrome 130.0.6723.117 (64-bit)

🖥️ Deployment Environment

Runtime: Docker 27.3.1
Database: Embedded MariaDB
Filesystem used to store the database on: local, ext4 on SSD
number of monitors: 379

📝 Relevant log output

2024-11-12T05:31:24.310916492Z 2024-11-12T00:31:24-05:00 [SOCKET] ERROR: Error: DELETE FROM `group` WHERE id NOT IN () AND status_page_id = 2 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND status_page_id = 2' at line 1
2024-11-12T05:31:24.310993811Z     at Packet.asError (/app/node_modules/mysql2/lib/packets/packet.js:738:17)
2024-11-12T05:31:24.311009959Z     at Query.execute (/app/node_modules/mysql2/lib/commands/command.js:29:26)
2024-11-12T05:31:24.311021485Z     at Connection.handlePacket (/app/node_modules/mysql2/lib/connection.js:481:34)
2024-11-12T05:31:24.311033423Z     at PacketParser.onPacket (/app/node_modules/mysql2/lib/connection.js:97:12)
2024-11-12T05:31:24.311051590Z     at PacketParser.executeStart (/app/node_modules/mysql2/lib/packet_parser.js:75:16)
2024-11-12T05:31:24.311068855Z     at Socket.<anonymous> (/app/node_modules/mysql2/lib/connection.js:104:25)
2024-11-12T05:31:24.311081174Z     at Socket.emit (node:events:519:28)
2024-11-12T05:31:24.311091473Z     at addChunk (node:internal/streams/readable:559:12)
2024-11-12T05:31:24.311101972Z     at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
2024-11-12T05:31:24.311150885Z     at Readable.push (node:internal/streams/readable:390:5) {
2024-11-12T05:31:24.311166361Z   code: 'ER_PARSE_ERROR',
2024-11-12T05:31:24.311176595Z   errno: 1064,
2024-11-12T05:31:24.311186693Z   sqlState: '42000',
2024-11-12T05:31:24.311197072Z   sqlMessage: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND status_page_id = 2' at line 1",
2024-11-12T05:31:24.311208815Z   sql: 'DELETE FROM `group` WHERE id NOT IN () AND status_page_id = 2'
2024-11-12T05:31:24.311223323Z }

Originally created by @drewstopherlee on GitHub (Nov 12, 2024). ### 📑 I have found these related issues/pull requests Unable to find similar issues via search. ### 🛡️ Security Policy - [X] I agree to have read this project [Security Policy](https://github.com/louislam/uptime-kuma/security/policy) ### Description When running the v2 Beta (specifically the nightly2 image, [sha256:87ad383f586f9251eb6b644c45f2af3480f205d349b8bfa54c755fce323ee1b0](https://hub.docker.com/layers/louislam/uptime-kuma/nightly2/images/sha256-243cdccdb62d3ccaeae601453e05ae833bb4bf071305deea76934bf14645edc6?context=explore)), I get an error when trying to save changes made to a status page. ### 👟 Reproduction steps Fresh install of v2 Beta, add monitors, create status page, while in edit mode, make changes and click Save. ### 👀 Expected behavior Changes should be applied to the status page and edit mode should close gracefully. ### 😓 Actual Behavior Red error popup with text that reads: ``` DELETE FROM `group` WHERE id NOT IN () AND status_page_id = 2 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND status_page_id = 2' at line 1 ``` ### 🐻 Uptime-Kuma Version 2.0.0-beta.0-nightly-20241105100611 ### 💻 Operating System and Arch Ubuntu Server 22.04.5 LTS x64 ### 🌐 Browser Google Chrome 130.0.6723.117 (64-bit) ### 🖥️ Deployment Environment - Runtime: Docker 27.3.1 - Database: Embedded MariaDB - Filesystem used to store the database on: local, ext4 on SSD - number of monitors: 379 ### 📝 Relevant log output ```shell 2024-11-12T05:31:24.310916492Z 2024-11-12T00:31:24-05:00 [SOCKET] ERROR: Error: DELETE FROM `group` WHERE id NOT IN () AND status_page_id = 2 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND status_page_id = 2' at line 1 2024-11-12T05:31:24.310993811Z at Packet.asError (/app/node_modules/mysql2/lib/packets/packet.js:738:17) 2024-11-12T05:31:24.311009959Z at Query.execute (/app/node_modules/mysql2/lib/commands/command.js:29:26) 2024-11-12T05:31:24.311021485Z at Connection.handlePacket (/app/node_modules/mysql2/lib/connection.js:481:34) 2024-11-12T05:31:24.311033423Z at PacketParser.onPacket (/app/node_modules/mysql2/lib/connection.js:97:12) 2024-11-12T05:31:24.311051590Z at PacketParser.executeStart (/app/node_modules/mysql2/lib/packet_parser.js:75:16) 2024-11-12T05:31:24.311068855Z at Socket.<anonymous> (/app/node_modules/mysql2/lib/connection.js:104:25) 2024-11-12T05:31:24.311081174Z at Socket.emit (node:events:519:28) 2024-11-12T05:31:24.311091473Z at addChunk (node:internal/streams/readable:559:12) 2024-11-12T05:31:24.311101972Z at readableAddChunkPushByteMode (node:internal/streams/readable:510:3) 2024-11-12T05:31:24.311150885Z at Readable.push (node:internal/streams/readable:390:5) { 2024-11-12T05:31:24.311166361Z code: 'ER_PARSE_ERROR', 2024-11-12T05:31:24.311176595Z errno: 1064, 2024-11-12T05:31:24.311186693Z sqlState: '42000', 2024-11-12T05:31:24.311197072Z sqlMessage: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND status_page_id = 2' at line 1", 2024-11-12T05:31:24.311208815Z sql: 'DELETE FROM `group` WHERE id NOT IN () AND status_page_id = 2' 2024-11-12T05:31:24.311223323Z } ```