Hi All,
- What Grafana version and what operating system are you using?
Grafana - 9.2.0
OS - Ubuntu 20.04.5
This problem occurred when applying the following updates to the server:
Start-Date: 2022-10-16 08:41:43
Commandline: apt upgrade -y
Requested-By: grafadmin (1000)
Install:
linux-headers-5.4.0-128:amd64 (5.4.0-128.144, automatic),
linux-headers-5.4.0-128-generic:amd64 (5.4.0-128.144, automatic),
linux-modules-extra-5.4.0-128-generic:amd64 (5.4.0-128.144, automatic),
linux-modules-5.4.0-128-generic:amd64 (5.4.0-128.144, automatic),
linux-image-5.4.0-128-generic:amd64 (5.4.0-128.144, automatic)
Upgrade:
libgssapi3-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
libwind0-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
linux-headers-generic:amd64 (5.4.0.126.127, 5.4.0.128.129),
linux-libc-dev:amd64 (5.4.0-126.142, 5.4.0-128.144),
linux-image-generic:amd64 (5.4.0.126.127, 5.4.0.128.129),
libheimntlm0-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
libgmp10:amd64 (2:6.2.0+dfsg-4, 2:6.2.0+dfsg-4ubuntu0.1),
libheimbase1-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
libhcrypto4-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
grafana-enterprise:amd64 (9.1.7, 9.2.0), unzip:amd64 (6.0-25ubuntu1, 6.0-25ubuntu1.1),
libroken18-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
libasn1-8-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
libkrb5-26-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
libhx509-5-heimdal:amd64 (7.7.0+dfsg-1ubuntu1, 7.7.0+dfsg-1ubuntu1.1),
linux-generic:amd64 (5.4.0.126.127, 5.4.0.128.129)
End-Date: 2022-10-16 08:43:16
-
What are you trying to achieve?
Send an empty string to our Microsoft SQL server ie ‘’ -
How are you trying to achieve it?
Typing ‘’ -
What happened?
The query inspector shows a single quote ’ -
What did you expect to happen?
The query inspector should show two single quotes ‘’ -
Can you copy/paste the configuration(s) that you are having problems with?
Example 1
Line from the query, part of a case statement:
WHEN TMSFC.code in(‘BHOL’,‘H’,‘HU’,‘CS’) and TMSFC.STARTDATE = ENDDATE AND TMSFC.STARTDATE = CAST(CAST(GETDATE() AS date) AS datetime) THEN ‘’
Query Inspector line
WHEN TMSFC.code in(‘BHOL’,‘H’,‘HU’,‘CS’) and TMSFC.STARTDATE = ENDDATE AND TMSFC.STARTDATE = CAST(CAST(GETDATE() AS date) AS datetime) THEN ’
-
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
I received the following below the query box:
db query error: mssql: Incorrect syntax near ‘BHOL’. -
Did you follow any online instructions? If so, what is the URL?
I cannot find anything relating to this issue.
With thanks
Ian