# Need help - Cannot install palette SQLITE on v2.2.2 on ARMV6 (RPi)

**URL:** <https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213>\
**Category:** General\
**Created:** [29 May 2022 13:40 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213 "2022-05-29T13:40:03Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![championc](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/championc/32/39754_2.png) [@championc](https://discourse.nodered.org/u/championc)\
**Post date:** [29 May 2022 13:40 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/1 "2022-05-29T13:40:03Z")

</div>

Hi all,

I urgently need help. I have had Node-Red running perfectly for about a year. I suddenly got an issue with Aedes "Flows Stopped due to missing node types". I couldn't resolve and ended up now doing a full re-install. That was originally on v1.3.4

So I am now on v2.2.2 but every time I try to install node-red-node-sqlite, it eventually fails. Can anyone advise me as to how to get it installed. I managed to install node-red-contrib-sqlitedb, but the node-sqlite just will not install for me

```auto
2022-05-28T21:22:47.364Z Install : node-red-node-sqlite 1.0.3

2022-05-28T21:22:46.815Z npm install --no-audit --no-update-notifier --no-fund --save --save-prefix=~ --production --engine-strict node-red-node-sqlite@1.0.3
2022-05-28T21:25:57.469Z [out] 
2022-05-28T21:25:57.469Z [out] > sqlite3@5.0.8 install /home/pi/.node-red/node_modules/sqlite3
2022-05-28T21:25:57.469Z [out] > node-pre-gyp install --fallback-to-build
2022-05-28T21:25:57.469Z [out] 
2022-05-28T21:26:06.501Z [err] node-pre-gyp
2022-05-28T21:26:06.511Z [err] ERR! install response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.0.8/napi-v6-linux-glibc-arm.tar.gz 
2022-05-28T21:26:06.517Z [err] node-pre-gyp
2022-05-28T21:26:06.521Z [err]  
2022-05-28T21:26:06.531Z [err] WARN Pre-built binaries not installable for sqlite3@5.0.8 and node@14.19.1 (node-v83 ABI, glibc) (falling back to source compile with node-gyp) 
2022-05-28T21:26:06.531Z [err] node-pre-gyp WARN Hit error response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.0.8/napi-v6-linux-glibc-arm.tar.gz 
2022-05-28T21:26:39.622Z [out] make: Entering directory '/home/pi/.node-red/node_modules/sqlite3/build'
2022-05-28T21:26:39.643Z [out] CC(target) Release/obj.target/nothing/../node-addon-api/nothing.o
2022-05-28T21:26:41.268Z [out] AR(target) Release/obj.target/../node-addon-api/nothing.a
2022-05-28T21:26:41.409Z [out] COPY Release/nothing.a
2022-05-28T21:26:41.527Z [out] ACTION deps_sqlite3_gyp_action_before_build_target_unpack_sqlite_dep Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c
2022-05-28T21:26:48.665Z [out] TOUCH Release/obj.target/deps/action_before_build.stamp
2022-05-28T21:26:48.748Z [out] CC(target) Release/obj.target/sqlite3/gen/sqlite-autoconf-3380400/sqlite3.o
2022-05-28T21:26:51.606Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘sqlite3ResultStrAccum’:
2022-05-28T21:26:51.622Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:26:51.622Z [err] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:26:51.622Z [err] ^
2022-05-28T21:26:51.622Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:30530:51: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:26:51.622Z [err] sqlite3_result_text(pCtx, p->zText, p->nChar, SQLITE_DYNAMIC);
2022-05-28T21:26:51.622Z [err] ^ ~~~~~~~~~~~~~
2022-05-28T21:26:52.715Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘sqlite3ErrorWithMsg’:
2022-05-28T21:26:52.742Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:26:52.742Z [err] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:26:52.742Z [err] ^
2022-05-28T21:26:52.742Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:32763:54: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:26:52.742Z [err] sqlite3ValueSetStr(db->pErr, -1, z, SQLITE_UTF8, SQLITE_DYNAMIC);
2022-05-28T21:26:52.742Z [err] ^ ~~~~~~~~~~~~~
2022-05-28T21:27:12.458Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘sqlite3VdbeMemSetStr’:
2022-05-28T21:27:12.529Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:27:12.529Z [err] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:27:12.529Z [err] ^
2022-05-28T21:27:12.529Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:79018:15: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:27:12.529Z [err] if( xDel==SQLITE_DYNAMIC ){
2022-05-28T21:27:12.529Z [err] ^ ~~~~~~~~~~~~~
2022-05-28T21:27:12.816Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘valueFromExpr’:
2022-05-28T21:27:12.887Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:27:12.887Z [err] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:27:12.887Z [err] ^
2022-05-28T21:27:12.887Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:79430:55: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:27:12.887Z [err] sqlite3ValueSetStr(pVal, -1, zVal, SQLITE_UTF8, SQLITE_DYNAMIC);
2022-05-28T21:27:12.887Z [err] ^ ~~~~~~~~~~~~~
2022-05-28T21:27:13.170Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:27:13.170Z [err] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:27:13.170Z [err] ^
2022-05-28T21:27:13.170Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:79483:29: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:27:13.170Z [err] 0, SQLITE_DYNAMIC);
2022-05-28T21:27:13.170Z [err] ^ ~~~~~~~~~~~~~
2022-05-28T21:28:12.372Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘printfFunc’:
2022-05-28T21:28:12.489Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:28:12.489Z [err] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:28:12.489Z [err] ^
2022-05-28T21:28:12.489Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:121402:25: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:28:12.489Z [err] SQLITE_DYNAMIC);
2022-05-28T21:28:12.489Z [err] ^ ~~~~~~~~~~~~~
2022-05-28T21:28:14.600Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘quoteFunc’:
2022-05-28T21:28:14.716Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:28:14.716Z [err] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:28:14.716Z [err] ^
2022-05-28T21:28:14.716Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:122229:23: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:28:14.716Z [err] SQLITE_DYNAMIC);
2022-05-28T21:28:14.716Z [err] ^ ~~~~~~~~~~~~~
2022-05-28T21:28:36.852Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘sqlite3GenerateColumnNames’:
2022-05-28T21:28:36.984Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:28:36.984Z [err] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:28:36.984Z [err] ^
2022-05-28T21:28:36.984Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:136299:58: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:28:36.984Z [err] sqlite3VdbeSetColName(v, i, COLNAME_NAME, zName, SQLITE_DYNAMIC);
2022-05-28T21:28:36.984Z [err] ^ ~~~~~~~~~~~~~
2022-05-28T21:28:37.119Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:14524:27: warning: cast between incompatible function types from ‘void * (*)(sqlite3 *)’ {aka ‘void * (*)(struct sqlite3 *)’} to ‘void (*)(void *)’ [-Wcast-function-type]
2022-05-28T21:28:37.119Z [err] #define SQLITE_DYNAMIC ((sqlite3_destructor_type)sqlite3OomFault)
2022-05-28T21:28:37.119Z [err] ^
2022-05-28T21:28:37.119Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:136306:52: note: in expansion of macro ‘SQLITE_DYNAMIC’
2022-05-28T21:28:37.119Z [err] sqlite3VdbeSetColName(v, i, COLNAME_NAME, z, SQLITE_DYNAMIC);
2022-05-28T21:28:37.119Z [err] ^ ~~~~~~~~~~~~~
2022-05-28T21:32:32.446Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘cellArea’:
2022-05-28T21:32:32.643Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197997:22: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:32.643Z [err] case 5: area = p->aCoord[9].f - p->aCoord[8].f;
2022-05-28T21:32:32.643Z [err] ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:32.742Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197998:7: note: here
2022-05-28T21:32:32.742Z [err] case 4: area *= p->aCoord[7].f - p->aCoord[6].f;
2022-05-28T21:32:32.742Z [err] ^~~~
2022-05-28T21:32:32.936Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197998:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:32.936Z [err] case 4: area *= p->aCoord[7].f - p->aCoord[6].f;
2022-05-28T21:32:32.936Z [err] ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:33.036Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197999:7: note: here
2022-05-28T21:32:33.036Z [err] case 3: area *= p->aCoord[5].f - p->aCoord[4].f;
2022-05-28T21:32:33.036Z [err] ^~~~
2022-05-28T21:32:33.229Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197999:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:33.229Z [err] case 3: area *= p->aCoord[5].f - p->aCoord[4].f;
2022-05-28T21:32:33.229Z [err] ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:33.328Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198000:7: note: here
2022-05-28T21:32:33.328Z [err] case 2: area *= p->aCoord[3].f - p->aCoord[2].f;
2022-05-28T21:32:33.328Z [err] ^~~~
2022-05-28T21:32:33.524Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198000:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:33.524Z [err] case 2: area *= p->aCoord[3].f - p->aCoord[2].f;
2022-05-28T21:32:33.524Z [err] ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:33.624Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198001:7: note: here
2022-05-28T21:32:33.624Z [err] default: area *= p->aCoord[1].f - p->aCoord[0].f;
2022-05-28T21:32:33.624Z [err] ^ ~~~~~~
2022-05-28T21:32:33.727Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198007:22: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:33.727Z [err] case 5: area = (i64)p->aCoord[9].i - (i64)p->aCoord[8].i;
2022-05-28T21:32:33.727Z [err] ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:33.826Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198008:7: note: here
2022-05-28T21:32:33.826Z [err] case 4: area *= (i64)p->aCoord[7].i - (i64)p->aCoord[6].i;
2022-05-28T21:32:33.826Z [err] ^~~~
2022-05-28T21:32:34.019Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198008:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:34.019Z [err] case 4: area *= (i64)p->aCoord[7].i - (i64)p->aCoord[6].i;
2022-05-28T21:32:34.019Z [err] ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:34.119Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198009:7: note: here
2022-05-28T21:32:34.119Z [err] case 3: area *= (i64)p->aCoord[5].i - (i64)p->aCoord[4].i;
2022-05-28T21:32:34.119Z [err] ^~~~
2022-05-28T21:32:34.312Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198009:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:34.312Z [err] case 3: area *= (i64)p->aCoord[5].i - (i64)p->aCoord[4].i;
2022-05-28T21:32:34.312Z [err] ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:34.411Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198010:7: note: here
2022-05-28T21:32:34.411Z [err] case 2: area *= (i64)p->aCoord[3].i - (i64)p->aCoord[2].i;
2022-05-28T21:32:34.411Z [err] ^~~~
2022-05-28T21:32:34.607Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198010:21: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:34.607Z [err] case 2: area *= (i64)p->aCoord[3].i - (i64)p->aCoord[2].i;
2022-05-28T21:32:34.607Z [err] ~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2022-05-28T21:32:34.706Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:198011:7: note: here
2022-05-28T21:32:34.706Z [err] default: area *= (i64)p->aCoord[1].i - (i64)p->aCoord[0].i;
2022-05-28T21:32:34.706Z [err] ^ ~~~~~~
2022-05-28T21:32:34.861Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c: In function ‘rtreeCallbackConstraint’:
2022-05-28T21:32:35.052Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197136:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:35.052Z [err] readCoord(pCellData+32, &c); aCoord[8] = c.f;
2022-05-28T21:32:35.052Z [err] ~~~~~~~~~~^~~~~
2022-05-28T21:32:35.151Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197137:7: note: here
2022-05-28T21:32:35.151Z [err] case 8: readCoord(pCellData+28, &c); aCoord[7] = c.f;
2022-05-28T21:32:35.151Z [err] ^~~~
2022-05-28T21:32:35.251Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197138:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:35.251Z [err] readCoord(pCellData+24, &c); aCoord[6] = c.f;
2022-05-28T21:32:35.251Z [err] ~~~~~~~~~~^~~~~
2022-05-28T21:32:35.350Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197139:7: note: here
2022-05-28T21:32:35.350Z [err] case 6: readCoord(pCellData+20, &c); aCoord[5] = c.f;
2022-05-28T21:32:35.350Z [err] ^~~~
2022-05-28T21:32:35.449Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197140:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:35.449Z [err] readCoord(pCellData+16, &c); aCoord[4] = c.f;
2022-05-28T21:32:35.449Z [err] ~~~~~~~~~~^~~~~
2022-05-28T21:32:35.549Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197141:7: note: here
2022-05-28T21:32:35.549Z [err] case 4: readCoord(pCellData+12, &c); aCoord[3] = c.f;
2022-05-28T21:32:35.549Z [err] ^~~~
2022-05-28T21:32:35.650Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197142:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:35.650Z [err] readCoord(pCellData+8, &c); aCoord[2] = c.f;
2022-05-28T21:32:35.650Z [err] ~~~~~~~~~~^~~~~
2022-05-28T21:32:35.749Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197143:7: note: here
2022-05-28T21:32:35.749Z [err] default: readCoord(pCellData+4, &c); aCoord[1] = c.f;
2022-05-28T21:32:35.749Z [err] ^ ~~~~~~
2022-05-28T21:32:35.852Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197151:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:35.852Z [err] readCoord(pCellData+32, &c); aCoord[8] = c.i;
2022-05-28T21:32:35.852Z [err] ~~~~~~~~~~^~~~~
2022-05-28T21:32:35.951Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197152:7: note: here
2022-05-28T21:32:35.951Z [err] case 8: readCoord(pCellData+28, &c); aCoord[7] = c.i;
2022-05-28T21:32:35.951Z [err] ^~~~
2022-05-28T21:32:36.050Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197153:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:36.050Z [err] readCoord(pCellData+24, &c); aCoord[6] = c.i;
2022-05-28T21:32:36.050Z [err] ~~~~~~~~~~^~~~~
2022-05-28T21:32:36.149Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197154:7: note: here
2022-05-28T21:32:36.149Z [err] case 6: readCoord(pCellData+20, &c); aCoord[5] = c.i;
2022-05-28T21:32:36.149Z [err] ^~~~
2022-05-28T21:32:36.249Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197155:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:36.249Z [err] readCoord(pCellData+16, &c); aCoord[4] = c.i;
2022-05-28T21:32:36.249Z [err] ~~~~~~~~~~^~~~~
2022-05-28T21:32:36.348Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197156:7: note: here
2022-05-28T21:32:36.348Z [err] case 4: readCoord(pCellData+12, &c); aCoord[3] = c.i;
2022-05-28T21:32:36.348Z [err] ^~~~
2022-05-28T21:32:36.448Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197157:56: warning: this statement may fall through [-Wimplicit-fallthrough=]
2022-05-28T21:32:36.448Z [err] readCoord(pCellData+8, &c); aCoord[2] = c.i;
2022-05-28T21:32:36.448Z [err] ~~~~~~~~~~^~~~~
2022-05-28T21:32:36.547Z [err] Release/obj/gen/sqlite-autoconf-3380400/sqlite3.c:197158:7: note: here
2022-05-28T21:32:36.547Z [err] default: readCoord(pCellData+4, &c); aCoord[1] = c.i;
2022-05-28T21:32:36.547Z [err] ^ ~~~~~~
2022-05-29T05:22:45.788Z [err] cc: fatal error: Killed signal terminated program cc1
2022-05-29T05:22:45.788Z [err] compilation terminated.
2022-05-29T05:22:45.788Z [err] make: *** [deps/sqlite3.target.mk:141: Release/obj.target/sqlite3/gen/sqlite-autoconf-3380400/sqlite3.o] Error 1
2022-05-29T05:22:46.541Z [out] make: Leaving directory '/home/pi/.node-red/node_modules/sqlite3/build'
2022-05-29T05:22:48.240Z [err] gyp
2022-05-29T05:22:48.544Z [err]  
2022-05-29T05:22:48.580Z [err] ERR!
2022-05-29T05:22:48.679Z [err] build error 
2022-05-29T05:22:48.874Z [err] gyp
2022-05-29T05:22:48.911Z [err]  
2022-05-29T05:22:49.042Z [err] ERR! stack Error: `make` failed with exit code: 2
2022-05-29T05:22:49.042Z [err] gyp ERR! stack at ChildProcess.onExit (/usr/lib/node_modules/npm/node_modules/node-gyp/lib/build.js:194:23)
2022-05-29T05:22:49.042Z [err] gyp ERR! stack at ChildProcess.emit (events.js:400:28)
2022-05-29T05:22:49.042Z [err] gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:282:12)
2022-05-29T05:22:49.151Z [err] gyp
2022-05-29T05:22:49.189Z [err]  
2022-05-29T05:22:49.232Z [err] ERR! System Linux 5.10.103+
2022-05-29T05:22:49.232Z [err] gyp ERR! command "/usr/bin/node" "/usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js" "build" "--fallback-to-build" "--module=/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm" "--napi_version=8" "--node_abi_napi=napi" "--napi_build_version=6" "--node_napi_label=napi-v6"
2022-05-29T05:22:49.232Z [err] gyp ERR! cwd /home/pi/.node-red/node_modules/sqlite3
2022-05-29T05:22:49.232Z [err] gyp 
2022-05-29T05:22:49.259Z [err] ERR!
2022-05-29T05:22:49.309Z [err] node -v v14.19.1
2022-05-29T05:22:49.309Z [err] gyp ERR! node-gyp -v v5.1.0
2022-05-29T05:22:49.309Z [err] gyp ERR! not ok 
2022-05-29T05:22:49.892Z [err] node-pre-gyp
2022-05-29T05:22:49.920Z [err]  
2022-05-29T05:22:49.930Z [err] ERR!
2022-05-29T05:22:49.972Z [err] build error 
2022-05-29T05:22:49.989Z [err] node-pre-gyp
2022-05-29T05:22:50.039Z [err] ERR! stack Error: Failed to execute '/usr/bin/node /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm --napi_version=8 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1)
2022-05-29T05:22:50.039Z [err] node-pre-gyp ERR! stack at ChildProcess.<anonymous> (/home/pi/.node-red/node_modules/@mapbox/node-pre-gyp/lib/util/compile.js:89:23)
2022-05-29T05:22:50.039Z [err] node-pre-gyp ERR! stack at ChildProcess.emit (events.js:400:28)
2022-05-29T05:22:50.039Z [err] node-pre-gyp ERR! stack at maybeClose (internal/child_process.js:1058:16)
2022-05-29T05:22:50.039Z [err] node-pre-gyp ERR! stack at Process.ChildProcess._handle.onexit (internal/child_process.js:293:5)
2022-05-29T05:22:50.079Z [err] node-pre-gyp
2022-05-29T05:22:50.082Z [err]  
2022-05-29T05:22:50.130Z [err] ERR! System Linux 5.10.103+
2022-05-29T05:22:50.130Z [err] node-pre-gyp ERR! command "/usr/bin/node" "/home/pi/.node-red/node_modules/.bin/node-pre-gyp" "install" "--fallback-to-build"
2022-05-29T05:22:50.130Z [err] node-pre-gyp ERR! cwd
2022-05-29T05:22:50.169Z [err] /home/pi/.node-red/node_modules/sqlite3
2022-05-29T05:22:50.169Z [err] node-pre-gyp ERR! node -v v14.19.1
2022-05-29T05:22:50.198Z [err] node-pre-gyp ERR! node-pre-gyp -v v1.0.9
2022-05-29T05:22:50.198Z [err] node-pre-gyp
2022-05-29T05:22:50.240Z [err] ERR! not ok 
2022-05-29T05:22:50.329Z [out] Failed to execute '/usr/bin/node /usr/lib/node_modules/npm/node_modules/node-gyp/bin/node-gyp.js build --fallback-to-build --module=/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node --module_name=node_sqlite3 --module_path=/home/pi/.node-red/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm --napi_version=8 --node_abi_napi=napi --napi_build_version=6 --node_napi_label=napi-v6' (1)
2022-05-29T05:23:46.711Z [err] npm
2022-05-29T05:23:46.719Z [err] ERR! code ELIFECYCLE
2022-05-29T05:23:46.719Z [err] npm ERR! errno 1
2022-05-29T05:23:47.189Z [err] npm
2022-05-29T05:23:47.197Z [err] ERR! sqlite3@5.0.8 install: `node-pre-gyp install --fallback-to-build`
2022-05-29T05:23:47.197Z [err] npm ERR! Exit status 1
2022-05-29T05:23:47.197Z [err] npm ERR! 
2022-05-29T05:23:47.197Z [err] npm ERR!
2022-05-29T05:23:47.201Z [err] Failed at the sqlite3@5.0.8 install script.
2022-05-29T05:23:47.203Z [err] npm
2022-05-29T05:23:47.209Z [err] ERR! This is probably not a problem with npm. There is likely additional logging output above.
2022-05-29T05:23:47.620Z [err] 
2022-05-29T05:23:47.624Z [err] npm
2022-05-29T05:23:47.631Z [err] ERR! A complete log of this run can be found in:
2022-05-29T05:23:47.631Z [err] npm ERR!
2022-05-29T05:23:47.639Z [err] /home/pi/.npm/_logs/2022-05-29T05_23_47_541Z-debug.log
2022-05-29T05:23:47.739Z rc=1
```

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/4/242dc65043896ed81044c1ffd89ae6f3a4507564.png)

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [29 May 2022 13:55 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/2 "2022-05-29T13:55:30Z")

