no such table: main.gravity

[TungstenE2]

This is a: FILL ME IN

Just updated to Docker Tag [2024.07.0]

When I Update Gravity I've this error message:

[i] Building tree... [✗] Unable to build gravity tree in /etc/pihole/gravity.db_temp Error: in prepare, no such table: main.gravity [✗] Unable to create database. Please contact support.

How to run pihole -r command on docker on Synology?

Details

Related Issues

• [ ] I have searched this repository/Pi-hole forums for existing issues and pull requests that look similar

https://github.com/pi-hole/pi-hole/issues/5006

How to reproduce the issue

Steps to reproduce the behavior:

Go to 'Tools'
Click on 'Update Gravity'
Click on 'Update'
Wait untill the end of process

1. Environment data

• Operating System: ENTER HERE
• Hardware:
• Kernel Architecture:
• Docker Install Info and version:
  • Software source:
  • Supplimentary Software:
• Hardware architecture:

2. docker-compose.yml contents, docker run shell command, or paste a screenshot of any UI based configuration of containers here
3. any additional info to help reproduce

These common fixes didn't work for my issue

• [ ] I have tried removing/destroying my container, and re-creating a new container
• [ ] I have tried fresh volume data by backing up and moving/removing the old volume data
• [ ] I have tried running the stock docker run example(s) in the readme (removing any customizations I added)
• [ ] I have tried a newer or older version of Docker Pi-hole (depending what version the issue started in for me)
• [ ] I have tried running without my volume data mounts to eliminate volumes as the cause

If the above debugging / fixes revealed any new information note it here. Add any other debugging steps you've taken or theories on root cause that may help.