Automattic / Automattic/newspack-workspace

Can't add a site if there is a dash in the title

Open Beginner friendly
#35 1 comment 1 reaction 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.