ERROR: speed_camera Failed: To INSERT Speed Data into TABLE speed

[KurtJacobson]

Hey Claude.

Thanks for making this available, should be very useful!

For some reason I am getting an error when trying to record the event into the DB.
See the log below.
Is this something that could be caused by an error on my configuration?

I have tried deleting the DB so it gets recreated, but same error.

Thank you!

Loading Wait...
----------------------------------------------------------------------
speed-cam.py 13.3  written by Claude Pageau
Motion Track Largest Moving Object and Calculate Speed per Calibration.
----------------------------------------------------------------------
2025-06-01 20:25:25 INFO     <module>   pluginEnabled plugins\ipcam-640x480.py
2025-06-01 20:25:25 INFO     <module>   Copy plugins\ipcam-640x480.py to plugins\current.py
2025-06-01 20:25:26 INFO     strmcam    Imported Required Camera Stream Settings from config.py
2025-06-01 20:25:26 WARNING  strmcam    cannot import name 'IM_FRAMERATE' from 'plugins.current' (C:\Users\Kurt\dev\speed-camera\source\plugins\current.py)
2025-06-01 20:25:26 INFO     strmcam    RTSPCAM Imported New Camera Stream Settings from plugin ipcam-640x480
2025-06-01 20:25:27 INFO     create_cam_thread RTSPCAM src=rtsp://admin:xxx@xxx:554/cam/realmonitor?channel=1&subtype=1
2025-06-01 20:25:27 INFO     strmcam    ver 13.1 Warming Up Camera 3 sec ...
2025-06-01 20:25:30 INFO     is_SQLite3 Success: File is sqlite3 Format data\speed_cam.db
2025-06-01 20:25:30 INFO     db_check   Success: sqlite3 Connected to DB data\speed_cam.db
2025-06-01 20:25:30 INFO     speed_camera sqlite3 DB is Open data\speed_cam.db
2025-06-01 20:25:30 INFO     speed_notify Plugin Enabled per PLUGIN_NAME=ipcam-640x480
2025-06-01 20:25:30 INFO     speed_notify RTSPCAM video stream size is 640 x 480
2025-06-01 20:25:30 INFO     speed_notify Resized Photos after IM_BIGGER=1.50 is 960 x 720
2025-06-01 20:25:30 INFO     speed_camera Logging to Console per Variable LOG_VERBOSE_ON=True
2025-06-01 20:25:30 INFO     speed_camera Press lower case q on OpenCV GUI Window to Quit program
2025-06-01 20:25:30 INFO     speed_camera         or ctrl-c in this terminal session to Quit
2025-06-01 20:25:30 INFO     speed_camera Begin Motion Tracking .....
----------------------------------------------------------------------
2025-06-01 20:28:33 INFO     speed_camera New  - 0/6 xy(26,52) Start New Track
2025-06-01 20:28:33 INFO     speed_camera  Add - 1/6 xy(29,52) 22.71 mph D=3/40 C=1 60x28=1680 sqpx L2R
2025-06-01 20:28:33 INFO     speed_camera  Add - 2/6 xy(34,52) 21.04 mph D=5/40 C=1 62x28=1736 sqpx L2R
2025-06-01 20:28:33 INFO     speed_camera  Add - 3/6 xy(40,52) 19.36 mph D=6/40 C=1 63x28=1764 sqpx L2R
2025-06-01 20:28:33 INFO     speed_camera  Add - 4/6 xy(46,52) 21.04 mph D=6/40 C=1 64x28=1792 sqpx L2R
2025-06-01 20:28:33 INFO     speed_camera  Add - 5/6 xy(53,51) 22.71 mph D=7/40 C=1 64x29=1856 sqpx L2R
2025-06-01 20:28:33 INFO     speed_camera  Add - 6/6 xy(58,52) 21.04 mph D=5/40 C=1 66x28=1848 sqpx L2R
2025-06-01 20:28:33 INFO     speed_camera  Saved 960x720 media/images\speed-20250601-1012/ 21-20250601-2028334.jpg
2025-06-01 20:28:33 INFO     is_SQLite3 Success: File is sqlite3 Format data\speed_cam.db
2025-06-01 20:28:33 INFO     db_check   Success: sqlite3 Connected to DB data\speed_cam.db
2025-06-01 20:28:33 ERROR    speed_camera sqlite3 DB data\speed_cam.db
2025-06-01 20:28:33 ERROR    speed_camera Failed: To INSERT Speed Data into TABLE speed
2025-06-01 20:28:33 ERROR    speed_camera Err Msg: near "(": syntax error
2025-06-01 20:28:33 ERROR    save_recent symlink Failed: [WinError 1314] A required privilege is not held by the client: '..\\images\\speed-20250601-1012\\ 21-20250601-2028334.jpg' -> 'media/recent\\ 21-20250601-2028334.jpg'
2025-06-01 20:28:33 INFO     save_recent Saved media/images\speed-20250601-1012/ 21-20250601-2028334.jpg to media/recent
2025-06-01 20:28:33 INFO     speed_camera End  - L2R Ave Speed 21.0 mph Tracked 32 px in 0.187 sec Calib 80px 4700mm
2025-06-01 20:28:33 INFO     speed_camera MO_TRACK_TIMEOUT_SEC 1.00 sec Delay to Avoid Tracking Same Object Multiple Times.
----------------------------------------------------------------------

[sylvesterkaczmarek]

The error occurs because your filename has a leading space (" 21-20250601..."), which breaks the SQL INSERT command.

Fix it by removing spaces in the filename generation (use .strip() in your plugin code).

Also, run the script as admin to fix the symlink error.

Update to the latest version of speed-cam.py if possible.

The IM_FRAMERATE warning is unrelated but worth checking later.

[KurtJacobson]

I found the error, it was not related to the file name, but to round(ave_speed, 2) resulting in np.float64 data type being inserted into the database.

I changed this line

speed-camera/source/speed-cam.py

Line 1698 in df289e7

round(ave_speed, 2),

to float(round(ave_speed, 2)) and everything works as expected.

This was the original SQL command format that was erroring out:

insert into speed values ('20250603-1536468', '"2025-06-03 15:36:46"', 'RTSPCAM', np.float64(30.0), 'mph', 'media/images\\speed-20250601-1012/speed-30-20250603-1536468.jpg', 960, 720, 1.5, 'L2R', 'ipcam-640x480', 81, 49, 37, 31, 1147, 75, 300, 180, 260, 0, 200, 6, 70, 5200, 'Test', 'Front Window')

This is the new SQL command that works:

insert into speed values ('20250603-1541428', '"2025-06-03 15:41:42"', 'RTSPCAM', 140.56, 'mph', 'media/images\\speed-20250601-1012/speed-141-20250603-1541428.jpg', 960, 720, 1.5, 'L2R', 'ipcam-640x480', 115, 48, 66, 32, 2112, 75, 300, 180, 260, 0, 200, 6, 70, 5200, 'Test', 'Front Window')

I'm surprised that others have not ran into this issue.

Thank you!