iconnor wrote: ↑Mon Jun 16, 2025 10:03 pm
Yeha it won't be NaN, the NaN will be because we returned 0 results or nothing at all, or something like that. Can you turn on debug logging Options->Logging->Debug
It should put a lot of verbose logs into /var/log/zm/web_php.log which should include the results of the events list query. Which should shed some light.
Forgive me for not remembering how to attach files to phpBB. I searched the log for the NaN, then went backwards until I found the most recent SQL query. I can see that the NaN appears in a results array before any SQL query in the log. I figure that's probably what you want to see. Let me know if you want more. There's a bunch of odd ffmpeg spew in there as well, complaining that it can't write to a file. Not sure why, as the path on that does exist, and the owner/group permissions are set to www-data:www-data. Here's a section of the log that might be most relevant.
cat /var/log/zm/web_php.log.debug
cpb: bitrate max/min/avg: 0/0/200000 buffer size: 0 vbv_delay: N/A
displaymatrix: rotation of -0.00 degrees
frame= 1 fps=0.0 q=8.6 Lsize=N/A time=00:00:00.03 bitrate=N/A speed=0.0348x
video:198kB audio:0kB subtitle:0kB other streams:0kB global headers:0kB muxing overhead: unknown] at /usr/share/zoneminder/www/views/image.php line 342
6/16/25, 3:09:24 PM PDT.584038 web_php[55812].DBG [98.188.57.164] [Doing a scaled image: scale(0) width(48) height(85)] at /usr/share/zoneminder/www/views/image.php line 499
6/16/25, 3:09:24 PM PDT.584091 web_php[55812].DBG [98.188.57.164] [Cached scaled image does not exist at /var/cache/zoneminder/events/1/2025-06-15/3432/snapshot-48x85.jpg. Creating it] at /usr/share/zoneminder/www/views/image.php line 527
6/16/25, 3:09:24 PM PDT.613939 web_php[55812].DBG [98.188.57.164] [Have image scaling to 48 x 85] at /usr/share/zoneminder/www/views/image.php line 541
6/16/25, 3:09:24 PM PDT.621953 web_php[49602].DBG [98.188.57.164] [Array
(
[view] => request
[request] => events
[task] => query
[filter] => Array
(
[Query] => Array
(
[terms] => Array
(
[0] => Array
(
[cnj] => and
[attr] => Monitor
[op] => =
[val] => Array
(
[0] => 1
)
)
[1] => Array
(
[cnj] => and
[attr] => StartDateTime
[op] => >=
[val] =>
)
[2] => Array
(
[cnj] => and
[attr] => EndDateTime
[op] => <=
[val] =>
)
[3] => Array
(
[cnj] => and
[attr] => Notes
[op] => LIKE
[val] =>
)
[4] => Array
(
[cnj] => and
[attr] => Tags
[op] => =
[val] =>
)
[5] => Array
(
[cnj] => and
[attr] => Archived
[op] => =
[val] =>
)
)
[sort_asc] => 1
[sort_field] => StartDateTime
)
)
[__csrf_magic] => key:8e04f41d7289b3befa405e2d6e5c97aa1e6abb7d,1750111764
[search] =>
[sort] => StartDateTime
[order] => asc
[offset] => NaN
[limit] => NaN
)] at /usr/share/zoneminder/www/index.php line 33
6/16/25, 3:09:24 PM PDT.623403 web_php[49602].DBG [98.188.57.164] [View: request Request: events Action: User: admin] at /usr/share/zoneminder/www/index.php line 187
6/16/25, 3:09:24 PM PDT.624707 web_php[49602].ERR [98.188.57.164] [Invalid value for offset: NaN] at /usr/share/zoneminder/www/ajax/events.php line 81
6/16/25, 3:09:24 PM PDT.625537 web_php[49602].ERR [98.188.57.164] [Invalid value for limit: NaN] at /usr/share/zoneminder/www/ajax/events.php line 92
6/16/25, 3:09:24 PM PDT.626941 web_php[49602].DBG [98.188.57.164] [Calling the following sql query: SELECT
E.*,
UNIX_TIMESTAMP(E.StartDateTime) AS StartTimeSecs,
CASE WHEN E.EndDateTime IS NULL THEN (SELECT NOW()) ELSE E.EndDateTime END AS EndDateTime,
CASE WHEN E.EndDateTime IS NULL THEN (SELECT UNIX_TIMESTAMP(NOW())) ELSE UNIX_TIMESTAMP(EndDateTime) END AS EndTimeSecs,
M.Name AS Monitor,
GROUP_CONCAT(T.Name SEPARATOR ", ") AS Tags FROM `Events` AS E
INNER JOIN Monitors AS M ON E.MonitorId = M.Id
LEFT JOIN Events_Tags AS ET ON E.Id = ET.EventId
LEFT JOIN Tags AS T ON T.Id = ET.TagId
WHERE ( E.MonitorId = '1'
)
GROUP BY E.Id, Monitor
ORDER BY E.StartDateTime ASC] at /usr/share/zoneminder/www/ajax/events.php line 242
6/16/25, 3:09:24 PM PDT.630073 web_php[49602].DBG [98.188.57.164] [Have 194 events matching base filter.] at /usr/share/zoneminder/www/ajax/events.php line 266
6/16/25, 3:09:24 PM PDT.634162 web_php[55812].DBG [98.188.57.164] [Array
(
[view] => request
[request] => events
[task] => query
[filter] => Array
(
[Query] => Array
(
[terms] => Array
(
[0] => Array
(
[cnj] => and
[attr] => Monitor
[op] => =
[val] => Array
(
[0] => 1
)
)
[1] => Array
(
[cnj] => and
[attr] => StartDateTime
[op] => >=
[val] =>
)
[2] => Array
(
[cnj] => and
[attr] => EndDateTime
[op] => <=
[val] =>
)
[3] => Array
(
[cnj] => and
[attr] => Notes
[op] => LIKE
[val] =>
)
[4] => Array
(
[cnj] => and
[attr] => Tags
[op] => =
[val] =>
)
[5] => Array
(
[cnj] => and
[attr] => Archived
[op] => =
[val] =>
)
)
[sort_asc] => 1
[sort_field] => StartDateTime
)
)
[__csrf_magic] => key:8e04f41d7289b3befa405e2d6e5c97aa1e6abb7d,1750111764
[search] =>
[sort] => StartDateTime
[order] => asc
[offset] => NaN
[limit] => NaN
)] at /usr/share/zoneminder/www/index.php line 33
6/16/25, 3:09:24 PM PDT.635539 web_php[55812].DBG [98.188.57.164] [View: request Request: events Action: User: admin] at /usr/share/zoneminder/www/index.php line 187
6/16/25, 3:09:24 PM PDT.636743 web_php[55812].ERR [98.188.57.164] [Invalid value for offset: NaN] at /usr/share/zoneminder/www/ajax/events.php line 81
6/16/25, 3:09:24 PM PDT.637615 web_php[55812].ERR [98.188.57.164] [Invalid value for limit: NaN] at /usr/share/zoneminder/www/ajax/events.php line 92
6/16/25, 3:09:24 PM PDT.639028 web_php[55812].DBG [98.188.57.164] [Calling the following sql query: SELECT
E.*,
UNIX_TIMESTAMP(E.StartDateTime) AS StartTimeSecs,
CASE WHEN E.EndDateTime IS NULL THEN (SELECT NOW()) ELSE E.EndDateTime END AS EndDateTime,
CASE WHEN E.EndDateTime IS NULL THEN (SELECT UNIX_TIMESTAMP(NOW())) ELSE UNIX_TIMESTAMP(EndDateTime) END AS EndTimeSecs,
M.Name AS Monitor,
GROUP_CONCAT(T.Name SEPARATOR ", ") AS Tags FROM `Events` AS E
INNER JOIN Monitors AS M ON E.MonitorId = M.Id
LEFT JOIN Events_Tags AS ET ON E.Id = ET.EventId
LEFT JOIN Tags AS T ON T.Id = ET.TagId
WHERE ( E.MonitorId = '1'
)
GROUP BY E.Id, Monitor
ORDER BY E.StartDateTime ASC] at /usr/share/zoneminder/www/ajax/events.php line 242
6/16/25, 3:09:24 PM PDT.642174 web_php[55812].DBG [98.188.57.164] [Have 194 events matching base filter.] at /usr/share/zoneminder/www/ajax/events.php line 266
6/16/25, 3:09:24 PM PDT.675026 web_php[60492].DBG [98.188.57.164] [Array
(
[view] => request
[request] => events
[task] => query
[filter] => Array
(
[Query] => Array
(
[terms] => Array
(
[0] => Array
(
[cnj] => and
[attr] => Monitor
[op] => =
[val] => Array
(
[0] => 1
)
)
[1] => Array
(
[cnj] => and
[attr] => StartDateTime
[op] => >=
[val] =>
)
[2] => Array
(
[cnj] => and
[attr] => EndDateTime
[op] => <=
[val] =>
)
[3] => Array
(
[cnj] => and
[attr] => Notes
[op] => LIKE
[val] =>
)
[4] => Array
(
[cnj] => and
[attr] => Tags
[op] => =
[val] =>
)
[5] => Array
(
[cnj] => and
[attr] => Archived
[op] => =
[val] =>
)
)
[sort_asc] => 1
[sort_field] => StartDateTime
)
)
[__csrf_magic] => key:8e04f41d7289b3befa405e2d6e5c97aa1e6abb7d,1750111764
[search] =>
[sort] => StartDateTime
[order] => asc
[offset] => NaN
[limit] => NaN
[undefined] =>
)] at /usr/share/zoneminder/www/index.php line 33