#Laravel Error についてのメモ

#laravel error SQLSTATE[HY000][2002] No such file or directory (2002)

Illuminate \ Database \ QueryException (2002)
SQLSTATE[HY000][2002] No such file or directory (SQL: select * fromCAMwhere (domain= cam.com) limit 1)
Previous exceptions
SQLSTATE[HY000][2002] No such file or directory (2002)

グーグル先生は、いろんな対応教えてくれました。

#DB_HOST=127.0.0.1 に変更

この回答はちゃんと理由つけているので、信用できそうですが、結果は残念でした。

#127.0.01 から mysql に変更

この回答を見た限り微妙ですが、試したところ今度のエラー解消になりませんでした。

#色々みてやはり.env ファイルが原因見たい

再チェックでわかりました。

DB_HOST=ocalhost

DB_HOST がおかしかった。

因みに、変更してもエラーが最初直らなかったけど、

php artisan config:clear

でキャッシュクリアすると、すぐに解消しました。

#Error: Can't find Python executable "python", you can set the PYTHON env variable.

GW 連休明けにもともと動いたものが動かなくなった。
npm run watch してテストしていましたが、エラー出現

$ npm i

> node-sass@4.11.0 install C:\Users\ユーザー名\Desktop\laravel\node_modules\node-sass
> node scripts/install.js

Downloading binary from https://github.com/sass/node-sass/releases/download/v4.11.0/win32-x64-72_binding.node
Cannot download "https://github.com/sass/node-sass/releases/download/v4.11.0/win32-x64-72_binding.node":

HTTP error 404 Not Found

Hint: If github.com is not accessible in your location
      try setting a proxy via HTTP_PROXY, e.g.

      export HTTP_PROXY=http://example.com:1234

or configure npm proxy via

      npm config set proxy http://example.com:8080

> node-sass@4.11.0 postinstall C:\Users\ユーザー名\Desktop\laravel\node_modules\node-sass
> node scripts/build.js

