Full ALPR Database System for Blue Iris!

Are you running in Docker? I had to specify my Timezone in the docker-compose.yml file. It reverts to GMT.

environment:
- NODE_ENV=production
- ADMIN_PASSWORD= # Change this to a secure password
- DB_PASSWORD= # Change this to match your postgres password
- TZ=America/New_York
 
  • Like
Reactions: svalvasori
wpiman said:
Are you running in Docker? I had to specify my Timezone in the docker-compose.yml file. It reverts to GMT.

environment:
- NODE_ENV=production
- ADMIN_PASSWORD= # Change this to a secure password
- DB_PASSWORD= # Change this to match your postgres password
- TZ=America/New_York
Click to expand...
looks like mine is already set to New_York, which is good.
 
svalvasori said:
My histogram timing doesn't align with the plates for some reason. I've checked the timezone on the app and db containers and also my BI PC and all are EST.

For instance, you see at 21:00, it say 8 plates were captured.
View attachment 217651

But when I click on the 18:00 blue line it shows me 3 plates that are actually from 22:00
View attachment 217652

So the number at the top top of the column, and the column size are correct, but the click through doesn't work correctly - seems an EST/GMT thing but I don't know where else I would set that.
Click to expand...
There are some known issues with converting back and forth from local to UTC. There are a couple bugs already written up related to similar problems:
alprdatabase.featurebase.app

Date filters don't respect local timezone - ALPR Database

If I pick a date like 3/2/2025 from the date filter (on live view or database view), I’d expect to see any plate reads between local midnight of 3/2 u...
alprdatabase.featurebase.app alprdatabase.featurebase.app
 
  • Like
Reactions: svalvasori
VideoDad said:
There are some known issues with converting back and forth from local to UTC. There are a couple bugs already written up related to similar problems:
alprdatabase.featurebase.app

Date filters don't respect local timezone - ALPR Database

If I pick a date like 3/2/2025 from the date filter (on live view or database view), I’d expect to see any plate reads between local midnight of 3/2 u...
alprdatabase.featurebase.app alprdatabase.featurebase.app
Click to expand...
Thanks - I don't think I've seen that site before.
 
algertc said:
Is it correct if you switch it to 12 hour time? The hour filter is kind of tricky the way it works with the timestamps.

Also make sure you have the full correctly formatted time zone: List of tz database time zones - Wikipedia

Why not use one of the Canadian ones?
Click to expand...
It was 12hr time, I switched to 24 and it had the issue in both. I have Toronto on some and New_York on the other. Same actual timezone. I'll switch it to Toronto just in case.
 
smallik said:
To those who have conquered multiple plate reads in quick succession, I could sure use some advice. I've included some screen shots of my computer horsepower (or lack thereof), chosen camera to do the work, and the road scene which usually totally ignores reading the plates with the shown actual example. I know there are literally a million combinations of settings between Blue Iris and the camera to make this scenario work (I've already played with the first half million... unsuccessfully), so I was wondering if someone would be willing to share a collection of their setup/screen shots where it's working for them. Perhaps the trigger object detection/zones and hot spots, alert/AI configuration in BI, and their camera settings. Thanks

View attachment 217956View attachment 217957View attachment 217958
Click to expand...

Maybe better to ask here: LPR

This thread is more focused on ALPR Database than general LPR questions.
 
PeteJ said:
Maybe better to ask here: LPR

This thread is more focused on ALPR Database than general LPR questions.
Click to expand...

And better for the OP to post their screenshots as everyone has different BI versions and someone could post something theirs doesn't have or vice versa. Easier for us to troubleshoot seeing their settings than providing ours.
 