</div>

> [@championc](#):
>
> Flows Stopped due to missing node types

If you get that, you can restart node-red in safe mode and at least remove the offending nodes which will let you start everything else back up.

What version of Node.js are you running?

---

<div class="post-metadata">

**Author:** ![championc](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/championc/32/39754_2.png) [@championc](https://discourse.nodered.org/u/championc)\
**Post date:** [29 May 2022 14:00 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/3 "2022-05-29T14:00:50Z")

</div>

node.js version 14.19.1

npm version 6.14.16

I have a decent usage of saving data to the database, so I'm not really keen to blow away the stuff [yet] unless it actually led to resolution, which I believe it won't

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [29 May 2022 14:21 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/4 "2022-05-29T14:21:09Z")

</div>

You shouldn't throw away the DB, it is a separate file anyway so you can easily back it up.

My initial thought was that you were on an older version of node.js but clearly not so.

So just installed the node on both my Windows 10 dev pc and my live server (AMD rather than ARM though. I don't currently have a working ARM based server). Probably doesn't prove much I'm afraid since it clearly didn't trigger a build.

There are only 64bit ARM versions of that library unfortunately. Hence the need to compile. Do other npm packages that need compiling install successfully? Do you have build-tools installed?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [29 May 2022 14:37 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/5 "2022-05-29T14:37:56Z")

</div>

Try deleting `/home/pi/.node-red/node_modules` then running

```bash
cd /home/pi/.node-red
npm install

```

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [29 May 2022 14:58 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/6 "2022-05-29T14:58:14Z")

</div>

By the way the node-sqlite3 dependancy that the sqlite node depends on had a few important updates  
( fixing issues related to `node-gyp` and using prebuilt binaries )

> **[Releases · TryGhost/node-sqlite3](https://github.com/TryGhost/node-sqlite3/releases)**
>
> Asynchronous, non-blocking SQLite3 bindings for Node.js - TryGhost/node-sqlite3

We are currently on version 5.0.2

```auto
"dependencies": {
        "sqlite3": "^5.0.2"
    },

```

maybe worth updating to 5.0.8 ?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [29 May 2022 15:02 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/7 "2022-05-29T15:02:57Z")

</div>

`5.0.8` satisfies constraint `^5.0.2` so if you install `node-red-node-sqlite` then you will get `5.0.8` (or the latest 5.x.x)

---

<div class="post-metadata">

**Author:** ![UnborN](https://avatars.discourse-cdn.com/v4/letter/u/4491bb/32.png) [@UnborN](https://discourse.nodered.org/u/UnborN)\
**Post date:** [29 May 2022 15:05 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/8 "2022-05-29T15:05:57Z")

</div>

I see .. ofcourse .. its even there in the log 😇

```auto
2022-05-28T21:25:57.469Z [out] > sqlite3@5.0.8

```

---

<div class="post-metadata">

**Author:** ![championc](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/championc/32/39754_2.png) [@championc](https://discourse.nodered.org/u/championc)\
**Post date:** [29 May 2022 16:12 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/9 "2022-05-29T16:12:47Z")

</div>

> [@Steve-Mcl](#):
>
> Try deleting `/home/pi/.node-red/node_modules` then running
> 
> ```auto
> cd /home/pi/.node-red
> npm install
> 
> ```

Currently re-trying the sqlite install, which could take some time (giving much the same output as before. After running the above, I got the following

```auto

added 405 packages from 445 contributors and audited 405 packages in 665.649s

64 packages are looking for funding
  run `npm fund` for details

found 1 critical severity vulnerability
  run `npm audit fix` to fix them, or `npm audit` for details
```

after which I ran npm fund followed by npm audit fix and got

```auto
pi@solarpi:~/.node-red $ npm audit fix
up to date in 85.352s

64 packages are looking for funding
  run `npm fund` for details

fixed 0 of 1 vulnerability in 405 scanned packages
  1 vulnerability required manual review and could not be updated
pi@solarpi:~/.node-red $
```

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [29 May 2022 19:03 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/10 "2022-05-29T19:03:36Z")

</div>

> [@championc](#):
>
> npm audit fix

No!

Never a good idea and it is a pain that the npm folk thought that would ever be useful.

Ignore the audit messages unless you want to deliberately break things.

As for the fund messages, by all means do look at those if you are wanting to give some funding to authors 😀

---

<div class="post-metadata">

**Author:** ![championc](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/championc/32/39754_2.png) [@championc](https://discourse.nodered.org/u/championc)\
**Post date:** [29 May 2022 20:23 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/11 "2022-05-29T20:23:30Z")

</div>

Well the install process is STILL running. I haven't got an RC=0 or RC=1 yet - but I certainly expect RC=1

What can I do next ?

---

<div class="post-metadata">

**Author:** ![championc](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/championc/32/39754_2.png) [@championc](https://discourse.nodered.org/u/championc)\
**Post date:** [29 May 2022 22:48 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/12 "2022-05-29T22:48:51Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/0/50a30345d967e6c4f5298761128960adb4749545.png)

---

<div class="post-metadata">

**Author:** ![dynamicdave](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dynamicdave/32/96_2.png) [@dynamicdave](https://discourse.nodered.org/u/dynamicdave)\
**Post date:** [30 May 2022 10:33 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/13 "2022-05-30T10:33:03Z")

</div>

I had a very similar situation with sqlite a year ago.

I fixed it by doing..`cd /home/pi/.node-red` or wherever you have node-RED  
And then doing... `npm rebuild sqlite3`  
Note: It take ages to rebuild

---

<div class="post-metadata">

**Author:** ![championc](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/championc/32/39754_2.png) [@championc](https://discourse.nodered.org/u/championc)\
**Post date:** [30 May 2022 19:44 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/14 "2022-05-30T19:44:45Z")

</div>

Unfortunately, since sqlite won't install, then I cannot do a repair

So I then tried

```auto
npm install sqlite3
npm install sqlite
```

And then

```auto
pi@solarpi:~/.node-red $ npm install node-red-node-sqlite
+ node-red-node-sqlite@1.0.3
added 1 package from 1 contributor and audited 486 packages in 128.728s

68 packages are looking for funding
  run `npm fund` for details

found 1 critical severity vulnerability
  run `npm audit fix` to fix them, or `npm audit` for details
pi@solarpi:~/.node-red $ node-red-restart
Restarted Node-RED
pi@solarpi:~/.node-red $
```

And it appears to have done the trick

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [30 May 2022 20:26 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/15 "2022-05-30T20:26:52Z")

</div>

did you do a deploy and clear your browsers caches?

---

<div class="post-metadata">

**Author:** ![championc](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/championc/32/39754_2.png) [@championc](https://discourse.nodered.org/u/championc)\
**Post date:** [30 May 2022 21:04 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/16 "2022-05-30T21:04:47Z")

</div>

All sorted

A huge thanks to everyone who made suggestions and took time to contribute to resolve my issues. I hope that this thread may help someone else in a similar situation in the future.

I'd never have resolved this without all of your assistance - so thank you so much to all

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [13 June 2022 21:05 UTC](https://discourse.nodered.org/t/need-help-cannot-install-palette-sqlite-on-v2-2-2-on-armv6-rpi/63213/17 "2022-06-13T21:05:19Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.