SQLSTATE[HY000]: General error: 1 no such table: sessions

[enjiew]

Pre-work

• I have read the docs.
• I have searched open and closed issues.
• I agree to follow this project's Code of Conduct.

Description

I use the offical docker compose https://docs.speedtest-tracker.dev/getting-started/installation/using-docker-compose, and it shows like this pic, how to solve it? pls help me

Expected Behavior

it should be normal

Steps to Reproduce

I use the offical docker compose https://docs.speedtest-tracker.dev/getting-started/installation/using-docker-compose, and it shows like this pic, how to solve it? pls help me

Deployment Environment

Docker Compose

Application Information

docker compose

What browser(s) are you seeing the problem on?

chrome

Logs

[svenvg93]

Did you replace the placeholders for the volumes and added your APP_KEY?
Can you share the docker container logs and full compose file 😄

[enjiew]

Did you replace the placeholders for the volumes and added your APP_KEY? Can you share the docker container logs and full compose file 😄

full compose file：

### docker container logs:

2025/08/01 17:14:49 | stdout |  
2025/08/01 17:14:49 | stdout |  
2025/08/01 17:14:49 | stdout | SQLSTATE[HY000]: General error: 1 no such table: cache
2025/08/01 17:14:49 | stdout |  
2025/08/01 17:14:49 | stdout | In Connection.php line 406:
2025/08/01 17:14:49 | stdout |  
2025/08/01 17:14:49 | stdout |  
2025/08/01 17:14:49 | stdout | restart))
2025/08/01 17:14:49 | stdout | SQL: select * from "cache" where "key" in (laravel_cache_illuminate:queue:
2025/08/01 17:14:49 | stdout | SQLSTATE[HY000]: General error: 1 no such table: cache (Connection: sqlite,
2025/08/01 17:14:49 | stdout |  
2025/08/01 17:14:49 | stdout | In Connection.php line 824:
2025/08/01 17:14:49 | stdout |  
2025/08/01 17:14:49 | stderr | "}
2025/08/01 17:14:49 | stderr | #29 {main}
2025/08/01 17:14:49 | stderr | #28 /app/www/artisan(16): Illuminate\Foundation\Application->handleCommand()
2025/08/01 17:14:49 | stderr | #27 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Application.php(1234): Illuminate\Foundation\Console\Kernel->handle()
2025/08/01 17:14:49 | stderr | #26 /app/www/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(197): Symfony\Component\Console\Application->run()
2025/08/01 17:14:49 | stderr | #25 /app/www/vendor/symfony/console/Application.php(192): Symfony\Component\Console\Application->doRun()
2025/08/01 17:14:49 | stderr | #24 /app/www/vendor/symfony/console/Application.php(341): Symfony\Component\Console\Application->doRunCommand()
2025/08/01 17:14:49 | stderr | #23 /app/www/vendor/symfony/console/Application.php(1092): Illuminate\Console\Command->run()
2025/08/01 17:14:49 | stderr | #22 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\Component\Console\Command\Command->run()
2025/08/01 17:14:49 | stderr | #21 /app/www/vendor/symfony/console/Command/Command.php(318): Illuminate\Console\Command->execute()
2025/08/01 17:14:49 | stderr | #20 /app/www/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\Container\Container->call()
2025/08/01 17:14:49 | stderr | #19 /app/www/vendor/laravel/framework/src/Illuminate/Container/Container.php(780): Illuminate\Container\BoundMethod::call()
2025/08/01 17:14:49 | stderr | #18 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
2025/08/01 17:14:49 | stderr | #17 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(96): Illuminate\Container\Util::unwrapIfClosure()
2025/08/01 17:14:49 | stderr | #16 /app/www/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()
2025/08/01 17:14:49 | stderr | #15 /app/www/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Queue\Console\WorkCommand->handle()
2025/08/01 17:14:49 | stderr | #14 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(131): Illuminate\Queue\Console\WorkCommand->runWorker()
2025/08/01 17:14:49 | stderr | #13 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(148): Illuminate\Queue\Worker->daemon()
2025/08/01 17:14:49 | stderr | #12 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(139): Illuminate\Queue\Worker->getTimestampOfLastQueueRestart()
2025/08/01 17:14:49 | stderr | #11 /app/www/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(729): Illuminate\Cache\Repository->get()
2025/08/01 17:14:49 | stderr | #10 /app/www/vendor/laravel/framework/src/Illuminate/Cache/Repository.php(119): Illuminate\Cache\DatabaseStore->get()
2025/08/01 17:14:49 | stderr | #9 /app/www/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php(105): Illuminate\Cache\DatabaseStore->many()
2025/08/01 17:14:49 | stderr | #8 /app/www/vendor/laravel/framework/src/Illuminate/Cache/DatabaseStore.php(130): Illuminate\Database\Query\Builder->get()
2025/08/01 17:14:49 | stderr | #7 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3172): Illuminate\Database\Query\Builder->onceWithColumns()
2025/08/01 17:14:49 | stderr | #6 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3763): Illuminate\Database\Query\Builder->{closure:Illuminate\Database\Query\Builder::get():3172}()
2025/08/01 17:14:49 | stderr | #5 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3173): Illuminate\Database\Query\Builder->runSelect()
2025/08/01 17:14:49 | stderr | #4 /app/www/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3188): Illuminate\Database\Connection->select()
2025/08/01 17:14:49 | stderr | #3 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(397): Illuminate\Database\Connection->run()
2025/08/01 17:14:49 | stderr | #2 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(778): Illuminate\Database\Connection->runQueryCallback()
2025/08/01 17:14:49 | stderr | #1 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(811): Illuminate\Database\Connection->{closure:Illuminate\Database\Connection::select():397}()
2025/08/01 17:14:49 | stderr | #0 /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php(406): PDO->prepare()
2025/08/01 17:14:49 | stderr | [stacktrace]
2025/08/01 17:14:49 | stderr | [previous exception] [object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1 no such table: cache at /app/www/vendor/laravel/framework/src/Illuminate/Database/Connection.php:406)
2025/08/01 17:14:49 | stderr |  
2025/08/01 17:14:49 | stderr | #27 {main}

[svenvg93]

Can you run below on the shell of the container.

cd app/www
php artisan migrate:status

If the mirgation did not run you can try php artisan migrate. Then we can see why it failed.

[enjiew]

Can you run below on the shell of the container.

cd app/www
php artisan migrate:status

If the mirgation did not run you can try php artisan migrate. Then we can see why it failed.

### it shows like this：

and I restart the docker ：

and the web shows like this：

[alexjustesen]

If this is a fresh install stop the container, delete the db and restart the container. Also make sure your user id and group are correct.

[enjiew]

your user id and group are

it seems like my user id and group id is wrong，I change them to the actual No. from the default 1000, and now it works normal, thank u very much, appreciated ！

[svenvg93]

Glad you figured it out! If everything works as expected feel free to close the issue