Encountered non-critical SQL warnings

I have not seen this in a long time. Try

cd /etc/.pihole
sudo git reset --hard HEAD^^^
sudo git fetch
sudo git checkout tweak/database_warnings_inspection
sudo git pull

Works for me - way to good :wink:

I think I have to do some clean up.

  SQL warnings:
  - /tmp/tmp.iN2xxQGkLb.gravity:148240: expected 2 columns but found 4 - extras ignored
    Line contains: ||2mdn.net^$object,third-party,domain=anleger-fernsehen.de|blick.ch|fitforfun.de|focus.de|giga.de|golem.de|helpster.de|myspass.de|netzwelt.de|stol.it|sueddeutsche.de|tvtoday.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148255: expected 2 columns but found 3 - extras ignored
    Line contains: ||ad.de.doubleclick.net^$~object,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148397: expected 2 columns but found 3 - extras ignored
    Line contains: ||doubleclick.net^$third-party,domain=augsburger-allgemeine.de|autobild.de|bild.de|buffed.de|bundesliga.de|cnet.de|computerbild.de|dashausanubis.de|de.msn.com|dooloop.tv|eyep.tv|filmjunkies.de|flashgames.de|focus.de|gameone.de|gamepro.de|gamesaktuell.de|gamestar.de|gameswelt.at|gameswelt.ch|gameswelt.de|gameswelt.tv|gamezone.de|gzsz.rtl.de|hatenight.com|homerj.de|icarly.de|kino.de|kochbar.de|laola1.tv|lustich.de|motorvision.de|myvideo.at|myvideo.ch|myvideo.de|n-tv.de|onlinewelten.com|pcgames.de|pcgameshardware.de|pcwelt.de|radio.de|ran.de|rtlregional.de|southpark.de|spiegel.tv|spiele-zone.de|spongebob.de|sport.de|spox.com|spreeradio.de|t-online.de|teleboerse.de|the-hills.tv|trailerseite.de|tvmovie.de|video.de|videogameszone.de|vip.de|vodafonelive.de|vox.de|welt.de|wetter.de|wetterschnecken.de|wikifit.de|www.rtl2.de|zdnet.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148582: expected 2 columns but found 3 - extras ignored
    Line contains: ||smartclip.net^$~object,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148672: expected 2 columns but found 3 - extras ignored
    Line contains: ||ad.de.doubleclick.net^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148673: expected 2 columns but found 3 - extras ignored
    Line contains: ||adperform.de^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148674: expected 2 columns but found 3 - extras ignored
    Line contains: ||adshot.de^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148675: expected 2 columns but found 3 - extras ignored
    Line contains: ||binany-code.com^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148676: expected 2 columns but found 3 - extras ignored
    Line contains: ||cp-network.uk.to^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148677: expected 2 columns but found 3 - extras ignored
    Line contains: ||der-wallstreet-trick.eu^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148678: expected 2 columns but found 3 - extras ignored
    Line contains: ||gamigoads.com^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148679: expected 2 columns but found 3 - extras ignored
    Line contains: ||insta-cash.net^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148680: expected 2 columns but found 3 - extras ignored
    Line contains: ||jinkads.com^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148681: expected 2 columns but found 3 - extras ignored
    Line contains: ||sevenads.net^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148682: expected 2 columns but found 3 - extras ignored
    Line contains: ||websc.org^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148683: expected 2 columns but found 3 - extras ignored
    Line contains: ||xx00.info^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148684: expected 2 columns but found 3 - extras ignored
    Line contains: ||zomap.de^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148694: expected 2 columns but found 3 - extras ignored
    Line contains: ||amarotic.com^*.php?wmid=$script,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148695: expected 2 columns but found 3 - extras ignored
    Line contains: ||amateurbusters.com^*.php?wmid=$script,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148708: expected 2 columns but found 3 - extras ignored
    Line contains: ||bit.ly^$image,domain=flugzeugbilder.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148712: expected 2 columns but found 3 - extras ignored
    Line contains: ||cambabestube.com^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148715: expected 2 columns but found 3 - extras ignored
    Line contains: ||china-gadgets.de^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148718: expected 2 columns but found 3 - extras ignored
    Line contains: ||cyonix.to^*.html$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148720: expected 2 columns but found 3 - extras ignored
    Line contains: ||erotik1.de^*.php?$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148726: expected 2 columns but found 3 - extras ignored
    Line contains: ||fuckmetube.org^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148727: expected 2 columns but found 3 - extras ignored
    Line contains: ||fuckshow.org^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148728: expected 2 columns but found 3 - extras ignored
    Line contains: ||gamercharts.com^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148730: expected 2 columns but found 3 - extras ignored
    Line contains: ||generika-bestellen.net^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148732: expected 2 columns but found 3 - extras ignored
    Line contains: ||hamster.cc^*.php$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148734: expected 2 columns but found 3 - extras ignored
    Line contains: ||hitnova.to^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148748: expected 2 columns but found 3 - extras ignored
    Line contains: ||nazometer.in^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148749: expected 2 columns but found 3 - extras ignored
    Line contains: ||nestoria.de^*?partner=$script,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148750: expected 2 columns but found 3 - extras ignored
    Line contains: ||netatwork.de^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148752: expected 2 columns but found 3 - extras ignored
    Line contains: ||oecherdeal.de^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148755: expected 2 columns but found 3 - extras ignored
    Line contains: ||online-casino.de^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148795: expected 2 columns but found 3 - extras ignored
    Line contains: ||preis-vergleich.tv^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148797: expected 2 columns but found 3 - extras ignored
    Line contains: ||probefahrten.cc^*?subid=$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148798: expected 2 columns but found 3 - extras ignored
    Line contains: ||profiwin.de^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148804: expected 2 columns but found 3 - extras ignored
    Line contains: ||s1.ja-pics.net^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148806: expected 2 columns but found 3 - extras ignored
    Line contains: ||sofadeals.com^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148808: expected 2 columns but found 3 - extras ignored
    Line contains: ||stealth.to^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148809: expected 2 columns but found 3 - extras ignored
    Line contains: ||superwin.de^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148810: expected 2 columns but found 3 - extras ignored
    Line contains: ||tarifdoc.de^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148811: expected 2 columns but found 3 - extras ignored
    Line contains: ||tarifliste.com^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148816: expected 2 columns but found 3 - extras ignored
    Line contains: ||toplist.raidrush.ws^$~image,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148821: expected 2 columns but found 3 - extras ignored
    Line contains: ||torrent-hitz.to^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148824: expected 2 columns but found 3 - extras ignored
    Line contains: ||ultramailtausch.de^$subdocument,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148846: expected 2 columns but found 3 - extras ignored
    Line contains: ||amateurseite.com^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148847: expected 2 columns but found 3 - extras ignored
    Line contains: ||bigpoint.com^*?aid=*&aig=*&aip=$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148848: expected 2 columns but found 3 - extras ignored
    Line contains: ||china-gadgets.de^*&utm_medium=popdown&$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148849: expected 2 columns but found 3 - extras ignored
    Line contains: ||dealdoktor.de^*&utm_medium=popdown&$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148850: expected 2 columns but found 3 - extras ignored
    Line contains: ||ext.amateurcommunity.com^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148851: expected 2 columns but found 3 - extras ignored
    Line contains: ||ext.amateurcommunity.de^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148854: expected 2 columns but found 3 - extras ignored
    Line contains: ||mediadealr.com^$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148856: expected 2 columns but found 3 - extras ignored
    Line contains: ||vodafone.de^*&tsid=$popup,third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148861: expected 2 columns but found 3 - extras ignored
    Line contains: ||4taktershop.de^$subdocument,domain=rollertuningpage.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148877: expected 2 columns but found 3 - extras ignored
    Line contains: ||blankrefer.com^$subdocument,domain=anime-loads.org,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148888: expected 2 columns but found 3 - extras ignored
    Line contains: ||damoh.$media,domain=chip.de|focus.de|n-tv.de|rtl.de|rtl2.de|spiegel.de|spiegel.tv|spieletipps.de|tvnow.de|vip.de|winfuture.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148890: expected 2 columns but found 4 - extras ignored
    Line contains: ||ddl-search.biz^$image,popup,domain=w3-warez.cc,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148904: expected 2 columns but found 3 - extras ignored
    Line contains: ||fap-tastic.com^$subdocument,domain=trendhure.com,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148923: expected 2 columns but found 3 - extras ignored
    Line contains: ||hd-world.org^$subdocument,domain=hd-world.org,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148925: expected 2 columns but found 3 - extras ignored
    Line contains: ||hmediacdn.com^$media,domain=4players.de|golem.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148927: expected 2 columns but found 3 - extras ignored
    Line contains: ||homad1.spiegel.tv^$object,domain=spiegel.tv,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148928: expected 2 columns but found 3 - extras ignored
    Line contains: ||homad2.spiegel.tv^$object,domain=spiegel.tv,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148930: expected 2 columns but found 3 - extras ignored
    Line contains: ||hornoxe.com^*.php|$script,domain=hornoxe.com,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148933: expected 2 columns but found 3 - extras ignored
    Line contains: ||imgur.com^$image,domain=monster-titten.com,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148946: expected 2 columns but found 3 - extras ignored
    Line contains: ||movie-blog.org^$subdocument,domain=movie-blog.org,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148948: expected 2 columns but found 3 - extras ignored
    Line contains: ||myvideo.de^$subdocument,domain=schulterglatze.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148954: expected 2 columns but found 3 - extras ignored
    Line contains: ||nullrefer.com^$subdocument,domain=anime-loads.org,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148960: expected 2 columns but found 3 - extras ignored
    Line contains: ||picdump.tv^$subdocument,domain=trendhure.com,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148964: expected 2 columns but found 3 - extras ignored
    Line contains: ||pornkino.to^$popup,domain=xxx-blog.to,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148978: expected 2 columns but found 3 - extras ignored
    Line contains: ||scooter-attack.com^$subdocument,domain=rollertuningpage.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148980: expected 2 columns but found 3 - extras ignored
    Line contains: ||smsit.me^$subdocument,domain=rapidvideo.com,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148995: expected 2 columns but found 3 - extras ignored
    Line contains: ||threepi.de^$media,domain=gamepro.de|gamestar.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:148998: expected 2 columns but found 3 - extras ignored
    Line contains: ||trendhure.tv^$subdocument,domain=trendhure.com,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149001: expected 2 columns but found 3 - extras ignored
    Line contains: ||windowspro.de^$xmlhttprequest,domain=windowspro.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149005: expected 2 columns but found 3 - extras ignored
    Line contains: ||www.connect.de^$script,domain=www.connect.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149007: expected 2 columns but found 3 - extras ignored
    Line contains: ||www.pc-magazin.de^$script,domain=www.pc-magazin.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149008: expected 2 columns but found 3 - extras ignored
    Line contains: ||www.tiervermittlung.de^*.js?ts=$script,domain=tiervermittlung.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149015: expected 2 columns but found 3 - extras ignored
    Line contains: @@||autobild.de^$genericblock,generichide,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149053: expected 2 columns but found 3 - extras ignored
    Line contains: .gif|$popup,domain=autozeitung.de|formel1.de|fremdwort.de|inside-handy.de|motorsport-total.com|news.de|seniorbook.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149054: expected 2 columns but found 3 - extras ignored
    Line contains: ^utm_campaign^$popup,domain=jappy.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149055: expected 2 columns but found 3 - extras ignored
    Line contains: ^utm_medium=popunder^$popup,domain=hilfreich.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149056: expected 2 columns but found 3 - extras ignored
    Line contains: ||ad.netzquadrat.de^$popup,domain=sms.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149057: expected 2 columns but found 3 - extras ignored
    Line contains: ||adclick.g.doubleclick.net^$popup,domain=4players.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149058: expected 2 columns but found 3 - extras ignored
    Line contains: ||adcloud.net^$popup,domain=lustich.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149059: expected 2 columns but found 3 - extras ignored
    Line contains: ||adscale.de^$popup,domain=4players.de|lustich.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149060: expected 2 columns but found 3 - extras ignored
    Line contains: ||amazon.de^*&tag=$popup,domain=gamona.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149061: expected 2 columns but found 3 - extras ignored
    Line contains: ||amazon.de^*&tag=bluray18-21&$popup,domain=bluray-disc.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149062: expected 2 columns but found 3 - extras ignored
    Line contains: ||amazon.de^*^tag=$popup,domain=wetteronline.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149063: expected 2 columns but found 3 - extras ignored
    Line contains: ||campartner.com^$popup,domain=g-stream.in,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149066: expected 2 columns but found 3 - extras ignored
    Line contains: ||dealbunny.de^$popup,domain=dokus4.me,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149067: expected 2 columns but found 3 - extras ignored
    Line contains: ||doubleclick.net^$popup,domain=gamestar.de|gamona.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149068: expected 2 columns but found 3 - extras ignored
    Line contains: ||goo.gl^$popup,domain=fail.to|omfg.to|warezking.in,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149069: expected 2 columns but found 3 - extras ignored
    Line contains: ||googleadservices.com^$popup,domain=wetteronline.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149070: expected 2 columns but found 3 - extras ignored
    Line contains: ||hd-movies.cx^$popup,domain=drop-games.org,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149071: expected 2 columns but found 3 - extras ignored
    Line contains: ||ligatus.com^$popup,domain=gamona.de|n-tv.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149072: expected 2 columns but found 3 - extras ignored
    Line contains: ||lovoo.net^$popup,domain=smsform.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149073: expected 2 columns but found 3 - extras ignored
    Line contains: ||luschtiges.blogspot.de^$popup,domain=ragecomic.com,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149074: expected 2 columns but found 3 - extras ignored
    Line contains: ||neckermann.de^$popup,domain=5vor12.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149075: expected 2 columns but found 3 - extras ignored
    Line contains: ||partners.webmasterplan.com^$popup,domain=tele5.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149076: expected 2 columns but found 3 - extras ignored
    Line contains: ||sexpartnersite.net^$popup,domain=pornkino.to,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149077: expected 2 columns but found 3 - extras ignored
    Line contains: ||sms2me.at^$popup,domain=superchat.at,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149078: expected 2 columns but found 3 - extras ignored
    Line contains: ||sunmaker.com^$popup,domain=hd-world.org|movie-blog.org,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149079: expected 2 columns but found 3 - extras ignored
    Line contains: ||superclix.de^$popup,domain=4players.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149080: expected 2 columns but found 3 - extras ignored
    Line contains: ||thepornlist.net^$popup,domain=sexuria.com,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149081: expected 2 columns but found 3 - extras ignored
    Line contains: ||tinyurl.com^$popup,domain=gamersglobal.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149082: expected 2 columns but found 3 - extras ignored
    Line contains: ||tipico.com^$popup,domain=yabeat.com,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149083: expected 2 columns but found 3 - extras ignored
    Line contains: ||urlaubsguru.de^$popup,domain=omfg.to,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149084: expected 2 columns but found 3 - extras ignored
    Line contains: ||usenext.de^$popup,domain=5vor12.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149085: expected 2 columns but found 3 - extras ignored
    Line contains: ||williamhill.com^$popup,domain=trailerzone.info,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149086: expected 2 columns but found 3 - extras ignored
    Line contains: ||williamhillcasino.com^$popup,domain=trailerzone.info,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149103: expected 2 columns but found 3 - extras ignored
    Line contains: @@||adimg.uimserv.net^$image,domain=millionenklick.web.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149104: expected 2 columns but found 3 - extras ignored
    Line contains: @@||adindex.de^*^gutschein_$subdocument,domain=gutscheindoktor.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149106: expected 2 columns but found 3 - extras ignored
    Line contains: @@||adonline.anonza.de^$~document,~third-party,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149111: expected 2 columns but found 3 - extras ignored
    Line contains: @@||apmebf.com^$subdocument,domain=gutscheindoktor.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149113: expected 2 columns but found 3 - extras ignored
    Line contains: @@||bauer-plus.de^*?advertiser=$subdocument,domain=abosgratis.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149114: expected 2 columns but found 3 - extras ignored
    Line contains: @@||campaign.adindex.de^*?idpartner=$subdocument,domain=gutscheindoktor.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149118: expected 2 columns but found 3 - extras ignored
    Line contains: @@||creatives.sascdn.com^$image,domain=fitbook.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149119: expected 2 columns but found 3 - extras ignored
    Line contains: @@||damoh.giga.de^$script,domain=giga.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149120: expected 2 columns but found 3 - extras ignored
    Line contains: @@||damoh.golem.de^$script,domain=golem.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149121: expected 2 columns but found 3 - extras ignored
    Line contains: @@||damoh.schneevonmorgen.com^$script,domain=chip.de|erdbeerlounge.de|giga.de|golem.de|kino.de|spieletipps.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149122: expected 2 columns but found 3 - extras ignored
    Line contains: @@||dt.adsafeprotected.com^$image,domain=welect.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149124: expected 2 columns but found 3 - extras ignored
    Line contains: @@||ebayclassifiedsgroup.com^$xmlhttprequest,domain=ebay-kleinanzeigen.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149126: expected 2 columns but found 3 - extras ignored
    Line contains: @@||eltern.de^*_300x250px.$image,domain=eltern.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149127: expected 2 columns but found 4 - extras ignored
    Line contains: @@||emsservice.de^$image,xmlhttprequest,domain=kochbar.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149130: expected 2 columns but found 3 - extras ignored
    Line contains: @@||firebaseapp.com^$script,domain=freenet.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149134: expected 2 columns but found 3 - extras ignored
    Line contains: @@||ib.adnxs.com^$xmlhttprequest,domain=bz-berlin.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149139: expected 2 columns but found 4 - extras ignored
    Line contains: @@||pixel.adsafeprotected.com^$image,script,domain=welect.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149140: expected 2 columns but found 3 - extras ignored
    Line contains: @@||player.skystream.tv^$subdocument,domain=torgranate.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149141: expected 2 columns but found 3 - extras ignored
    Line contains: @@||promo.douglas.de^$subdocument,domain=facebook.com,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149145: expected 2 columns but found 3 - extras ignored
    Line contains: @@||s1.adform.net^$script,domain=rewe.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149146: expected 2 columns but found 3 - extras ignored
    Line contains: @@||s357.mxcdn.net^$script,domain=welect.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149147: expected 2 columns but found 3 - extras ignored
    Line contains: @@||s79.mxcdn.net^$script,domain=welect.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149149: expected 2 columns but found 3 - extras ignored
    Line contains: @@||search.spotxchange.com^$image,domain=welect.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149150: expected 2 columns but found 3 - extras ignored
    Line contains: @@||smartadserver.com^*^tag=sas_3648^$script,domain=welt.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149151: expected 2 columns but found 3 - extras ignored
    Line contains: @@||smartadserver.com^*^tag=sas_3650^$script,domain=welt.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149152: expected 2 columns but found 3 - extras ignored
    Line contains: @@||spielesite.com^$script,domain=spielesite.com,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149153: expected 2 columns but found 3 - extras ignored
    Line contains: @@||static.adsafeprotected.com^$script,domain=welect.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149154: expected 2 columns but found 3 - extras ignored
    Line contains: @@||track.adform.net^$image,domain=welect.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149160: expected 2 columns but found 3 - extras ignored
    Line contains: @@||werbung.specials.de^$subdocument,domain=zentralreisen.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149161: expected 2 columns but found 3 - extras ignored
    Line contains: @@||windowspro.de^$script,domain=windowspro.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149163: expected 2 columns but found 3 - extras ignored
    Line contains: @@||eltern.de^*_300x250.$image,domain=eltern.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149165: expected 2 columns but found 3 - extras ignored
    Line contains: @@||888casino.com^$popup,domain=online-casino.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149166: expected 2 columns but found 3 - extras ignored
    Line contains: @@||adclick.g.doubleclick.net^$popup,domain=marketing-a.akamaihd.net,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149167: expected 2 columns but found 3 - extras ignored
    Line contains: @@||adform.net^$popup,domain=onvista.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149168: expected 2 columns but found 3 - extras ignored
    Line contains: @@||ads.smartfeedads.com^$popup,domain=motorrad2000.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149169: expected 2 columns but found 3 - extras ignored
    Line contains: @@||adspirit.de^$popup,domain=dealdoktor.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149170: expected 2 columns but found 3 - extras ignored
    Line contains: @@||elvenar.com^$popup,domain=t-online.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149171: expected 2 columns but found 3 - extras ignored
    Line contains: @@||eurogrand.com^$popup,domain=online-casino.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149172: expected 2 columns but found 3 - extras ignored
    Line contains: @@||europacasino.com^$popup,domain=online-casino.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149173: expected 2 columns but found 3 - extras ignored
    Line contains: @@||g.doubleclick.net^$popup,domain=11freunde.de|deals.chip.de|notebooksbilliger.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149174: expected 2 columns but found 3 - extras ignored
    Line contains: @@||getmyads.com^$popup,domain=wieverdienen.online,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149175: expected 2 columns but found 3 - extras ignored
    Line contains: @@||partycasino.com^$popup,domain=online-casino.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149176: expected 2 columns but found 3 - extras ignored
    Line contains: @@||stargames.com^$popup,domain=online-casino.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149177: expected 2 columns but found 3 - extras ignored
    Line contains: @@||sunmaker.com^$popup,domain=online-casino.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149178: expected 2 columns but found 3 - extras ignored
    Line contains: @@||track.adform.net^$popup,domain=dealdoktor.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149179: expected 2 columns but found 3 - extras ignored
    Line contains: @@||williamhill.com^$popup,domain=online-casino.de,8
  - /tmp/tmp.iN2xxQGkLb.gravity:149180: expected 2 columns but found 3 - extras ignored
    Line contains: @@||zanox-affiliate.de^$popup,domain=dealdoktor.de,8