Building: C:\Program Files\nodejs\node.exe C:\Users\ユーザー名\Desktop\laravel\node_modules\node-gyp\bin\node-gyp.js rebuild --verbose --libsass_ext= --libsass_cflags= --libsass_ldflags= --libsass_library=
gyp info it worked if it ends with ok
gyp verb cli [
gyp verb cli   'C:\\Program Files\\nodejs\\node.exe',
gyp verb cli   'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\node-gyp\\bin\\node-gyp.js',
gyp verb cli   'rebuild',
gyp verb cli   '--verbose',
gyp verb cli   '--libsass_ext=',
gyp verb cli   '--libsass_cflags=',
gyp verb cli   '--libsass_ldflags=',
gyp verb cli   '--libsass_library='
gyp verb cli ]
gyp info using node-gyp@3.8.0
gyp info using node@12.0.0 | win32 | x64
gyp verb command rebuild []
gyp verb command clean []
gyp verb clean removing "build" directory
gyp verb command configure []
gyp verb check python checking for Python executable "python2" in the PATH
gyp verb `which` failed Error: not found: python2
gyp verb `which` failed     at getNotFoundError (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:13:12)
gyp verb `which` failed     at F (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:68:19)
gyp verb `which` failed     at E (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:80:29)
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:89:16
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\index.js:42:5
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\windows.js:36:5
gyp verb `which` failed     at FSReqCallback.oncomplete (fs.js:166:21)
gyp verb `which` failed  python2 Error: not found: python2
gyp verb `which` failed     at getNotFoundError (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:13:12)
gyp verb `which` failed     at F (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:68:19)
gyp verb `which` failed     at E (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:80:29)
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:89:16
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\index.js:42:5
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\windows.js:36:5
gyp verb `which` failed     at FSReqCallback.oncomplete (fs.js:166:21) {
gyp verb `which` failed   stack: 'Error: not found: python2\n    at getNotFoundError ' +
gyp verb `which` failed     '(C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:13:12)\n' +
gyp verb `which` failed     '    at F ' +
gyp verb `which` failed     '(C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:68:19)\n' +
gyp verb `which` failed     '    at E ' +
gyp verb `which` failed     '(C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:80:29)\n' +
gyp verb `which` failed     '    at ' +
gyp verb `which` failed     'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:89:16\n  ' +
gyp verb `which` failed     '  at ' +
gyp verb `which` failed     'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\isexe\\index.js:42:5\n   ' +
gyp verb `which` failed     ' at ' +
gyp verb `which` failed     'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\isexe\\windows.js:36:5\n ' +
gyp verb `which` failed     '   at FSReqCallback.oncomplete (fs.js:166:21)',
gyp verb `which` failed   code: 'ENOENT'
gyp verb `which` failed }
gyp verb check python checking for Python executable "python" in the PATH
gyp verb `which` failed Error: not found: python
gyp verb `which` failed     at getNotFoundError (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:13:12)
gyp verb `which` failed     at F (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:68:19)
gyp verb `which` failed     at E (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:80:29)
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:89:16
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\index.js:42:5
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\windows.js:36:5
gyp verb `which` failed     at FSReqCallback.oncomplete (fs.js:166:21)
gyp verb `which` failed  python Error: not found: python
gyp verb `which` failed     at getNotFoundError (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:13:12)
gyp verb `which` failed     at F (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:68:19)
gyp verb `which` failed     at E (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:80:29)
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:89:16
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\index.js:42:5
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\windows.js:36:5
gyp verb `which` failed     at FSReqCallback.oncomplete (fs.js:166:21) {
gyp verb `which` failed   stack: 'Error: not found: python\n    at getNotFoundError ' +
gyp verb `which` failed     '(C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:13:12)\n' +
gyp verb `which` failed     '    at F ' +
gyp verb `which` failed     '(C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:68:19)\n' +
gyp verb `which` failed     '    at E ' +
gyp verb `which` failed     '(C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:80:29)\n' +
gyp verb `which` failed     '    at ' +
gyp verb `which` failed     'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:89:16\n  ' +
gyp verb `which` failed     '  at ' +
gyp verb `which` failed     'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\isexe\\index.js:42:5\n   ' +
gyp verb `which` failed     ' at ' +
gyp verb `which` failed     'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\isexe\\windows.js:36:5\n ' +
gyp verb `which` failed     '   at FSReqCallback.oncomplete (fs.js:166:21)',
gyp verb `which` failed   code: 'ENOENT'
gyp verb `which` failed }
gyp verb could not find "python". checking python launcher
gyp verb could not find "python". guessing location
gyp verb ensuring that file exists: C:\Python27\python.exe
gyp ERR! configure error
gyp ERR! stack Error: Can't find Python executable "python", you can set the PYTHON env variable.
gyp ERR! stack     at PythonFinder.failNoPython (C:\Users\ユーザー名\Desktop\laravel\node_modules\node-gyp\lib\configure.js:484:19)
gyp ERR! stack     at PythonFinder.<anonymous> (C:\Users\ユーザー名\Desktop\laravel\node_modules\node-gyp\lib\configure.js:509:16)
gyp ERR! stack     at C:\Users\ユーザー名\Desktop\laravel\node_modules\graceful-fs\polyfills.js:282:31
gyp ERR! stack     at FSReqCallback.oncomplete (fs.js:166:21)
gyp ERR! System Windows_NT 10.0.17763
gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild" "--verbose" "--libsass_ext=" "--libsass_cflags=" "--libsass_ldflags=" "--libsass_library="
gyp ERR! cwd C:\Users\ユーザー名\Desktop\laravel\node_modules\node-sass
gyp ERR! node -v v12.0.0
gyp ERR! node-gyp -v v3.8.0
gyp ERR! not ok
Build failed with error code: 1
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: fsevents@1.2.7 (node_modules\fsevents):
npm WARN notsup SKIPPING OPTIONAL DEPENDENCY: Unsupported platform for fsevents@1.2.7: wanted {"os":"darwin","arch":"any"} (current: {"os":"win32","arch":"x64"})

npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! node-sass@4.11.0 postinstall: `node scripts/build.js`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the node-sass@4.11.0 postinstall script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\ユーザー名\AppData\Roaming\npm-cache\_logs\2019-05-07T03_54_47_087Z-debug.log
$ npm i

> node-sass@4.11.0 install C:\Users\ユーザー名\Desktop\laravel\node_modules\node-sass
> node scripts/install.js

Downloading binary from https://github.com/sass/node-sass/releases/download/v4.11.0/win32-x64-72_binding.node
Cannot download "https://github.com/sass/node-sass/releases/download/v4.11.0/win32-x64-72_binding.node":

