Updating comment in gravity.db fails

jacklul / pihole-updatelists

Update Pi-hole's lists from remote sources easily

MIT License

1.39k stars 81 forks source link

Updating comment in gravity.db fails #154

Closed cmonty14 closed 1 month ago

cmonty14 commented 1 month ago

Hi, I have manually added 10 adlists to Pihole; all use comment like firebog.net - Suspicious List 1 firebog.net - Suspicious List 2 etc.

Running command sudo sqlite3 /etc/pihole/gravity.db "UPDATE adlist SET comment = 'Managed by pihole-updatelists' WHERE comment LIKE '%Firebog |%' OR comment LIKE '%[ph5lt]' OR comment LIKE '%firebog |%'" does not update the comment.

Can you please advise how to fix this?

jacklul commented 1 month ago

The command only supports comment created by pihole5-list-tool, as mentioned line above it in the readme.

In your case the correct match would be '%firebog.net - %'.