Click on camera from dashboard results in a SQL Error

[jshank]

Zoneminder 1.28.1 updated the dbEscape method to add single quotes around variables.
Removing the extra single-quote from views/watch.php line 27 for example:
$sql = "select C.*, M.* from Monitors as M left join Controls as C on (M.ControlId = C.Id ) where M.Id = ".dbEscape($_REQUEST['mid']);

There are probably quite a few instances of this throughout the skin but it's worth every second to fix them for this great improvement to zoneminder.

[edgiru]

Zoneminder 1.28.1
and I have such an error when viewing the camera.
SQL-ERR dbFetchOne no result, statement was 'select C., M. from Monitors as M left join Controls as C on (M.ControlId = C.Id ) where M.Id = ''4'''

[leganas]

jshank, Thank you