When I run a custom filter and then click on a selected event in order to view it I get this message in the viewer window, and nothing else:
Unknown table 'M' in where clause
When I select a list of events via the links in the main monitor summary page the event viewing links work fine.
The shorter custom filter that fails this way is (typed as text):
Monitor name matches one
and Archived Status Unarchived Only
and Total Score less than 50
Unknown table 'M' in where clause (using 1.19.1)
- lazyleopard
- Posts: 403
- Joined: Tue Mar 02, 2004 6:12 pm
- Location: Gloucestershire, UK
- zoneminder
- Site Admin
- Posts: 5215
- Joined: Wed Jul 09, 2003 2:07 pm
- Location: Bristol, UK
- Contact:
Re: Unknown table 'M' in where clause (using 1.19.1)
Hi Rick,
Yes this appears to be a bug I will look into it and see if it's easy to fix. As a workaround you can use monitor ids instead of names which doesn't suffer from this problem.
Phil,
Yes this appears to be a bug I will look into it and see if it's easy to fix. As a workaround you can use monitor ids instead of names which doesn't suffer from this problem.
Phil,
- lazyleopard
- Posts: 403
- Joined: Tue Mar 02, 2004 6:12 pm
- Location: Gloucestershire, UK
Re: Unknown table 'M' in where clause (using 1.19.1)
Cheers. Will do.