Received plate read data: [object Object] in Log

[jhuettner]

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!

[tinker3433]

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

[dlo747]

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
<

[jhuettner]

I'm not getting the DB error on mine just FYI

[dlo747]

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.

[tinker3433]

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

[jhuettner]

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

[jhuettner]

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

[tinker3433]

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>

[tinker3433]

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.

[dlo747]

You try nuking everything and just starting over? meaning delete the images/container/folders and just reinstall. then try to do the following again

[jhuettner]

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.

[algertc]

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.

[jhuettner]

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]

[algertc]

@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"

[tinker3433]

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