node-gyp error with building @vscode/sqlite3: binding.gyp not found

[ouliuquan]

Issue Summary

I remove all the node_gyp folder, and re-install nodejs, try anything command, the problem still, is it any way to find out what's wrong with my env?My repo have push to GitHub.

Also I have create an issue in node-gyp, but for now we still can't find out the problem. So I am here ask for your help. #nodejs/node-gyp#2732

Relevant logs or output

PS D:\Repos\testsqlite3> yarn node-gyp configure
yarn run v1.22.19
$ D:\Repos\testsqlite3\node_modules\.bin\node-gyp configure
gyp info it worked if it ends with ok
gyp info using node-gyp@9.1.0
gyp info using node@16.17.0 | win32 | x64
gyp info find Python using Python version 3.10.6 found at "D:\Program Files\Python310\python.exe"
gyp info find VS using VS2019 (16.11.32802.440) found at:
gyp info find VS "C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise"
gyp info find VS run with --verbose for detailed information
gyp info spawn D:\Program Files\Python310\python.exe
gyp info spawn args [
gyp info spawn args   'D:\\Repos\\testsqlite3\\node_modules\\node-gyp\\gyp\\gyp_main.py',
gyp info spawn args   'binding.gyp',
gyp info spawn args   '-f',
gyp info spawn args   'msvs',
gyp info spawn args   '-I',
gyp info spawn args   'D:\\Repos\\testsqlite3\\build\\config.gypi',
gyp info spawn args   '-I',
gyp info spawn args   'D:\\Repos\\testsqlite3\\node_modules\\node-gyp\\addon.gypi',
gyp info spawn args   '-I',
gyp info spawn args   'C:\\Users\\SmartOne\\AppData\\Local\\node-gyp\\Cache\\16.17.0\\include\\node\\common.gypi',
gyp info spawn args   '-Dlibrary=shared_library',
gyp info spawn args   '-Dvisibility=default',
gyp info spawn args   '-Dnode_root_dir=C:\\Users\\SmartOne\\AppData\\Local\\node-gyp\\Cache\\16.17.0',
gyp info spawn args   '-Dnode_gyp_dir=D:\\Repos\\testsqlite3\\node_modules\\node-gyp',
gyp info spawn args   '-Dnode_lib_file=C:\\\\Users\\\\SmartOne\\\\AppData\\\\Local\\\\node-gyp\\\\Cache\\\\16.17.0\\\\<(target_arch)\\\\node.lib',
gyp info spawn args   '-Dmodule_root_dir=D:\\Repos\\testsqlite3',
gyp info spawn args   '-Dnode_engine=v8',
gyp info spawn args   '--depth=.',
gyp info spawn args   '--no-parallel',
gyp info spawn args   '--generator-output',
gyp info spawn args   'D:\\Repos\\testsqlite3\\build',
gyp info spawn args   '-Goutput_dir=.'
gyp info spawn args ]
gyp: binding.gyp not found (cwd: D:\Repos\testsqlite3) while trying to load binding.gyp
gyp ERR! configure error 
gyp ERR! stack Error: `gyp` failed with exit code: 1
gyp ERR! stack     at ChildProcess.onCpExit (D:\Repos\testsqlite3\node_modules\node-gyp\lib\configure.js:284:16)
gyp ERR! stack     at ChildProcess.emit (node:events:513:28)
gyp ERR! stack     at Process.ChildProcess._handle.onexit (node:internal/child_process:291:12)
gyp ERR! System Windows_NT 10.0.22000
gyp ERR! command "D:\\Program\\nodejs\\node.exe" "D:\\Repos\\testsqlite3\\node_modules\\node-gyp\\bin\\node-gyp.js" "configure"
gyp ERR! cwd D:\Repos\testsqlite3
gyp ERR! node -v v16.17.0
gyp ERR! node-gyp -v v9.1.0
gyp ERR! not ok
error Command failed with exit code 1.
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.
PS D:\Repos\testsqlite3> 

Version

5.0.8

Node.js Version

v16.17.0

How did you install the library?

Windows 11 10.0.22000 Build 22000 x64

[daniellockyer]

Hey @ouliuquan 👋🏻 This repo is for sqlite3, not @vscode/sqlite3, which was a fork of this repo but they've since recommended to use this original version instead. Would you be able to try with the latest sqlite3?

[ouliuquan]

@daniellockyer Hi Daniel, I was building VSCode source got stuck by this question, @vscode/sqlite3 is used by VSCode's package.json, I follow the https://www.npmjs.com/package/@vscode/sqlite3 to find here.
I create this issue to solve the VSCode building problem, hope to find some help here.

[daniellockyer]

The VSCode fork comes here because it's a fork of this repo and the URL has not been updated.

This repo should build and run on most common systems 🙂

[ouliuquan]

@daniellockyer Hi, I have been known that @vscode/sqlite3 is not your repo, it's so sorry about this issue.
The truely repo is here https://github.com/microsoft/vscode-node-sqlite3, thanks for your patience

[daniellockyer]

No problem 🙂