HTTP error 404 Not Found

Hint: If github.com is not accessible in your location
      try setting a proxy via HTTP_PROXY, e.g.

      export HTTP_PROXY=http://example.com:1234

or configure npm proxy via

      npm config set proxy http://example.com:8080

> node-sass@4.11.0 postinstall C:\Users\ユーザー名\Desktop\laravel\node_modules\node-sass
> node scripts/build.js

Building: C:\Program Files\nodejs\node.exe C:\Users\ユーザー名\Desktop\laravel\node_modules\node-gyp\bin\node-gyp.js rebuild --verbose --libsass_ext= --libsass_cflags= --libsass_ldflags= --libsass_library=
gyp info it worked if it ends with ok
gyp verb cli [
gyp verb cli   'C:\\Program Files\\nodejs\\node.exe',
gyp verb cli   'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\node-gyp\\bin\\node-gyp.js',
gyp verb cli   'rebuild',
gyp verb cli   '--verbose',
gyp verb cli   '--libsass_ext=',
gyp verb cli   '--libsass_cflags=',
gyp verb cli   '--libsass_ldflags=',
gyp verb cli   '--libsass_library='
gyp verb cli ]
gyp info using node-gyp@3.8.0
gyp info using node@12.0.0 | win32 | x64
gyp verb command rebuild []
gyp verb command clean []
gyp verb clean removing "build" directory
gyp verb command configure []
gyp verb check python checking for Python executable "python2" in the PATH
gyp verb `which` failed Error: not found: python2
gyp verb `which` failed     at getNotFoundError (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:13:12)
gyp verb `which` failed     at F (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:68:19)
gyp verb `which` failed     at E (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:80:29)
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:89:16
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\index.js:42:5
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\windows.js:36:5
gyp verb `which` failed     at FSReqCallback.oncomplete (fs.js:166:21)
gyp verb `which` failed  python2 Error: not found: python2
gyp verb `which` failed     at getNotFoundError (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:13:12)
gyp verb `which` failed     at F (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:68:19)
gyp verb `which` failed     at E (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:80:29)
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:89:16
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\index.js:42:5
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\windows.js:36:5
gyp verb `which` failed     at FSReqCallback.oncomplete (fs.js:166:21) {
gyp verb `which` failed   stack: 'Error: not found: python2\n    at getNotFoundError ' +
gyp verb `which` failed     '(C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:13:12)\n' +
gyp verb `which` failed     '    at F ' +
gyp verb `which` failed     '(C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:68:19)\n' +
gyp verb `which` failed     '    at E ' +
gyp verb `which` failed     '(C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:80:29)\n' +
gyp verb `which` failed     '    at ' +
gyp verb `which` failed     'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:89:16\n  ' +
gyp verb `which` failed     '  at ' +
gyp verb `which` failed     'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\isexe\\index.js:42:5\n   ' +
gyp verb `which` failed     ' at ' +
gyp verb `which` failed     'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\isexe\\windows.js:36:5\n ' +
gyp verb `which` failed     '   at FSReqCallback.oncomplete (fs.js:166:21)',
gyp verb `which` failed   code: 'ENOENT'
gyp verb `which` failed }
gyp verb check python checking for Python executable "python" in the PATH
gyp verb `which` failed Error: not found: python
gyp verb `which` failed     at getNotFoundError (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:13:12)
gyp verb `which` failed     at F (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:68:19)
gyp verb `which` failed     at E (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:80:29)
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:89:16
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\index.js:42:5
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\windows.js:36:5
gyp verb `which` failed     at FSReqCallback.oncomplete (fs.js:166:21)
gyp verb `which` failed  python Error: not found: python
gyp verb `which` failed     at getNotFoundError (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:13:12)
gyp verb `which` failed     at F (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:68:19)
gyp verb `which` failed     at E (C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:80:29)
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\which\which.js:89:16
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\index.js:42:5
gyp verb `which` failed     at C:\Users\ユーザー名\Desktop\laravel\node_modules\isexe\windows.js:36:5
gyp verb `which` failed     at FSReqCallback.oncomplete (fs.js:166:21) {
gyp verb `which` failed   stack: 'Error: not found: python\n    at getNotFoundError ' +
gyp verb `which` failed     '(C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:13:12)\n' +
gyp verb `which` failed     '    at F ' +
gyp verb `which` failed     '(C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:68:19)\n' +
gyp verb `which` failed     '    at E ' +
gyp verb `which` failed     '(C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:80:29)\n' +
gyp verb `which` failed     '    at ' +
gyp verb `which` failed     'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\which\\which.js:89:16\n  ' +
gyp verb `which` failed     '  at ' +
gyp verb `which` failed     'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\isexe\\index.js:42:5\n   ' +
gyp verb `which` failed     ' at ' +
gyp verb `which` failed     'C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\isexe\\windows.js:36:5\n ' +
gyp verb `which` failed     '   at FSReqCallback.oncomplete (fs.js:166:21)',
gyp verb `which` failed   code: 'ENOENT'
gyp verb `which` failed }
gyp verb could not find "python". checking python launcher
gyp verb could not find "python". guessing location
gyp verb ensuring that file exists: C:\Python27\python.exe
gyp ERR! configure error
gyp ERR! stack Error: Can't find Python executable "python", you can set the PYTHON env variable.
gyp ERR! stack     at PythonFinder.failNoPython (C:\Users\ユーザー名\Desktop\laravel\node_modules\node-gyp\lib\configure.js:484:19)
gyp ERR! stack     at PythonFinder.<anonymous> (C:\Users\ユーザー名\Desktop\laravel\node_modules\node-gyp\lib\configure.js:509:16)
gyp ERR! stack     at C:\Users\ユーザー名\Desktop\laravel\node_modules\graceful-fs\polyfills.js:282:31
gyp ERR! stack     at FSReqCallback.oncomplete (fs.js:166:21)
gyp ERR! System Windows_NT 10.0.17763
gyp ERR! command "C:\\Program Files\\nodejs\\node.exe" "C:\\Users\\ユーザー名\\Desktop\\laravel\\node_modules\\node-gyp\\bin\\node-gyp.js" "rebuild" "--verbose" "--libsass_ext=" "--libsass_cflags=" "--libsass_ldflags=" "--libsass_library="
gyp ERR! cwd C:\Users\ユーザー名\Desktop\laravel\node_modules\node-sass
gyp ERR! node -v v12.0.0
gyp ERR! node-gyp -v v3.8.0
gyp ERR! not ok
Build failed with error code: 1
npm WARN optional SKIPPING OPTIONAL DEPENDENCY: fsevents@1.2.7 (node_modules\fsevents):
npm WARN notsup SKIPPING OPTIONAL DEPENDENCY: Unsupported platform for fsevents@1.2.7: wanted {"os":"darwin","arch":"any"} (current: {"os":"win32","arch":"x64"})

npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! node-sass@4.11.0 postinstall: `node scripts/build.js`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the node-sass@4.11.0 postinstall script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\ユーザー名\AppData\Roaming\npm-cache\_logs\2019-05-07T03_54_47_087Z-debug.log

#対応 1

npm install --global --production windows-build-tools

#結果

エラーのまま

#対応 2

新規作成してみる

laravel new test

#結果 2

エラーのまま

#もしかしたら nodejs?

休み前に nodejs のバージョンを 10 から 12 にアップグレードしたので、犯人は。。。
nodejs バージョン戻し

#結果 3

行けました

#結論

不安定のバージョンは適当にアップしてはいけない
nodejs の問題でした。

2019-06-01
  • php

関連記事

twig 3 人気 PHP テンプレートエンジンがバージョンアップ
php curl 使って クリックなしで POST 送信
allowurlinclude の設定で ftp_connect()エラー
Lumen と Laravel 違い比較
Laravel5.7 の MVC 使う時のメモ
php 開発におけるルール・規約
PHP 7.4 にアップグレードして使えなくなる機能
解決!phpMyAdmin テーブル構造の内容が表示されない問題
正規表現一覧 よく使う検索・置換のパターン
開発時によく使うゼロ埋めパディング作業まとめ
知ってるようで知らなかった composer のコマンドとオプションの世界
Laravel 5.1 から 8.1 にバージョンアップ
laravel vuejs 初期設定
HTML から PDF に変換 PHP ライブラリ mPDF の設定
nuxtjs と codeigniter で jwt システム構築
爆速・軽量フレームワーク codeigniter PHP 開発