spikerj/spikersoft-issues
1
0
Fork 0
Code Issues 196 Pull Requests Actions Packages Projects Releases Wiki Activity

# [Bug] Missing translations at SQL Playground #274

New Issue
Closed
opened 2026-06-27 17:06:20 +00:00 by enjin2310 · 1 comment
enjin2310 commented 2026-06-27 17:06:20 +00:00
Copy Link
Copy Source

Summary

Lesson content and instructional text in the SQL Playground remain in English when the platform language is set to Spanish.

Issue Description

The instructions section and lesson body within the SQL Playground are not localized. Despite the interface being set to Español, the instructional text continues to display in English. This creates inconsistency in the localized learning environment.

  • Affected Component: Lesson instructions and content in SQL Playground
  • Observed Behavior: English text displayed while UI elements are in Spanish
  • User Impact: Spanish-speaking users encounter mixed-language content
  • Visible Symptoms: English text under the “INSTRUCCIONES” heading

Environment

Property Value
Application SpikerSoft Learning Platform
Module SQL Playground
Environment Production
Browser Firefox
Operating System Windows 11
Version v2026.06.26a
Device Desktop PC

Preconditions

Platform language set to Español.

Steps to Reproduce

  1. Navigate to learn.spikersoft.com/tools/sql-playground.
  2. Switch the interface language to Español.
  3. Open lesson 60100 – SELECT * — todas las filas, todas las columnas.
  4. Observe the INSTRUCCIONES section.

Expected Result

All instructional and descriptive text should appear in Spanish, consistent with the selected language.

Actual Result

Instructional text remains in English despite the interface being localized to Spanish.

Evidence

  • Screenshot shows lesson “SELECT * — todas las filas, todas las columnas” with English instructions:
    • “Concept focus: apply this lesson’s SQL pattern first.”
    • “Write a query that returns every row from the travelers table.”
    • “Use * to ask for every column rather than naming them one at a time.”
  • Interface elements such as “Fuentes de datos”, “Enviar”, and “Nuevo intento” are correctly displayed in Spanish.

Impact

  • Localization inconsistency within lesson content.
  • Spanish-speaking users may struggle to follow instructions.
  • Reduces overall translation completeness and platform usability.

Frequency

Always

Reproducibility

100%

Severity

Medium

Notes

All environment details confirmed from screenshot. No additional anomalies observed.

## Summary Lesson content and instructional text in the SQL Playground remain in English when the platform language is set to Spanish. ## Issue Description The **instructions section** and **lesson body** within the SQL Playground are not localized. Despite the interface being set to **Español**, the instructional text continues to display in English. This creates inconsistency in the localized learning environment. - **Affected Component:** Lesson instructions and content in SQL Playground - **Observed Behavior:** English text displayed while UI elements are in Spanish - **User Impact:** Spanish-speaking users encounter mixed-language content - **Visible Symptoms:** English text under the “INSTRUCCIONES” heading ## Environment | Property | Value | |-----------|--------| | Application | SpikerSoft Learning Platform | | Module | SQL Playground | | Environment | Production | | Browser | Firefox | | Operating System | Windows 11 | | Version | v2026.06.26a | | Device | Desktop PC | ## Preconditions Platform language set to **Español**. ## Steps to Reproduce 1. Navigate to `learn.spikersoft.com/tools/sql-playground`. 2. Switch the interface language to **Español**. 3. Open lesson **60100 – SELECT * — todas las filas, todas las columnas**. 4. Observe the **INSTRUCCIONES** section. ## Expected Result All instructional and descriptive text should appear in Spanish, consistent with the selected language. ## Actual Result Instructional text remains in English despite the interface being localized to Spanish. ## Evidence - Screenshot shows lesson **“SELECT * — todas las filas, todas las columnas”** with English instructions: - “Concept focus: apply this lesson’s SQL pattern first.” - “Write a query that returns every row from the travelers table.” - “Use * to ask for every column rather than naming them one at a time.” - Interface elements such as **“Fuentes de datos”**, **“Enviar”**, and **“Nuevo intento”** are correctly displayed in Spanish. ## Impact - Localization inconsistency within lesson content. - Spanish-speaking users may struggle to follow instructions. - Reduces overall translation completeness and platform usability. ## Frequency Always ## Reproducibility 100% ## Severity Medium ## Notes All environment details confirmed from screenshot. No additional anomalies observed.
Screenshot 2026-06-27 130410.png
202 KiB
Screenshot 2026-06-27 130410.png
spikerj commented 2026-06-30 22:34:40 +00:00
Owner
Copy Link
Copy Source

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 text quoted 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). 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 text quoted 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). Closing.
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
agentic
Actionable surfaced by the agentic architecture & security review
 bug
Something is not working
 duplicate
This issue or pull request already exists
 enhancement
New feature
 help wanted
Need some help
 invalid
Something is wrong
 question
More information is needed
 sonarqube
Code quality issue surfaced by SonarQube (bug / code smell)
 wontfix
This won't be fixed
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
spikerj (Joseph Spiker)
No Assignees
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: spikerj/spikersoft-issues#274