Line contains: ||2mdn.net^$object,third-party,domain=anleger-fernsehen.de|blick.ch|fitforfun.de|focus.de|giga.de|golem.de|helpster.de|myspass.de|netzwelt.de|stol.it|sueddeutsche.de|tvtoday.de,8
Line contains: ||ad.de.doubleclick.net^$~object,third-party,8
Line contains: ||doubleclick.net^$third-party,domain=augsburger-allgemeine.de|autobild.de|bild.de|buffed.de|bundesliga.de|cnet.de|computerbild.de|dashausanubis.de|de.msn.com|dooloop.tv|eyep.tv|filmjunkies.de|flashgames.de|focus.de|gameone.de|gamepro.de|gamesaktuell.de|gamestar.de|gameswelt.at|gameswelt.ch|gameswelt.de|gameswelt.tv|gamezone.de|gzsz.rtl.de|hatenight.com|homerj.de|icarly.de|kino.de|kochbar.de|laola1.tv|lustich.de|motorvision.de|myvideo.at|myvideo.ch|myvideo.de|n-tv.de|onlinewelten.com|pcgames.de|pcgameshardware.de|pcwelt.de|radio.de|ran.de|rtlregional.de|southpark.de|spiegel.tv|spiele-zone.de|spongebob.de|sport.de|spox.com|spreeradio.de|t-online.de|teleboerse.de|the-hills.tv|trailerseite.de|tvmovie.de|video.de|videogameszone.de|vip.de|vodafonelive.de|vox.de|welt.de|wetter.de|wetterschnecken.de|wikifit.de|www.rtl2.de|zdnet.de,8
Line contains: ||smartclip.net^$~object,third-party,8
Line contains: ||ad.de.doubleclick.net^$popup,third-party,8
Line contains: ||adperform.de^$popup,third-party,8
Line contains: ||adshot.de^$popup,third-party,8
Line contains: ||binany-code.com^$popup,third-party,8
Line contains: ||cp-network.uk.to^$popup,third-party,8
Line contains: ||der-wallstreet-trick.eu^$popup,third-party,8
Line contains: ||gamigoads.com^$popup,third-party,8
Line contains: ||insta-cash.net^$popup,third-party,8
Line contains: ||jinkads.com^$popup,third-party,8
Line contains: ||sevenads.net^$popup,third-party,8
Line contains: ||websc.org^$popup,third-party,8
Line contains: ||xx00.info^$popup,third-party,8
Line contains: ||zomap.de^$popup,third-party,8
Line contains: ||amarotic.com^*.php?wmid=$script,third-party,8
Line contains: ||amateurbusters.com^*.php?wmid=$script,third-party,8
Line contains: ||bit.ly^$image,domain=flugzeugbilder.de,8
Line contains: ||cambabestube.com^$subdocument,third-party,8
Line contains: ||china-gadgets.de^$subdocument,third-party,8
Line contains: ||cyonix.to^*.html$subdocument,third-party,8
Line contains: ||erotik1.de^*.php?$subdocument,third-party,8
Line contains: ||fuckmetube.org^$subdocument,third-party,8
Line contains: ||fuckshow.org^$subdocument,third-party,8
Line contains: ||gamercharts.com^$subdocument,third-party,8
Line contains: ||generika-bestellen.net^$subdocument,third-party,8
Line contains: ||hamster.cc^*.php$subdocument,third-party,8
Line contains: ||hitnova.to^$subdocument,third-party,8
Line contains: ||nazometer.in^$subdocument,third-party,8
Line contains: ||nestoria.de^*?partner=$script,third-party,8
Line contains: ||netatwork.de^$subdocument,third-party,8
Line contains: ||oecherdeal.de^$subdocument,third-party,8
Line contains: ||online-casino.de^$subdocument,third-party,8
Line contains: ||preis-vergleich.tv^$subdocument,third-party,8
Line contains: ||probefahrten.cc^*?subid=$subdocument,third-party,8
Line contains: ||profiwin.de^$subdocument,third-party,8
Line contains: ||s1.ja-pics.net^$subdocument,third-party,8
Line contains: ||sofadeals.com^$subdocument,third-party,8
Line contains: ||stealth.to^$subdocument,third-party,8
Line contains: ||superwin.de^$subdocument,third-party,8
Line contains: ||tarifdoc.de^$subdocument,third-party,8
Line contains: ||tarifliste.com^$subdocument,third-party,8
Line contains: ||toplist.raidrush.ws^$~image,third-party,8
Line contains: ||torrent-hitz.to^$subdocument,third-party,8
Line contains: ||ultramailtausch.de^$subdocument,third-party,8
Line contains: ||amateurseite.com^$popup,third-party,8
Line contains: ||bigpoint.com^*?aid=*&aig=*&aip=$popup,third-party,8
Line contains: ||china-gadgets.de^*&utm_medium=popdown&$popup,third-party,8
Line contains: ||dealdoktor.de^*&utm_medium=popdown&$popup,third-party,8
Line contains: ||ext.amateurcommunity.com^$popup,third-party,8
Line contains: ||ext.amateurcommunity.de^$popup,third-party,8
Line contains: ||mediadealr.com^$popup,third-party,8
Line contains: ||vodafone.de^*&tsid=$popup,third-party,8
Line contains: ||4taktershop.de^$subdocument,domain=rollertuningpage.de,8
Line contains: ||blankrefer.com^$subdocument,domain=anime-loads.org,8
Line contains: ||damoh.$media,domain=chip.de|focus.de|n-tv.de|rtl.de|rtl2.de|spiegel.de|spiegel.tv|spieletipps.de|tvnow.de|vip.de|winfuture.de,8
Line contains: ||ddl-search.biz^$image,popup,domain=w3-warez.cc,8
Line contains: ||fap-tastic.com^$subdocument,domain=trendhure.com,8
Line contains: ||hd-world.org^$subdocument,domain=hd-world.org,8
Line contains: ||hmediacdn.com^$media,domain=4players.de|golem.de,8
Line contains: ||homad1.spiegel.tv^$object,domain=spiegel.tv,8
Line contains: ||homad2.spiegel.tv^$object,domain=spiegel.tv,8
Line contains: ||hornoxe.com^*.php|$script,domain=hornoxe.com,8
Line contains: ||imgur.com^$image,domain=monster-titten.com,8
Line contains: ||movie-blog.org^$subdocument,domain=movie-blog.org,8
Line contains: ||myvideo.de^$subdocument,domain=schulterglatze.de,8
Line contains: ||nullrefer.com^$subdocument,domain=anime-loads.org,8
Line contains: ||picdump.tv^$subdocument,domain=trendhure.com,8
Line contains: ||pornkino.to^$popup,domain=xxx-blog.to,8
Line contains: ||scooter-attack.com^$subdocument,domain=rollertuningpage.de,8
Line contains: ||smsit.me^$subdocument,domain=rapidvideo.com,8
Line contains: ||threepi.de^$media,domain=gamepro.de|gamestar.de,8
Line contains: ||trendhure.tv^$subdocument,domain=trendhure.com,8
Line contains: ||windowspro.de^$xmlhttprequest,domain=windowspro.de,8
Line contains: ||www.connect.de^$script,domain=www.connect.de,8
Line contains: ||www.pc-magazin.de^$script,domain=www.pc-magazin.de,8
Line contains: ||www.tiervermittlung.de^*.js?ts=$script,domain=tiervermittlung.de,8
Line contains: @@||autobild.de^$genericblock,generichide,8
Line contains: .gif|$popup,domain=autozeitung.de|formel1.de|fremdwort.de|inside-handy.de|motorsport-total.com|news.de|seniorbook.de,8
Line contains: ^utm_campaign^$popup,domain=jappy.de,8
Line contains: ^utm_medium=popunder^$popup,domain=hilfreich.de,8
Line contains: ||ad.netzquadrat.de^$popup,domain=sms.de,8
Line contains: ||adclick.g.doubleclick.net^$popup,domain=4players.de,8
Line contains: ||adcloud.net^$popup,domain=lustich.de,8
Line contains: ||adscale.de^$popup,domain=4players.de|lustich.de,8
Line contains: ||amazon.de^*&tag=$popup,domain=gamona.de,8
Line contains: ||amazon.de^*&tag=bluray18-21&$popup,domain=bluray-disc.de,8
Line contains: ||amazon.de^*^tag=$popup,domain=wetteronline.de,8
Line contains: ||campartner.com^$popup,domain=g-stream.in,8
Line contains: ||dealbunny.de^$popup,domain=dokus4.me,8
Line contains: ||doubleclick.net^$popup,domain=gamestar.de|gamona.de,8
Line contains: ||goo.gl^$popup,domain=fail.to|omfg.to|warezking.in,8
Line contains: ||googleadservices.com^$popup,domain=wetteronline.de,8
Line contains: ||hd-movies.cx^$popup,domain=drop-games.org,8
Line contains: ||ligatus.com^$popup,domain=gamona.de|n-tv.de,8
Line contains: ||lovoo.net^$popup,domain=smsform.de,8
Line contains: ||luschtiges.blogspot.de^$popup,domain=ragecomic.com,8
Line contains: ||neckermann.de^$popup,domain=5vor12.de,8
Line contains: ||partners.webmasterplan.com^$popup,domain=tele5.de,8
Line contains: ||sexpartnersite.net^$popup,domain=pornkino.to,8
Line contains: ||sms2me.at^$popup,domain=superchat.at,8
Line contains: ||sunmaker.com^$popup,domain=hd-world.org|movie-blog.org,8
Line contains: ||superclix.de^$popup,domain=4players.de,8
Line contains: ||thepornlist.net^$popup,domain=sexuria.com,8
Line contains: ||tinyurl.com^$popup,domain=gamersglobal.de,8
Line contains: ||tipico.com^$popup,domain=yabeat.com,8
Line contains: ||urlaubsguru.de^$popup,domain=omfg.to,8
Line contains: ||usenext.de^$popup,domain=5vor12.de,8
Line contains: ||williamhill.com^$popup,domain=trailerzone.info,8
Line contains: ||williamhillcasino.com^$popup,domain=trailerzone.info,8
Line contains: @@||adimg.uimserv.net^$image,domain=millionenklick.web.de,8
Line contains: @@||adindex.de^*^gutschein_$subdocument,domain=gutscheindoktor.de,8
Line contains: @@||adonline.anonza.de^$~document,~third-party,8
Line contains: @@||apmebf.com^$subdocument,domain=gutscheindoktor.de,8
Line contains: @@||bauer-plus.de^*?advertiser=$subdocument,domain=abosgratis.de,8
Line contains: @@||campaign.adindex.de^*?idpartner=$subdocument,domain=gutscheindoktor.de,8
Line contains: @@||creatives.sascdn.com^$image,domain=fitbook.de,8
Line contains: @@||damoh.giga.de^$script,domain=giga.de,8
Line contains: @@||damoh.golem.de^$script,domain=golem.de,8
Line contains: @@||damoh.schneevonmorgen.com^$script,domain=chip.de|erdbeerlounge.de|giga.de|golem.de|kino.de|spieletipps.de,8
Line contains: @@||dt.adsafeprotected.com^$image,domain=welect.de,8
Line contains: @@||ebayclassifiedsgroup.com^$xmlhttprequest,domain=ebay-kleinanzeigen.de,8
Line contains: @@||eltern.de^*_300x250px.$image,domain=eltern.de,8
Line contains: @@||emsservice.de^$image,xmlhttprequest,domain=kochbar.de,8
Line contains: @@||firebaseapp.com^$script,domain=freenet.de,8
Line contains: @@||ib.adnxs.com^$xmlhttprequest,domain=bz-berlin.de,8
Line contains: @@||pixel.adsafeprotected.com^$image,script,domain=welect.de,8
Line contains: @@||player.skystream.tv^$subdocument,domain=torgranate.de,8
Line contains: @@||promo.douglas.de^$subdocument,domain=facebook.com,8
Line contains: @@||s1.adform.net^$script,domain=rewe.de,8
Line contains: @@||s357.mxcdn.net^$script,domain=welect.de,8
Line contains: @@||s79.mxcdn.net^$script,domain=welect.de,8
Line contains: @@||search.spotxchange.com^$image,domain=welect.de,8
Line contains: @@||smartadserver.com^*^tag=sas_3648^$script,domain=welt.de,8
Line contains: @@||smartadserver.com^*^tag=sas_3650^$script,domain=welt.de,8
Line contains: @@||spielesite.com^$script,domain=spielesite.com,8
Line contains: @@||static.adsafeprotected.com^$script,domain=welect.de,8
Line contains: @@||track.adform.net^$image,domain=welect.de,8
Line contains: @@||werbung.specials.de^$subdocument,domain=zentralreisen.de,8
Line contains: @@||windowspro.de^$script,domain=windowspro.de,8
Line contains: @@||eltern.de^*_300x250.$image,domain=eltern.de,8
Line contains: @@||888casino.com^$popup,domain=online-casino.de,8
Line contains: @@||adclick.g.doubleclick.net^$popup,domain=marketing-a.akamaihd.net,8
Line contains: @@||adform.net^$popup,domain=onvista.de,8
Line contains: @@||ads.smartfeedads.com^$popup,domain=motorrad2000.de,8
Line contains: @@||adspirit.de^$popup,domain=dealdoktor.de,8
Line contains: @@||elvenar.com^$popup,domain=t-online.de,8
Line contains: @@||eurogrand.com^$popup,domain=online-casino.de,8
Line contains: @@||europacasino.com^$popup,domain=online-casino.de,8
Line contains: @@||g.doubleclick.net^$popup,domain=11freunde.de|deals.chip.de|notebooksbilliger.de,8
Line contains: @@||getmyads.com^$popup,domain=wieverdienen.online,8
Line contains: @@||partycasino.com^$popup,domain=online-casino.de,8
Line contains: @@||stargames.com^$popup,domain=online-casino.de,8
Line contains: @@||sunmaker.com^$popup,domain=online-casino.de,8
Line contains: @@||track.adform.net^$popup,domain=dealdoktor.de,8
Line contains: @@||williamhill.com^$popup,domain=online-casino.de,8
Line contains: @@||zanox-affiliate.de^$popup,domain=dealdoktor.de,8

