[BUG] SQLite DB update script missing?

Anteus commented 1 month ago

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.

github-actions[bot] commented 1 month ago

Thanks for opening your first issue here! Be sure to follow the relevant issue templates, or risk having this issue marked as invalid.

LinuxServer-CI commented 2 days ago

This issue has been automatically marked as stale because it has not had recent activity. This might be due to missing feedback from OP. It will be closed if no further activity occurs. Thank you for your contributions.

linuxserver / docker-freshrss