protected$namespace='App\\Http\\Controllers';//コメントアウトを解除/**
* Define your route model bindings, pattern filters, etc.
*
* @return void
*/publicfunctionboot(){$this->configureRateLimiting();$this->routes(function(){Route::prefix('api')->middleware('api')->namespace($this->namespace)->group(base_path('routes/api.php'));Route::middleware('web')->namespace($this->namespace)->group(base_path('routes/web.php'));});}
<?phpnamespaceApp\Http\Controllers;useIlluminate\Http\Request;classHelloControllerextendsController{publicfunctionmessage(){$msg='こんにちは';$title='this is title!';returnview('child',['hello'=>$msg,'title'=>$title]);}}
$ docker exec -it docker-sample_php-fpm_1 bash
root@39aae0ad8da6:/var/www/html# php artisan migrate
Illuminate\Database\QueryException
SQLSTATE[HY000]: General error: 1812 Tablespace is missing for table `laravel`.`migrations`. (SQL: select `migration` from `migrations` order by `batch` asc, `migration` asc)
at vendor/laravel/framework/src/Illuminate/Database/Connection.php:671
667| // If an exception occurs when attempting to run a query, we'll format the error
668| // message to include the bindings with SQL, which will make this exception a
669| // lot more helpful to the developer instead of just the database's errors.
670| catch (Exception $e) {
> 671| throw new QueryException(
672| $query, $this->prepareBindings($bindings), $e
673| );
674| }
675|
+27 vendor frames
28 artisan:37
Illuminate\Foundation\Console\Kernel::handle(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
が発生した。
備忘録として、メモしておく
何が起こったか？
出ているエラーをよくみてみると
Tablespace is missing for table `laravel`.`migrations`
と出ている。
dokcerのmysqlのコンテナーにログインして、テーブルを確認すると
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| laravel |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.01 sec)
mysql> use laravel;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+-------------------+
| Tables_in_laravel |
+-------------------+
| failed_jobs |
| migrations |
| password_resets |
| tasks |
| users |
+-------------------+
5 rows in set (0.00 sec)
migrationsテーブルは存在する。
migrationsテーブルの中身を見てみる。
mysql> select * from migrations;
ERROR 1812 (HY000): Tablespace is missing for table `laravel`.`migrations`.
