learningequality / learningequality/studio
Channel description character limit (DB column width)
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 191
- Forks
- 307
- Avg merge
- 5d 6h
- Merged PRs (30d)
- 10
Description
Summary
Using varying(400) in Postgres means 400 unicode chars,
but https://sentry.io/learningequality/studio/issues/781062048/activity/
DataError - /api/internal/create_channel
value too long for type character varying(400)
Somehow the 400-char unicode string truncated by ricecooker ends up longer than 400 on Studio.
See https://learningequality.slack.com/archives/C0LK8QS9J/p1543358413395200
Category
Select one: BUG
How to reproduce
- Upload a ricecooker channel with description 400 chars in Arabic
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the Arabic 400-character description through the /api/internal/create_channel endpoint, then inspect the linked ricecooker truncation in ricecooker/classes/nodes.py and the Studio database handling. Done means the upload no longer raises PostgreSQL's character varying(400) DataError for a 400-character description.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql, python
- Domain
- api, backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 30/100