When I have a parked car and it gets a lot of entries in the database, if I click on that from the dashboard (where it's listed at the top with the number of plates), I get a list of database rows for the plate. If I select delete next to one plate, I get this message:
1743430769467.png

Which to me indicates one row will be deleted - but instead, this action deletes all the plates listed (all the same plate number). Is this expected? It's not intuitive. It's actually what I wanted to do, but it feels like this isn't the expected outcome.
 
  • Like
Reactions: algertc
Another observation is the histogram display on the dashboard - is it possible to have an option where it is displayed as the past 24hrs in chronological order? (Not sure if that's actually what you call it). So if it's 17:00 when I look at it the chart X axis shows 17:00 (yesterday) to 17:00 (today)? Or if it can only display 00:00 - 23:59 on the X axis, then not fill in future hour bars with yesterday's data? Just leave them blank since that time hasn't come. I find the current display odd for 'today'; it would make perfect sense if I was looking at a previous day. Or....is mine just strange because of the way the timezones aren't aligning?

Like right now, it's 10:26AM, and all the data from 11:00-23:59 is from yesterday, but is in the future on the chart. IDK, maybe I'm over thinking this?
1743431281831.png
 
This probably has to do with the above and is likely an issue with my install somehow. It's 10:30AM - 15:56 and 15:58 timestamps say 'Today'; clearly that time has not come yet. Any idea where this is getting mixed up?
1743431597605.png
 
svalvasori said:
When I have a parked car and it gets a lot of entries in the database, if I click on that from the dashboard (where it's listed at the top with the number of plates), I get a list of database rows for the plate. If I select delete next to one plate, I get this message:
View attachment 218119
Which to me indicates one row will be deleted - but instead, this action deletes all the plates listed (all the same plate number). Is this expected? It's not intuitive. It's actually what I wanted to do, but it feels like this isn't the expected outcome.
Click to expand...
I got bitten by this too. I had two reads of the same plate in quick succession and went to remove one and it removed every read that had ever occurred. This is not very intuitive and I'm not sure why it behaves that way.
 
  • Like
Reactions: algertc
Im getting this error and cannot figure out where or how to fix it.


Error processing request: error: null value in column "plate_number" of relation "plate_reads" violates not-null constraint
at <unknown> (/app/node_modules/pg/lib/client.js:535:17)
at async p (/app/.next/server/app/api/plate-reads/route.js:1:6064)
at async te.do (/app/node_modules/next/dist/compiled/next-server/app-route.runtime.prod.js:18:17826)
at async te.handle (/app/node_modules/next/dist/compiled/next-server/app-route.runtime.prod.js:18:22492)
at async doRender (/app/node_modules/next/dist/server/base-server.js:1455:42)
at async responseGenerator (/app/node_modules/next/dist/server/base-server.js:1814:28)
at async NextNodeServer.renderToResponseWithComponentsImpl (/app/node_modules/next/dist/server/base-server.js:1824:28)
at async NextNodeServer.renderPageComponent (/app/node_modules/next/dist/server/base-server.js:2240:24)
at async NextNodeServer.renderToResponseImpl (/app/node_modules/next/dist/server/base-server.js:2278:32) {
length: 504,
severity: 'ERROR',
code: '23502',
detail: 'Failing row contains (43, null, null, images/2025/04/01/undefined_1743524021322_3cd91a1d.jpg, thumbnails/2025/04/01/undefined_1743524021322_3cd91a1d_thumb.jpg, 2025-04-01 12:13:27.976-04, 2025-04-01 12:13:41.395125-04, PTZ, ui3.htm?rec=195257569683655-803426&cam=PTZ, null, {0,250,1313,1197}, null, 0.86, null, f).',
hint: undefined,
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: 'public',
table: 'plate_reads',
column: 'plate_number',
dataType: undefined,
constraint: undefined,
file: 'execMain.c',
line: '1942',
routine: 'ExecConstraints'
}

From what i can deciper by the failing row contains im guessing its related to the payload string? { "ai_dump":&JSON, "Image":"&ALERT_JPEG", "camera":"&CAM", "ALERT_PATH": "&ALERT_PATH", "ALERT_CLIP": "&ALERT_CLIP", "timestamp":"&ALERT_TIME" }
 
strife1one1 said:
Im getting this error and cannot figure out where or how to fix it.


Error processing request: error: null value in column "plate_number" of relation "plate_reads" violates not-null constraint
at <unknown> (/app/node_modules/pg/lib/client.js:535:17)
at async p (/app/.next/server/app/api/plate-reads/route.js:1:6064)
at async te.do (/app/node_modules/next/dist/compiled/next-server/app-route.runtime.prod.js:18:17826)
at async te.handle (/app/node_modules/next/dist/compiled/next-server/app-route.runtime.prod.js:18:22492)
at async doRender (/app/node_modules/next/dist/server/base-server.js:1455:42)
at async responseGenerator (/app/node_modules/next/dist/server/base-server.js:1814:28)
at async NextNodeServer.renderToResponseWithComponentsImpl (/app/node_modules/next/dist/server/base-server.js:1824:28)
at async NextNodeServer.renderPageComponent (/app/node_modules/next/dist/server/base-server.js:2240:24)
at async NextNodeServer.renderToResponseImpl (/app/node_modules/next/dist/server/base-server.js:2278:32) {
length: 504,
severity: 'ERROR',
code: '23502',
detail: 'Failing row contains (43, null, null, images/2025/04/01/undefined_1743524021322_3cd91a1d.jpg, thumbnails/2025/04/01/undefined_1743524021322_3cd91a1d_thumb.jpg, 2025-04-01 12:13:27.976-04, 2025-04-01 12:13:41.395125-04, PTZ, ui3.htm?rec=195257569683655-803426&cam=PTZ, null, {0,250,1313,1197}, null, 0.86, null, f).',
hint: undefined,
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: 'public',
table: 'plate_reads',
column: 'plate_number',
dataType: undefined,
constraint: undefined,
file: 'execMain.c',
line: '1942',
routine: 'ExecConstraints'
}

From what i can deciper by the failing row contains im guessing its related to the payload string? { "ai_dump":&JSON, "Image":"&ALERT_JPEG", "camera":"&CAM", "ALERT_PATH": "&ALERT_PATH", "ALERT_CLIP": "&ALERT_CLIP", "timestamp":"&ALERT_TIME" }
Click to expand...
Did you get the latest migration.sql when doing the last update? It sounds like you are missing the most recent DB update.
 
VideoDad said:
Did you get the latest migration.sql when doing the last update? It sounds like you are missing the most recent DB update.
Click to expand...
I believe so. I have run the update.ps1 multiple times and have also just manually replaced it by downloading from github and dropping into the folder, overwriting restarting containers and also re-running update.ps1 again.
 
strife1one1 said:
I believe so. I have run the update.ps1 multiple times and have also just manually replaced it by downloading from github and dropping into the folder, overwriting restarting containers and also re-running update.ps1 again.
Click to expand...
Could it be the extra spaces after the colon in ALERT_PATH and ALERT_CLIP?
 
VideoDad said:
Could it be the extra spaces after the colon in ALERT_PATH and ALERT_CLIP?
Click to expand...
Well deleted the spaces and same error persists. totally stumped on this one.
2025-04-01 12:53:26.457 EDT [964] ERROR: null value in column "plate_number" of relation "plate_reads" violates not-null constraint
2025-04-01 12:53:26.457 EDT [964] DETAIL: Failing row contains (129, null, null, images/2025/04/01/undefined_1743526406389_cfd48ff1.jpg, thumbnails/2025/04/01/undefined_1743526406389_cfd48ff1_thumb.jpg, 2025-04-01 12:53:14.391-04, 2025-04-01 12:53:26.457311-04, PTZ, ui3.htm?rec=195257569683655-3157757&cam=PTZ, null, {0,130,1378,1256}, null, 0.83, null, f).
2025-04-01 12:53:26.457 EDT [964] STATEMENT: WITH new_plate AS (
INSERT INTO plates (plate_number)
VALUES ($1)
 
You must log in or register to reply here.
Top Bottom