# 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 * from CAM where (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
  • laravel

関連記事

Laravel timestamp() auto update 有効化無効化
正規表現一覧 よく使う検索・置換のパターン
Apache 初期設定メモ
codeigniter email ライブラリでメール送信 日本語対応
php 開発におけるコーディングルール・規約
php curl 使って クリックなしで POST 送信
php date 日付の日数・月数差を計算
PHP empty isset is_null の違い
php Exception エラーキャッチでメール送信
FlattenException deprecated
allowurlinclude の設定で ftp_connect()エラー
Laravel blade foreach loop と current url
Lumen と Laravel 違い比較
Laravel 5.7 の MVC 使う時のメモ
laravel session を制する
Laravel toSql パラメータ付きで出力
Lumen8 で JWT ユーザー認証
PHP 8 リリース新機能と変更
Lumen8 で API 開発
twig 3 人気 PHP テンプレートエンジンがバージョンアップ
開発時によく使うゼロ埋めパディング作業まとめ
解決!phpMyAdmin テーブル構造の内容が表示されない問題
Smarty HTTP URL 取得できるサーバー関数
nuxtjs と codeigniter で jwt システム構築
laravel に vuejs 使うための初期設定
Laravel 5.1 から 8.1 にバージョンアップ
PHP 7.4 にアップグレードして使えなくなる機能
HTML から PDF に変換 PHP ライブラリ mPDF の設定
php.ini 初期設定のいろいろ
爆速軽量フレームワーク codeigniter PHP 開発
Composer コマンドとオプション