(1048, "Column 'api_key' cannot be null")

[keldnorman]

Where do i miss an API key when i am seeing this error ? (1048, "Column 'api_key' cannot be null")

---

• 18:06:22 home - SUCCESS Adding a new tower: <Tower: 238-1-2600-39752.0, loc: 55.872089437,12.358322492, time: 2022-09-17 18:06:22, freq: 1815.0>

---

Exception happened during processing of request from
Traceback (most recent call last):
File "/usr/lib/python3.8/socketserver.py", line 316, in _handle_request_noblock
self.process_request(request, client_address)
File "/usr/lib/python3.8/socketserver.py", line 347, in process_request
self.finish_request(request, client_address)
File "/usr/lib/python3.8/socketserver.py", line 360, in finish_request
self.RequestHandlerClass(request, client_address, self)
File "/usr/lib/python3.8/socketserver.py", line 747, in init
self.handle()
File "/root/source/CrocodileHunter/crocodilehunter/src/watchdog.py", line 563, in handle
wd_inst.process_tower(data)
File "/root/source/CrocodileHunter/crocodilehunter/src/watchdog.py", line 276, in process_tower
self.db_session.commit()
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/scoping.py", line 163, in do
return getattr(self.registry(), name)(*args, **kwargs)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 1042, in commit
self.transaction.commit()
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 502, in commit
self._assert_active(prepared_ok=True)
File "/usr/local/lib/python3.8/dist-packages/sqlalchemy/orm/session.py", line 289, in _assert_active
raise sa_exc.InvalidRequestError(
sqlalchemy.exc.InvalidRequestError: This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (MySQLdb._exceptions.OperationalError) (1048, "Column 'api_key' cannot be null")
[SQL: INSERT INTO tower_data (mcc, mnc, tac, cid, phyid, earfcn, lat, lon, timestamp, rssi, suspiciousness, frequency, enodeb_id, sector_id, cfo, rsrq, snr, rsrp, tx_pwr, est_dist, raw_sib1, classification, external_db, api_key, ext_id, uploaded) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)]
[parameters: (238, 1, 2600, 10176356, 401, 300, 55.871948207, 12.358092724, datetime.datetime(2022, 9, 17, 18, 4, 58), -42.5467, 0, 2140.0, 39751.0, 100.0, -2.04403, -13.8662, 4.09863, -11.6939, -4.5133, 0.4028981911256925, '4948e00391c00723800c28a026d1d9206006020611308d848d2e0000', 'unknown', 'unknown', None, None, None)]
(Background on this error at: http://sqlalche.me/e/13/e3q8) (Background on this error at: http://sqlalche.me/e/13/7s2a)

[cooperq]

Okay I finally looked into this. For some reason I made the api_key and some other fields "NOT NULL" which is not how it should be. I have fixed that and now it should all work. You might need to recreate your database or modify it manually for those changes to take effect. Fixed in 44298d0