Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

"Monitors" Table Missing "WallClockTimestamps" Column #4087

Closed
jalitriver opened this issue Jul 7, 2024 · 2 comments
Closed

"Monitors" Table Missing "WallClockTimestamps" Column #4087

jalitriver opened this issue Jul 7, 2024 · 2 comments

Comments

@jalitriver
Copy link

Environment

  • ZoneMinder v1.37.62
  • Installed from ppa:iconnor/zoneminder-master
  • Ubuntu-24.04

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` (...)
Copy link

welcome bot commented Jul 7, 2024

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
Copy link
Member

Fixed by 7d685e9

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
2 participants