Did you try, as @hardillb suggested, running
npm run rebuild
in the sqlite3 directory under the /opt/flowfuse-device/project/node_modules
@Colin I don't know if you meant me or the person who started the thread? I have not tried node-red-node-sqlite V2.0.0 on my Pi (Bookworm) because I can't afford to break it. I wasn't sure if the comment from @hardillb about running the npm run rebuild meant that it made V2.0.0 work or just that the rebuild completed.
@Colin @tonylane26 I also have not tried it yet... I have numerous devices in production and don't want to mess with it until I have more time... just sticking with v1.1.1 for now.
