Page 1 of 1

Unknown table 'M' in where clause (using 1.19.1)

Posted: Tue Mar 30, 2004 10:52 am
by lazyleopard
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

Re: Unknown table 'M' in where clause (using 1.19.1)

Posted: Wed Mar 31, 2004 9:35 am
by zoneminder
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,

Re: Unknown table 'M' in where clause (using 1.19.1)

Posted: Wed Mar 31, 2004 9:56 am
by lazyleopard
Cheers. Will do.