Table won't load after update

After updating Pi-Hole via the command, I get the following error message while trying to view the query logs:

Token: micnterbrq

I noticed that once the adlists populate, the query fails to load.

In your debug log I see

Allowed memory size of 134217728 bytes exhausted

when you open the Query Log page (several times).

How many queries do you have? Check in the summary on the main page.

68 total queries. I purged the logs earlier thinking it would fix the issue.

That is odd. Did you try again after flushing the logs? If it's not working, send another debug log.

Yup, issue still persists. Token: ifqvxgvjxo

Same here. Chrome JavaScript console output:

I also ran the debug:
Your debug token is : q4zs727xuk

It appears that you haven't set any upstream DNS servers:

PIHOLE_DNS_1=
PIHOLE_DNS_2=

What DNS server did you choose during setup?

Your error is related to caching. We have updated all libraries. The error shows the old ones. Please clear your cache.

1 Like

That did it. Thank you!

I'm using DNScrypt from [OUTDATED] Setting Up and Using DNScrypt-Loader

Ok, can you set the DNS servers in /etc/pihole/setupVars.conf to the ones you set in that guide?

I did this and I still encountered errors, however I noticed the issue was with the adlist itself. If I tried to view the query log with pihole -g running, it would load fine, but when it was complete, it would throw the error. I backed up my adlist and restored it with the default one and now everything works. The issue is something within the adlist.

Make sure it is in a HOST format, either:
0.0.0.0 example.com
or
example.com
where 0.0.0.0 can be any address.

I tailed the log and found the issues from the following adlists:

# Untested lists
https://raw.githubusercontent.com/reek/anti-adblock-killer/master/anti-adblock-killer-filters.txt

# Custom
https://hosts-file.net/emd.txt
https://hosts-file.net/exp.txt

Removed them and the log works fine. Thanks!

Where do I make those changes? I'm having the same issue and I'm not quite savvy enough to know exactly where that is.

Thanks!!

sudo nano /etc/pihole/adlist.list

1 Like

Yeah, that file is showing empty.

Sorry, it's:

sudo nano /etc/pihole/adlists.list

that silly hidden 's'...

So, I '#' the two custom 'emd.txt' and 'exp.txt' and I'm still getting the same ajax error.