Datatable issue

[Spidy67]

What installation are you running?

Production (netalertx) 📦

Is there an existing issue for this?

• I have searched the existing open and closed issues and I checked the docs https://docs.netalertx.com/

The issue occurs in the following browsers. Select at least 2.

• Firefox
• Chrome
• Edge
• Safari (unsupported) - PRs welcome
• N/A - This is an issue with the backend

Current Behavior

DataTables warning: table id=tableDevices - Requested unknown parameter '30' for row 0, column 30. For more information about this error, please see http://datatables.net/tn/4

Expected Behavior

No dialog box error

Steps To Reproduce

Just load add on

Relevant app.conf settings

docker-compose.yml

Debug or Trace enabled

• I have read and followed the steps in the wiki link above and provided the required debug logs and the log section covers the time when the issue occurs.

Relevant app.log section

  PASTE LOG HERE. Using the triple backticks preserves format.

Docker Logs

  PASTE DOCKER LOG HERE. Using the triple backticks preserves format.

[jokob-sk]

Please add logs otherwise I can't helps as insufficient information provided.

Include browser console logs from an incognito window.

[mmstano]

I'm getting the same error -

DataTables warning: table id=tableDevices - Requested unknown parameter '30' for row 0, column 30. For more information about this error, please see http://datatables.net/tn/4

I'm using the Home Assistant app version from Alex Belgium's repo. I tried updating to v26.2.4, but it wrecked all of my settings. Thankfully, I backed it up. Reverted back to v26.1.17. But even this version is buggy and it's giving me this error in a pop-up, plus it won't load device pages for any edits after I delete a device. My wife's apple watch has been acting up and reverting to random MAC setting. I usually reset the watch settings and it works for some time and I'll delete the ghost entry. Some weird stuff going on, lol... BTW, NetAlertX rocks! Thank you so much for creating it. When it's working, it gives me peace of mind.

Relevant Log entries (maybe?) -

02:03:31 [Settings] ⚠ File not found: /tmp/api/table_settings.json

02:05:44 [Plugins] SUCCESS for LUCIRPC received 79 entries
02:05:44 [Plugins] Processing : LUCIRPC
02:05:44 [Settings] ⚠ ERROR - setting_missing - LUCIRPC_REPORT_ON not in /tmp/api/table_settings.json
02:05:44 [Plugins] Should I update API (userUpdatedDevices): False
02:05:44 [Scheduler] run for ARPSCAN: YES
02:05:44 [Plugin utils] ---------------------------------------------
02:05:44 [Plugin utils] display_name : Arp-Scan (Network scan)
02:05:44 [Plugins] Executing: python3 /app/front/plugins/arp_scan/script.py userSubnets={subnets}
02:05:47 [ARPSCAN] In script
02:05:47 [ARPSCAN] Scan failed on x.x.x.x/24 --interface=eth0 --vlan=1: pcap_activate: eth0: No such device exists
(No such device exists)

[jokob-sk]

There have been new db columns added so if you revert back to a previous version you have to start with a new db or restore the db as well. If the db column definitions differ you might be getting these issues.

What I would recommend is backing up devices (e. G. With the CSV backup method) and settings and trying to migrate to the new version by following the migration docs.

Alternatively install a fresh new version and import devices and settings.

• https://docs.netalertx.com/BACKUPS/?h=backu
• https://docs.netalertx.com/MIGRATION/?h=migrat

[legionGer]

I got a similar issue

 netalertx  | Successfully updated IEEE OUI database (113017 entries)
netalertx  | Traceback (most recent call last):
netalertx  |   File "<frozen runpy>", line 198, in _run_module_as_main
netalertx  |   File "<frozen runpy>", line 88, in _run_code
netalertx  |   File "/app/server/__main__.py", line 260, in <module>
netalertx  |     sys.exit(main())
netalertx  |              ^^^^^^
netalertx  |   File "/app/server/__main__.py", line 117, in main
netalertx  |     pm.check_and_run_user_event()
netalertx  |   File "/app/server/plugin.py", line 152, in check_and_run_user_event
netalertx  |     self.handle_run(param)
netalertx  |   File "/app/server/plugin.py", line 183, in handle_run
netalertx  |     execute_plugin(self.db, self.all_plugins, plugin)
netalertx  |   File "/app/server/plugin.py", line 711, in execute_plugin
netalertx  |     process_plugin_events(db, plugin, sqlParams)
netalertx  |   File "/app/server/plugin.py", line 1053, in process_plugin_events
netalertx  |     sql.executemany(q, sqlParams)
netalertx  | sqlite3.OperationalError: table CurrentScan has no column named cur_NAME

Docker-compose from the offical installation source, fresh install. No imported data. Happens whenever I try to run LUCI plugin.

[jokob-sk]

@legionGer see #1502

[legionGer]

Thanks, failed to find that after debugging. Will try it the coming days.