GoogleCloudPlatform / bigquery-geo-viz

Visualize Google BigQuery geospatial data using Google Maps Platform APIs
https://bigquerygeoviz.appspot.com/
Apache License 2.0
112 stars 41 forks source link

Query Box not working. #74

Closed Atharva131201 closed 1 month ago

Atharva131201 commented 1 month ago

When I select project from project section. It shows some random numbers on the Query Box and I cannot type any query or execute it.

maxmouchet commented 1 month ago

Same here on Safari and Firefox. This seems to be due to the CodeMirror CSS failing to load:

Failed to load resource: the server responded with a status of 403 (Forbidden)

Reproducing the browser request with cURL it fails when the Referrer header is set:

curl 'https://codemirror.net/5/lib/codemirror.css' -H 'Referer: https://bigquerygeoviz.appspot.com/'
# <center><h1>403 Forbidden</h1></center>

But it works without it:

curl -s 'https://codemirror.net/5/lib/codemirror.css'
# .CodeMirror {
# ...

So that seems to be a change on CodeMirror side.

maxmouchet commented 1 month ago

Fixed it locally by changing the CodeMirror URL to one hosted on jsDelivr:

diff --git a/src/index.html b/src/index.html
index 3fd67dd..df8a547 100644
--- a/src/index.html
+++ b/src/index.html
@@ -8,7 +8,7 @@
   <meta name="viewport" content="width=device-width, initial-scale=1">
   <link rel="icon" type="image/x-icon" href="favicon.ico?v2">
   <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
-  <link href="https://codemirror.net/5/lib/codemirror.css" rel="stylesheet">
+  <link href="https://cdn.jsdelivr.net/npm/codemirror@5/lib/codemirror.css" rel="stylesheet">
   <script>
     window.pendingMap = new Promise((resolve) => {
       window.initMap = () => resolve();
Atharva131201 commented 1 month ago

Can anyone please fix this issue, and redeploy it. Thank you!

mentin commented 1 month ago

Should be fixed now, thanks for report.