Automattic / Automattic/newspack-workspace
Can't add a site if there is a dash in the title
- Dominant language
- PHP
- Stars
- 22
- Forks
- 18
- Avg merge
- 2d 23h
- Merged PRs (30d)
- 131
Description
`n sites-add site-with-dashes` errors out with `ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-with-dashes.* TO 'wordpress'@'%' IDENTIFIED BY 'wordpress' WITH GRANT OPTION' at line 1`
This is not a huge nuisance, but still not desired.
Contributor guide
Research direction
Start by reproducing `n sites-add site-with-dashes` and inspect the SQL generated by that command, using the MariaDB error to locate the failing database-name handling. Done means a site title containing dashes is added successfully without the SQL syntax error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mariadb, php
- Domain
- cli, databases
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Active
- Clarity
- Mostly clear
- Newbie friendliness
- 67/100