Ghost installation fails before it creates folders

Developer help Installation
1

Hello,

I’ve been having a repeated problem with installing the latest versions of ghost on my self hosted pi server. I followed the guide exactly as it is written, but I always get the same error. Here is the output of the debug log:

Debug Information:
    OS: Ubuntu, v20.04.6 LTS
    Node Version: v16.20.0
    Ghost-CLI Version: 1.24.0
    Environment: production
    Command: 'ghost install'
Message: Command failed: yarn install --no-emoji --no-progress
warning ../../../package.json: No license field
warning ghost@5.49.0: The engine "cli" appears to be invalid.
warning Resolution field "@elastic/elasticsearch@8.5.0" is incompatible with requested version "@elastic/elasticsearch@8.6.0"
warning Resolution field "moment@2.24.0" is incompatible with requested version "moment@^2.29.1"
warning Resolution field "@tryghost/errors@1.2.24" is incompatible with requested version "@tryghost/errors@1.2.21"
warning Resolution field "@tryghost/errors@1.2.24" is incompatible with requested version "@tryghost/errors@^1.2.25"
warning Resolution field "moment@2.24.0" is incompatible with requested version "moment@2.29.1"
warning Resolution field "moment@2.24.0" is incompatible with requested version "moment@^2.27.0"
warning Resolution field "moment-timezone@0.5.23" is incompatible with requested version "moment-timezone@^0.5.31"
warning Resolution field "moment@2.24.0" is incompatible with requested version "moment@2.29.4"
warning Resolution field "moment@2.24.0" is incompatible with requested version "moment@2.29.4"
warning Resolution field "moment-timezone@0.5.23" is incompatible with requested version "moment-timezone@0.5.34"
warning Resolution field "@tryghost/errors@1.2.24" is incompatible with requested version "@tryghost/errors@1.2.21"
warning Resolution field "moment@2.24.0" is incompatible with requested version "moment@2.29.1"
warning Resolution field "moment@2.24.0" is incompatible with requested version "moment@2.29.3"
warning Resolution field "moment-timezone@0.5.23" is incompatible with requested version "moment-timezone@^0.5.33"
warning Resolution field "moment@2.24.0" is incompatible with requested version "moment@2.27.0"
warning Resolution field "@tryghost/errors@1.2.24" is incompatible with requested version "@tryghost/errors@1.2.25"
warning Resolution field "@tryghost/logging@2.4.4" is incompatible with requested version "@tryghost/logging@2.4.5"
warning Resolution field "@tryghost/logging@2.4.4" is incompatible with requested version "@tryghost/logging@^2.4.5"
warning Resolution field "@tryghost/errors@1.2.24" is incompatible with requested version "@tryghost/errors@1.2.25"
warning Resolution field "@tryghost/logging@2.4.4" is incompatible with requested version "@tryghost/logging@2.4.5"
warning Resolution field "moment@2.24.0" is incompatible with requested version "moment@^2.29.1"
warning "@tryghost/kg-lexical-html-renderer > @lexical/rich-text@0.10.0" has unmet peer dependency "@lexical/selection@0.10.0".
warning "@tryghost/kg-lexical-html-renderer > @lexical/rich-text@0.10.0" has unmet peer dependency "@lexical/utils@0.10.0".
warning " > bookshelf@1.2.0" has incorrect peer dependency "knex@>=0.15.0 <0.22.0".
warning Error running install script for optional dependency: "/var/www/gazette/versions/5.49.0/node_modules/sqlite3: Command failed.
Exit code: 1
Command: node-pre-gyp install --fallback-to-build
Arguments: 
Directory: /var/www/gazette/versions/5.49.0/node_modules/sqlite3
Output:
node-pre-gyp info it worked if it ends with ok
node-pre-gyp info using node-pre-gyp@1.0.10
node-pre-gyp info using node@16.20.0 | linux | arm
node-pre-gyp info check checked for \"/var/www/gazette/versions/5.49.0/node_modules/sqlite3/lib/binding/napi-v6-linux-glibc-arm/node_sqlite3.node\" (not found)
node-pre-gyp http GET https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.6/napi-v6-linux-glibc-arm.tar.gz
node-pre-gyp ERR! install response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.6/napi-v6-linux-glibc-arm.tar.gz 
node-pre-gyp WARN Pre-built binaries not installable for sqlite3@5.1.6 and node@16.20.0 (node-v93 ABI, glibc) (falling back to source compile with node-gyp) 
node-pre-gyp WARN Hit error response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.6/napi-v6-linux-glibc-arm.tar.gz
2

There are several warnings and your output, but just one error:

ERR! install response status 404 Not Found on https://github.com/TryGhost/node-sqlite3/releases/download/v5.1.6/napi-v6-linux-glibc-arm.tar.gz

The Ghost project has not packaged this package for the “arm” platform. Maybe if you manually compile/install the package into the same place that the installer would put it, it would see the step was already done, so not trigger this error and keep going.