Add frames.tBITS field #45

Open
opened 2023-12-14 09:01:04 -06:00 by W1CDN · 0 comments
Owner
2023-12-14 08:57:28,233 - K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:}W0RFP-1>APMI06,TCPIP,K0RQ-1*::W0RFP-1  :BITS.11111111,WX3in1Plus20 Telemetry
2023-12-14 08:57:28,234 - Parsing: K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:}W0RFP-1>APMI06,TCPIP,K0RQ-1*::W0RFP-1  :BITS.11111111,WX3in1Plus20 Telemetry
2023-12-14 08:57:28,251 - Packet is third-party
2023-12-14 08:57:28,252 - Parsing: W0RFP-1>APMI06,TCPIP,K0RQ-1*::W0RFP-1  :BITS.11111111,WX3in1Plus20 Telemetry
2023-12-14 08:57:28,254 - Attempting to parse as message packet
2023-12-14 08:57:28,266 - Attempting to parse telemetry-message packet
2023-12-14 08:57:28,268 - Parsed ok.
2023-12-14 08:57:28,269 - Parsed ok.
2023-12-14 08:57:28,271 - "raw", "from", "to", "path", "via", "format", "subpacket", "station_call", "station_lat", "station_lon", "created_unix", "party"
2023-12-14 08:57:28,272 - dict_values(['K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:}W0RFP-1>APMI06,TCPIP,K0RQ-1*::W0RFP-1  :BITS.11111111,WX3in1Plus20 Telemetry', 'K0RQ-1', 'APDW16', "['KB0UGF-3', 'WIDE1', 'WIDE2-1']", '', 'thirdparty', "{'raw': 'W0RFP-1>APMI06,TCPIP,K0RQ-1*::W0RFP-1  :BITS.11111111,WX3in1Plus20 Telemetry', 'from': 'W0RFP-1', 'to': 'APMI06', 'path': ['TCPIP', 'K0RQ-1*'], 'via': '', 'addresse': 'W0RFP-1', 'format': 'telemetry-message', 'tBITS': '11111111', 'title': 'WX3in1Plus20 Telemetry'}", 'W1CDN-1', '47.941500', '-97.027000', 1702565848, 1])
2023-12-14 08:57:28,273 - "raw", "from", "to", "path", "via", "addresse", "format", "tBITS", "title", "party", "header_raw", "station_call", "station_lat", "station_lon", "created_unix"
2023-12-14 08:57:28,274 - dict_values(['W0RFP-1>APMI06,TCPIP,K0RQ-1*::W0RFP-1  :BITS.11111111,WX3in1Plus20 Telemetry', 'W0RFP-1', 'APMI06', "['TCPIP', 'K0RQ-1*']", '', 'W0RFP-1', 'telemetry-message', '11111111', 'WX3in1Plus20 Telemetry', 3, 'K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:', 'W1CDN-1', '47.941500', '-97.027000', 1702565848])
2023-12-14 08:57:28,275 - Inserting into database
2023-12-14 08:57:28,280 - Error with SQLite!
Traceback (most recent call last):
  File "kiss_and_db.py", line 117, in main
    conn.execute(b_sql, list(b.values()))
sqlite3.OperationalError: table frames has no column named tBITS
``` 2023-12-14 08:57:28,233 - K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:}W0RFP-1>APMI06,TCPIP,K0RQ-1*::W0RFP-1 :BITS.11111111,WX3in1Plus20 Telemetry 2023-12-14 08:57:28,234 - Parsing: K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:}W0RFP-1>APMI06,TCPIP,K0RQ-1*::W0RFP-1 :BITS.11111111,WX3in1Plus20 Telemetry 2023-12-14 08:57:28,251 - Packet is third-party 2023-12-14 08:57:28,252 - Parsing: W0RFP-1>APMI06,TCPIP,K0RQ-1*::W0RFP-1 :BITS.11111111,WX3in1Plus20 Telemetry 2023-12-14 08:57:28,254 - Attempting to parse as message packet 2023-12-14 08:57:28,266 - Attempting to parse telemetry-message packet 2023-12-14 08:57:28,268 - Parsed ok. 2023-12-14 08:57:28,269 - Parsed ok. 2023-12-14 08:57:28,271 - "raw", "from", "to", "path", "via", "format", "subpacket", "station_call", "station_lat", "station_lon", "created_unix", "party" 2023-12-14 08:57:28,272 - dict_values(['K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:}W0RFP-1>APMI06,TCPIP,K0RQ-1*::W0RFP-1 :BITS.11111111,WX3in1Plus20 Telemetry', 'K0RQ-1', 'APDW16', "['KB0UGF-3', 'WIDE1', 'WIDE2-1']", '', 'thirdparty', "{'raw': 'W0RFP-1>APMI06,TCPIP,K0RQ-1*::W0RFP-1 :BITS.11111111,WX3in1Plus20 Telemetry', 'from': 'W0RFP-1', 'to': 'APMI06', 'path': ['TCPIP', 'K0RQ-1*'], 'via': '', 'addresse': 'W0RFP-1', 'format': 'telemetry-message', 'tBITS': '11111111', 'title': 'WX3in1Plus20 Telemetry'}", 'W1CDN-1', '47.941500', '-97.027000', 1702565848, 1]) 2023-12-14 08:57:28,273 - "raw", "from", "to", "path", "via", "addresse", "format", "tBITS", "title", "party", "header_raw", "station_call", "station_lat", "station_lon", "created_unix" 2023-12-14 08:57:28,274 - dict_values(['W0RFP-1>APMI06,TCPIP,K0RQ-1*::W0RFP-1 :BITS.11111111,WX3in1Plus20 Telemetry', 'W0RFP-1', 'APMI06', "['TCPIP', 'K0RQ-1*']", '', 'W0RFP-1', 'telemetry-message', '11111111', 'WX3in1Plus20 Telemetry', 3, 'K0RQ-1>APDW16,KB0UGF-3,WIDE1,WIDE2-1:', 'W1CDN-1', '47.941500', '-97.027000', 1702565848]) 2023-12-14 08:57:28,275 - Inserting into database 2023-12-14 08:57:28,280 - Error with SQLite! Traceback (most recent call last): File "kiss_and_db.py", line 117, in main conn.execute(b_sql, list(b.values())) sqlite3.OperationalError: table frames has no column named tBITS ```
W1CDN added the
bug
label 2023-12-14 09:01:07 -06:00
Sign in to join this conversation.
No Milestone
No project
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: W1CDN/aprs_tool#45
No description provided.