ERR [Can't insert frames: You have an error in your SQL synt

Forum for questions and support relating to the 1.25.x releases only.
Locked
BlankMan
Posts: 147
Joined: Tue Jan 19, 2010 2:53 am
Location: Milwaukee, WI USA

ERR [Can't insert frames: You have an error in your SQL synt

Post by BlankMan »

Getting this on one camera every time it wants to add an event.

Sep 28 13:20:54 router zma_m4[29750]: 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]

Captured the MySQL INSERT statement, looks to me like it's incomplete/truncated, ergo the problem.

Code: Select all

                11560 Query     insert into Frames ( EventId, FrameId, TimeStamp, Delta ) values ( 278740, 1, from_unixtime(1317234058), 0.00 ), ( 278740, 2, from_unixtime(1317234058), 0.03 ), ( 278740, 3, from_unixtime(1317234058), 0.06 ), ( 278740, 4, from_unixtime(1317234058), 0.10 ), ( 278740, 5, from_unixtime(1317234058), 0.13 ), ( 278740, 6, from_unixtime(1317234059), 0.17 ), ( 278740, 7, from_unixtime(1317234059), 0.21 ), ( 278740, 8, from_unixtime(1317234059), 0.24 ), ( 278740, 9, from_unixtime(1317234059), 0.27 ), ( 278740, 10, from_unixtime(1317234059), 0.31 ), ( 278740, 11, from_unixtime(1317234059), 0.34 ), ( 278740, 12, from_unixtime(1317234059), 0.37 ), ( 278740, 13, from_unixtime(1317234059), 0.41 ), ( 278740, 14, from_unixtime(1317234059), 0.44 ), ( 278740, 15, from_unixtime(1317234059), 0.47 ), ( 278740, 16, from_unixtime(1317234059), 0.51 ), ( 278740, 17, from_unixtime(1317234059), 0.54 ), ( 278740, 18, from_unixtime(1317234059), 0.57 ), ( 278740, 19, from_unixtime(1317234059), 0.61 ), ( 278740, 20, from_unixtime(1317234059), 0.64 ), ( 278740, 21, from_unixtime(1317234059), 0.67 ), ( 278740, 22, from_unixtime(1317234059), 0.71 ), ( 278740, 23, from_unixtime(1317234059), 0.74 ), ( 278740, 24, from_unixtime(1317234059), 0.77 ), ( 278740, 25, from_unixtime(1317234059), 0.81 ), ( 278740, 26, from_unixtime(1317234059), 0.84 ), ( 278740, 27, from_unixtime(1317234059), 0.87 ), ( 278740, 28, from_unixtime(1317234059), 0.91 ), ( 278740, 29, from_unixtime(1317234059), 0.94 ), ( 278740, 30, from_unixtime(1317234059), 0.97 ), ( 278740, 31, from_unixtime(1317234059), 1.00 ), ( 278740, 32, from_unixtime(1317234059), 1.03 ), ( 278740, 33, from_unixtime(1317234059), 1.06 ), ( 278740, 34, from_unixtime(1317234059), 1.10 ), ( 278740, 35, from_unixtime(1317234059), 1.13 ), ( 278740, 36, from_unixtime(1317234060), 1.17 ), ( 278740, 37, from_unixtime(1317234060), 1.21 ), ( 278740, 38, from_unixtime(1317234060), 1.24 ), ( 278740, 39, from_unixtime(1317234060), 1.27 ), ( 278740, 40, from_unixtime(1317234060), 1.31 ), ( 278740, 41, from_unixtime(1317234060), 1.34 ), ( 278740, 42, from_unixtime(1317234060), 1.37 ), ( 278740, 43, from_unixtime(1317234060), 1.41 ), ( 278740, 44, from_unixtime(1317234060), 1.44 ), ( 278740, 45, from_unixtime(1317234060), 1.47 ), ( 278740, 46, from_unixtime(1317234060), 1.51 ), ( 278740, 47, from_unixtime(1317234060), 1.54 ), ( 278740, 48, from_unixtime(1317234060), 1.57 ), ( 278740, 49, from_unixtime(1317234060), 1.61 ), ( 278740, 50, from_unixtime(1317234060), 1.64 ), ( 278740, 51, from_unixtime(1317234060), 1.67 ), ( 278740, 52, from_unixtime(1317234060), 1.71 ), ( 278740, 53, from_unixtime(1317234060), 1.74 ), ( 278740, 54, from_unixtime(1317234050), -8.02 ), ( 278740, 55, from_unixtime(1317234050), -8.00 ), ( 278740, 56, from_unixtime(1317234050), -7.96 ), ( 278740, 57, from_unixtime(1317234050), -7.93 ), ( 278740, 58, from_unixtime(1317234050), -7.90 ), ( 278740, 59, from_unixtime(1317234050), -7.86 ), ( 278740, 60, from_unixtime(1317234051), -7.82 ), ( 278740, 61, from_unixtime(1317234051), -7.78 ), ( 278740, 62, from_unixtime(1317234051), -7.75 ), ( 278740, 63, from_unixtime(1317234051), -7.72 ), ( 278740, 64, from_unixtime(1317234051), -7.68 ), ( 278740, 65, from_unixtime(1317234051), -7.65 ), ( 278740, 66, from_unixtime(1317234051), -7.62 ), ( 278740, 67, from_unixtime(1317234051), -7.58 ), ( 278740, 68, from_unixtime(1317234051), -7.55 ), ( 278740, 69, from_unixtime(1317234051), -7.51 ), ( 278740, 70, from_unixtime(1317234051), -7.48 ), ( 278740, 71, from_unixtime(1317234051), -7.45 ), ( 278740, 72, from_unixtime(1317234051), -7.42 ), ( 278740, 73, from_unixtime(1317234051), -7.38 ), ( 278740, 74, from_unixtime(1317234051), -7.35 ), ( 278740, 75, from_unixtime(1317234051), -7.31 ), ( 278740, 76, from_unixtime(1317234051), -7.28 ), ( 278740, 77, from_unixtime(1317234051), -7.25 ), ( 278740, 78, from_unixtime(1317234051), -7.21 ), ( 278740, 79, from_unixtime(1317234051), -7.18 ), ( 278740, 80, from_unixtime(1317234051), -7.15 ), ( 278740, 81, from_unixtime(1317234051), -7.11 ), ( 278740, 82, from_unixtime(1317234051), -7.08 ), ( 278740, 83, from_unixtime(1317234051), -7.05 ), ( 278740, 84, from_unixtime(1317234051), -7.01 ), ( 278740, 85, from_unixtime(1317234051), -6.99 ), ( 278740, 86, from_unixtime(1317234051), -6.95 ), ( 278740, 87, from_unixtime(1317234051), -6.92 ), ( 278740, 88, from_unixtime(1317234051), -6.89 ), ( 278740, 89, from_unixtime(1317234051), -6.85 ), ( 278740, 90, from_unixtime(1317234052), -6.81 ), ( 278740, 91, from_unixtime(1317234052), -6.78 ), ( 278740, 92, from_unixtime(1317234052), -6.74 ), ( 278740, 93, from_unixtime(1317234052), -6.71 ), ( 278740, 94, from_unixtime(1317234052), -6.68 ), ( 278740, 95, from_unixtime(1317234052), -6.64 ), ( 278740, 96, from_unixtime(1317234052), -6.61 ), ( 278740, 97, from_unixtime(1317234052), -6.58 ), ( 278740, 98, from_unixtime(1317234052), -6.54 ), ( 278740, 99, from_unixtime(1317234052), -6.51 ), ( 278740, 100, from_unixtime(1317234052), -6.47 ), ( 278740, 101, from_unixtime(1317234052), -6.44 ), ( 278740, 102, from_unixtime(1317234052), -6.41 ), ( 278740, 103, from_unixtime(1317234052), -6.37 ), ( 278740, 104, from_unixtime(1317234052), -6.34 ), ( 278740, 105, from_unixtime(1317234052), -6.31 ), ( 278740, 106, from_unixtime(1317234052), -6.27 ), ( 278740, 107, from_unixtime(1317234052), -6.24 ), ( 278740, 108, from_unixtime(1317234052), -6.21 ), ( 278740, 109, from_unixtime(1317234052), -6.17 ), ( 278740, 110, from_unixtime(1317234052), -6.14 ), ( 278740, 111, from_unixtime(1317234052), -6.10 ), ( 278740, 112, from_unixtime(1317234052), -6.07 ), ( 278740, 113, from_unixtime(1317234052), -6.04 ), ( 278740, 114, from_unixtime(1317234052), -6.00 ), ( 278740, 115, from_unixtime(1317234052), -5.98 ), ( 278740, 116, from_unixtime(1317234052), -5.95 ), ( 278740, 117, from_unixtime(1317234052), -5.91 ), ( 278740, 118, from_unixtime(1317234052), -5.88 ), ( 278740, 119, from_unixtime(1317234052), -5.85 ), ( 278740, 120, from_unixtime(1317234053), -5.80 ), ( 278740, 121, from_unixtime(1317234053), -5.77 ), ( 278740, 122, from_unixtime(1317234053), -5.74 ), ( 278740, 123, from_unixtime(1317234053), -5.70 ), ( 278740, 124, from_unixtime(1317234053), -5.67 ), ( 278740, 125, from_unixtime(1317234053), -5.64 ), ( 278740, 126, from_unixtime(1317234053), -5.63 ), ( 278740, 127, from_unixtime(1317234053), -5.63 ), ( 278740, 128, from_unixtime(1317234053), -5.63 ), ( 278740, 129, from_unixtime(1317234053), -5.63 ), ( 278740, 130, from_unixtime(1317234053), -5.63 ), ( 278740, 131, from_unixtime(1317234053), -5.63 ), ( 278740, 132, from_unixtime(1317234053), -5.63 ), ( 278740, 133, from_unixtime(1317234053), -5.60 ), ( 278740, 134, from_unixtime(1317234053), -5.57 ), ( 278740, 135, from_unixtime(1317234053), -5.53 ), ( 278740, 136, from_unixtime(1317234053), -5.50 ), ( 278740, 137, from_unixtime(1317234053), -5.47 ), ( 278740, 138, from_unixtime(1317234053), -5.43 ), ( 278740, 139, from_unixtime(1317234053), -5.40 ), ( 278740, 140, from_unixtime(1317234053), -5.37 ), ( 278740, 141, from_unixtime(1317234053), -5.33 ), ( 278740, 142, from_unixtime(1317234053), -5.30 ), ( 278740, 143, from_unixtime(1317234053), -5.27 ), ( 278740, 144, from_unixtime(1317234053), -5.23 ), ( 278740, 145, from_unixtime(1317234053), -5.20 ), ( 278740, 146, from_unixtime(1317234053), -5.17 ), ( 278740, 147, from_unixtime(1317234053), -5.13 ), ( 278740, 148, from_unixtime(1317234053), -5.10 ), ( 278740, 149, from_unixtime(1317234053), -5.07 ), ( 278740, 150, from_unixtime(1317234053), -5.03 ), ( 278740, 151, from_unixtime(1317234053), -5.00 ), ( 278740, 152, from_unixtime(1317234053), -4.98 ), ( 278740, 153, from_unixtime(1317234053), -4.94 ), ( 278740, 154, from_unixtime(1317234053), -4.91 ), ( 278740, 155, from_unixtime(1317234053), -4.88 ), ( 278740, 156, from_unixtime(1317234053), -4.84 ), ( 278740, 157, from_unixtime(1317234054), -4.80 ), ( 278740, 158, from_unixtime(1317234054), -4.77 ), ( 278740, 159, from_unixtime(1317234054), -4.73 ), ( 278740, 160, from_unixtime(1317234054), -4.70 ), ( 278740, 161, from_unixtime(1317234054), -4.67 ), ( 278740, 162, from_unixtime(1317234054), -4.63 ), ( 278740, 163, from_uni
BlankMan
Posts: 147
Joined: Tue Jan 19, 2010 2:53 am
Location: Milwaukee, WI USA

Re: ERR [Can't insert frames: You have an error in your SQL

Post by BlankMan »

Ok has something to do with Buffers. When I set the Buffers to this:

Code: Select all

Image Buffer Size (frames)	300
Warmup Frames		25
Pre Event Image Count	240
Post Event Image Count	240
The problem occurs. When I set the Buffers to this:

Code: Select all

Image Buffer Size (frames)	200
Warmup Frames		25
Pre Event Image Count	180
Post Event Image Count	180
I get a different problem, get WAR [Approaching buffer overrun, consider slowing capture, simplifying analysis or increasing ring buffer size]

When I set it to this:

Code: Select all

Image Buffer Size (frames)	200
Warmup Frames		25
Pre Event Image Count	120
Post Event Image Count	180
Everything is fine but I want more frames recorded pre-event hence the 300/240.
BlankMan
Posts: 147
Joined: Tue Jan 19, 2010 2:53 am
Location: Milwaukee, WI USA

Re: ERR [Can't insert frames: You have an error in your SQL

Post by BlankMan »

Any ideas? Anyone?
Locked