(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)