algertc
Received plate read data: [object Object] in Log
Very much appreciate this project!!! Trying to get it working for the first time. BI is showing plates and the log appears to be showing data coming over, but plate count shows zero.
ALPR-Database app logs show repeated: 4/15/2025, 3:40:01 PM [INFO] Received plate read data: [object Object] 4/15/2025, 3:40:02 PM [INFO] POST /api/plate-reads 4/15/2025, 3:40:02 PM [INFO] Received plate read data: [object Object] 4/15/2025, 3:40:03 PM [INFO] POST /api/plate-reads
BI is V5.9.9.37 x64, CodeProject AI v2.9.7 with License Plate Reader v3.3.4. Cameras are configured with the following web requests on alert:
Appreciate any help!
Mine is not working either. But it is getting a bit further than yours is. I will post the log i get in case it will help you troubleshoot. It looks like your Database connection has an issue based on the next step that shows in my log
4/15/2025, 7:24:57 PM [INFO] POST /api/plate-reads
4/15/2025, 7:24:57 PM [INFO] Received plate read data: [object Object]
4/15/2025, 7:24:57 PM [INFO] Database connection established
4/15/2025, 7:24:57 PM [INFO] [FileStorage] Successfully saved image
4/15/2025, 7:24:57 PM [ERROR] Error processing request: error: there is no unique or exclusion constraint matching the ON CONFLICT specification
Mine has the same issue and error . Any idea?
4/16/2025, 5:20:54 PM [INFO] POST /api/verify-session 4/16/2025, 5:20:55 PM [INFO] GET /api/check-update 4/16/2025, 5:27:10 PM [INFO] POST /api/plate-reads 4/16/2025, 5:27:11 PM [INFO] Received plate read data: [object Object] 4/16/2025, 5:27:11 PM [INFO] Database connection established 4/16/2025, 5:27:11 PM [INFO] [FileStorage] Successfully saved image 4/16/2025, 5:27:11 PM [ERROR] Error processing request: error: there is no unique or exclusion constraint matching the ON CONFLICT specification 4/16/2025, 5:27:12 PM [INFO] POST /api/plate-reads 4/16/2025, 5:27:13 PM [INFO] Received plate read data: [object Object] 4/16/2025, 5:27:13 PM [INFO] Database connection established 4/16/2025, 5:27:14 PM [INFO] [FileStorage] Successfully saved image 4/16/2025, 5:27:14 PM [ERROR] Error processing request: error: there is no unique or exclusion constraint matching the ON CONFLICT specification 4/16/2025, 5:27:15 PM [INFO] POST /api/plate-reads 4/16/2025, 5:27:15 PM [INFO] Received plate read data: [object Object] 4/16/2025, 5:27:15 PM [INFO] Database connection established 4/16/2025, 5:27:16 PM [INFO] [FileStorage] Successfully saved image 4/16/2025, 5:27:16 PM [ERROR] Error processing request: error: there is no unique or exclusion constraint matching the ON CONFLICT specification 4/16/2025, 5:27:17 PM [INFO] POST /api/plate-reads 4/16/2025, 5:27:17 PM [INFO] GET /dashboard 4/16/2025, 5:27:17 PM [INFO] POST /api/verify-session 4/16/2025, 5:27:18 PM [INFO] GET /api/check-update 4/16/2025, 5:27:18 PM [INFO] GET /manifest.webmanifest 4/16/2025, 5:27:18 PM [INFO] POST /api/verify-whitelist <
SOLUTION:
Step 1: Download the migrations.sql
https://github.com/algertc/ALPR-Database/blob/962103071ce468cd3282b740a6a8b5648ec85555/migrations.sql
Step 2: docker compose down ,
Step 3: docker compose up -d .
Step 4: Then, docker compose down again, replace the migrations.sql file again with the newest version in the repo
Step 5: docker compose up -d again.
SOLUTION:
Step 1: Download the migrations.sql
https://github.com/algertc/ALPR-Database/blob/962103071ce468cd3282b740a6a8b5648ec85555/migrations.sql
Step 2: docker compose down ,
Step 3: docker compose up -d .
Step 4: Then, docker compose down again, replace the migrations.sql file again with the newest version in the repo
Step 5: docker compose up -d again.
Any suggestion on how to do this on Docker Desktop? I know nothing about docker and just followed the instructions to download it and run the setup script
I did: wget https://github.com/algertc/ALPR-Database/blob/962103071ce468cd3282b740a6a8b5648ec85555/migrations.sql docker compose down mv migrations.sql.1 migrations.sql docker compose up -d docker compose down docker pull docker compose up -d
But I'm still getting the object errors: 4/17/2025, 4:09:04 PM [INFO] Received plate read data: [object Object] 4/17/2025, 4:09:05 PM [INFO] Received plate read data: [object Object] 4/17/2025, 4:09:06 PM [INFO] Received plate read data: [object Object] 4/17/2025, 4:09:07 PM [INFO] Received plate read data: [object Object] 4/17/2025, 4:09:09 PM [INFO] Received plate read data: [object Object] 4/17/2025, 4:09:11 PM [INFO] Received plate read data: [object Object] 4/17/2025, 4:09:12 PM [INFO] Received plate read data: [object Object] 4/17/2025, 4:09:13 PM [INFO] Received plate read data: [object Object] 4/17/2025, 4:09:13 PM [INFO] Received plate read data: [object Object] 4/17/2025, 4:09:14 PM [INFO] Received plate read data: [object Object] 4/17/2025, 4:09:14 PM [INFO] Received plate read data: [object Object] 4/17/2025, 4:09:14 PM [INFO] Received plate read data: [object Object]
Docker logs show: } POST /dashboard POST /api/verify-session GET /api/check-update Received plate read data: { ai_dump: [ { api: 'objects', found: [Object] }, { api: 'alpr', found: [Object] } ], Image: 'TRUNCATED', camera: 'cam-dow-25-1', ALERT_PATH: 'cam-dow-25-1.20250417_160001.720415.3-1.jpg', ALERT_CLIP: '@564694884218967', timestamp: '2025-04-17T23:12:00.033Z' } GET /dashboard POST /api/verify-session GET /api/check-update POST /dashboard POST /api/verify-session GET /api/check-update Fetching dashboard metrics POST /dashboard POST /api/verify-session GET /api/check-update GET /live_feed?page=1&hourFrom=07&hourTo=07 POST /api/verify-session GET /api/check-update POST /dashboard POST /api/verify-session GET /api/check-update
SOLUTION: Step 1: Download the migrations.sql https://github.com/algertc/ALPR-Database/blob/962103071ce468cd3282b740a6a8b5648ec85555/migrations.sql Step 2: docker compose down , Step 3: docker compose up -d . Step 4: Then, docker compose down again, replace the migrations.sql file again with the newest version in the repo Step 5: docker compose up -d again.
Any suggestion on how to do this on Docker Desktop? I know nothing about docker and just followed the instructions to download it and run the setup script
You have to drop to a command line to do it, try starting a powershell session
SOLUTION: Step 1: Download the migrations.sql https://github.com/algertc/ALPR-Database/blob/962103071ce468cd3282b740a6a8b5648ec85555/migrations.sql Step 2: docker compose down , Step 3: docker compose up -d . Step 4: Then, docker compose down again, replace the migrations.sql file again with the newest version in the repo Step 5: docker compose up -d again.
Any suggestion on how to do this on Docker Desktop? I know nothing about docker and just followed the instructions to download it and run the setup script
You have to drop to a command line to do it, try starting a powershell session
Ok, Thanks, that seemed to work better, not sure if i did it right, time will tell..... For anyone else trying it, I opened Powershell as Adminstrator, navigated to the folder where i have the ALPR-Desktop, and then executed the commands there. Looked like this:
Windows PowerShell Copyright (C) Microsoft Corporation. All rights reserved.
Install the latest PowerShell for new features and improvements! https://aka.ms/PSWindows
PS C:\WINDOWS\system32> cd g: PS G:> cd alpr PS G:\alpr> docker compose down time="2025-04-17T19:07:05-05:00" level=warning msg="project has been loaded without an explicit name from a symlink. Using name "alpr"" [+] Running 3/3 ✔ Container alpr-app-1 Removed 0.7s ✔ Container alpr-db-1 Removed 10.8s ✔ Network alpr_default Removed 0.9s PS G:\alpr> docker compose up -d time="2025-04-17T19:07:30-05:00" level=warning msg="project has been loaded without an explicit name from a symlink. Using name "alpr"" [+] Running 3/3 ✔ Network alpr_default Created 0.1s ✔ Container alpr-db-1 Started 1.1s ✔ Container alpr-app-1 Started 1.2s PS G:\alpr> docker compose down time="2025-04-17T19:07:50-05:00" level=warning msg="project has been loaded without an explicit name from a symlink. Using name "alpr"" [+] Running 3/3 ✔ Container alpr-app-1 Removed 0.6s ✔ Container alpr-db-1 Removed 10.7s ✔ Network alpr_default Removed 0.9s PS G:\alpr> docker compose up -d time="2025-04-17T19:09:38-05:00" level=warning msg="project has been loaded without an explicit name from a symlink. Using name "alpr"" [+] Running 3/3 ✔ Network alpr_default Created 0.1s ✔ Container alpr-db-1 Started 1.2s ✔ Container alpr-app-1 Started 1.3s PS G:\alpr>
SOLUTION: Step 1: Download the migrations.sql https://github.com/algertc/ALPR-Database/blob/962103071ce468cd3282b740a6a8b5648ec85555/migrations.sql Step 2: docker compose down , Step 3: docker compose up -d . Step 4: Then, docker compose down again, replace the migrations.sql file again with the newest version in the repo Step 5: docker compose up -d again.
Any suggestion on how to do this on Docker Desktop? I know nothing about docker and just followed the instructions to download it and run the setup script
You have to drop to a command line to do it, try starting a powershell session
Ok, Thanks, that seemed to work better, not sure if i did it right, time will tell..... For anyone else trying it, I opened Powershell as Adminstrator, navigated to the folder where i have the ALPR-Desktop, and then executed the commands there.
Still no luck, but the error changed:
4/17/2025, 7:26:07 PM [INFO] POST /api/plate-reads 4/17/2025, 7:26:07 PM [INFO] Received plate read data: [object Object] 4/17/2025, 7:26:07 PM [INFO] Database connection established 4/17/2025, 7:26:07 PM [INFO] [FileStorage] Successfully saved image 4/17/2025, 7:26:07 PM [ERROR] Error processing request: error: null value in column "plate_number" of relation "plate_reads" violates not-null constraint
This was on 2 Alerts where Plate-Recognizer returned the correct plate number on the Alert Memo.
You try nuking everything and just starting over? meaning delete the images/container/folders and just reinstall. then try to do the following again
You try nuking everything and just starting over? meaning delete the images/container/folders and just reinstall. then try to do the following again
I never had anything in there to begin with, it was a from-scratch install. No data in my DB at all.
Sorry for the troubles. I've been super busy with other things lately and haven't been able to look at this much. The problem seems to stem from my addition of a new database function to the schema.sql to try to make it work seamlessly for new users. That seems to have backfired, because I defined the function before that constraint that it depends on gets created, which you see in the errors.
I updated the schema.sql file just now, and it should work properly now.
Anyone with an already properly working deployment should not change anything. That schema.sql file is only run the very first time the container is started and never again.
Anyone still having issues should nuke it, delete the containers, delete all related docker VOLUMES!, and redeploy. The scripts will always get the newest versions of the files, so running them now should work as intended.
Pretty annoying that such a minor oversight totally broke it for new users. All I had to do was copy like 15 lines and move them to the bottom of the file.
Sorry for the troubles. I've been super busy with other things lately and haven't been able to look at this much. The problem seems to stem from my addition of a new database function to the schema.sql to try to make it work seamlessly for new users. That seems to have backfired, because I defined the function before that constraint that it depends on gets created, which you see in the errors.
I updated the schema.sql file just now, and it should work properly now.
Anyone with an already properly working deployment should not change anything. That schema.sql file is only run the very first time the container is started and never again.
Anyone still having issues should nuke it, delete the containers, delete all related docker VOLUMES!, and redeploy. The scripts will always get the newest versions of the files, so running them now should work as intended.
Pretty annoying that such a minor oversight totally broke it for new users. All I had to do was copy like 15 lines and move them to the bottom of the file.
Sorry but I'm still getting the same error after a complete reinstall
Stopped all containers, deleted all volumes and reinstalled from curl -sSL https://raw.githubusercontent.com/algertc/ALPR-Database/main/install.sh | bash
Still getting:
4/19/2025, 5:56:52 PM [INFO] Received plate read data: [object Object] 4/19/2025, 5:57:52 PM [INFO] GET /login 4/19/2025, 5:57:52 PM [INFO] GET /grid.svg 4/19/2025, 5:57:52 PM [INFO] POST /api/verify-session 4/19/2025, 5:57:52 PM [INFO] GET /api/check-update 4/19/2025, 5:57:54 PM [INFO] POST /login 4/19/2025, 5:57:54 PM [INFO] Logging in user 4/19/2025, 5:57:54 PM [INFO] Created session ID: c9f371444d005077711a234b23537710a51cf4c91d09bb039ecd09cf5dc593a1 4/19/2025, 5:57:54 PM [INFO] Cookie after setting: [object Object]
@jhuettner That looks right to me? What is the issue? It is receiving the plate correctly and logging you in.
You are getting plate numbers in the memo already in blue iris right? When you say the "plate count" is zero, there are no records showing up in the app?
My guess would be that the issue is with your codeproject/AI configuration in blue iris. You need it to be returning actual plate numbers, not just dayplate/nightplate.
The ALPR database app seems to be functioning exactly as it should, so I don't think there is anything you need to do there.
If you are getting plate numbers in the memo in BI, you could try using the plate_number parameter instead of AI_dump to troubleshoot. It would be "plate_number":"&Plate"
I am also still unable to get anything to show up on the dashboard
I delete the containers, all Docker volumes, and the folder where i had the ALPR-Database files. Then i reinstalled from scratch
I am getting plate numbers in the Blue Iris memo "VICI"
The only odd thing i see is that the identification of the plate number show up earlier in the flow than the identified "license-plate" or "DayPlate" confirmations:
The images do show up in the ALPR-Database "images" folder The files in the "Images" folder are of the later shots where "license-plate" or "DayPlate" were confirmed, but those are closer images so should have been better than what was in the earlier image
Here is the log:
4/19/2025, 5:37:49 PM [INFO] POST /api/plate-reads
4/19/2025, 5:37:49 PM [INFO] Received plate read data: [object Object]
4/19/2025, 5:37:49 PM [INFO] Database connection established
4/19/2025, 5:37:50 PM [INFO] [FileStorage] Successfully saved image
4/19/2025, 5:37:50 PM [ERROR] Error processing request: error: there is no unique or exclusion constraint matching the ON CONFLICT specification
If you are using platerecognizer, you can not use ai_dump because codeproject is not doing the ALPR. Other users have been able to use platerecognizer still by using the plate_number option as mentioned above.
I'm getting the exact same error with a fresh install.
&JSON info
[{"api":"objects","found":{"message":"Found car","count":1,"predictions":[{"confidence":0.9242175221443176,"label":"car","x_min":328,"y_min":756,"x_max":1610,"y_max":1787}],"success":true,"processMs":1086,"inferenceMs":1086,"moduleId":"ObjectDetectionYOLOv5-6.2","moduleName":"Object Detection (YOLOv5 6.2)","code":200,"command":"detect","requestId":"423c140a-c2fa-41ac-9949-478bfce04391","inferenceDevice":"CPU","analysisRoundTripMs":1191,"processedBy":"localhost","timestampUTC":"Mon, 28 Apr 2025 05:56:52 GMT"}},{"api":"alpr","found":{"success":true,"processMs":495,"inferenceMs":418,"predictions":[{"confidence":0.9858999848365784,"label":"Plate: XXXXXX","plate":"CYF76H","x_min":571,"y_min":1454,"x_max":772,"y_max":1557}],"message":"Found Plate: XXXXXX","moduleId":"ALPR","moduleName":"License Plate Reader","code":200,"command":"alpr","requestId":"1ccc3ef3-8666-498d-accb-db43b669bfc2","inferenceDevice":"CPU","analysisRoundTripMs":579,"processedBy":"localhost","timestampUTC":"Mon, 28 Apr 2025 05:56:52 GMT"}}]
The JPGS are then saved in the folder, which I can see, in the following naming convention. undefined_1745819817998_5e2d5d9b.jpg
I got it to work!, instructions in this thread: https://ipcamtalk.com/threads/full-alpr-database-system-for-blue-iris.79082/post-925239
