## [Bug] Missing or Incomplete Translations in SQL Playground Lessons #203

New Issue

2026-05-24T16:58:58Z

enjin2310 commented

2026-05-24 16:58:58 +00:00

🧩 Summary

In the SQL Playground section, several lessons display incomplete or missing Spanish translations within the instruction panels. While the interface and lesson titles are localized, the instructional text remains partially or entirely in English, creating inconsistency for Spanish-speaking users.

🧪 Steps to Reproduce

Navigate to learn.spikersoft.com/tools/sql-playground.
Open any lesson (e.g., SELECT * — todas las filas, todas las columnas).
Observe the INSTRUCCIONES section.
Notice that the content is written in English despite the interface being in Spanish.

✅ Expected Behavior

All instructional text should be fully translated into Spanish, maintaining consistency with the localized interface.
Example:

“Write a query that returns every row from the travelers table.”
→ “Escribe una consulta que devuelva todas las filas de la tabla travelers.”

❌ Actual Behavior

Lesson instructions remain in English.
Some technical terms are untranslated or mixed between languages.
The learning flow feels inconsistent for Spanish-speaking users.

📸 Evidence

The attached screenshot shows the lesson SELECT * — todas las filas, todas las columnas with English instructions under the Spanish interface.

🧠 Possible Root Cause

Missing translation keys in the lesson content database.
Static English text not linked to localization files.
Partial implementation of language switching for instructional content.

### 🧩 Summary In the **SQL Playground** section, several lessons display **incomplete or missing Spanish translations** within the instruction panels. While the interface and lesson titles are localized, the instructional text remains partially or entirely in English, creating inconsistency for Spanish-speaking users. ### 🧪 Steps to Reproduce 1. Navigate to `learn.spikersoft.com/tools/sql-playground`. 2. Open any lesson (e.g., *SELECT * — todas las filas, todas las columnas*). 3. Observe the **INSTRUCCIONES** section. 4. Notice that the content is written in English despite the interface being in Spanish. ### ✅ Expected Behavior All instructional text should be fully translated into Spanish, maintaining consistency with the localized interface. Example: - “Write a query that returns every row from the travelers table.” → **“Escribe una consulta que devuelva todas las filas de la tabla travelers.”** ### ❌ Actual Behavior - Lesson instructions remain in English. - Some technical terms are untranslated or mixed between languages. - The learning flow feels inconsistent for Spanish-speaking users. ### 📸 Evidence The attached screenshot shows the lesson **SELECT * — todas las filas, todas las columnas** with English instructions under the Spanish interface. ### 🧠 Possible Root Cause - Missing translation keys in the lesson content database. - Static English text not linked to localization files. - Partial implementation of language switching for instructional content.

Screenshot 2026-05-24 125815.png

205 KiB

spikerj referenced this issue

2026-06-30 16:00:24 +00:00

[Epic][Bug] Localize lesson code-template comments (Spanish) across all playgrounds #296

spikerj commented

2026-06-30 22:34:44 +00:00

Re-verified against current master. Lesson 60100 (SELECT * — todas las filas, todas las columnas) now has full Spanish instructions/hints in es/sql.json, matching the example translation given in this report verbatim ("Escribe una consulta que devuelva todas las filas de la tabla travelers.").

Resolved by spikersoft-backend PR #30 (merged to master, part of the #279 → #296 localization effort). Duplicate symptom of #274, also closed. Closing.

Re-verified against current `master`. Lesson 60100 (`SELECT * — todas las filas, todas las columnas`) now has full Spanish `instructions`/`hints` in `es/sql.json`, matching the example translation given in this report verbatim ("Escribe una consulta que devuelva todas las filas de la tabla travelers."). Resolved by spikersoft-backend PR #30 (merged to `master`, part of the #279 → #296 localization effort). Duplicate symptom of #274, also closed. Closing.

spikerj closed this issue

2026-06-30 22:34:44 +00:00

spikerj referenced this issue

2026-06-30 22:36:12 +00:00

[Epic][Bug] Localize lesson code-template comments (Spanish) across all playgrounds #296

spikerj referenced this issue

2026-07-11 23:26:26 +00:00

Auditable blog post hide/remove for staff (two-tier moderation + immutable audit trail) #476

Sign in to join this conversation.