CUAHSI / CUAHSI/HydroServerLite
WorldWater: need validation for new database name
- Dominant language
- PHP
- Stars
- 7
- Forks
- 6
- PR merge metrics
- No merged PRs in 30d
Description
jirikadlec2[CodePlex]
In worldwater.byu.edu when I create a new database and I have a space in the database name, for example quotTest Databasequot, I get an error message on the setup page:
Error creating database: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Database' at line 1
Error selecting the database Test DatabaseUnknown database 'Test Database'
This message is very unclear.
Suggestion: Add a validation for the new database name, only English letters and numbers should be allowed in the database name.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the setup-page database creation flow with a name containing a space, such as "Test Database", and locate the code that creates and selects the database. Add validation so names contain only English letters and numbers, then verify that invalid names receive a clear message and valid names complete setup without SQL errors.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php
- Domain
- backend, database
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100