search

pi-hole / FTL

The Pi-hole FTL engine
https://pi-hole.net
Other
1.36k stars 194 forks source link

Network.php no longer works after upgrading to FTL v5.16.3 #1418

Closed Sh311c0d324 closed 2 years ago

Sh311c0d324 commented 2 years ago

In raising this issue, I confirm the following (please check boxes, eg [X]) Failure to fill the template will close your issue:

How familiar are you with the codebase?:

{replace this text with a number from 1 to 10, with 1 being not familiar, and 10 being very familiar}

[BUG | ISSUE] Expected Behaviour:

Click on network and it shows devices being populated

[BUG | ISSUE] Actual Behaviour:

An error message is displayed

[BUG | ISSUE] Steps to reproduce:

Log file output [if available]

 -----tail of FTL.log------
   [2022-09-02 12:40:05.828 30260M] getMACfromIP("::1") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.829 30260M] SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
   [2022-09-02 12:40:05.829 30260M] getNameFromIP("::1") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.829 30260M] SQLite3 message: no such table: network in "SELECT interface FROM network JOIN network_addresses ON network_addresses.network_id = network.id WHERE network_addresses.ip = ? AND interface != 'N/A' AND interface IS NOT NULL;" (1)
   [2022-09-02 12:40:05.829 30260M] getIfaceFromIP("::1") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.831 30260M] SQLite3 message: no such table: network in "SELECT hwaddr FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? GROUP BY ip HAVING max(lastSeen));" (1)
   [2022-09-02 12:40:05.831 30260M] getMACfromIP("::1") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.831 30260M] SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
   [2022-09-02 12:40:05.831 30260M] getNameFromIP("::1") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.831 30260M] SQLite3 message: no such table: network in "SELECT interface FROM network JOIN network_addresses ON network_addresses.network_id = network.id WHERE network_addresses.ip = ? AND interface != 'N/A' AND interface IS NOT NULL;" (1)
   [2022-09-02 12:40:05.831 30260M] getIfaceFromIP("::1") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.906 30260M] SQLite3 message: no such table: network in "SELECT hwaddr FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? GROUP BY ip HAVING max(lastSeen));" (1)
   [2022-09-02 12:40:05.906 30260M] getMACfromIP("fe80::dc5e:5981:b339:3aa0") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.906 30260M] SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
   [2022-09-02 12:40:05.906 30260M] getNameFromIP("fe80::dc5e:5981:b339:3aa0") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.907 30260M] SQLite3 message: no such table: network in "SELECT interface FROM network JOIN network_addresses ON network_addresses.network_id = network.id WHERE network_addresses.ip = ? AND interface != 'N/A' AND interface IS NOT NULL;" (1)
   [2022-09-02 12:40:05.907 30260M] getIfaceFromIP("fe80::dc5e:5981:b339:3aa0") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.908 30260M] SQLite3 message: no such table: network in "SELECT hwaddr FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? GROUP BY ip HAVING max(lastSeen));" (1)
   [2022-09-02 12:40:05.908 30260M] getMACfromIP("fe80::dc5e:5981:b339:3aa0") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.909 30260M] SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
   [2022-09-02 12:40:05.909 30260M] getNameFromIP("fe80::dc5e:5981:b339:3aa0") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.909 30260M] SQLite3 message: no such table: network in "SELECT interface FROM network JOIN network_addresses ON network_addresses.network_id = network.id WHERE network_addresses.ip = ? AND interface != 'N/A' AND interface IS NOT NULL;" (1)
   [2022-09-02 12:40:05.909 30260M] getIfaceFromIP("fe80::dc5e:5981:b339:3aa0") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.911 30260M] SQLite3 message: no such table: network in "SELECT hwaddr FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? GROUP BY ip HAVING max(lastSeen));" (1)
   [2022-09-02 12:40:05.911 30260M] getMACfromIP("fe80::dc5e:5981:b339:3aa0") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.911 30260M] SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
   [2022-09-02 12:40:05.911 30260M] getNameFromIP("fe80::dc5e:5981:b339:3aa0") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:05.911 30260M] SQLite3 message: no such table: network in "SELECT interface FROM network JOIN network_addresses ON network_addresses.network_id = network.id WHERE network_addresses.ip = ? AND interface != 'N/A' AND interface IS NOT NULL;" (1)
   [2022-09-02 12:40:05.911 30260M] getIfaceFromIP("fe80::dc5e:5981:b339:3aa0") - SQL error prepare: SQL logic error
   [2022-09-02 12:40:08.015 30260M] WARNING in dnsmasq core: no address range available for DHCP request via lo
   [2022-09-02 12:40:08.016 30260M] SQLite3 message: no such table: message in "INSERT INTO message (timestamp,type,message,blob1,blob2,blob3,blob4,blob5) VALUES ((cast(strftime('%s', 'now') as int)),?,?,?,?,?,?,?);" (1)
   [2022-09-02 12:40:08.016 30260M] add_message(type=5, message=no address range available for DHCP request via lo) - SQL error prepare: SQL logic error
   [2022-09-02 12:40:08.016 30260M] WARNING in dnsmasq core: DHCP packet received on eth0 which has no address
   [2022-09-02 12:40:08.017 30260M] SQLite3 message: no such table: message in "INSERT INTO message (timestamp,type,message,blob1,blob2,blob3,blob4,blob5) VALUES ((cast(strftime('%s', 'now') as int)),?,?,?,?,?,?,?);" (1)
   [2022-09-02 12:40:08.017 30260M] add_message(type=5, message=DHCP packet received on eth0 which has no address) - SQL error prepare: SQL logic error

Device specifics

Hardware Type: rPi OS: Raspbian GNU/Linux 10 (buster)

This template was created based on the work of udemy-dl.

jfb-pihole commented 2 years ago

Let's start with a new query database (the old one will be saved):

sudo service pihole-FTL stop

sudo mv /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL-old.db

sudo service pihole-FTL start

Sh311c0d324 commented 2 years ago

Wow that was an easy fix. This resolved my issue, thanks!