Recently I upgraded from a single 878a to a 4 chip 878a for a high capture rate. Monitoring is working fine, but everytime a capture is triggered I am getting this error. I upgraded to 1.24.3 at the end of January and it was working fine.
Searching through the forum I am not seeing an exact hit on the error.
Any thoughts?
Apr 18 16:14:11 mdame-gx zmc_dvideo2[12677]: INF [BackPorch: 17888000 - Capturing at 29.41 fps]
Apr 18 16:14:33 mdame-gx zmc_dvideo3[12673]: INF [Pond: 17894000 - Capturing at 29.41 fps]
Apr 18 16:14:36 mdame-gx zmc_dvideo0[12681]: INF [Front: 16460000 - Capturing at 24.39 fps]
Apr 18 16:14:41 mdame-gx zma_m5[10932]: INF [Front: 375841 - Gone into alarm state]
Apr 18 16:14:41 mdame-gx zma_m5[10932]: INF [Front: 375841 - Opening new event 86685, alarm start]
Apr 18 16:14:43 mdame-gx zma_m5[10932]: ERR [Can't insert frames: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]
Apr 18 16:14:43 mdame-gx zmdc[12646]: ERR ['zma -m 5' exited abnormally, exit status 40]
Apr 18 16:14:43 mdame-gx zmdc[12646]: INF [Starting pending process, zma -m 5]
Apr 18 16:14:43 mdame-gx zmdc[12646]: INF ['zma -m 5' starting at 11/04/18 16:14:43, pid = 13243]
Apr 18 16:14:43 mdame-gx zmdc[13243]: INF ['zma -m 5' started at 11/04/18 16:14:43]
'error in your SQL syntax' after upgrading capture card.
- punch-card
- Posts: 39
- Joined: Thu Nov 25, 2010 10:29 pm
- Location: St Peters MO
'error in your SQL syntax' after upgrading capture card.
Best Regards
Mike
Mike
- punch-card
- Posts: 39
- Joined: Thu Nov 25, 2010 10:29 pm
- Location: St Peters MO
Re: 'error in your SQL syntax' after upgrading capture card.
finally figured this out, it was a buffer issue.
I ended up using option --> config --> V4L_MULTI_BUFFER [checked]
and editing the source and set "Capture Method" --> Video for Linux version 1
This allowed me to capture at about 30fps for all 4 camera.
I did increase the buffers since I am capturing at a much higher rate.
I ended up using option --> config --> V4L_MULTI_BUFFER [checked]
and editing the source and set "Capture Method" --> Video for Linux version 1
This allowed me to capture at about 30fps for all 4 camera.
I did increase the buffers since I am capturing at a much higher rate.
Best Regards
Mike
Mike