I've been using, for years now, the lists from this selection (Non-crossed lists). Firebog is well known, and used by many pihole users. If you're going to toss lists from reputable block lists maintainers, what will be left?

At least everything seem to be coming from ID 8, so please run

sqlite3 /etc/pihole/gravity.db "SELECT address FROM adlist WHERE id = 8;"

to reveal which list is the bad one.

An old easylist :see_no_evil:

nanopi@nanopi:~$ sqlite3 /etc/pihole/gravity.db "SELECT address FROM adlist WHERE id = 8;"
https://easylist.to/easylistgermany/easylistgermany.txt

Being at this point - is there a way to know that a list contributed at least one meaningful entry to gravity.db?

I have to decide now if I delete this list, but it contains way more lines than I got SQL warnings. I would ignore the warnings if at least one potential domain is blocked because of this list and all non-meaningful entries would just be ignored.

If @WaLLy3K has bad lists I would be extremely surprised. I know he would immediately address any issues with his lists.

1 Like

No, the warnings are just highlighting the individual lines that caused warnings. Other lines not causing warnings may still not be meaningful at all when they contain stuff that does never match any domain.
We highly optimized the gravity processing, I think @jpgpi250 observed the improvements best. Doing additional checking on the imported lists will notably slow down the process and defeat some of our improvements.

