Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

UNIQUE constraint failed Procesising (sic) scan results #114

Closed
numbermonkey opened this issue Apr 24, 2021 · 4 comments
Closed

UNIQUE constraint failed Procesising (sic) scan results #114

numbermonkey opened this issue Apr 24, 2021 · 4 comments
Assignees
@pucherot
Labels
bug Something isn't working fixed Bug fixed

Comments

@numbermonkey
Copy link

"DietPi"
[dietpi@DietPi ~]$ cat /etc/issue
Raspbian GNU/Linux 10 \n \l

Persists after running automated uninstall and occurs during reinstall.
(BTW "Processing" is spelt incorrectly :))

Scanning...
arp-scan Method...
Pi-hole Method...
DHCP Leases Method...

Procesising scan results...
Traceback (most recent call last):
File "/home/dietpi/pialert/back/pialert.py", line 1486, in
sys.exit(main())
File "/home/dietpi/pialert/back/pialert.py", line 85, in main
res = scan_network()
File "/home/dietpi/pialert/back/pialert.py", line 379, in scan_network
save_scanned_devices (arpscan_devices, cycle_interval)
File "/home/dietpi/pialert/back/pialert.py", line 603, in save_scanned_devices
"VALUES ( ?, ?, ?, Null, 'local_MAC') ", (cycle, local_mac, local_ip) )
sqlite3.IntegrityError: UNIQUE constraint failed: CurrentScan.cur_ScanCycle, CurrentScan.cur_MAC

  • Adding jobs to the crontab...
@tcg96
Copy link

tcg96 commented Apr 24, 2021

Got the same error on my Raspberry Pi 1 B running DietPi 7.0.2 (based on Debian 10). Restarted and ran the update script to try again, but it fails every time. The only device that appears is "Internet" with my public IP address.

2021-04-24 07_56_54-ale@T440s_ _mnt_c_Users_Ale

pucherot added a commit that referenced this issue Apr 24, 2021
@pucherot
Pi.Alert v3.02
9232f31 
#114 - Fixed: UNIQUE constraint failed with Local MAC
@pucherot
Copy link
Owner

Solved in v3.02
Please, try it!!

@pucherot pucherot self-assigned this Apr 24, 2021
@pucherot pucherot added bug Something isn't working fixed Bug fixed labels Apr 24, 2021
@numbermonkey
Copy link
Author

Confirmed. Install now completes wit 3.02

@tcg96
Copy link

tcg96 commented Apr 24, 2021

It works now, thank you.

jokob-sk referenced this issue in jokob-sk/NetAlertX Jul 17, 2022
@pucherot
Pi.Alert v3.02
c08226e 
#114 - Fixed: UNIQUE constraint failed with Local MAC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@pucherot pucherot

Labels
bug Something isn't working fixed Bug fixed
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@tcg96 @pucherot @numbermonkey