Whitelist blacklist and most blocklist disappeared after gravity update

[pbsnpr]

i have very little knowledge on pihole.

currently running
Pi-hole v5.6 FTL v5.11 Web Interface v5.8

on a raspberry pi 4b with raspberry pi os

Actual Behaviour:

tried updating gravity but showed error with no domains on blocklist. ran pihole -r and some blocklist came back. realized whitelist, blacklist were all missing. cleared browser cache, didn't help.

i read somewhere to try this but i have no idea what this is.. i think it is gravity database:
sqlite3 /etc/pihole/gravity.db --header --column "Select *from domainlist"

i also read that the database for whitelist and blacklist should be stored somewhere but i don't know how to retrieve or access them.

thanks for your help.

Debug Token:

https://tricorder.pi-hole.net/5JcKsajm/

[jfb]

@pbsnpr

sqlite3 /etc/pihole/gravity.db --header --column "Select *from domainlist"

This is an SQL command to display your domain list from the gravity (domain) database located at /etc/pihole/gravity.db. Details of the database are discussed in our documentation:

Redirecting...

Here is an example of what you will see as the output from this command - taken from one of my Pi-holes.

sqlite3 /etc/pihole/gravity.db --header --column "Select *from domainlist"
id   type  domain                                     enabled  date_added  date_modified  comment                                                                   
---  ----  -----------------------------------------  -------  ----------  -------------  --------------------------------------------------------------------------
1    0     freegeoip.app                              1        1625858549  1625858549     Used by dietpi-banner and dietpi-vpn to obtain your public IP and location
39   0     click.email.rdaenthusiast.com              1        1582661625  1625868681     email linker

This output is similar to what you will see if you look in your debug log. In your case, you have no domain entries and have two adlists:

*** [ DIAGNOSING ]: Groups
   id    enabled  name                                                date_added           date_modified        description                                       
   ----  -------  --------------------------------------------------  -------------------  -------------------  --------------------------------------------------
   0           1  Default                                             2021-11-04 08:46:32  2021-11-04 08:46:32  The default group                                 

*** [ DIAGNOSING ]: Domainlist (0/1 = exact white-/blacklist, 2/3 = regex white-/blacklist)

*** [ DIAGNOSING ]: Clients

*** [ DIAGNOSING ]: Adlists
   id     enabled  group_ids     address                                                                                               date_added           date_modified        comment                                           
   -----  -------  ------------  ----------------------------------------------------------------------------------------------------  -------------------  -------------------  --------------------------------------------------
   1            1  0             https://raw.githubusercontent.com/StevenBlack/hosts/master/hosts                                      2021-11-04 08:46:32  2021-11-04 08:46:32  Migrated from /etc/pihole/adlists.list            
   2            1  0             https://mirror1.malwaredomains.com/files/justdomains                                                  2021-11-04 08:46:32  2021-11-04 08:46:32  Migrated from /etc/pihole/adlists.list