FlowFuse / FlowFuse/flowfuse

node-red-node-sqlite 'failed to open' error message.

Open
#2,154 6 comments 0 reactions 0 assignees View on GitHub
needs-triage
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.