docker-freshrss icon indicating copy to clipboard operation
docker-freshrss copied to clipboard

[BUG] SQLite DB update script missing?

Open Anteus opened this issue 9 months ago • 2 comments

Is there an existing issue for this?

  • [X] I have searched the existing issues

Current Behavior

Release notes on 1.24 mentions auto-update of database and that for SQLite it needs to be run manually but can't find the ./cli/db-backup.php files inside the docker image?

Auto-update PostgreSQL or MariaDB / MySQL databases for column details changes since FreshRSS 1.21.0 https://github.com/FreshRSS/FreshRSS/pull/6279 For SQLite, DB update require running ./cli/db-backup.php ; ./cli/db-restore.php --force-overwrite -https://github.com/FreshRSS/FreshRSS/releases/tag/1.24.0

Expected Behavior

No response

Steps To Reproduce

/app/www/cli# ls doesn't list db-backup.php

Environment

- OS: Raspberry PI OS
- How docker service was installed: apt install docker and then following the docker-compose guide

CPU architecture

arm64

Docker creation

1   │services:
   2   │   freshrss:
   3   │     image: lscr.io/linuxserver/freshrss:latest
   4   │     container_name: freshrss
   5   │     environment:
   6   │       - PUID=1000
   7   │       - PGID=1000
   8   │       - TZ=[...]
   9   │     volumes:
  10   │       - freshrss_data:/config
  11   │     ports:
  12   │       - 8081:80
  13   │     restart: unless-stopped
  28   │
  29   │ volumes:
  30   │   freshrss_data:
  31   │     external: true

Container logs

[migrations] started
[migrations] 01-nginx-site-confs-default: skipped
[migrations] 02-default-location: skipped
[migrations] done
───────────────────────────────────────

      ██╗     ███████╗██╗ ██████╗
      ██║     ██╔════╝██║██╔═══██╗
      ██║     ███████╗██║██║   ██║
      ██║     ╚════██║██║██║   ██║
      ███████╗███████║██║╚██████╔╝
      ╚══════╝╚══════╝╚═╝ ╚═════╝

   Brought to you by linuxserver.io
───────────────────────────────────────

To support LSIO projects visit:
https://www.linuxserver.io/donate/

───────────────────────────────────────
GID/UID
───────────────────────────────────────

User UID:    1000
User GID:    1000
───────────────────────────────────────

using keys found in /config/keys
**** The following active confs have different version dates than the samples that are shipped. ****
**** This may be due to user customization or an update to the samples. ****
**** You should compare the following files to the samples in the same folder and update them. ****
**** Use the link at the top of the file to view the changelog. ****
┌────────────┬────────────┬────────────────────────────────────────────────────────────────────────┐
│  old date  │  new date  │ path                                                                   │
├────────────┼────────────┼────────────────────────────────────────────────────────────────────────┤
│ 2022-08-20 │ 2024-03-06 │ /config/nginx/site-confs/default.conf                                  │
│ 2022-08-16 │ 2023-04-13 │ /config/nginx/nginx.conf                                               │
│ 2022-08-20 │ 2023-08-13 │ /config/nginx/ssl.conf                                                 │
└────────────┴────────────┴────────────────────────────────────────────────────────────────────────┘
[custom-init] No custom files found, skipping...
[ls.io-init] done.
[migrations] started
[migrations] 01-nginx-site-confs-default: skipped
[migrations] 02-default-location: skipped
[migrations] done
usermod: no changes
───────────────────────────────────────

      ██╗     ███████╗██╗ ██████╗
      ██║     ██╔════╝██║██╔═══██╗
      ██║     ███████╗██║██║   ██║
      ██║     ╚════██║██║██║   ██║
      ███████╗███████║██║╚██████╔╝
      ╚══════╝╚══════╝╚═╝ ╚═════╝

   Brought to you by linuxserver.io
───────────────────────────────────────

To support LSIO projects visit:
https://www.linuxserver.io/donate/

───────────────────────────────────────
GID/UID
───────────────────────────────────────

User UID:    1000
User GID:    1000
───────────────────────────────────────

using keys found in /config/keys
**** The following active confs have different version dates than the samples that are shipped. ****
**** This may be due to user customization or an update to the samples. ****
**** You should compare the following files to the samples in the same folder and update them. ****
**** Use the link at the top of the file to view the changelog. ****
┌────────────┬────────────┬────────────────────────────────────────────────────────────────────────┐
│  old date  │  new date  │ path                                                                   │
├────────────┼────────────┼────────────────────────────────────────────────────────────────────────┤
│ 2022-08-20 │ 2024-03-06 │ /config/nginx/site-confs/default.conf                                  │
│ 2022-08-16 │ 2023-04-13 │ /config/nginx/nginx.conf                                               │
│ 2022-08-20 │ 2023-08-13 │ /config/nginx/ssl.conf                                                 │
└────────────┴────────────┴────────────────────────────────────────────────────────────────────────┘
[custom-init] No custom files found, skipping...
[ls.io-init] done.

Anteus avatar May 24 '24 13:05 Anteus