wallabag / wallabag/docker

Database table missing (wallabag_internal_setting) when populating database

Open
#377 2 comments 1 reaction 0 assignees View on GitHub
Awaiting response
Dominant language
Shell
Stars
769
Forks
168
PR merge metrics
No merged PRs in 30d

Description

### Environment

* **Version**: 2.6.6
* **Installation**: Docker Image (latest)
* **PHP version**: 8.1.23 (provided by image)
* **OS**: Synology DSM
* **Database**: SQLite
* **Parameters**: see below
* **Env variables**: ``POPULATE_DATABASE='True'``

My app/config/parameters.yml is:

```
parameters:
database_driver: pdo_sqlite
database_host: 127.0.0.1
database_port: null
database_name: symfony
database_user: root
database_password: null
database_path: '%kernel.project_dir%/data/db/wallabag.sqlite'
database_table_prefix: wallabag_
database_socket: null
database_charset: utf8
domain_name: 'https://wallabag.mydomain.com'
server_name: 'Your wallabag instance'
mailer_dsn: 'smtp://127.0.0.1'
locale: de
secret: ovmpmAWXRCabNlMgzlzFXDYmCFfzGv
twofactor_sender: no-reply@wallabag.org
fosuser_registration: false
fosuser_confirmation: false
fos_oauth_server_access_token_lifetime: 3600
fos_oauth_server_refresh_token_lifetime: 1209600
from_email: no-reply@wallabag.org
rss_limit: 50
rabbitmq_host: localhost
rabbitmq_port: 5672
rabbitmq_user: guest
rabbitmq_password: guest
rabbitmq_prefetch_count: 10
redis_scheme: tcp
redis_host: wallabag-redis
redis_port: 6379
redis_path: null
redis_password: null
sentry_dsn: null
```

### What steps will reproduce the bug?

Whenever I start the container (with ``POPULATE_DATABASE='True'``) wallabag tables get generated and the database file is created (I mounted the ``/var/www/wallabag/data`` to a Docker volume to persist state).
However one table (``wallabag_internal_setting``) seems not to be created and the logs throws errors:

```
> bin/console cache:clear --no-warmup
[WARNING] Some commands could not be registered:
In ExceptionConverter.php line 52:

An exception occurred while executing a query: SQLSTATE[HY000]: General err
or: 1 no such table: wallabag_internal_setting

In Exception.php line 28:

SQLSTATE[HY000]: General error: 1 no such table: wallabag_internal_setting
```

### Already tried solutions

I already tried to run migrations for the database manually after the container startup by ``exec``-ing into the container and running
1. ``/var/www/wallabag/bin/console wallabag:install --env=prod --no-interaction`` or
2. ``/var/www/wallabag/bin/console doctrine:migrations:migrate --env=prod --no-interaction``

However this also leads to the already above mentioned error with the ``wallabag_internal_setting`` table as seen in the following screenshot:

![CleanShot 2023-09-11 at 16 09 13@2x](https://github.com/wallabag/wallabag/assets/28538704/32641116-239b-42bf-bc25-b71ce7be2dca)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.