Montage Review Fails with a blank screen and error

Forum for questions and support relating to 1.35.x development only.
Post Reply
phillipwheat
Posts: 8
Joined: Wed Aug 05, 2020 10:48 pm

Montage Review Fails with a blank screen and error

Post by phillipwheat » Wed Aug 05, 2020 10:56 pm

Fairly new to Zoneminder, after getting tired of cheap camera solutions. So far loving ZM!

Today suddenly Montage Review fails.
Log error is: 2020-08-05 17:40:20 web_php 1406 ERR SQL-ERR 'SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty', statement was '' params: /usr/share/zoneminder/www/includes/database.php 162

Many google and forum searches reveal similar but not exactly the same error. And no viable solutions.

I am running on Ubuntu 20.04 with mysql db. Resources (cpu, storage, memory) are more than adequate.

I would appreciate any assistance as my PHP skills are simple at best.
I am a financial supporter and hope that zoneminder continues development at a high level!

dougmccrary
Posts: 79
Joined: Sat Aug 31, 2019 7:35 am

Re: Montage Review Fails with a blank screen and error

Post by dougmccrary » Wed Aug 05, 2020 11:11 pm

Yeah, it brings up the live view OK, but blanks on pretty much every review option.
Darn. iConnor has said they are breaking stuff - hadn't noticed this.

Not surprisingly, it's the same on 18.04 Bionic

User avatar
iconnor
Posts: 1325
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Montage Review Fails with a blank screen and error

Post by iconnor » Thu Aug 06, 2020 12:01 am

Yeah those looking for things to keep working should be running 1.34.

We are breaking things and we don't have the resources to be too careful about it

That being said, I have just pushed the fixes so new packages are building.

phillipwheat
Posts: 8
Joined: Wed Aug 05, 2020 10:48 pm

Re: Montage Review Fails with a blank screen and error

Post by phillipwheat » Thu Aug 06, 2020 12:27 am

I don't mind the breaking, just want to help by reporting issues.
I appreciate this project and will support it as best I can!
If there is a better path to report issues I would like to help.

phillipwheat
Posts: 8
Joined: Wed Aug 05, 2020 10:48 pm

Awesome!

Post by phillipwheat » Thu Aug 06, 2020 12:33 am

You fixed it! Awesome work. I'm even more supportive now!
Paypal donation executed. Have a nice dinner on me!

dougmccrary
Posts: 79
Joined: Sat Aug 31, 2019 7:35 am

Re: Montage Review Fails with a blank screen and error

Post by dougmccrary » Thu Aug 06, 2020 12:51 am

Well, I like to try to run the latest. I have Bionic for my 'real' system, and focal - same cams and all, but on an even crummier computer system.
I guess you know the zones are not editable...

phillipwheat
Posts: 8
Joined: Wed Aug 05, 2020 10:48 pm

Re: Montage Review Fails with a blank screen and error

Post by phillipwheat » Thu Aug 06, 2020 1:08 am

dougmccrary wrote:
Thu Aug 06, 2020 12:51 am
Well, I like to try to run the latest. I have Bionic for my 'real' system, and focal - same cams and all, but on an even crummier computer system.
I guess you know the zones are not editable...
Yes I've played with the zones thing, but for my porpoises I'm just recording everything. 7 cameras and hope to have 4 TB of storage. ZM is a hobby now, but I see opportunity in my "day job" to replace aging commercial (expensive) systems with ZM systems. If we can get there, then we can pour some serious donation support at ZM.

I will blaspheme a couple of commercial products I run now. Verint and March. Both good but ZM has so much more potential.

dougmccrary
Posts: 79
Joined: Sat Aug 31, 2019 7:35 am

Re: Montage Review Fails with a blank screen and error

Post by dougmccrary » Thu Aug 06, 2020 1:26 am

Yes I've played with the zones thing, but for my porpoises I'm just recording everything.
Me too - mocord.

I use it to highlight a couple of 'possums and 'coons that visit from time to time.
And I have one cam that has a shade that flutters in the wind, which I set to ignore, so I can see actual events.

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests