search

ZoneMinder / zoneminder

ZoneMinder is a free, open source Closed-circuit television software application developed for Linux which supports IP, USB and Analog cameras.
http://www.zoneminder.com/
GNU General Public License v2.0
4.96k stars 1.2k forks source link

"Monitors" Table Missing "WallClockTimestamps" Column #4087

Closed jalitriver closed 5 days ago

jalitriver commented 1 week ago

Environment

Describe the bug The "Monitors" table appears to be missing the new "WallClockTimestamps" column.

To Reproduce The problem occurs when adding a new camera which fails with the error message shown in the log below.

Expected behavior I expected to be able to add the new camera. After looking through recent commits, it looks like the WallClockTimestamps column should hold booleans so I manually added the a WallClockTimestamps column to my "zm" database, and it appears to have fixed the problem.

I also expected to find "WallClockTimestamps" in the files in /usr/share/zoneminder/db, but it is not there.

Debug Logs

SQL-ERR 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'WallClockTimestamps' in 'field list'', statement was 'INSERT INTO `Monitors` (...)
welcome[bot] commented 1 week ago

Thanks for opening your first issue here! Just a reminder, this forum is for Bug Reports only. Be sure to follow the issue template!

connortechnology commented 5 days ago

Fixed by 7d685e96df1be6fa1355d22e080edeb6445502cb