Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

zmu utility fail with MySQL database query error #2885

Closed
andreafrati1969 opened this issue Mar 13, 2020 · 0 comments
Closed

zmu utility fail with MySQL database query error #2885

andreafrati1969 opened this issue Mar 13, 2020 · 0 comments

Comments

@andreafrati1969
Copy link

Describe Your Environment
MySQL Server version 8.0.19-0ubuntu0.19.10.3

  • Version of ZoneMinder [release version, development version, or commit]
    1.35.1~20200310184748-eoan
  • How you installed ZoneMinder [e.g. PPA, RPMFusion, from-source, etc]
    http://ppa.launchpad.net/iconnor/zoneminder-master/ubuntu eoan/main amd64 Packages
  • Full name and version of OS
    Ubuntu 19.10 5.3.0-42-generic Minor errors when either OPT_MAIL, OPT_MESSAGE, or OPT_UPLOAD are not set #34-Ubuntu SMP Fri Feb 28 05:49:40 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
  • Browser name and version (if this is an issue with the web interface)
    Not applicable
    If the issue concerns a camera
  • Make and Model
  • frame rate
  • resolution
  • ZoneMinder Source Type:
    Not applicable
    Describe the bug
    When i run zmu utility it procduce a MySQL error

To Reproduce
Steps to reproduce the behavior:

  1. Open a console as root or use sudo command
  2. Run the command zmu -l -U -P
  3. See error
    ERR-zmu.cpp/718 [Can't run query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Function+0 from Monitorswhere Function != 'None' order by Id asc' at line 1]

Expected behavior
It should list cameras in zoneminder system

Debug Logs


<insert debug logs here, please make sure they are within the ``` quotes so they are formatted properly>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant