Vendor name containing a special char

[vemore]

Is there an existing issue for this?

• I have searched the existing open and closed issues and I checked the docs https://github.com/jokob-sk/NetAlertX/tree/main/docs

Current Behavior

I have a device which Vendor name is "Micro-Star INT'L CO., LTD".

The char "'" cause an error when the device is newly detected.

netalertx | Traceback (most recent call last):
netalertx | File "", line 198, in _run_module_as_main
netalertx | File "", line 88, in _run_code
netalertx | File "/app/server/main.py", line 209, in
netalertx | sys.exit(main())
netalertx | ^^^^^^
netalertx | File "/app/server/main.py", line 139, in main
netalertx | process_scan(db)
netalertx | File "/app/server/networkscan.py", line 37, in process_scan
netalertx | create_new_devices (db)
netalertx | File "/app/server/device.py", line 252, in create_new_devices
netalertx | sql.execute(sqlQuery, (startTime, startTime))

An error occurred: near "L": syntax error

Expected Behavior

The device Vendor Name does not cause any error

Steps To Reproduce

No response

app.conf

No response

docker-compose.yml

No response

What branch are you running?

Production

app.log

No response

Debug 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.

[jokob-sk]

Thanks for the report @vemore - this should be fixed in the latest release in ~15 min from now -> Closing