Page 1 of 1

'error in your SQL syntax' after upgrading capture card.

Posted: Mon Apr 18, 2011 9:49 pm
by punch-card
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]

Re: 'error in your SQL syntax' after upgrading capture card.

Posted: Thu Apr 21, 2011 9:36 pm
by punch-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.