WiseLibs / better-sqlite3

The fastest and simplest library for SQLite3 in Node.js.
MIT License
5.26k stars 391 forks source link

Error with Different Package #1063

Closed M3rcena closed 9 months ago

M3rcena commented 10 months ago

Problem

I am trying to install weky-update package using npm and every time I run the npm i weky-update on terminal it tries to do something with better-sqlite3 which causes an error. They don't me to contact better-sqlite3 while the error is not from their side.

Error

C:\Users\micha\OneDrive\Υπολογιστής\Milrato Remake\Multipurpose-discord-bot>npm i weky-update
npm ERR! code 1
npm ERR! path C:\Users\micha\OneDrive\Υπολογιστής\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3
npm ERR! command failed
npm ERR! command C:\WINDOWS\system32\cmd.exe /d /s /c prebuild-install || npm run build-release
npm ERR! > better-sqlite3@7.6.2 build-release
npm ERR! > node-gyp rebuild --release
npm ERR!
npm ERR!
npm ERR!   copy_builtin_sqlite3
npm ERR!   sqlite3.c
npm ERR!   win_delay_load_hook.cc
npm ERR!   sqlite3.vcxproj -> C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\Release\\sqlite3.lib
npm ERR!   better_sqlite3.cpp
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\better_sqlite3.lzz(67,1): warning C4566: character represented by universal-character-name '\u03A5' cannot be represented in the current code page (1252) [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\better_sqlite3.lzz(67,1): warning C4566: character represented by universal-character-name '\u03C0' cannot be represented in the current code page (1252) [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\better_sqlite3.lzz(67,1): warning C4566: character represented by universal-character-name '\u03BF' cannot be represented in the current code page (1252) [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\better_sqlite3.lzz(67,1): warning C4566: character represented by universal-character-name '\u03BB' cannot be represented in the current code page (1252) [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\better_sqlite3.lzz(67,1): warning C4566: character represented by universal-character-name '\u03B3' cannot be represented in the current code page (1252) [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\better_sqlite3.lzz(67,1): warning C4566: character represented by universal-character-name '\u03B9' cannot be represented in the current code page (1252) [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\better_sqlite3.lzz(67,1): warning C4566: character represented by universal-character-name '\u03C3' cannot be represented in the current code page (1252) [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\better_sqlite3.lzz(67,1): warning C4566: character represented by universal-character-name '\u03C4' cannot be represented in the current code page (1252) [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\better_sqlite3.lzz(67,1): warning C4566: character represented by universal-character-name '\u03AE' cannot be represented in the current code page (1252) [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\better_sqlite3.lzz(67,1): warning C4566: character represented by universal-character-name '\u03C2' cannot be represented in the current code page (1252) [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\util\macros.lzz(157,21): error C2039: 'AccessorSignature': is not a member of 'v8' [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\AppData\Local\node-gyp\Cache\20.3.1\include\node\v8.h(71,11): message : see declaration of 'v8' [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\util\macros.lzz(157,21): error C3083: 'AccessorSignature': the symbol to the left of a '::' must be a type [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\util\macros.lzz(157,40): error C2039: 'New': is not a member of 'v8' [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\AppData\Local\node-gyp\Cache\20.3.1\include\node\v8.h(71,11): message : see declaration of 'v8' [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\util\macros.lzz(157,40): error C3861: 'New': identifier not found [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\src\util\binder.lzz(37,51): error C2039: 'CreationContext': is not a member of 'v8::Object' [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR! C:\Users\micha\AppData\Local\node-gyp\Cache\20.3.1\include\node\v8-value-serializer.h(22,7): message : see declaration of 'v8::Object' [C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\better_sqlite3.vcxproj]
npm ERR!   test_extension.c
npm ERR!   win_delay_load_hook.cc
npm ERR!      Creating library C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\Release\test_extension.lib and object C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\Release\test_extension.exp
npm ERR!   Generating code
npm ERR!   Previous IPDB not found, fall back to full compilation.
npm ERR!   All 3 functions were compiled because no usable IPDB/IOBJ from previous compilation was found.
npm ERR!   Finished generating code
npm ERR!   test_extension.vcxproj -> C:\Users\micha\OneDrive\?�?????��??\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3\build\Release\\test_extension.node
npm ERR! prebuild-install warn install No prebuilt binaries found (target=20.3.1 runtime=node arch=x64 libc= platform=win32)
npm ERR! gyp info it worked if it ends with ok
npm ERR! gyp info using node-gyp@9.3.1
npm ERR! gyp info using node@20.3.1 | win32 | x64
npm ERR! gyp info find Python using Python version 3.11.4 found at "C:\Users\micha\AppData\Local\Programs\Python\Python311\python.exe"
npm ERR! gyp info find VS using VS2022 (17.7.34024.191) found at:
npm ERR! gyp info find VS "C:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools"
npm ERR! gyp info find VS run with --verbose for detailed information
npm ERR! gyp info spawn C:\Users\micha\AppData\Local\Programs\Python\Python311\python.exe
npm ERR! gyp info spawn args [
npm ERR! gyp info spawn args   'C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\gyp\\gyp_main.py',npm ERR! gyp info spawn args   'binding.gyp',
npm ERR! gyp info spawn args   '-f',
npm ERR! gyp info spawn args   'msvs',
npm ERR! gyp info spawn args   '-I',
npm ERR! gyp info spawn args   'C:\\Users\\micha\\OneDrive\\Υπολογιστής\\Milrato Remake\\Multipurpose-discord-bot\\node_modules\\quick.db\\node_modules\\better-sqlite3\\build\\config.gypi',
npm ERR! gyp info spawn args   '-I',
npm ERR! gyp info spawn args   'C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\addon.gypi',
npm ERR! gyp info spawn args   '-I',
npm ERR! gyp info spawn args   'C:\\Users\\micha\\AppData\\Local\\node-gyp\\Cache\\20.3.1\\include\\node\\common.gypi',
npm ERR! gyp info spawn args   '-Dlibrary=shared_library',
npm ERR! gyp info spawn args   '-Dvisibility=default',
npm ERR! gyp info spawn args   '-Dnode_root_dir=C:\\Users\\micha\\AppData\\Local\\node-gyp\\Cache\\20.3.1',
npm ERR! gyp info spawn args   '-Dnode_gyp_dir=C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp',
npm ERR! gyp info spawn args   '-Dnode_lib_file=C:\\\\Users\\\\micha\\\\AppData\\\\Local\\\\node-gyp\\\\Cache\\\\20.3.1\\\\<(target_arch)\\\\node.lib',
npm ERR! gyp info spawn args   '-Dmodule_root_dir=C:\\Users\\micha\\OneDrive\\Υπολογιστής\\Milrato Remake\\Multipurpose-discord-bot\\node_modules\\quick.db\\node_modules\\better-sqlite3',
npm ERR! gyp info spawn args   '-Dnode_engine=v8',
npm ERR! gyp info spawn args   '--depth=.',
npm ERR! gyp info spawn args   '--no-parallel',
npm ERR! gyp info spawn args   '--generator-output',
npm ERR! gyp info spawn args   'C:\\Users\\micha\\OneDrive\\Υπολογιστής\\Milrato Remake\\Multipurpose-discord-bot\\node_modules\\quick.db\\node_modules\\better-sqlite3\\build',
npm ERR! gyp info spawn args   '-Goutput_dir=.'
npm ERR! gyp info spawn args ]
npm ERR! gyp info spawn C:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools\MSBuild\Current\Bin\MSBuild.exe
npm ERR! gyp info spawn args [
npm ERR! gyp info spawn args   'build/binding.sln',
npm ERR! gyp info spawn args   '/clp:Verbosity=minimal',
npm ERR! gyp info spawn args   '/nologo',
npm ERR! gyp info spawn args   '/p:Configuration=Release;Platform=x64'
npm ERR! gyp info spawn args ]
npm ERR! gyp ERR! build error
npm ERR! gyp ERR! stack Error: `C:\Program Files (x86)\Microsoft Visual Studio\2022\BuildTools\MSBuild\Current\Bin\MSBuild.exe` failed with exit code: 1
npm ERR! gyp ERR! stack     at ChildProcess.onExit (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\build.js:203:23)
npm ERR! gyp ERR! stack     at ChildProcess.emit (node:events:511:28)
npm ERR! gyp ERR! stack     at ChildProcess._handle.onexit (node:internal/child_process:293:12)
npm ERR! gyp ERR! System Windows_NT 10.0.19045
npm ERR! gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Program Files\\nodejs\\node_modules\\npm\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild" "--release"
npm ERR! gyp ERR! cwd C:\Users\micha\OneDrive\Υπολογιστής\Milrato Remake\Multipurpose-discord-bot\node_modules\quick.db\node_modules\better-sqlite3
npm ERR! gyp ERR! node -v v20.3.1
npm ERR! gyp ERR! node-gyp -v v9.3.1
npm ERR! gyp ERR! not ok
Prinzhorn commented 10 months ago

Probably the special characters in Υπολογιστής or the space in Milrato Remake which causes trouble with building (outside the control of better-sqlite3). If you upgrade to the latest better-sqlite3 (7.6.2 is old) this should not be an issue since it has prebuild for Node 20.

M3rcena commented 10 months ago

Probably the special characters in Υπολογιστής or the space in Milrato Remake which causes trouble with building (outside the control of better-sqlite3). If you upgrade to the latest better-sqlite3 (7.6.2 is old) this should not be an issue since it has prebuild for Node 20.

M3rcena commented 10 months ago

What else can I try?

Prinzhorn commented 10 months ago

Are you getting the same error with the renamed path? From what I can see weky-update is an outdated package that is no longer maintained so you're on your own.

M3rcena commented 10 months ago

Well the package itself doesn't use better-sqlite3 that why they told me to contact here. They are not responsible for the error. Also I am getting the same error.

Prinzhorn commented 10 months ago

What happens if you run npm install better-sqlite3 in a completely empty folder with no parent folder containing any node_modules? Does that install without any error? If so, then this is not an issue with better-sqlite3.

M3rcena commented 10 months ago

I can install better-sqlite3 package to any folder without error. Even the project I am trying to install the weky-update package the better-sqlite3 was installed already with version 8.6.0.

mceachen commented 9 months ago

Try installing the latest node 20 build, and make sure you click the checkbox that adds support for compiling native modules:

image

Also, this may help set up you box:

https://github.com/WiseLibs/better-sqlite3/blob/master/docs/troubleshooting.md

Closing as this isn't an issue with better-sqlite3, but a windows toolchain setup issue.