Insert Query Error about ya-pihole-list

[JavanXD]

I'll fix it soon. it is only a warning therefore the import should have worked.

[jbeardon]

Unfortunately, they do seem to be preventing the list imports - nothing in adlists.list.updater has appeared (that was not already there)

[JavanXD]

thank you! i fixed this issue. importing from adlist should work now.

[JavanXD]

If you try to add a blocklist which is already in the gravity.db you will receive the following warnings:

Info: Adding content of /home/pi/adlists.list.updater into gravity database
Warning: Some warnings in table adlist in database /etc/pihole/gravity.db:
/home/pi/adlists.list.updater.tmp:1: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:2: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:3: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:4: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:5: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:6: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:7: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:8: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:9: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:10: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:11: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:12: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:13: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:14: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:15: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:16: INSERT failed: UNIQUE constraint failed: adlist.address
/home/pi/adlists.list.updater.tmp:17: INSERT failed: UNIQUE constraint failed: adlist.address

which is fine because the adlist are already in the adlists collection.