Interesting, I don't have a drop trigger and it still works. But now that you remind me, I'll add it.
Good catch though. Also yes, I should call it _add !!
1 Like
I removed the drop again, it gave me this error:
[✓] Storing downloaded domains in new gravity database
[✓] Building tree
[i] Swapping databases...
[✗] Unable to copy data from /etc/pihole/gravity.db to /etc/pihole/gravity_temp.db
Error: near line 10: no such trigger: tr_group_add
[i] Number of gravity domains: 14578098 (2161132 unique domains)
[i] Number of exact blacklisted domains: 60
[i] Number of regex blacklist filters: 68
[i] Number of exact whitelisted domains: 803
[i] Number of regex whitelist filters: 0
[✓] Flushing DNS cache
[✓] Cleaning up stray matter
[✓] DNS service is running
[✓] Pi-hole blocking is Enabled
Didn't add the drop trigger and it still works fine. Here is my gravity_copy.sql.
Here is the log from last nights pihole -g run:
[✓] Storing downloaded domains in new gravity database
[✓] Building tree
[✓] Swapping databases
[i] Number of gravity domains: 1190673 (343611 unique domains)
[i] Number of exact blacklisted domains: 245
[i] Number of regex blacklist filters: 406
[i] Number of exact whitelisted domains: 601
[i] Number of regex whitelist filters: 10
[✓] Flushing DNS cache
[✓] Cleaning up stray matter
[✓] DNS service is running
[✓] Pi-hole blocking is Enabled
No error.
now same result for me (without the drop line) and things still work
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.