node-red-node-sqlite - DB filename doesn't support underscore
baxerus opened this issue · 3 comments
Which node are you reporting an issue on?
node-red-node-sqlite
What are the steps to reproduce?
- Configure a new database with an underscore in the name (I tried
/data/sqlite/dwd_mosmix
) - Try a
CREATE TABLE
statement - Nothing happens
- Change filename to something without underscore (I changed to
/data/sqlite/dwd-mosmix
) - Retry step 2
- File gets created. Everything is working fine
What happens?
Nothing. No file appearing in the filesystem
What do you expect to happen?
Also file names with underscore do work.
But even more important help the user understand and prevent the issue!
By either a check on the input field that prevent not allowed chars (if there is a reason for this) or at least by throwing an error on the failed CREATE
statement (other non-functional commands also show errors in the debug log)
Please tell us about your environment:
- Node-RED version: v3.1.0
- node.js version: ?
- npm version: ?
- Platform/OS: Docker container from hub.docker.com
nodered/node-red@sha256:cf9749f31fdaee0a87a27aebf97ef6c051e1b6e77f021806f876055ae8d0b4c8
- Browser: Chrome
Did you create the /data/sqlite
directory first and is it fully rwx
by the node-red
user in the container (uid 1000 iirc)
I tried again and now I also can not reproduce the issue (I could before opening this issue. Opening issues is to much effort to not retrying multiple times before).
I'm sorry and closing this issue.