CodeMirror fails to load on database page

[simonw]

It's not loading on https://latest.datasette.io/fixtures

But it does load on https://latest.datasette.io/fixtures?sql=select+*+from+facetable

[simonw]

TypeError: textarea is null[Learn More] codemirror-5.31.0.js:9508:3
    fromTextArea http://127.0.0.1:8001/-/static/codemirror-5.31.0.js:9508
    <anonymous> http://127.0.0.1:8001/fixtures:286

[simonw]

Here's why:

datasette/datasette/templates/_codemirror_foot.html

Line 2 in 6abe6fa

var editor = CodeMirror.fromTextArea(document.getElementById("sql-editor"), {

This works on the query.html template:

datasette/datasette/templates/query.html

Line 38 in 6abe6fa

<p><textarea id="sql-editor" name="sql">{% if query and query.sql %}{{ query.sql }}{% else %}select * from {{ tables[0].name|escape_sqlite }}{% endif %}</textarea></p>

But fails on the database.html template:

datasette/datasette/templates/database.html

Line 28 in 6abe6fa

<p><textarea name="sql">{% if tables %}select * from {{ tables[0].name|escape_sqlite }}{% else %}select sqlite_version(){% endif %}</textarea></p>

[simonw]

This is released in 0.29.3

Compare https://v0-29.datasette.io/fixtures (broken) with https://v0-29-3.datasette.io/fixtures (fixed)