Opened 4 years ago

Closed 4 years ago

#13654 closed Bug Report - General (Fixed)

Mythzoneminder plugin server for zoneminder updated so it works again

Reported by: 0n3man Owned by: paul-h
Priority: minor Milestone: 32.0
Component: Plugin - MythZoneminder Version: v31-fixes
Severity: medium Keywords: SQL zmserver
Cc: Ticket locked: no

Description

https://github.com/MythTV/mythtv/pull/200

The zoneminder database includes a column named function, which is a reserved word in mysql v8.x, so the SQl statements needed to be updated. The shared memory data structure for zoneminder 1.34.x also changed and had not been added to zmserver code. The code was none functional because of these errors. With correction the code works again.

Change History (2)

comment:1 Changed 4 years ago by Stuart Auchterlonie

Owner: set to paul-h
Status: newassigned

comment:2 Changed 4 years ago by paul-h

Milestone: needs_triage32.0
Resolution: Fixed
Status: assignedclosed

This was committed to master in [b8a98d9acde259f53ce71087e6aa6e5540667f37].

I briefly tested it with ZM v1.34.19 and it worked fine. Didn't test with older versions of ZM to see if it broke anything but the patch doesn't look like it will cause any problems.

Note: See TracTickets for help on using tickets.