Lists from reputable block lists maintainers are properly maintained and meet the format requirements. These won't be tossed. I have had zero problems with any of my blocklists on several Pi's. I generally run the stock lists, but for testing purposes I have added many of the firebog lists and they all work fine. The problem comes with lists converted from other formats (i.e. adBlock) and others that don't meet the format requirements.

1 Like

Just a short glimpse at the first line in this file (i.e. [Adblock Plus 1.1]) tells me it is meant ot be used by AdBlock Plus, and thus beyond pure domain blocking -. certainly not hosts format.

I saw this on screen:

  Encountered non-critical SQL warnings. Please check the suitability of the lis                        ts you're using!

  SQL warnings:
  - /tmp/tmp.Q4i2pVumHS.gravity:1866856: expected 2 columns but found 3 - extras                         ignored
    Line contains: denizbank-balbey.subesi.tc,,34

Line contains: denizbank-balbey.subesi.tc,,34

and

pi@raspberrypi:~ $ sqlite3 /etc/pihole/gravity.db "SELECT address FROM adlist WHERE id =34;"
https://raw.githubusercontent.com/HorusTeknoloji/TR-PhishingList/master/url-lists.txt

I may be lazy, but why don't you script the sqlquery automatically, you know the result (34)
showing the list is the last step, e.g. error message:

