node-red-node-sqlite 'failed to open' error message.
- Dominant language
- JavaScript
- Stars
- 400
- Forks
- 89
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 146
Description
### Current Behavior
When deploying flow the message 'failed to open /home/tbg/db/aircraft.db' shows in debug tab.
When injecting select statement, no data is returned.
sqlite node shows green 'connected' status under node.
### Expected Behavior
When running the same select statement via command line, expected data is returned.
Installed Node-RED on same machine and select statement returns expected data.
Expected Flow Forge to return the expected data.
### Steps To Reproduce
Install fresh Flow Forge 1.7.0.
From Manage Pallet menu, install node-red-node-sqlite 1.0.3.
Create or copy existing sqlite.db file with known table structure to known path.
Configure db path in node.
Deploy.
Observe 'failed to open /home/tbg/db/aircraft.db' message in debug tab.
Inject select statement via inject node.
Observe no error message (or expected data) is shown in debug tab or Flow Forge log.
### Environment
- FlowForge version: 1.7.0
- Node.js version: 16.19.1
- npm version: 8.19.3
- Platform/OS: Ubuntu 22.04.1
- Browser: Firefox and Chrome both tested.
- Node-RED version: 3.0.2
### Have you provided an initial effort estimate for this issue?
I am not a FlowForge team member
Contributor guide
Assessment
This issue has not been assessed yet.