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

Error by adding Groups #2939

Closed
bartbk opened this issue May 22, 2020 · 2 comments
Closed

Error by adding Groups #2939

bartbk opened this issue May 22, 2020 · 2 comments

Comments

@bartbk
Copy link

bartbk commented May 22, 2020

Describe Your Environment

  • Version of ZoneMinder [1.34.15]
  • How you installed ZoneMinder [e.g. PPA iconnor]
  • Full name and version of OS Ubuntu 20.04
  • Browser name and version (Chrome Version 81.0.4044.138 (Official Build) (64-bit) / Edge Version 84.0.516.0 (Official build) canary (64-bit) )

If the issue concerns a camera

  • Make and Model
  • frame rate
  • resolution
  • ZoneMinder Source Type:

Describe the bug
Every time I try to add group
SQL-ERR 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 'Groups (Id, Name, ParentId) VALUES (?, ?, ?)' at line 1', statement was 'INSERT INTO Groups (Id, Name, ParentId) VALUES (?, ?, ?)' params:,Podjazd,
To Reproduce
Steps to reproduce the behavior:

  1. Go to Zonemider Web
  2. Click on Groups
  3. Click New
  4. Enter any name, Parent group = None, Monitor = Select Monitor 1 / Leave as is
  5. Click Save
  6. See error in log

Expected behavior
Add a group with name selected.

Debug Logs
SQL-ERR 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 'Groups (Id, Name, ParentId) VALUES (?, ?, ?)' at line 1', statement was 'INSERT INTO Groups (Id, Name, ParentId) VALUES (?, ?, ?)' params:,Podjazd,

@welcome
Copy link

welcome bot commented May 22, 2020

Thanks for opening your first issue here! Just a reminder, this forum is for Bug Reports only. Be sure to follow the issue template!

@connortechnology
Copy link
Member

I believe these issues were fixed in 1.34.16. Please update and close this issue if the problem is sovled.

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

2 participants