CUAHSI / CUAHSI/HydroServerLite

WorldWater: need validation for new database name

Open
#55 0 comments 0 reactions 0 assignees View on GitHub
CodePlex
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.