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

[adekbadek]

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.

[jason10lee]

Fixed in #66 (9a377db08, 2026-05-28). bin/sites-add.sh now backtick-quotes the database name in the GRANT:

-ON $name.* TO '$MYSQL_USER'@'%' …
+ON `$name`.* TO '$MYSQL_USER'@'%' …

That's the line that produced the error here: unquoted, MariaDB read site-with-dashes as an expression rather than an identifier. The same commit quoted the surrounding mysqladmin create, chown and path arguments. n sites-add with a dashed name completes cleanly now, which I confirmed by running it rather than by reading the diff.

Not covered by that change: n:383 still interpolates the name unquoted into sh -c, one layer above this script, so the container's shell splits it before sites-add.sh sees it. n sites-add 'two words' creates a site called two. That's tracked separately as NPPM-3157 (https://linear.app/a8c/issue/NPPM-3157) — worth knowing before this is closed, since the dash case is fixed but names generally aren't safe yet.