Encountered non-critical SQL warnings. Please check the suitability of the lis                        ts you're using!
List: https://raw.githubusercontent.com/HorusTeknoloji/TR-PhishingList/master/url-lists.txt
Line contains: denizbank-balbey.subesi.tc

What's stopping you from doing it?

How should Pi-Hole tidy up this mess?

&werbemittel=
-werb_hori.
-werb_vert.
-werbebanner.
.at/ads/
.at/werbung/
.com/de/ad/
.com/werbung_
.de.be/zzz/$script
.de.ms/zzz/$script
.de.vu/zzz/$script
.de/ads/$~xmlhttprequest
.de/ads?
.de/ads_
.de/werb/
.de/werbung/
.net/werbung/
.org/werbung/
.to/werbung/
/_werbung/*
/aaa-werbung/*
/ad-rahmen-
/ad/anzeige_
/banner125werbung.
/banner_quartermedia.
/banner_woomws.
/bannerwerbung-
/bilder/ads/*

You're trying to force the square peg into the round Pi-Hole hole, and it doesn't fit.

1 Like

I somehow like the idea of a simple conformance checker.

That could be done upon adding a source to the lists of blacklist sources, i.e. as a separate step, before and independent of gravity construction.

1 Like

I get the feeling that the goal of all this is to make Pi-hole in to a list linter and checker for the lazy to make and distribute their own lists. I don't think the goal is to find and remove bad lists.

I still am for something that says the list is bad and will not be used in its entirety.

3 Likes

Agree. If we just partially fix the bad lists (by rejecting bad lines), the lists stay bad forever and Pi-Hole is stuck fixing them forever. If a bad list is rejected entirely, than there is a driver for the list maintainer to fix it so it works with Pi-Hole. He/she fixes it once, and Pi-Hole is out of the list fixing business.

The burden should be a list creator / maintainer to make a list compatible for the software with which it is intended to be used.

Edit - if a fruit buyer receives bad fruit with the good, they reject the entire shipment. They don't fish through and remove the bad fruit, it all goes back. Next shipment, no bad fruit.

5 Likes

Because I'm not smart enough. I've been testing beta5, trying to help the developers identify the things, users will notice and complain about, despite the reactions I sometimes get.

Normally, I never react on discourse topics, unless I submit a 'pihole customization' OR it's a problem for which I know the solution with 100% certainty.

1 Like

We've made a home DNS server very easy to deploy. I sometimes think we've made it too easy and people don't see that DNS servers are a vital part of their networks. They shouldn't be feed unchecked data, I don't trust random lists as I don't know who is adding what to the lists. The stock lists are verified and trustworthy.

This is a network necessity, treat it with the amount of respect and diligence it requires.

Yes, this is an obvious idea, I agree, however, it may not always lead to the correct result. Take the warning we had with the other user (for whom I originally wrote the displaying of the warning). For him, the malformed line would have looked like:

domaina,4domainb,5

where the bug was, in fact, in list no. 4. When we'd have automatically shown the list no. 5 address, the user would have removed/disabled the wrong list and the warning would have shown up again, this time maybe with list no. 6.

The idea here is to show what went wrong. As things can go wrong in so many ways, we should have a human being involved who can look at the code. My personal opinion is that making assumptions on the form of something that is obviously malformed is not a good strategy. Even if it may work in some or even a lot of cases, it will not work in others and may be more confusing than anything else.

That is fair and fine. But please do not disrespect the developers by saying things like "This is so easy, why don't you do it" when you don't know how easy it is. This is all free to everyone and no one owes anyone anything.

1 Like