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

Support and queries relating to all previous versions of ZoneMinder
Locked
User avatar
lazyleopard
Posts: 403
Joined: Tue Mar 02, 2004 6:12 pm
Location: Gloucestershire, UK

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

Post 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
User avatar
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)

Post 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,
User avatar
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)

Post by lazyleopard »

Cheers. Will do.
Locked